Messages In This Digest (3 Messages)

Messages

1a.: Re: Help!!

Posted by: "gordonbruce@btopenworld.com" GordonBruce@btopenworld.com gordonbruce@btopenworld.com

Wed May 9, 2012 3:48 am (PDT)

Randy, that's great! Many thanks for your prompt help.

Regards
Gordon

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> This works for me:
>
> =RCHGetTableCell("
> http://www.morningstar.co.uk/uk/snapshot/snapshot.aspx?id=VAUSA07HRO&investmenttype=SA",2,"ABI
> Sector")
>
> ...and returns:
>
> Asia Pacific excl. Japan Equities (Pen)
>
> On Tue, May 8, 2012 at 1:45 PM, gordonbruce@... <
> GordonBruce@...> wrote:
>
> > As a beginner I am struggling to understand this well enough.
> >
> > I do appreciate your time must be limited but I would very much appreciate
> > any help you can provide to help me construct the =RCHGetTableCell formula
> > to retrieve data from the "Key Stats" table on the following web page-
> >
> >
> > http://www.morningstar.co.uk/uk/snapshot/snapshot.aspx?id=VAUSA07HRO&investmenttype=SA
> >
> > I think I would be able to get the rest of the data I require if you could
> > give me an example of what I need to do to achieve one result from this
> > table. I am able to retrieve data from the left of the web page but can't
> > get at the data in the "Key Stats" table.
> >
>

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

2a.: Monthly price spreadsheet

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

Wed May 9, 2012 12:17 pm (PDT)

I am looking for a spreadsheet that will lookup monthly prices for say 10 years.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.: Re: Monthly price spreadsheet

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

Wed May 9, 2012 12:19 pm (PDT)

Just use the RCHGetYahooHistory() function. One of the parameters tells
Yahoo to return monthly data.

On Wed, May 9, 2012 at 12:17 PM, almondtree <almondtree@yahoo.com> wrote:

> I am looking for a spreadsheet that will lookup monthly prices for say 10
> years.
>

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

Messages | Files | Photos | Polls