2 Messages

Digest #3159

morningstar forward comparisons by cgrauballe

Re: morningstar forward comparisons by "Randy Harmelink" rharmelink

Messages

1a

morningstar forward comparisons

Sat Aug 23, 2014 2:01 pm (PDT) . Posted by:

cgrauballe

Hi all, i have a problem with retrieving som data from morningstar. The URL is: =financials.morningstar.com/valuation/forward-comparisons-list.action?&t=GOOGL

Ive tried creating an array with the following, but it doesnt quite help me,

RCHGetHTMLTable("financials.morningstar.com/valuation/forward-comparisons-list.action?&t="&TICKER,"Forward Comparisons",1,"",1)

Hope anyone has the time to help!

best regards Caspar

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

1b

Re: morningstar forward comparisons

Sat Aug 23, 2014 4:38 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Your URL in your formula is missing the "http://" prefix. Add that and it
works fine.

Note that the items on that web page have been defined as elements. See the
SMF-Template-Morningstar-Stock-Data.xls template on the website.

On Sat, Aug 23, 2014 at 1:59 PM, cgrauballe@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Hi all, i have a problem with retrieving som data from morningstar. The
> URL is: =
> financials.morningstar.com/valuation/forward-comparisons-list.action?&t=GOOGL
>
> Ive tried creating an array with the following, but it doesnt quite help
> me,
>
> RCHGetHTMLTable("
> financials.morningstar.com/valuation/forward-comparisons-list.action?&t="&TICKER,"Forward
> Comparisons",1,"",1)
>
> Hope anyone has the time to help!
>