3 New Messages

Digest #2937

Re: RCHGetYahooQuotes Problem by "Randy Harmelink" rharmelink

Re: RCHGetYahooQuotes Problem by "rumplestilskin" stanfordpatrick@sbcglobal.net

Re: Extracting Fidelity Fund Identifiers by mjdaumer

Messages

1a

I'll reiterate Mike's response that trailing figures are the only truly
accurate ones, since forward figures are estimates that can change.
However, I will strongly agree that forward figures are more useful in many
situations.

And he is also correct that you would need to use RCHGetElementNumber() to
get the data, since Yahoo never added Yahoo codes for the forward figures
when they added the data to their web site. However, note that
RCHGetElementNumber() will need to to an Internet access for each web page
you grab data from, so it could be very slow if you have a lot of ticker
symbols.

On Tue, Jan 21, 2014 at 2:44 PM, rumplestilskin <
stanfordpatrick@sbcglobal.net> wrote:

>
> I've managed to build a spreadsheet that uses the RCHgetyahooQuotes
> function in an array and it works well, using the codes such as n for
> name, I1 which pulls in last trade, c for change, r for PE ratio, etc.
>
> However, I noticed that the dividend per share d, and dividend yield y,
> are pulling in trailing figures and hence are not accurate.
>
> Does anyone know if there are codes for RCHgetyahooquotes that pull in the
> current dividend and current yield (also referred to on the yahoo site as
> "forward")
>
> If there are no codes for this, what function would be a good replacement
> for RCHgetyahooquotes to utilize in an array (which I built using Randy's
> small example)?
>
> Any help will be greatly appreciated.
>

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

1b

Re: RCHGetYahooQuotes Problem

Tue Jan 21, 2014 6:35 pm (PST) . Posted by:

"rumplestilskin" stanfordpatrick@sbcglobal.net

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I'll reiterate Mike's response that trailing figures are the only truly
> accurate ones, since forward figures are estimates that can change.
> However, I will strongly agree that forward figures are more useful in many
> situations.
>
> And he is also correct that you would need to use RCHGetElementNumber() to
> get the data, since Yahoo never added Yahoo codes for the forward figures
> when they added the data to their web site. However, note that
> RCHGetElementNumber() will need to to an Internet access for each web page
> you grab data from, so it could be very slow if you have a lot of ticker
> symbols.
>
> On Tue, Jan 21, 2014 at 2:44 PM, rumplestilskin <
> stanfordpatrick@...> wrote:
>
> >
> > I've managed to build a spreadsheet that uses the RCHgetyahooQuotes
> > function in an array and it works well, using the codes such as n for
> > name, I1 which pulls in last trade, c for change, r for PE ratio, etc.
> >
> > However, I noticed that the dividend per share d, and dividend yield y,
> > are pulling in trailing figures and hence are not accurate.
> >
> > Does anyone know if there are codes for RCHgetyahooquotes that pull in the
> > current dividend and current yield (also referred to on the yahoo site as
> > "forward")
> >
> > If there are no codes for this, what function would be a good replacement
> > for RCHgetyahooquotes to utilize in an array (which I built using Randy's
> > small example)?
> >
> > Any help will be greatly appreciated.
> >
>

Randy and Mike

Thanks to both of you for your answers.

I noticed the difference in trailing and forward dividends when I realized one of my stocks is paying me more than quoted by the dividend code (d) in my spread sheet, and in fact the "current" dividend on the yahoo summary page is the same as the "forward" dividend on the key statistics page, and the "trailing"; dividend is no longer relevant.

Its not a really big deal and certainly not worth abandoning all the hours of work I've done to get the array working well (which I then use as a source for a vlookup function to put stock data on different sheets by industry in my workbook... all very fast and efficient.)

The array rchgetyahooquotes is really fast and seems very reliable

A very clever and elegant solution to pull in stock data.

Thanks again