How To Use GOOGLEFINANCE() Function in Google Sheets


Fetches current or historical securities information from Google Finance.

Common Questions About the GOOGLEFINANCE Formula:

-What data can the GOOGLEFINANCE formula be used to track?
-What are the criteria used to access data using the GOOGLEFINANCE formula?
-What is the syntax of the formula?

How Can the GOOGLEFINANCE Formula Be Used Appropriately?

- GOOGLEFINANCE formula can be used to get information on stocks, bonds, commodities, currencies and mutual funds.
- It can be used to display current stock prices, track market data, and return historical pricing data.

How Can the GOOGLEFINANCE Formula Be Commonly Mistyped?

The GOOGLEFINANCE formula is often mistyped as GOOoGLEFinance or GoogleFinancial, or GOOGFIN, or GOOGFINCIE, or FINANCE, or GFINANCE, or GOOLFINANCE, or GOOGLFINCIALL

What Are Some Common Ways the GOOGLEFINANCE Formula Is Used Inappropriately?

-Using GOOGLEFINANCE without inputting the correct stock tickers or symbols
-Using GOOGLEFINANCE to get advice about investing
-Using GOOGLEFINANCE to try and predict stock market behavior

What Are Some Common Pitfalls When Using the GOOGLEFINANCE Formula?

-GOOGLEFINANCE can only be used in Google Sheets, not Excel. 
-GOOGLEFINANCE can only acquire current and historical prices, not advice about investing. 
-There can be lags in the data due to latency.

What Are Common Mistakes When Using the GOOGLEFINANCE Formula?

-Incorrectly typing the formula
-Incorrectly inputting the stock tickers or symbols
-Using GOOGLEFINANCE without setting the correct parameters or criteria

Google Sheet Formula Frustrations Solved

Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

At, I have everything you need to take your Google Sheets skills to the next level. 
From ARRAYFORMULA() to ZTEST(), Better Sheets has it all. 

There’s no shortcuts to becoming a Google Sheets pro! Learn more here at Better Sheets

Watch the magic for yourself. Video tutorials at every turn here at Better Sheets.

Your spreadsheets will never be the same again.

How To Actually Use GOOGLEFINANCE() in Sheets

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

3Better Sheets Tutorials

Get crypto prices into a Google Sheet.
Create little graphs with SPARKLINE() super easy!
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.

Learn more about the GOOGLEFINANCE() formula:

How to use the GOOGLEFINANCE function in Google Sheets (WITH 5 EXAMPLES)

he GOOGLEFINANCE function allows you to import real-time financial and currency market data straight into Google Sheets.

Generate a GOOGLEFINANCE() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.