Excel and RTD function
Last updated
Was this helpful?
Last updated
Was this helpful?
Start from the version 1.39 OptimusFLOW supports RealTimeData (RTD) for sending data and other market information to Microsoft Excel®. This feature opens up many opportunities for creating custom displays and other ways to better manage your workflow.
RTD is a newer protocol that offers several advantages over DDE, including more flexibility and better performance and reliability.
We prepared the spreadsheet that outlines the basic syntax of RTD formulas with details more complex formulas. Included is a collection of popular RTD formulas, which you can simply copy and paste into your own spreadsheet. .
Here is the General Syntax for getting symbol info via RTD function:
Also in the settings there are two important settings:
Custom RTD formula name — depending on the language of your operating system, the name of the RTD function in Excel may be called differently. The original name of the function in the English version of Excel is RTD, but for Russuian version it's called as "ДРВ".
When retrieving instrument data using RTD, you need to specify the ID of the instrument and the properties you want to retrieve.
RTD formula uses the following basic structure:
For Windows 7:
go to Start > Control Panel > Regional and Language Options
Click on Formats Tab > Additional Settings
for List Separator check the argument. _**_It must be the same as in RTD settings.
For Windows 10:
go to Start >type Control Panel and press enter > Region
click Additional Settings
for List Separator check the argument. _**_It must be the same as in RTD settings.
Go to the of the platform, then to section Excel RTD and tick off "Enable Microsoft Excel RTD"
Custom argument separator — the separator that participates in the formula. It depends on the localization of your operating system. Get to know .
