Sample Portfolio Tracker in Google Sheets

Reading Time: 2 minutes

A few people were looking for a way to track their portfolios. Here is a sample tracker I have built on google sheets complete with charts, relative performance, asset allocation, portfolio and industry weights. I have not opened the sheet as ready to use as I believe such trackers should be built custom to ones need. The sheet will require adjustments, inputs from the owner from time to time as the portfolio changes. If you will just start using mine you will always be breaking the formulae, references etc. I advise to take this as a template and make it your own.


  1. The stocks in the sample tracker are picked at random, please do not consider the stocks, and their weights as investment recommendations.
  2. The returns shown in the sample are fictitious and no attempts are being made to solicit investment capital from anyone based on such fictitious returns.

Source link

Disclaimer: The opinions expressed in this publication are those of the authors. They do not purport to reflect the opinions or views of the FinMedium or its members. The presentation of material therein does not imply the expression of any opinion whatsoever on the part of the FinMedium concerning the legal status of any company, country, area, or territory or of its authorities. For more info. please read our ToU & Privacy Policy here. If you have any concerns regarding this post, please reach out to us at

Also Read on FinMedium:  Debt Crisis of Evergrande

Every Wednesday and Saturday, we send Info-Graphic and FinMedium Weekly Digest newsletters to our 25000+ Subscribers.

Join Them Now!

Abhinav Mehrotra

Abhinav Mehrotra

Abhinav focuses on long-term positions in deeply moated businesses in the Indian equity space. He seeks momentum in the business model of a company and in the space in which it operates.
Please Share Now :)