Easy Tech TutsHow to Get Stock Data in Google Sheets with Google Finance
By Impran M N
Tracking a stock portfolio manually is slow and quickly gets out of date, but Google Sheets has a built-in function that pulls live market data for you. This guide covers the GOOGLEFINANCE formula syntax, from basic real-time prices to historical data and advanced metrics, so you can build an automated tracking spreadsheet.
01Learn the basic formula syntax
Write a GOOGLEFINANCE formula referencing any stock ticker to start pulling data.
02Pull real-time stock prices
Use the formula to fetch current price and day-over-day change for a given stock.
03Use the correct exchange prefix
Add the appropriate market prefix to your ticker to avoid discrepancies between similarly named stocks on different exchanges.
04Fetch historical price data
Adjust the formula with a start date and interval to pull daily or weekly historical prices.
05Extract advanced metrics
Pull additional attributes like P/E ratio, market cap, and 52-week highs using the same function.
06Build a multi-stock watchlist
Combine multiple GOOGLEFINANCE formulas into a dynamic table to track several stocks or currency exchange rates at once.
Frequently asked questions
Why is my GOOGLEFINANCE formula pulling the wrong stock?
This usually happens when the exchange prefix is missing or incorrect, causing the formula to match a similarly named ticker on a different exchange.
Can I get historical stock prices, not just live data?
Yes, by adding a start date and interval parameter to the formula, you can pull historical daily or weekly price data.
Does GOOGLEFINANCE update in real time?
The function is designed to provide near real-time data, though there can be occasional lags depending on the query and market.
Can I track currency exchange rates the same way?
Yes, GOOGLEFINANCE also supports pulling currency exchange rate data alongside stock information.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
