Formulas > =GOOGLEFINANCE()
How To Use GOOGLEFINANCE() Function in Google Sheets
Description
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.
Hints (2)
-
Remember to use the correct ticker symbol for Google.
-
The second argument should specify that you want the current price.
3 Better Sheets Tutorials
Add Cool Responsive Graphs to Your Stock Tracking Sheets
Create little graphs with SPARKLINE() super easy!
GOOGLEFINANCE()
INDEX()
SPARKLINE()
TODAY()
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.
GOOGLEFINANCE()
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