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.3 comments to Stock Dividend Data Downloader. |
Excel Based Automated Channels. Updated every five minutes (9:05 EST to 4:15 EST). Click image for full size.
|
|
|
Copyright © 2010 ExcelTrader - All Rights Reserved |
||
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!