How to Use GOOGLEFINANCE() in Google Sheets

Description

Fetches current or historical securities information from Google Finance.

How To Actually Use GOOGLEFINANCE() in Sheets

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

Try GOOGLEFINANCE yourself

In cell A1, use the GOOGLEFINANCE formula to fetch the current stock price of Google (ticker: GOOGL). The result should display the price in A1.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Better Sheets Tutorial

Add Cool Responsive Graphs to Your Stock Tracking Sheets

Create little graphs with SPARKLINE() super easy!

GOOGLEFINANCE() INDEX() SPARKLINE() TODAY()

How To Track Crypto Prices

Get crypto prices into a Google Sheet.

Intermediate

GOOGLEFINANCE()

Currency Exchange Tricks In Google Sheets

Little tricks to make Currency Exchange in Google Sheets better for you, and easier to read for others. Great for beginners, as well as Advanced Users.

Advanced Intermediate Beginner

GOOGLEFINANCE()

Transcript-matched member videos for GOOGLEFINANCE(). Click through to watch.

Watch more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Google Sheets Interface Changes

Showing off New experiences in smart canvas changes to sheets. Including...

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Unlock these tutorials

Learn more about the GOOGLEFINANCE() formula:

Generate a GOOGLEFINANCE() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses GOOGLEFINANCE(). 2 free AI generations, no signup. Members get unlimited use.

Generate a GOOGLEFINANCE() formula