FUNCTION CATALOGUE / FINANCIAL
STOCKHISTORY Excel function
Returns historical data for a financial instrument.
Correct sentence to use
Get historical prices for [ticker] from [start date] to [end date].
Modify this query in PlainFormula →Example formula
=STOCKHISTORY("MSFT",DATE(2025,1,1),TODAY())
Returns historical data where supported.
Syntax
STOCKHISTORY(stock, start_date, [end_date], [interval], [headers], [property0], …)
Argument signature: stock, start_date, [end_date], [interval], [headers], [property0], …
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.