Messages In This Digest (5 Messages)

Messages

1a.: Why does this formula produce an error

Posted by: "David" nicholasdavid@comcast.net dnicholas4967

Sun Oct 16, 2011 7:22 am (PDT)

=RCHGetTableCell("http://finance.yahoo.com/q/ks?s="&$A1&"+Key+Statistics",1,"Market Cap (intraday) :")

A1 is on the page that holds this formula
A1 =MCHP

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.: Re: Why does this formula produce an error

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

Sun Oct 16, 2011 9:45 am (PDT)

Because the "Market Cap (intraday) :" string is not in the source code of
the web page. If you look at the web page, you'll notice it has a "5" tag on
it for the footnotes. The actual source code for that table cell is:

<td class="yfnc_tablehead1" width="74%">Market Cap (intraday)<font
size="-1"><sup>5</sup></font>:</td>

...so you have a lot of data between "(intraday)" and ":".

What I use is:

=RCHGetTableCell("http://finance.yahoo.com/q/ks?s="&$A1,1,">Market Cap")

On Sun, Oct 16, 2011 at 7:22 AM, David <nicholasdavid@comcast.net> wrote:

> =RCHGetTableCell("http://finance.yahoo.com/q/ks?s="&$A1&"+Key+Statistics",1,"Market
> Cap (intraday) :")
>
> A1 is on the page that holds this formula
> A1 =MCHP
>

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

2a.: Re: Fair Value - Automated.xls

Posted by: "KailuaKid" Gary.Hartling@gmail.com garyhartling

Sun Oct 16, 2011 11:15 am (PDT)

This formula seems to work to get the corporate bond yield:

=RCHGetTableCell("http://finance.yahoo.com/bonds/composite_bond_rates",1,"Corporate Bonds","20yr AAA")&"%"

If you take the "$" out of the formulas in the first 11 rows in Column "C" you can copy the formulas to the right to create more columns if you have more than 10 tickers in your portfolio and you want to compare them all at once.

Thanks for a great spreadsheet!
Gary H.

--- In smf_addin@yahoogroups.com, osmangulseven@... wrote:
>
>
>
> --- In smf_addin@yahoogroups.com, "kiwi2y_98" <kiwi2y_98@> wrote:
> >
> > Great work!
> > Question -- Are the exponents missing in the calculations,
> > rows 23 thru 27, columns A thru J ?
> > thanks again.
> >
>
> No, they are not. The upper boundary includes the book value, and lower boundary does not. Nevertheless, there is a minor issue with the file. I should have automated the bond yields. It says 4.49% (30 yr AAA corporate bond yield) on the file, but that is static. Yahoo Finance has the data on corporate bond yields as well as treasuries:
>
> http://finance.yahoo.com/bonds/composite_bond_rates
>

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

3a.: Extracting data from Google Finance

Posted by: "skml88" skml88@gmail.com skml88

Sun Oct 16, 2011 11:49 pm (PDT)

Hi Randy,

I would like to extract data from the Related Companies section of Google Finance into a table. How can I do this? They don't seem to be located within the usual tags.

http://www.google.com/finance?q=aapl

I would greaty appreciate your help. Thanks.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.: Re: Extracting data from Google Finance

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

Mon Oct 17, 2011 12:00 am (PDT)

No. The data is within JavaScript. See:

http://finance.groups.yahoo.com/group/smf_addin/message/14738
http://finance.groups.yahoo.com/group/smf_addin/message/8487

On Sun, Oct 16, 2011 at 10:36 PM, skml88 <skml88@gmail.com> wrote:

>
> I would like to extract data from the Related Companies section of Google
> Finance into a table. How can I do this? They don't seem to be located
> within the usual tags.
>
> http://www.google.com/finance?q=aapl
>
> I would greaty appreciate your help. Thanks.
>

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

Messages | Files | Photos | Polls

MARKETPLACE