All Data Point outputs can be configured directly with the RTD request.
RTD Elements
=RTD("ice.xl",,<Request Type>,<Symbol>,<Field>,<Granularity>,<Date/Time>,<Index>)
Request Type
The Request type governs if a request is made to our History servers or if a streaming quote is needed.
Request Type |
||
Option |
Description |
Example |
*Q |
Quote requests for the most recently available value | =RTD("ice.xl",,"*Q","BRN 1!-ICE","Last") |
*H |
Historical requests made by index or specific date/time | =RTD("ice.xl",,"*H","BRN 1!-ICE","Last","D",Date(2019,9,10)) |
Symbols
A symbol is required and must be specified. Symbols can be written directly into the RTD as text or cell-referenced.
Fields
A field is required and must be specified. Not all fields are available historically or as a quote for each symbol.
Granularity
Granularity governs the interval of time, its range, aggregation method, and fill options. All fill options can be applied to all intervals, although only daily fills are shown in the table below.
Granularity |
||
Option |
Description |
Example |
| "S" | Second Granularity | =RTD("ice.xl",,"*H","BRN 1!-ICE","Last","S",,0) |
| "I1" | 1 Minute Granularity | =RTD("ice.xl",,"*H","BRN 1!-ICE","Last","I1",,0) |
| "I60" | 1 Hour Granularity | =RTD("ice.xl",,"*H","BRN 1!-ICE","Last","I60",,0) |
| "D" | Daily Granularity | =RTD("ice.xl",,"*H","BRN 1!-ICE","Last","D",,0) |
| "DF" | Daily with Fill Forward | =RTD("ice.xl",,"*H","BRN 1!-ICE","Last","DF",,0) |
| "DE" | Daily with Fill End | =RTD("ice.xl",,"*H","BRN 1!-ICE","Last","DE",,0) |
| "DB" | Daily with Fill Backwards | =RTD("ice.xl",,"*H","BRN 1!-ICE","Last","DB",,0) |
| "DI" | Daily with Fill Interpolate | =RTD("ice.xl",,"*H","BRN 1!-ICE","Last","DI",,0) |
| "W" | Weekly Granularity | =RTD("ice.xl",,"*H","BRN 1!-ICE","Last","W",,0) |
| "WA" | Weekly Average of Daily values aggregation | =RTD("ice.xl",,"*H","BRN 1!-ICE","Last","WA",,0) |
| "M" | Monthly Granularity | =RTD("ice.xl",,"*H","BRN 1!-ICE","Last","M",,0) |
| "MA" | Monthly Average of Daily values aggregation | =RTD("ice.xl",,"*H","BRN 1!-ICE","Last","MA",,0) |
Date/Time
Dates can be entered using Excel date functions, or as text using the excel integer that resolves to that date, or via cell reference.
Examples:
Date(2019,9,3)
"43711"
Eomonth(today(),-1)
Index
When Index is used it will return the N number index of the specified Granularity. Date and Index can't both be used in the same RTD.
Example which returns the 3rd most recent minute bar
=RTD("ice.xl",,"*H","BRN 1!-ICE","Last","I1",,3)