• Galactic Advisors

Create a Real Time Portfolio Tracker using Google Sheets

We've made a Real-time Portfolio tracker using Google Sheets. This can give you a snapshot of your investments in shares, mutual funds, bonds, ETFs. You can use this to track your investments across the world.

The above is a screenshot from a sample Portfolio Tracker we created for our Coffee Can Portfolio.

We've linked this sample for your reference: View Google Sheet

Here's how you create your own Portfolio Tracker:

  1. Create a new Sheet from Google Sheets.

  2. Create a table similar to the table we've created above.

  3. Add your stocks and Mutual funds under Particulars and number of shares/ units under units

  4. Copy the ticker Symbols from Google Finance for each stock. Note: You will need to remove space from between the symbols.

  5. Use GOOGLE FINANCE API to get real time prices. (delay upto 20 min). These prices are in local Currency i.e. USD for US stocks and INR for Indian Stocks etc.

  6. Voila. Your Portfolio tracker is ready.

  7. You can also create a donut chart like the one we've created.

You can also make a complete dashboard in this manner to help you track your portfolio.

Sign up for our newsletter for all the latest tax, FEMA, advisory, investment, accounting and finance news.

As an added bonus, we will answer your first query for free!

We'll also throw in a free tax regime comparer for you to minimize your taxes.

©2020 by Galactic Advisors.