Skip to content
Excel functionNot in Google Sheets

STOCKHISTORY function in Google Sheets

Google Sheets doesn't have STOCKHISTORY — here's what does.

GOOGLEFINANCE covers price history — and goes further, with live quotes in the same function.

What STOCKHISTORY does in Excel

Retrieves historical data about a financial instrument and loads it as an array

=STOCKHISTORY(stock, start_date, [end_date], [interval], [headers], [property0], [property1], [property2], [property3], [property4], [property5])

Convert STOCKHISTORY formulas to Google Sheets

Before and after, formula by formula.

  1. Daily close prices for a date range:

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

    GOOGLEFINANCE prepends a header row — offset the output if you need bare values.

  2. Weekly interval:

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

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

Browse Excel info functions

More conversions to Google Sheets