I'm not even aware of a source of the data on Reuters...

On Wed, Mar 12, 2014 at 12:28 AM, <lawrence.leesh@yahoo.com> wrote:

>
> Is there a way to retrieve prices by date via reuters? Some stocks don't
> have historical prices in Yahoo.
>

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

2a

Re: Morningstar dynamic pages (stupid questions)

Wed Mar 12, 2014 7:50 am (PDT) . Posted by:

"Philip Raphals"

Randy,

Apologies for a stupid question:

I am new to your system, and can't get it to work
right. xla is installed, but:

When I paste in the INDEX formula below, I just
get "Year-End Yield %" in each cell. No
data. I've also tried entering it as an array, unsuccessfully ...

Also, when I tried adding the Canada ("ca")
server to your GetYahooQuotes command
(=RCHGetYahooQuotes(A3:A21,B1:I1,ca,NOW())), I get #VALUE! in each cell.

I there a "For Dummies" page somewhere that will
answer all these boring questions?

Thanks!

Phil

At 12:23 AM 12/03/2014, Randy Harmelink wrote:

>
>
>Sure, either across a row:
>
>=INDEX(RCHGetHTMLTable("<http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=GIS>http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=GIS","",1,"",1,,6,26),6)
>
>...or down a column:
>
>=TRANSPOSE(INDEX(RCHGetHTMLTable("<http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=GIS>http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=GIS","",1,"",1,,6,26),6))
>
>On Tue, Mar 11, 2014 at 9:03 PM, Jacob Jose
><<mailto:pepecan47@yahoo.ca>pepecan47@yahoo.ca> wrote:
>Hey Randy, this is amazing. Is there a way to
>get all this data as an array? I love the year end yield.
>
>I used to get the dividend history from Yahoo,
>but I am fed up, too many errors and omissions.
>
>
>

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

2b

Re: Morningstar dynamic pages (stupid questions)

Wed Mar 12, 2014 8:31 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

On Wed, Mar 12, 2014 at 6:28 AM, Philip Raphals <philip@centrehelios.org>wrote:

>
> When I paste in the INDEX formula below, I just get "Year-End Yield %" in
> each cell. No data. I've also tried entering it as an array,
> unsuccessfully ...
>

You're array-entering it into a range, right? Not array-entering it into a
single cell and copying it?

> Also, when I tried adding the Canada ("ca") server to your GetYahooQuotes
> command (=RCHGetYahooQuotes(A3:A21,B1:I1,ca,NOW())), I get #VALUE! in each
> cell.
>

EXCEL shouldn't allow you to enter that, since the "ca" without double
quotes would be a formula error. However, this works fine for me:

=RCHGetYahooQuotes(A3:A21,B1:I1,"ca",NOW())

...but it may depend on what you have in cells A3:A21 and B1:I1. I don't
believe the "server id" is used by Yahoo any more. I've left it in the
function in case they go back to using the regional servers. I don't think
it hurts anything if you use it.

I there a "For Dummies" page somewhere that will answer all these boring
> questions?
>

The Documentation and the Tips and FAQs items cover most of it.

http://ogres-crypt.com/SMF/