Their current quotes CSV file has always brought in the trailing dividend,
as far as I know. They only added the forward annual dividend items to
their key statistics page a few years ago, and I don't think the CSV file
was ever modified for the update.
If you're interest in their API feeds, instead of just the CSV file, here
are a number of them, some of which I just recently added to my add-in:
Current quotes:
http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20%28%22YHOO%22%2C%22AAPL%22%2C%22GOOG%22%2C%22MSFT%22%29%0A%09%09&diagnostics=true&env=http%3A%2F%2Fdatatables.org%2Falltables.env
Historical quotes:
http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.historicaldata%20where%20symbol%20%3D
%20%22YHOO%22%20and%20startDate%20%3D%20%222009-09-11%22%20and
%20endDate%20%3D%20%222010-03-10%22&diagnostics=true&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys
Options (next expiration):
http://query.yahooapis.com/v1/public/yql?q=SELECT%20*%20FROM%20yahoo.finance.options%20WHERE%20(symbol%3D'MMM')&env=http%3A%2F%2Fdatatables.org%2Falltables.env
Options (specified expiration months):
http://query.yahooapis.com/v1/public/yql?q=SELECT%20*%20FROM%20yahoo.finance.options%20WHERE%20symbol=%22MMM%22%20AND%20expiration%20in%20%28%222013-01%22,%222013-02%22%29&env=http://datatables.org/alltables.env
Options (all contracts):
http://query.yahooapis.com/v1/public/yql?q=SELECT%20*%20FROM%20yahoo.finance.options%20WHERE%20symbol=%22SPY%22%20AND%20expiration%20in%20%28SELECT%20contract%20FROM%20yahoo.finance.option_contracts%20WHERE%20symbol=%22SPY%22%29&env=http%3A%2F%2Fdatatables.org%2Falltables.env
On Tue, Jan 8, 2013 at 1:50 PM, David who1012000@yahoo.com> wrote:
>
> Happy New Year to all. I have used this before, but it seems to have lost
> it's consistancy or may has changed?
>
> Link to the API stuff:
> http://greenido.wordpress.com/2009/12/22/yahoo-finance-hidden-api/
>
> Recently I was trying to bring in the Dividend and Yield, thus I was using:
> myurl = "http://download.finance.yahoo.com/d/quotes.csv?s=" & Symbol &
> "&f=dy"
>
> but it seems to bring in the wrong dividend sometimes, bring in the
> Trailing Annual Dividend Yield in the place of the dividend. Has anyone
> else experienced this? Is this a Yahoo inconsistancy that is just the way
> it is?
>
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar