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:
Create a new Sheet from Google Sheets.
Create a table similar to the table we've created above.
Add your stocks and Mutual funds under Particulars and number of shares/ units under units
Copy the ticker Symbols from Google Finance for each stock. Note: You will need to remove space from between the symbols.
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.
Voila. Your Portfolio tracker is ready.
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.