Skip to content
Google Sheets functionNot in Excel

GOOGLEFINANCE function in Excel

Excel doesn't have GOOGLEFINANCE — here's what does.

Excel splits the job in two: STOCKHISTORY for price history, the Stocks data type for live quotes and attributes.

What GOOGLEFINANCE does in Google Sheets

Fetches current or historical securities information from Google Finance.

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

Convert GOOGLEFINANCE formulas to Excel

Before and after, formula by formula.

  1. Daily close prices for a date range:

    Google Sheets
    =GOOGLEFINANCE("GOOG", "close", DATE(2026,1,1), DATE(2026,8,1), "DAILY")
    Excel
    =STOCKHISTORY("GOOG", DATE(2026,1,1), DATE(2026,8,1), 0)

    STOCKHISTORY's fourth argument is the interval: 0 daily, 1 weekly, 2 monthly.

  2. A live quote:

    Google Sheets
    =GOOGLEFINANCE("GOOG")
    Excel
    =A2.Price

    Convert the ticker cell to the Stocks data type first (Data → Stocks), then dot into Price, Change, Market Cap…

Worth knowing

  • STOCKHISTORY needs Microsoft 365; both features need Excel connected to Microsoft's data service.

Converting more than one formula? The Excel ↔ Sheets translator rewrites whole workbooks and flags every GOOGLEFINANCE so none slip through silently.

Browse Google Sheets google functions

More conversions to Excel