Messages In This Digest (4 Messages)
- 1a.
- Re: how to extrack text from ticker symbol From: Randy Harmelink
- 2a.
- Re: Get Yahoo Quotes From: Randy Harmelink
- 3a.
- Re: Is there a way to get NYSE daily number of new highs and new low From: Jacob Jose
- 3b.
- Re: Is there a way to get NYSE daily number of new highs and new low From: Randy Harmelink
Messages
- 1a.
-
Re: how to extrack text from ticker symbol
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Aug 14, 2011 2:22 pm (PDT)
You either need to add the hyperlink to the cell (an option on the
right-click context menu), or use EXCEL's hyperlink function:
=hyperlink("
http://investing.businessweek. com/research/ stocks/financial s/financials. asp?ticker=
"&B5,"Link")
In the future, please direct questions about EXCEL that are not related to
the add-in to an EXCEL Yahoo group. Thanks.
On Sun, Aug 14, 2011 at 12:36 PM, Hong Chong NG <nghongchong@hotmail.com >wrote:
>
> i still cant get it to work, how will you make it work please?
>
> I tried putting the
> http://investing.businessweek. <http://investing.com/research/ stocks/financial s/financials. asp?ticker businessweek. > incom/research/ stocks/financial s/financials. asp?ticker= $C$5
> one cell. (
>
> Then I use =b24&c5, I got this, "
> http://investing.businessweek. <http://investing.com/research/ stocks/financial s/financials. asp?ticker businessweek. >=ntes".com/research/ stocks/financial s/financials. asp?ticker= $C$5
> But its not a hyperlink, just plain text.
>
- 2a.
-
Re: Get Yahoo Quotes
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Aug 14, 2011 2:25 pm (PDT)
The uncommon ones I don't list are mostly for HTML markup. I don't know of
any for the additional items on the Key Statistics page. If I did, they
would already be in the documentation.
In general, the codes are the same ones that are used for Yahoo's
portfolios. I have included many that are not documented by Yahoo, at least
no where that I know of.
On Sun, Aug 14, 2011 at 1:08 PM, sterob <anticato124@gmail.com > wrote:
> In the documentation for the RCHGetYahooQuotes function, it says that the
> codes listed are the most commonly used. Does that mean that there are codes
> to use the function for other data on the Yahoo Key Statistics page? If so,
> could you tell us what they are?
>
- 3a.
-
Re: Is there a way to get NYSE daily number of new highs and new low
Posted by: "Jacob Jose" pepecan47@yahoo.ca pepecan47
Sun Aug 14, 2011 3:13 pm (PDT)
Thank you Randy, does anybody know another source for market internals?
Another question, where can I get the P/E for the S&P500?
Regards,
Jose L. Jacob
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Sunday, August 14, 2011 3:21:31 PM
Subject: Re: [smf_addin] Is there a way to get NYSE daily number of new highs and new lows?
No idea, but take a look at the "About" tab at http://unicorn.us.com/advdec
On Sun, Aug 14, 2011 at 12:01 PM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
>I use SMF-Template-Barchart- Market-Momentum. xls from the files area to get market momentum information.
>
>Randy, do you know why the values in this spreadsheet are different than the ones in http://unicorn.us.com/advdec/
>
>
- 3b.
-
Re: Is there a way to get NYSE daily number of new highs and new low
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Aug 14, 2011 3:57 pm (PDT)
You can pull it from the main SPY page on Yahoo:
=RCHGetTableCell("http://finance. yahoo.com/ ",1,">P/E")q?s=spy
Another option is to get it from Yahoo's ETF browser, which would be more
efficient if you want to pull data on a number of ETFs:
=RCHGetTableCell("
http://finance.yahoo.com/ etf/browser/ hl?c=0&k= 5&f=0&o=d& cs=1&ce=1254
",4,">SPY<")
On Sun, Aug 14, 2011 at 3:13 PM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
> Another question, where can I get the P/E for the S&P500?
>
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar