15 Messages
Digest #3325
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?
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?
>
>
>
>
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.
> Pacific Corp), it shows for Div & Yield 2.20 (1.80%). However, if I
> retrieve the same information using RCHGetYahooQuotes(
> RCHGetYahooQuotes(
>
> 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?
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?
>
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
> 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.
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.
>
# 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
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?
>
>
>
>
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
_____
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
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
_____
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
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?
>
>
>
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?
_____
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"
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?
=+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"
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
>
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
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:
Posting Komentar