FormulaCraft

GOOGLEFINANCE

GOOGLEFINANCE retrieves real-time or historical stock prices, exchange rates, market cap, P/E ratio, and other financial attributes for a given ticker symbol. It is the go-to function for building live portfolio trackers, currency converters, and financial dashboards directly inside Google Sheets.

Excel
=GOOGLEFINANCE("NASDAQ:AAPL","price")
Google Sheets
=GOOGLEFINANCE("NASDAQ:AAPL","price")

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1Enter the ticker symbol as a string in the format "EXCHANGE:SYMBOL" (e.g., "NASDAQ:AAPL") or just the symbol.
  2. 2Optionally specify an attribute such as "price", "high", "low", "volume", "marketcap", or "pe" as the second argument.
  3. 3For historical data, add start date and end date arguments plus an optional interval ("DAILY" or "WEEKLY").

Need a version for your data?

Try: “Show me the current stock price of Apple in my Google Sheet”

Related

IMPORTRANGEIMPORTHTMLIMPORTDATA

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: