Dividend Portfolio Update & Tracking Tools

By Scott Cunningham | Tech And Things | 26 Apr 2020

Hey everyone, I wanted to share an update on my dividend portfolio and my investing journey. I will also share with you some of the new tools I’m using to track my investing and dividends.

I’m going to do dividend portfolio updates every week or two going forward.

This was what I followed to build my excel sheet:

6 hours later and I ended up with something much more advanced which I will share with you below. This will allow you to use the same resource as me and you can just plug in all your data to spreadsheet:


Do note that the ones you must fill out yourself are marked as such plus you need to include the dividend percentages. This is because the custom codes to find and pull dividends are so complex and error-prone. For me as a Canadian especially, I found that every solution I found only covered a small portion of my stocks. All you really have to do is populate the stock name and or ticker in the “Stock Label” section which then populates the majority of the other fields.

This is set up for excel, not google spreadsheets, so it may operate differently. There are tons of google spreadsheet templates you can get out there too though.

Then I wanted to fully track my dividends coming in so I used Joseph Carlson’s amazing free template:


Was this helpful for you? What dividend stocks are you investing in? Do you prefer dividend investing or another style? Let me know what you think about this in the comments below and don’t forget to subscribe!

How do you rate this article?


Scott Cunningham
Scott Cunningham

Host of Crypto & Things. Sharing my vision of the emerging #Web3 landscape & how we can successfully navigate the digital transformation with #AI & #blockchain. Links:

Tech And Things
Tech And Things

I am the host of Tech & Things and a social media blockchain enthusiast using what I believe to be the next level of social communication. Join me as I share my vision of the emerging Web 3.0 landscape and how we can successfully navigate the digital transformation of AI & blockchain technologies. Links:

Send a $0.01 microtip in crypto to the author, and earn yourself as you read!

20% to author / 80% to me.
We pay the tips from our rewards pool.