Google Sheets beginner GOOGLEFINANCE stocks portfolio market data

GOOGLEFINANCE: Live Stock Data in Google Sheets

GOOGLEFINANCE Function is a Google Sheets function that googlefinance connects to google's financial data and returns the current trading price for apple (aapl). Formula Genius generates and validates this formula automatically from a plain-English prompt.

Pull real-time stock prices, historical data, and financial metrics directly into your spreadsheet. Build portfolio trackers and watchlists.

Generate This Formula Browse Library

The Formula

Prompt

"Get the current price of Apple stock and its 52-week change"

Google Sheets 
=GOOGLEFINANCE("AAPL", "price")

GOOGLEFINANCE connects to Google's financial data and returns the current trading price for Apple (AAPL). You can request different attributes like marketcap, pe, high52, low52, and more.

Step-by-Step Breakdown

  1. GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date], [interval])
  2. "AAPL" is the stock ticker symbol
  3. "price" returns the current/last trading price
  4. Other attributes: "marketcap", "pe", "eps", "high52", "low52", "volume"
  5. Add date range for historical data: =GOOGLEFINANCE("AAPL", "close", DATE(2025,1,1), TODAY())

Edge Cases & Warnings

  • Data is delayed by up to 20 minutes — not suitable for real-time trading
  • Ticker format varies: US stocks use plain tickers (AAPL), international use exchange prefix (LON:VOD)
  • Historical data requests spill into multiple rows — ensure enough empty space
  • GOOGLEFINANCE may return #N/A for delisted stocks or invalid tickers

Examples

Prompt

"=GOOGLEFINANCE("AAPL", "price")"

Google Sheets 
Current AAPL stock price
Prompt

"=GOOGLEFINANCE("GOOG", "marketcap")"

Google Sheets 
Google's market capitalization
Prompt

"=GOOGLEFINANCE("AAPL", "close", DATE(2025,1,1), TODAY())"

Google Sheets 
Daily closing prices table

Frequently Asked Questions

Is GOOGLEFINANCE real-time?

No. Data is delayed by up to 20 minutes. For real-time data, you'd need a dedicated market data API.

Can I get cryptocurrency prices?

Yes. Use the format: =GOOGLEFINANCE("CURRENCY:BTCUSD") for Bitcoin in USD.

Can't find what you need?

Describe any formula in plain English and Formula Genius will generate, explain, and validate it — instantly.

Generate Custom Formula See Examples