Sabtu, 10 Desember 2011

[smf_addin] Digest Number 2042

Messages In This Digest (19 Messages)

Messages

1a.

Trading Economics

Posted by: "newengwongpeggy" tong82@gmail.com   newengwongpeggy

Fri Dec 9, 2011 6:48 am (PST)



Hi Randy,

Possible to download the data from the charts?

http://www.tradingeconomics.com/china/imports

thx

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.

Re: Trading Economics

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Dec 9, 2011 8:22 am (PST)



Nope. Not with the add-in.

On Fri, Dec 9, 2011 at 7:48 AM, newengwongpeggy <tong82@gmail.com> wrote:

>
> Possible to download the data from the charts?
>
> http://www.tradingeconomics.com/china/imports
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2a.

Help grabbing data from site... can't get table cell formula to work

Posted by: "friedman_steve" friedman_steve@yahoo.com   friedman_steve

Fri Dec 9, 2011 8:12 am (PST)



2 problems:

1.
http://www.form4oracle.com/company/dg-fastchannel-inc-dgit?id=7629

When you go to this site, you'll see a cell with COMPANY SENTIMENT.
just below this is a picture of a number.
I'm trying to grab this data (currently, it is +3 for the stock DGIT).

2. 2nd problem is the website URL includes the company name, not just the ticker. I'd like to be able to reference another cell with the ticker. Is there a way to enter this in with just the ticker?

So, ideally, I'll have a formula where I reference the ticker "DGIT", and get the result back "+3".

Thanks,
Steve

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2b.

Re: Help grabbing data from site... can't get table cell formula to

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Dec 9, 2011 8:37 am (PST)



The data you want isn't text in tables, so RCHGetTableCell() would never
work.

These appear to work:

=0+smfStrExtr(RCHGetWebData("http://www.form4oracle.com/ticker?symbol=dgit
","_sentiment_"),"ment_","_")
=smfStrExtr(RCHGetWebData("http://www.form4oracle.com/ticker?symbol=dgit
","Sentiment:"),CHAR(32),"""")

On Fri, Dec 9, 2011 at 9:11 AM, friedman_steve <friedman_steve@yahoo.com>wrote:

> 2 problems:
>
> 1.
> http://www.form4oracle.com/company/dg-fastchannel-inc-dgit?id=7629
>
> When you go to this site, you'll see a cell with COMPANY SENTIMENT.
> just below this is a picture of a number.
> I'm trying to grab this data (currently, it is +3 for the stock DGIT).
>
> 2. 2nd problem is the website URL includes the company name, not just the
> ticker. I'd like to be able to reference another cell with the ticker. Is
> there a way to enter this in with just the ticker?
>
> So, ideally, I'll have a formula where I reference the ticker "DGIT", and
> get the result back "+3".
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2c.

Re: Help grabbing data from site... can't get table cell formula to

Posted by: "friedman_steve" friedman_steve@yahoo.com   friedman_steve

Fri Dec 9, 2011 8:56 am (PST)



awesome. Thanks.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The data you want isn't text in tables, so RCHGetTableCell() would never
> work.
>
> These appear to work:
>
> =0+smfStrExtr(RCHGetWebData("http://www.form4oracle.com/ticker?symbol=dgit
> ","_sentiment_"),"ment_","_")
> =smfStrExtr(RCHGetWebData("http://www.form4oracle.com/ticker?symbol=dgit
> ","Sentiment:"),CHAR(32),"""")
>
> On Fri, Dec 9, 2011 at 9:11 AM, friedman_steve <friedman_steve@...>wrote:
>
> > 2 problems:
> >
> > 1.
> > http://www.form4oracle.com/company/dg-fastchannel-inc-dgit?id=7629
> >
> > When you go to this site, you'll see a cell with COMPANY SENTIMENT.
> > just below this is a picture of a number.
> > I'm trying to grab this data (currently, it is +3 for the stock DGIT).
> >
> > 2. 2nd problem is the website URL includes the company name, not just the
> > ticker. I'd like to be able to reference another cell with the ticker. Is
> > there a way to enter this in with just the ticker?
> >
> > So, ideally, I'll have a formula where I reference the ticker "DGIT", and
> > get the result back "+3".
> >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2d.

Re: Help grabbing data from site... can't get table cell formula to

Posted by: "friedman_steve" friedman_steve@yahoo.com   friedman_steve

Fri Dec 9, 2011 9:12 am (PST)



i have it working in excel 2007, but not working in excel 2003. Any reason why not in 2003? (i prefer '03 since i have crashing problems in '07 due to conflicts with another program)

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The data you want isn't text in tables, so RCHGetTableCell() would never
> work.
>
> These appear to work:
>
> =0+smfStrExtr(RCHGetWebData("http://www.form4oracle.com/ticker?symbol=dgit
> ","_sentiment_"),"ment_","_")
> =smfStrExtr(RCHGetWebData("http://www.form4oracle.com/ticker?symbol=dgit
> ","Sentiment:"),CHAR(32),"""")
>
> On Fri, Dec 9, 2011 at 9:11 AM, friedman_steve <friedman_steve@...>wrote:
>
> > 2 problems:
> >
> > 1.
> > http://www.form4oracle.com/company/dg-fastchannel-inc-dgit?id=7629
> >
> > When you go to this site, you'll see a cell with COMPANY SENTIMENT.
> > just below this is a picture of a number.
> > I'm trying to grab this data (currently, it is +3 for the stock DGIT).
> >
> > 2. 2nd problem is the website URL includes the company name, not just the
> > ticker. I'd like to be able to reference another cell with the ticker. Is
> > there a way to enter this in with just the ticker?
> >
> > So, ideally, I'll have a formula where I reference the ticker "DGIT", and
> > get the result back "+3".
> >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
2e.

Re: Help grabbing data from site... can't get table cell formula to

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Dec 9, 2011 11:16 am (PST)



Do you have a different version of the add-in installed for the EXCEL 2003
copy? Otherwise, a description of "not working" doesn't give me any way to
help.

On Fri, Dec 9, 2011 at 10:12 AM, friedman_steve <friedman_steve@yahoo.com>wrote:

> i have it working in excel 2007, but not working in excel 2003. Any
> reason why not in 2003? (i prefer '03 since i have crashing problems in
> '07 due to conflicts with another program)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
3a.

Re: Complete list of all stocks

Posted by: "kenkiarash" kenkiarash@yahoo.com   kenkiarash

Fri Dec 9, 2011 10:28 am (PST)



Thanks. I will try FinViz. The reason such a tool is useful, is that what if you;re trying to identify all the stock that are in teh financial services industry? how about if you believe there is a turn in real estate coming and you want to go long or short the sector, but need to identify ALL the players in the space. I have even looked at industry categories on Bloomberg, FactSet, Yahoo! and other places, and they have different lists, and one can never find the complete universe of a particular category/industry.

Thanks for everyone's help..


--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You can try FinViz -- check the "Links" area of the group to retrieve their
> screener output with the add-in.
>
> Of what use is such a list, since it can change daily?
>
> On Wed, Dec 7, 2011 at 2:40 PM, kenkiarash <kenkiarash@...> wrote:
>
> > Does anyone know how to import the complete listing of all stocks on all
> > U.S. exchanges (NYSE, AMEX, NASDAQ, etc.)? Also, can this be done by
> > industry, such as financials, airlines, etc.?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
3b.

Re: Complete list of all stocks

Posted by: "kenkiarash" kenkiarash@yahoo.com   kenkiarash

Fri Dec 9, 2011 10:40 am (PST)



is there a way to get the list of ALL stocks from Zacks, with ticker and industry fields?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The full list from the FinViz screener is 6,819 symbols. Plus you could get
> any or all of the other 67 available fields along with the ticker symbols.
>
> =smfGetCSVFile("http://finviz.com/export.ashx?v=151&c=1")
>
> The Zacks screener returns 7,776 symbols:
>
> =smfGetCSVFile("http://screener.zacks.com/export?dummy=
> "&$C$2&RCHGetTableCell("http://screener.zacks.com/screens/
> "&$C$2&"/run",3,">Company",,,,1))
>
> ...where $C$2 contains the saved screen number from their screening tool.
> Again, with whatever of their other fields you told the screen to export.
>
> On Wed, Dec 7, 2011 at 6:05 PM, Mike McQuaid <mikemcq802@...> wrote:
>
> > **
> >
> > It is a nice list but far from complete. It's about 1,000 symbols.
> >
> > I subscribe to SI Pro from AAII and they have about 10,000 companies in
> > their database.
> >
> > You can export their data to Excel spreadsheets which would be one way to
> > get a list - it's not free but not expensive as data services go.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
3c.

Re: Complete list of all stocks

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Dec 9, 2011 11:19 am (PST)



Depending on which data provider you go to, you're going to find different
industry/sector group definitions. And what to do with conglomerates that
are a competitor to a company you're interested in, but the majority of
their business is in a different industry/sector...

You're never going to find a list of ALL the players.

On Fri, Dec 9, 2011 at 11:28 AM, kenkiarash <kenkiarash@yahoo.com> wrote:

> Thanks. I will try FinViz. The reason such a tool is useful, is that what
> if you;re trying to identify all the stock that are in teh financial
> services industry? how about if you believe there is a turn in real estate
> coming and you want to go long or short the sector, but need to identify
> ALL the players in the space. I have even looked at industry categories on
> Bloomberg, FactSet, Yahoo! and other places, and they have different lists,
> and one can never find the complete universe of a particular
> category/industry.
>
> Thanks for everyone's help..
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
3d.

Re: Complete list of all stocks

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Dec 9, 2011 11:20 am (PST)



Save the screen that way...

On Fri, Dec 9, 2011 at 11:40 AM, kenkiarash <kenkiarash@yahoo.com> wrote:

> is there a way to get the list of ALL stocks from Zacks, with ticker and
> industry fields?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
4a.

Re: Excel 2010

Posted by: "Ron" rlcarr71@yahoo.com   rlcarr71

Fri Dec 9, 2011 11:13 am (PST)





Thought I would add my two cents, in regards to compatibility.

After upgrading to Win7 and Excel 2010, I discoverd that all the functions worked (i.e. RCHGetElementNumber).
However, none of the macros would work (i.e SMFForceRecalcution). Yet all my macros from Personal.xls did work. To resolve this I had to click the checkbox "Trust access to VBA project model" under the Trust Center...Macro settings.

Ron

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)
4b.

Re: Excel 2010

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Dec 9, 2011 12:56 pm (PST)



Interesting. Thanks for the heads up! I added an entry in the "Links" area
of the group to your message.

On Fri, Dec 9, 2011 at 10:51 AM, Ron <rlcarr71@yahoo.com> wrote:

>
> Thought I would add my two cents, in regards to compatibility.
>
> After upgrading to Win7 and Excel 2010, I discoverd that all the functions
> worked (i.e. RCHGetElementNumber).
> However, none of the macros would work (i.e SMFForceRecalcution). Yet all
> my macros from Personal.xls did work. To resolve this I had to click the
> checkbox "Trust access to VBA project model" under the Trust Center...Macro
> settings.
>
> Ron
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (18)
5a.

Any way to pull data off this site - stock2own?

Posted by: "staspmr" staspmr@yahoo.ca   staspmr

Fri Dec 9, 2011 3:37 pm (PST)



I'm trying to get the data from this site and unfortunately it doesn't seem to use standard tables

e.g. http://stock2own.com/StockAnalyzer.aspx?s=US:AAPL

i want to get the values for growth rates, and the values under "value price" on the left hand side.

Can someone point me in the right direction?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
5b.

Re: Any way to pull data off this site - stock2own?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Dec 9, 2011 4:03 pm (PST)



You can grab the whole growth rate table with:

=RCHGetHTMLTable("http://stock2own.com/StockAnalyzer.aspx?s=US:AAPL
",">Result",-1,"",1)

You can get the two valuation tables with:

=RCHGetHTMLTable("http://stock2own.com/StockAnalyzer.aspx?s=US:AAPL","MOS
Price:",-1,"",1)
=RCHGetHTMLTable("http://stock2own.com/StockAnalyzer.aspx?s=US:AAPL",">Investment
Recovery Time",-1,"",1)

Or, you can pull individual items out of those tables with the
RCHGetTableCell() function. For example:

=RCHGetTableCell("http://stock2own.com/StockAnalyzer.aspx?s=US:AAPL",3,">Investment
Recovery Time")

On Fri, Dec 9, 2011 at 4:37 PM, staspmr <staspmr@yahoo.ca> wrote:

> I'm trying to get the data from this site and unfortunately it doesn't
> seem to use standard tables
>
> e.g. http://stock2own.com/StockAnalyzer.aspx?s=US:AAPL
>
> i want to get the values for growth rates, and the values under "value
> price" on the left hand side.
>
> Can someone point me in the right direction?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
5c.

Re: Any way to pull data off this site - stock2own?

Posted by: "staspmr" staspmr@yahoo.ca   staspmr

Fri Dec 9, 2011 5:22 pm (PST)



Thanks, I see what you did. I was thinking if there was a way to pull the data directly from the page.

e.g. I am trying to get the growth rate (e.g. 100.00) so I enter
=RCHGetTableCell("http://stock2own.com/StockAnalyzer.aspx?s=US:AAPL",0,"Growth Rates","growth Grade")

but it returns "Growth RatesgoodGrowth Grade100.00" i guess because it is like a cell on that page.

Any way to separate out the 100.00?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You can grab the whole growth rate table with:
>
> =RCHGetHTMLTable("http://stock2own.com/StockAnalyzer.aspx?s=US:AAPL
> ",">Result",-1,"",1)
>
> You can get the two valuation tables with:
>
> =RCHGetHTMLTable("http://stock2own.com/StockAnalyzer.aspx?s=US:AAPL","MOS
> Price:",-1,"",1)
> =RCHGetHTMLTable("http://stock2own.com/StockAnalyzer.aspx?s=US:AAPL",">Investment
> Recovery Time",-1,"",1)
>
> Or, you can pull individual items out of those tables with the
> RCHGetTableCell() function. For example:
>
> =RCHGetTableCell("http://stock2own.com/StockAnalyzer.aspx?s=US:AAPL",3,">Investment
> Recovery Time")
>
> On Fri, Dec 9, 2011 at 4:37 PM, staspmr <staspmr@...> wrote:
>
> > I'm trying to get the data from this site and unfortunately it doesn't
> > seem to use standard tables
> >
> > e.g. http://stock2own.com/StockAnalyzer.aspx?s=US:AAPL
> >
> > i want to get the values for growth rates, and the values under "value
> > price" on the left hand side.
> >
> > Can someone point me in the right direction?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
5d.

Re: Any way to pull data off this site - stock2own?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Dec 9, 2011 5:31 pm (PST)



Just a simple extract:

=0+smfStrExtr(RCHGetTableCell("http://stock2own.com/StockAnalyzer.aspx?s="&E11,0,">Growth
Rate")&"|","Grade","|")

On Fri, Dec 9, 2011 at 6:22 PM, staspmr <staspmr@yahoo.ca> wrote:

> Thanks, I see what you did. I was thinking if there was a way to pull the
> data directly from the page.
>
> e.g. I am trying to get the growth rate (e.g. 100.00) so I enter
> =RCHGetTableCell("http://stock2own.com/StockAnalyzer.aspx?s=US:AAPL",0,"Growth
> Rates","growth Grade")
>
> but it returns "Growth RatesgoodGrowth Grade100.00" i guess because it is
> like a cell on that page.
>
> Any way to separate out the 100.00?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
5e.

Re: Any way to pull data off this site - stock2own?

Posted by: "staspmr" staspmr@yahoo.ca   staspmr

Fri Dec 9, 2011 5:51 pm (PST)



Thanks again!

I am trying to understand though what the > and | does in >Growth Rate")&"|" ?

I didn't have any luck finding it in the documentation for the functions.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Just a simple extract:
>
> =0+smfStrExtr(RCHGetTableCell("http://stock2own.com/StockAnalyzer.aspx?s="&E11,0,">Growth
> Rate")&"|","Grade","|")
>
> On Fri, Dec 9, 2011 at 6:22 PM, staspmr <staspmr@...> wrote:
>
> > Thanks, I see what you did. I was thinking if there was a way to pull the
> > data directly from the page.
> >
> > e.g. I am trying to get the growth rate (e.g. 100.00) so I enter
> > =RCHGetTableCell("http://stock2own.com/StockAnalyzer.aspx?s=US:AAPL",0,"Growth
> > Rates","growth Grade")
> >
> > but it returns "Growth RatesgoodGrowth Grade100.00" i guess because it is
> > like a cell on that page.
> >
> > Any way to separate out the 100.00?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
5f.

Re: Any way to pull data off this site - stock2own?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Dec 9, 2011 5:57 pm (PST)



Check the "Documentation" folder in the files area -- 7.1a for smfStrExtr().

The ">" is the ending of an HTML tag in the source code of the web page. I
often use it to distinguish a search string. Otherwise, if you just use
"Growth Rate", it could appear anywhere in the source code -- as
descriptive text, in the meta data of the web page, in a comment, etc. You
really do need to examine the source code of the web page to find and
verify unique strings -- sometimes straightforward, other times not.

The "|" is just a dummy character I added to mark the end of the string so
the function knows where the end of the extraction is.

On Fri, Dec 9, 2011 at 6:51 PM, staspmr <staspmr@yahoo.ca> wrote:

>
> I am trying to understand though what the > and | does in >Growth
> Rate")&"|" ?
>
> I didn't have any luck finding it in the documentation for the functions.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
Recent Activity
Visit Your Group
Yahoo! News

Get it all here

Breaking news to

entertainment news

Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 01.52

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)