INFRONT.GETHISTORY function

Gets the price history for an instrument

Parameters

instrument {string} Infront instrumentId, ISIN, ISIN.MIC, Infront instrumentKey or search string
startDate {string} Start date
endDate {string} End date
[fieldList] {string} Comma separated fields (available fields: lastPriceTimestamp, firstPrice, highPrice, lowPrice, lastPrice, volume, cumulativeTrades)
[options] {string} Options in JSON format
dateSelection - optional parameter with 3 values:
- value: default selection that only returns dates for which there is a (price) value; this is the current behavior
- empty: just returns all dates but keeps the value fields empty
- lastknown: the last known value is used to fill up the gaps that would remain empty otherwise

[sorting] {"ASC" \| "DESC"}	Sorting of tick prices. Default: DESC (latest prices first)
[convertTo] {string}	Convert prices to currency (IsoAlpha3, e.g., "EUR"). Default: undefined (use original currency)
[processPayment] {boolean}	Process payments / dividends. Default: false
[processSplit] {boolean}	Process splits / corporate actions. Default: true
[targetCell] {string}	Target cell where the output starts at. Default: cell of the formula itself

Returns

Matrix of historical prices {number[][]}

Examples

=INFRONT.GETHISTORY("846900.ETR"; "2025-12-13"; "2026-01-13"; ""; "{""dateSelection"":""EMPTY""}")

=INFRONT.GETHISTORY("846900.ETR"; "2025-12-13"; "2026-01-13"; ""; "{""dateSelection"":""LASTKNOWN""}")

=INFRONT.GETHISTORY("846900.ETR"; "2025-12-13"; "2026-01-13"; ""; "{""dateSelection"":""VALUE""}")

=INFRONT.GETHISTORY("710000.ETR", "2024-01-01", TODAY(), "lastPriceTimestamp, lastPrice", "{""sorting"":""ASC"",""convertTo"":""JPY"",""dateSelection"":""VALUE""}")