Excel Add-in for IM
Excel Add-in for IM
Breadcrumbs

INFRONT.GETHISTORY function

Gets the price history for an instrument

Parameters 

  1. instrument {string} Infront instrumentId, ISIN, ISIN.MIC, Infront instrumentKey or search string 

  2. startDate {string} Start date

  3. endDate {string} End date

  4. [fieldList] {string} Comma separated fields (available fields: lastPriceTimestamp, firstPrice, highPrice, lowPrice, lastPrice, volume, cumulativeTrades)

  5. [options] {string} Options in JSON format

  6. 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""}")