RTD() panel
The RTD() function linked with Infront Professional Terminal can be automatically built via the RTD() panel.
Warning
Some users may need to enable manually the Manager.IDP needed for this panel, by changing value to "NO" on the following registry key:
Computer\HKEY_CURRENT_USER\SOFTWARE\VB and VBA Program Settings\EfFull\Setting\EfDisableRTDPanel
.
You can also do this by simply check to enable the Manager.IDP into Excel Add-in settings:
You can select the instrument and the fields via the list menu or directly refer to a cell on your spreadsheet.
Using the Format Output option, you would be able to easily create your own model.
Function Syntax
RTD(program_Id, , instrument_code, , field_Id)
Example
=RTD("ontrade.quotes",,"LSE:VOD",,"bid")
Function Parameter | Description |
---|---|
Instrument_code | Only instrument code is supported. To retrieve one, you can use the INFCODECONVERT() function. Examples LSE:VOD, ENP:BN |
Field_Id | The name of the field to be retrieved. For more information, see Field Name Settings Table. Only the keywords and names referenced can be used Examples |
The Field Picker, connected with your Infront Professionnel Terminal, will display the whole list of RTD() fields.