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

3 Better Sheets Tutorials

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.

Browse more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition, even if that condition is a date.

SUMIF() UNIQUE()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.

Intermediate

CONCATENATE() ROUND()

Google Sheets Interface Changes

Showing off New experiences in smart canvas changes to sheets. Including Date Chips, and Files Chips. Introduced in early 2023.

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 Add-on we'll be publishing to the Google Workspace Marketplace.

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