How To Use GOOGLEFINANCE()

Description

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 bettersheets.co/formulas, 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])

2Better Sheets Tutorials

Get crypto prices into a Google Sheet.
Create little graphs with SPARKLINE() super easy!

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.