RTD() function
Realtime symbol data may be accessed from Excel via Real Time Data (RTD) and Infront Professional Terminal. Using RTD requires Excel 2002 or later and needs the Infront Professional Terminal to be running before using RTD() function into Excel Add-in.
RTD() function is an Excel function, it is not developed specifically for Excel Add-in.
For more information about this function, please take a look at Microsoft page.
For any issue or question about this functionality, please contact directly Infront support.
Embedding RTD formulas in Excel
The RTD formula for quotes takes five or six parameters:
=RTD(ProgID;Server;Feed;Symbol;Field[;Level])
| Parameter | Description and value |
|---|---|
| ProgID | Always set to "ontrade.quotes" |
| Server | Leave blank "" |
| Feed or InstrumentCode | The feed code (e.g. "SSE") The Instrument code (e.g. "SSE:ERIC B). In that case, the symbol in 4th parameter should be blank. |
Symbol | The symbol ticker code (e.g. "ERIC B") |
| Field | The field to be displayed (e.g. "last") |
| Level | Optional numeric parameter (used for orderbook levels) |