The following (free) file downloads dividend data.
- Ex Dividend Date
- Dividend pay date.
- Dividend Yield.
The instructions are:
- Enter your symbols in Column A
- Press the “Get Dividend Data” button.
Below is an image of the file.
Stock Dividend Data Downloader.
February 21, 2010 By 7 Comments
Hi,
I want to ask you about the ‘Stock Dividend Data Downloader’ utility that you provide at your site. I see that it downloads quickly the dividend dates of symbols such as BAC and JPM from yahoo. How can I get the dates for their derivatives and preferred stocks that pay dividend. In yahoo they are spelled with a ticker such as BAC-PH or JPM-PZ, but when I enter them like this it doesn’t download the dividend date. Please help me out.
In order for the excel program to retrieve the dates, they must be available from yahoo. It looks like dividend data is not available from yahoo for those symbols (yahoo shows “N/A”)
Your Earnings and Dividend downloader are great!
Can you write a similar macro to retreive
“Days To Cover (Short Interest Ratio)” and “Short Percent of Float” or any other relevant numbers?
Some sources i found here:
http://shortsqueeze.com/?symbol=EMC
http://www.nasdaq.com/aspxcontent/shortinterests.aspx?symbol=EMC&selected=EMC
but there could be better and more reliable sources.
Thanks!
i have to ask where you are downloading data from. you say earlier yahoo, but this doesnt make sense. alliancebernstein (ab) is a 2.2% yield according to the site itself but the spreadsheet spits out 6.91%
The yield is from yahoo. Here is the direct link http://quote.yahoo.com/d/quotes.csv?s=AB&f=y. Thanks for reporting the issue though. It does appear that the yield of 6.93 is a historical yield. In a future update I will add the future yield. (all of which are available here.)
Can you add the actual dividend amount that has been declared? Since the yield changes based on the price of the stock I would rather see the amount of the dividend.
How do I get it to give me the dividend amount.