INFRONT.GETTICKDATA function
The INFRONT.GETSELECTION function allows to retrieve intraday tick-by-tick data for an instrument
Parameters
Instrument identifier
Datetime start
The start date and time from the period for which you want the intraday data.
Format should be <year>-<month>-<day>T<hour>:<minutes>:<seconds> eg 2023-02-01T09:00:00
Datetime end
The start date and time from the period for which you want the intraday data.
Format should be <year>-<month>-<day>T<hour>:<minutes>:<seconds> eg 2023-02-01T09:00:00
Options
The options are supposed to be provided as JSON, however it seems you can only provide parameters as string from Excel and parse it as JSON. That means the quotes inside the JSON string have to be double quoted for valid JSON.
Example
=INFRONT.GETTICKDATA("DTR0CK.ETR", "2022-11-21T12:00:00", "2022-11-21T13:00:00", "{""intradayType"":""BID""}")Optional parameter | Description |
|---|---|
| sorting | Sorting of the tick prices. Default is ASC (oldest prices first). Possible values
Example
CODE
|
| convertTo | ISO currency code which indicates to which currency the value should be converted. Example
CODE
|
tickAggregation | The number of ticks to aggregate. Default is 0. Possible values: 0, 5, 10, 20, 50, 100 Example
CODE
|
intradayType | Decide what price type you want to show. Possible values
Example
CODE
|