Excel functions
The Infront Add-in for Excel uses custom Excel functions to retrieve the actual data.
Function name | Description |
|---|---|
INFRONT.GETFIELD | Retrieve one value for a specific instrument at a given point in time. Some options can be set to do for example a currency conversion or backpadding. |
INFRONT.GETHISTORY | Gets the price history for an instrument. |
INFRONT.GETSELECTION | Retrieve dynamic selections from your terminal (watchlist, portfolio) or other dynamic lists e. g. index constituents, arbitrage list, index membership, vwd page. |
INFRONT.GETTICKDATA | Retrieve tick-by-tick data for an instrument for a given period. |
INFRONT.NOW | Since NOW and TODAY are volatile functions in Excel, they trigger updates much more frequently than other regular functions (see https://learn.microsoft.com/en-us/office/client-developer/excel/excel-recalculation#volatile-and-non-volatile-functions). When these functions are used in combination with functions for retrieving large data sets that do not necessarily change from one moment to the next, this can lead to unwanted loading effort and reduced performance. Infront has therefore integrated its own NOW and TODAY functions, which are only executed when an update occurs. |
INFRONT.TODAY |