Google Sheets | GOOGLEFINANCE | Function | Share Price | Example | Spreadsheet | Tutorial
The Google Sheets GOOGLEFINANCE function can return the present or historical price of securities. The function also allows to specify NYSE or NASDAQ as the exchange from which to get the data.
The only attribute required by GOOGLEFINANCE is the ticker symbol. If other arguments are omitted, this function gives the present price of the specified symbol.
-------------------------------------
How to Create a Pivot Table in Google Sheets?
Create a pivot table for calculation and in-depth data analysis:
• Google Sheets | Pivot Table | How to ...
-------------------------------------
How to Use Convert to Table in Google Sheets?
Convert a data range into a table easily:
• Google Sheets | Convert to Table | Ch...
-------------------------------------
How to Use REDUCE in Google Sheets?
Use REDUCE to get the final value of intermediate calculations:
• Google Sheets | REDUCE | Function | R...
-------------------------------------
How to Use SCAN in Google Sheets?
It's easy to calculate running total, running count and the like with SCAN:
• Google Sheets | SCAN | Function | Cal...
-------------------------------------
How to Use QUERY in Google Sheets?
QUERY helps, among others, to extract specific or all data from a range:
• Google Sheets | QUERY | Function | Ex...
-------------------------------------
How to Use FREQUENCY in Google Sheets?
FREQUENCY returns the frequency distribution of data:
• Google Sheets | FREQUENCY | Function ...
-------------------------------------
How to Use COUNTIFS in Google Sheets?
Count values that fulfill one or more criteria:
• How to use COUNTIFS in Google Sheets ...
-------------------------------------
How to Use XLOOKUP to Extract Multiple Values in Google Sheets?
XLOOKUP can return a single row or column with the search key:
• Google Sheets | XLOOKUP | Function | ...
-------------------------------------
How to Use VLOOKUP in Google Sheets?
Use VLOOKUP to get a single value:
• VLOOKUP Google Sheets | How to Use VL...
-------------------------------------
Format of GOOGLEFINANCE Function Formula:
=GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
ticker is the ticker symbol of the security.
attribute is optional, and can be "price", which is the default, "priceopen", "high", "low", "volume", etc.
start_date is optional, and is the starting date and applies to historical data.
end_date|num_days is optional, and is the end date or number of days and applies to historical data
interval is optional, and is the frequency of data. Interval value can be one of "DAILY", "WEEKLY", 1, or 7.
Example of GOOGLEFINANCE Function Formula:
Example
Present Data of a Security
=GOOGLEFINANCE("NASDAQ:AAPL")
The above function returns the present share price of Apple Inc., from the
specified stock exchange, which is NASDAQ.
Example
Historical Data of a Security
=GOOGLEFINANCE("NASDAQ:AAPL", "price", "01/08/24", "01/15/24")
The function returns the historical share price of Apple Inc. The attribute
argument value is "price" and the start_date and end_date argument values are "01/08/24" and "01/15/24" respectively.
Review this video tutorial, which gives the steps to use the Google Sheets
GOOGLEFINANCE function, with examples.