In this article:

Free Google Sheets Portfolio Tracker (2024 Update)

May 8, 2024

Free Portfolio Tracker for Google Sheets

You can make a copy of this stock portfolio tracker in Google Sheets for free. Don't request for permission to edit, simply go to File > Make a copy.

google sheets portfolio tracker

How to Use the Stock Portfolio Tracker in Google Sheets

Below we explain how to use our portfolio tracker in Google Sheets:

Investment Name 

Enter the full name of the investment.

Ticker Symbol 

Input the stock's ticker symbol (e.g., TSLA for Tesla, AAPL for Apple). This symbol is used for fetching the current price through Google Finance. You can find a list of all stock ticker symbols here.


Specify the sector to which the investment belongs (e.g., Technology, Healthcare).

Purchase Date

Enter the date on which you purchased the investment.

Purchase Price

Input the price at which you bought the investment.


Mention how many units/shares you purchased.

Current Price

Use the =GOOGLEFINANCE function with the ticker symbol in column B to automatically fetch the current price of the stock. 


portfolio tracker google sheets

Note: The GOOGLEFINANCE function automatically updates the stock prices, so your portfolio values are always up to date.

Current Value

This column calculates the total current value of your holdings. Multiply the purchase quantity by the current price using a formula (=F2*G2).

google sheets stock tracker

Below are more sample entries for your reference: 

stock portfolio tracker google sheets

We hope that this article has helped you and given you a better understanding of how to use our free Google Sheets portfolio tracker template. If you enjoyed this article, you might also want to check out our Google Sheets roster template and sports betting spreadsheet for Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->