Ross Michell

Investing Fundamentals: Track Your Investments with Google Sheets

TLDR: Create a Google Sheet which will automatically update and track share prices, gains, diversification and risk profile of your portfolio.

Yes, your broker website like CBA will track your performance very well. However, the things it won’t do well it remind you

To manage this, I would suggest to use your own personal tracking similar to what I have provided in a template below: Investing Fundamentals: Track Your Investments With Google Sheets

Notes for using such a template

  1. You will need to ensure your portfolio is updated from your Broker Site (e.g Commsec)
  2. Each time you make a purchase or sell, update the appropriate columns (the first few until you hit ‘Cost’)
  3. Personal Input will need to be manually input (unless you use the full template – releasing in coming days)
  4. Google Prices and statistics will update automatically when the market is open and every 10 or so minutes

If you are unfamiliar with Google Sheets – BECOME FAMILIAR WITH GOOGLE SHEETS!

The next and FINAL piece of this series will be bringing it all together with, you guessed it – A Google Sheet Template – Full Starter Template And Review

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on whatsapp
Share on email