Earnings.xls automatically downloads and fills in the expected earnings dates from zacks clearstation and yahoo.
1. Download the file earnings.xls (last updated 8/6/2010 to fix Clearstation error)
Initial Setup: (steps 2-3 only have to be done once)
2. Press alt + F11
3. From the Microsoft Visual Basic Menu, Select TOOLS, select REFERENCES, then find “Microsoft Internet Controls” and place a checkmark next to it. Click OK and Exit everything.
If Microsoft Internet Controls is not listed, click the browse button and browse to system32shdocvw.dll. Then it will appear in the list.
4. Import, paste or type symbols into column A
5. Press the “Get Earnings” button.
Earnings dates will fill in.
If earnings.xls does not pull in the dates:
Earnings.xls opens 3 websites (in hidden instances of Internet explorer) and parses for the earnings dates. It waits until the page is done loading before moving forward. Firewalls, adblockers, modified host files etc can prevent a website from completely loading. Here is how to fix this problem.
Open each of the following links in Internet Explorer (It has to be IE)
At the bottom left of IE you must get the message “Done” (not 1 item remaining etc).
http://www.zacks.com/research/report.php?type=estimates&t=MSFT
http://biz.yahoo.com/research/earncal/m/msft.html
http://clearstation.etrade.com/cgi-bin/details?Symbol=msft
Nice work!
I am so grateful for your wonderful earnings downloader. For ages I been searching high and low for some way get earnings dates for my watchlists without having to manually enter each one. Not only did I search all over the net but I even have accounts with Thinkorswim, Investools, and Worden TC Telechart and none of them allowed for this. I had actually come across your site months ago but kept getting runtime error #9 when I tried the download so I gave up. Today however, it worked but I’m not sure why. Now though I get a runtime error #5 but it works just great despite that. A million thanks.
Gillian.
Gillian,
Thanks for informing me of this issue. I have updated earnings.xls so that the error no longer occurs. The issue is that currently earnings data is missing from most all stocks on the clearstation website which is where the dates in column two are from. This appears to be a temporary problem but at least when there is no data the program will no longer error. Instead it will be skipped but earnings dates will still appear from yahoo/zacks.
Thank you so much for resolving the problem so quickly
At the risk of being redundant because I did send an email the gmail account but would you also be kind enough to tell me what file format to save as? When I try various things, I either can’t reopen it or I get runtime error #9 out of range.
Save as “Excel 97-2003 workbook (*xls)“. Also the file should not be renamed or it will error. (If you have Excel 2010 and that does not solve the issue you might also need to lower security settings File>Options>Trust Center>Trust Center Settings>Macro Settings> then Enable all macros and a check next to to “trust access to the vba project object model”)