Minggu, 15 Februari 2015

[smf_addin] Digest Number 3325

15 Messages

Digest #3325
1a
Accuracy of Data by rjemery7
1b
Re: Accuracy of Data by "Randy Randall" randyr_cds
1c
1d
Re: Accuracy of Data by "Randy Harmelink" rharmelink
1e
1f
Re: Accuracy of Data by "Randy Harmelink" rharmelink
2a
Ex-Dividend Date by "D. Scott MacKenzie" kb0fhp
2b
Re: Ex-Dividend Date by "Randy Harmelink" rharmelink
2c
Re: Ex-Dividend Date by "D. Scott MacKenzie" kb0fhp
2d
Re: Ex-Dividend Date by "D. Scott MacKenzie" kb0fhp
2e
Re: Ex-Dividend Date by "Randy Harmelink" rharmelink
2f
Re: Ex-Dividend Date by "D. Scott MacKenzie" kb0fhp
2g
Re: Ex-Dividend Date by "D. Scott MacKenzie" kb0fhp
2h
Re: Ex-Dividend Date by "Randy Harmelink" rharmelink
2i
Re: Ex-Dividend Date by "D. Scott MacKenzie" kb0fhp

Messages

Sun Feb 15, 2015 1:41 pm (PST) . Posted by:

rjemery7

For w/e 2/13/15 and using finance.yahoo.com to check on symbol UNP (Union Pacific Corp), it shows for Div & Yield 2.20 (1.80%). However, if I retrieve the same information using RCHGetYahooQuotes("UNP","d") and RCHGetYahooQuotes("UNP","y", I get 1.91 and 1.54% respectively).

Please comment on the discrepancy in the data. How do I retrieve what is shown on the website?


Sun Feb 15, 2015 2:08 pm (PST) . Posted by:

"Randy Randall" randyr_cds

The RCHGetYahooQuotes uses the CSV file to get the data. The information
returned is the trailing annual dividend/rate. The other information is
the forward annual dividend/rate.

The download for the SMF add-in contains a spreadsheet with element
definitions for use the RCHGetElementNumber function. You should be able
to find what you want in there.

Randy Randall

On Sun, Feb 15, 2015 at 4:41 PM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> For w/e 2/13/15 and using finance.yahoo.com to check on symbol UNP (Union
> Pacific Corp), it shows for Div & Yield 2.20 (1.80%). However, if I
> retrieve the same information using RCHGetYahooQuotes("UNP","d") and
> RCHGetYahooQuotes("UNP","y", I get 1.91 and 1.54% respectively).
>
> Please comment on the discrepancy in the data. How do I retrieve what is
> shown on the website?
>
>
>
>

Sun Feb 15, 2015 4:32 pm (PST) . Posted by:

rjemery7

According to your Element-Definitions spreadsheet, the Element Number 989 is the Dividend and 990 is the Dividend Yield. Using those numbers in RCHGetElementNumber("UNP",989) and RCHGetElementNumber("UNP",990), the data returned does not match what is displayed on the finance.yahoo webpage. This is true for a number of symbols and is not an isolated case as I have belatedly found.

1) For each symbol, how can one access what is actually displayed on the webpage, regardless if it is trailing, forward or current?

2) Perhaps a better source might be finviz.com. If so, how might one extract the data therefrom?

Sun Feb 15, 2015 4:38 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27953

On Sun, Feb 15, 2015 at 5:32 PM, rjemery@... wrote:

>
> According to your Element-Definitions spreadsheet, the Element Number 989
> is the Dividend and 990 is the Dividend Yield. Using those numbers in
> RCHGetElementNumber("UNP",989) and RCHGetElementNumber("UNP",990), the data
> returned does not match what is displayed on the finance.yahoo webpage.
> This is true for a number of symbols and is not an isolated case as I have
> belatedly found.
>
> 1) For each symbol, how can one access what is actually displayed on the
> webpage, regardless if it is trailing, forward or current?
>
> 2) Perhaps a better source might be finviz.com. If so, how might one
> extract the data therefrom?
>

Sun Feb 15, 2015 5:35 pm (PST) . Posted by:

rjemery7

Closer, but still no cigar.

For Verizon (VZ), element Numbers 4924 and 4925 return 2.16 and 4.40% respectively.

finance.yahoo and finviz.com reports 2.20 and 4.50% respectively.

Sun Feb 15, 2015 6:01 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I get $2.20 and 4.5% for VZ using elements 4924 and 4925:

# VZ Source Element 991 Feb 2, 2015 YahooKS Dividend Date 992 Jan 7, 2015
YahooKS Ex-Dividend Date 4924 $2.20 YahooKS Forward Annual Dividend Rate
4925 4.5% YahooKS Forward Annual Dividend Yield 4926 $2.16 YahooKS Trailing
Annual Dividend Rate 4927 4.4% YahooKS Trailing Annual Dividend Yield 4928
4.9% YahooKS 5 Year Average Dividend Yield 4929 88% YahooKS Payout Ratio

On Sun, Feb 15, 2015 at 6:35 PM, rjemery@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Closer, but still no cigar.
>
> For Verizon (VZ), element Numbers 4924 and 4925 return 2.16 and 4.40%
> respectively.
>
> finance.yahoo and finviz.com reports 2.20 and 4.50% respectively.
>

Sun Feb 15, 2015 3:23 pm (PST) . Posted by:

"D. Scott MacKenzie" kb0fhp

How do I grab the Ex-Dividend date and amount from either yahoo, google or
Morningstar?

Thank you - wonderful add-in

Sun Feb 15, 2015 3:36 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The following items are available for RCHGetElementNumber() and come from
Yahoo's Key Statistics web page:

# Source Element 991 YahooKS Dividend Date 992 YahooKS Ex-Dividend Date
4924 YahooKS Forward Annual Dividend Rate 4925 YahooKS Forward Annual
Dividend Yield 4926 YahooKS Trailing Annual Dividend Rate 4927
YahooKS Trailing
Annual Dividend Yield 4928 YahooKS 5 Year Average Dividend Yield 4929
YahooKS Payout Ratio

On Sun, Feb 15, 2015 at 10:47 AM, 'D. Scott MacKenzie' kb0fhp@...wrote:

>
> How do I grab the Ex-Dividend date and amount from either yahoo, google
> or Morningstar?
>
>
>
>

Sun Feb 15, 2015 4:41 pm (PST) . Posted by:

"D. Scott MacKenzie" kb0fhp

Thank you

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, February 15, 2015 6:36 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Ex-Dividend Date

The following items are available for RCHGetElementNumber() and come from
Yahoo's Key Statistics web page:

#

Source

Element

991

YahooKS

Dividend Date

992

YahooKS

Ex-Dividend Date

4924

YahooKS

Forward Annual Dividend Rate

4925

YahooKS

Forward Annual Dividend Yield

4926

YahooKS

Trailing Annual Dividend Rate

4927

YahooKS

Trailing Annual Dividend Yield

4928

YahooKS

5 Year Average Dividend Yield

4929

YahooKS

Payout Ratio

On Sun, Feb 15, 2015 at 10:47 AM, 'D. Scott MacKenzie' kb0fhp@...wrote:

How do I grab the Ex-Dividend date and amount from either yahoo, google or
Morningstar?

B

Sun Feb 15, 2015 5:56 pm (PST) . Posted by:

"D. Scott MacKenzie" kb0fhp

OK tried that - and I got "Error" What did I do wrong?

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, February 15, 2015 6:36 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Ex-Dividend Date

The following items are available for RCHGetElementNumber() and come from
Yahoo's Key Statistics web page:

#

Source

Element

991

YahooKS

Dividend Date

992

YahooKS

Ex-Dividend Date

4924

YahooKS

Forward Annual Dividend Rate

4925

YahooKS

Forward Annual Dividend Yield

4926

YahooKS

Trailing Annual Dividend Rate

4927

YahooKS

Trailing Annual Dividend Yield

4928

YahooKS

5 Year Average Dividend Yield

4929

YahooKS

Payout Ratio

On Sun, Feb 15, 2015 at 10:47 AM, 'D. Scott MacKenzie' kb0fhp@...wrote:

How do I grab the Ex-Dividend date and amount from either yahoo, google or
Morningstar?

B

Sun Feb 15, 2015 6:18 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

What ticker symbol did you try?

On Sun, Feb 15, 2015 at 6:56 PM, 'D. Scott MacKenzie' kb0fhp@...wrote:

>
> OK tried that - and I got "Error" What did I do wrong?
>
>
>

Sun Feb 15, 2015 6:25 pm (PST) . Posted by:

"D. Scott MacKenzie" kb0fhp

Mutual fund - VBTLX

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, February 15, 2015 9:18 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Ex-Dividend Date

What ticker symbol did you try?

On Sun, Feb 15, 2015 at 6:56 PM, 'D. Scott MacKenzie' kb0fhp@...wrote:

OK tried that - and I got "Error"B What did I do wrong?

Sun Feb 15, 2015 6:41 pm (PST) . Posted by:

"D. Scott MacKenzie" kb0fhp

This is the formula I used:

=+RCHGetElementNumber("VBTLX", 991)

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, February 15, 2015 9:18 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Ex-Dividend Date

What ticker symbol did you try?

On Sun, Feb 15, 2015 at 6:56 PM, 'D. Scott MacKenzie' kb0fhp@...wrote:

OK tried that - and I got "Error"B What did I do wrong?

Sun Feb 15, 2015 6:49 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The element numbers I cited would only work for stocks, because funds don't
have "Key Statistics" web pages, which is where the data is extracted from.
Where on Yahoo do you see the dividend amount and ex-dividend date for
mutual funds? Or Google?

Data sources often display data differently for stocks and mutual funds and
ETFs, so you may need to use different extraction formulas. For some data
items, the same formula works. For other data items, no.

I suppose you could use Yahoo historical quotes, but that would only give
you the historical ex-dividend dates and amounts, not declared ones.

What to retrieve would depend a great deal on what you plan to do with it.
For example, you only mention dividends, but mutual funds can also have
capital gains distributions.

On Sun, Feb 15, 2015 at 7:25 PM, 'D. Scott MacKenzie' kb0fhp@...wrote:

>
> Mutual fund - VBTLX
>

Sun Feb 15, 2015 6:57 pm (PST) . Posted by:

"D. Scott MacKenzie" kb0fhp

Oh - I didnt know that. I found the distribution data on Morningstar and
thought that Yahoo or Google would have the same. Sorry - I wasnt aware of
that.

Scott

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, February 15, 2015 9:49 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Ex-Dividend Date

The element numbers I cited would only work for stocks, because funds don't
have "Key Statistics" web pages, which is where the data is extracted from.
Where on Yahoo do you see the dividend amount and ex-dividend date for
mutual funds? Or Google?

Data sources often display data differently for stocks and mutual funds and
ETFs, so you may need to use different extraction formulas. For some data
items, the same formula works. For other data items, no.

I suppose you could use Yahoo historical quotes, but that would only give
you the historical ex-dividend dates and amounts, not declared ones.

What to retrieve would depend a great deal on what you plan to do with it.
For example, you only mention dividends, but mutual funds can also have
capital gains distributions.

On Sun, Feb 15, 2015 at 7:25 PM, 'D. Scott MacKenzie' kb0fhp@...wrote:

Mutual fund B - VBTLX

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar