How to track stock prices in Google sheets

Example of tracking stock prices in Google sheets
Tutorial
Jan 26 2020

You can now use the GOOGLEFINANCE function to track stock prices in real time. Using this function you can easily keep track of your stock portfolio value using live data. The GOOGLE finance function is particularly useful when you need customised calculations involving stock prices.

In this tutorial we will use the GOOGLEFINANCE function to lookup the live share value for Google, and calculate the portfolio value based on the number of shared held.

Function syntax

=GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|number_of_days], [interval])

Examples

=GOOGLEFINANCE("GOOG")

Step 1: Prepare your data

Setup your Google sheet for checking stock data

Setup your Google spreadsheet with column titles in row 1 as follows:

A - Share price
B - Shares held
C - Share price
D - Total value

Add the text 'Google' to A2, and 100 to B2

Step 2: Use the GOOGLEFINANCE function to get the share prices of your shares

Use Google finance function to get stock price in Google sheets

In cell B2, enter the following formula

=GOOGLEFINANCE("GOOG")

Then add the formula for the other stock prices lookup it's company name in Google.

Step 3: Calculate the total value

Calculate total value of stocks held using google sheets

In D2 enter the formula

=B2*C2

This multiplies the share value by the number of shares held to give the value of the shares held.

Spread the word