Daily Dividend Information: By clicking on any date in the calendar in 2) this section displays all relevant information for the stock(s) going ex-dividend currently it will inform you about the ex-dividend date, the dividend payment date and the declared $ dividend per share amount.įor a dividend investor the following is a use case I am frequently interested in:Īs a dividend investor I want to constantly monitor when and which stocks are going ex-dividend.Based on the number of stocks going ex-dividend on that day, the color changes from light blue to dark blue. 1-year overview: This 12-month rolling calendar stretches from 2016-2017 (as depicted in the header in 1) and highlights all ex-dividend dates over that period with a little red flag symbol.

Next ex-dividend date: Here we are notified about the next ex-dividend date based on today's date in this case, Southern Company (NYSE: SO) goes ex-dividend on this Thursday.

It consists of the following three (numbered) sections Once everything is set up appropriately this is what we get in the Excel Tool once we hit the 'Import Data' button on the 'Parameters' sheet:

Please let me know so in the comments sections. I will demonstrate the entire process by using the current Dividend Stock Portfolio Tracking file.įirst of all a personal wish here: As this article here is not about the typical content found on Seeking Alpha (stocks, strategy, etc.) it is likely that it will only be seen by a few readers, thus adding importance to your feedback as to whether you find this as useful as I do, encounter any difficulties or have any other feedback to report. For interested readers I will then outline what technically happens so you can adjust the tool for your purposes if necessary.

This article is structured in a way to first show what the final output allows you to do by using select information as a prime example. Therefore, I have uploaded a 'Dividend_Calendar_FINAL' Tool for everyone free to use here. Seeking Alpha readers now have access to a fully automated Dividend Calendar in Excel by importing data from our Google Sheets Tool into Excel.

Excel dividend tracker