A portfolio & dividend tracker tool (based on Google Sheets)

Hey all, I’ve put together a new dividend tracker spreadsheet and wrote up a blog post explaining how it works. You can check it using this url:


Looks very useful. I’m not a dividend investor specifically. How does one import your holdings into the spreadsheet?


You can input the holdings manually in ‘My Portfolio’ tab.
You only need to enter number of stocks and average cost.

Will it work on a csv file or something exported from T212? It would take way too long for me to manually enter all my holdings and especially all my buys and sells that I do many times a week


No it only works with manual input of holdings. For each holding, you need to enter the number of stocks and the average cost of purchase.
Importing a csv is not possible.