Dividend Portfolio Update & Tracking Tools

By Scott Cunningham | Crypto & 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:

https://www.thespreadsheetguru.com/blog/add-real-time-stock-prices-and-metrics-to-excel

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:

http://www.filedropper.com/stockinvestingtemplate

 

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: https://docs.google.com/spreadsheets/d/1OJNaygQsWVmttIEePSyphwS45d12cQazY4DO-Vbw4JQ/edit

 

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?


94

4

Scott Cunningham
Scott Cunningham

I am the host of Crypto & Things and a huge social blockchain enthusiast using what I believe to be the next level of social communication. I make educational content, review platforms, and interview cool people. Links: http://www.scottcbusiness.com/


Crypto & Things
Crypto & Things

I am the host of Crypto & Things and a huge social blockchain enthusiast using what I believe to be the next level of social communication. I make educational content, review platforms, share my passive & crypto income journey, and most importantly, I get the opportunity to interview and chat with so many amazing people in the blockchain, cryptocurrency, and tech space every week and share it all with you. Links: http://www.scottcbusiness.com/

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.