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:

https://travelandinvest.com/the-crucial-importance-of-tracking-your-portfolio-performance/

2 Likes

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

Hi.

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

Hi,

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.

Regards,

This Portfolio & Dividend Tracker is now updated and also supports GBP/EUR & USD.

You can check it here.

1 Like

Thank you for sharing. Highly recommended :ok_hand:

1 Like

Not trying to seem ungrateful, but have you considered to rebuilt this on MS Excel? Being able to pull data with Power Query might just elevate your tool to the next level.

1 Like

Yes, excel is very popular for portfolio trackers. It’s something that i’m already working on and will be available soon.

Thanks for your feedback. Much appreciated

1 Like