INFRONT.GETHISTORY function

Gets the price history for an instrument

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

[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

Matrix of historical prices {number[][]}

=INFRONT.GETHISTORY("DTR0CK.ETR", "2023-01-01", "2023-02-01")

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