3 New Messages

Digest #2813

Re: Formula for Yahoo balance sheet sub-categories by joelfp2000

Element not working by joelfp2000

Re: Element not working by "Randy Harmelink" rharmelink

Messages

1a

Re: Formula for Yahoo balance sheet sub-categories

Wed Oct 16, 2013 8:54 pm (PDT) . Posted by:

joelfp2000

Randy,
Awesome. Thank you very much. Joel

---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:

Randy,
I have two questions...and as always thanks for your help.

1.) I use the following formula to obtain the total assets of a stock, say "msft" that is located in cell c4.
=RCHGetTableCell("http://finance.yahoo.com/q/bs?s="&C4,1,"Total Assets")

What do I need to change in the formula to obtain an indented piece of information on the balance sheet, say Inventory which is a sub category of Current Assets?

2.) What change to the formula do I need to make to obtain the annual balance sheet instead of quarterly? I know I need to add an &annual but I can't figure out where to include it in the formula.

Thanks so much for your help!
Joel

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

2a

Element not working

Wed Oct 16, 2013 8:57 pm (PDT) . Posted by:

joelfp2000

Randy,

Great work on the AdvFN!

FYI..element #25 (MSN last price) and element # 848 (Zack's ranking) don't seem to be working.

Joel

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Re: Element not working

Wed Oct 16, 2013 9:44 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

This worked fine for me:

=RCHGetElementNumber("MMM";,848)

Element #25 has been obsoleted. MSN was posting the previous day's closing
price for "Last Price" since early last year. You should use
RCHGetYahooQuotes() for current quotes.

On Wed, Oct 16, 2013 at 8:57 PM, <joel.andrews@lpl.com> wrote:

>
> Randy,
>
> Great work on the AdvFN!
>
> FYI..element #25 (MSN last price) and element # 848 (Zack's ranking) don't
> seem to be working.
>
> Joel
>