Get historical dividends for many companies, and generate a payout stream cross-referenced against time. Free spreadsheet!
Update on June 18th 2017: now works with the new Yahoo Finance system
This Excel spreadsheet downloads historical dividends for many companies. It’s a companion sheet to the ever-popular Bulk Stock Quote Downloader, and is as simple-to-use as its counterpart. Get this free spreadsheet and learn how to download dividend data.
Simply enter a start and end date, a list of ticker symbols, and click the “Get Bulk Dividends” button.
Some clever VBA whirs away, and interrogates the Yahoo Finance web service. You get the historical dividend data for each ticker in its own sheet.
If you check Collate Data, all the dividends are collected onto one sheet. This gives you a stream of dividends over time, cross-referenced against the payout date.
So what can you do with this tool. You can identify groups of companies with a history of regular (and rising) dividend payouts.This provides points to mature financial management, and the long-term financial security of the business. Stocks like this are the bedrock of any long-term investment portfolio
Moreover, stock with higher dividends are generally less volatile than those with little or no history of paying divdends. That is the change in stock price plus the dividend payouts – can often be less volatile than the change in stock price itself . This protects your downside when markets are volatile.
Moreover, in the US, Canada and other countries, dividends are taxed at a lower rate than interest or salary income. So by targeting stocks with higher dividends, you minimize your tax . For example, in Canada, GIC bond income is taxed at your marginal tax rate. However, dividend income benefits from the “gross up” tax credit system that can cut the tax paid by about half.
You can view and edited the spreadsheet VBA. Feel free to learn from the code. I’d appreciate a link to http://investexcel.net if you find this spreadsheet of value.