Dividend Tracker

This sheet is for Dividend lovers like myself who do not have the time to track 100s of different stocks and their yields, payouts, prices or dividends. 

This Excel sheet will automatically update the following:

-Stock Price

-P/E Ratio

-52 Week High

-Beta

-Yield (the yield will be wrong if the annual payout is not up to date, i calculated the yield by doing Annual Payout divided by Stock Price)

As companies release their next dividends, you can update the sheet's "Dividend per Share" column and it will update the rest.

Also, you can edit the sheet and add your own stocks.

If you have any questions or errors with the sheet, please contact me!

Disclaimer: Information provided is solely for informational purposes only. This information is not for trading advice or purpose.

Enjoy!