STOCKHISTORY
Retrieves historical data about a financial instrument and loads it as an array.
InformationInformation & Auditing
What it does
Fetches stock history array.
Syntax
STOCKHISTORY(stock, start_date, [end_date], [interval], [headers], [properties])
Arguments
stock(text) — Ticker symbol.start_date(date) — Start.
Examples
Stock Data
Get MSFT history.
FORMULA
=STOCKHISTORY("MSFT", "2023-01-01", "2023-01-05")RESULT
[Array...]
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | (Spill Data) |