RTD.DB Application Settings

You can change the application settings in the RTD.DB.exe.config and RTD.DB32.exe.config files.

RTD.DB loads application settings at the application start. So, you have to restart the application to reload settings.

Use the File, Open Configuration File menu item to open the file. You can edit the file using notepad.exe or another tool.

Use the File, Open Connection Manager menu item if you need to edit the connection strings only.

Configuration File Format

The configuration file can contain the appSettings and connectionStrings sections.

Configuration file example:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <appSettings>
        <add key="AppCulture" value="en-US"/>
        <add key="AutoStart" value="true"/>
        <add key="ConfigurationFileEditor" value="notepad.exe"/>
        <add key="ConnectionTimeout" value="5"/>
        <add key="CommandTimeout" value="5"/>
        <add key="InstanceName" value=""/>
        <add key="MinimizeToTray" value="true"/>
        <add key="RefreshTimerInterval" value="50"/>
        <add key="RefreshTaskInterval" value="0"/>
        <add key="ServersAsAdmin" value="TOS VFX"/>
        <add key="TwsUserName" value=""/>
        <!--<add key="TosDecimalSeparator" value="."/>-->
        <!--<add key="TosGroupSeparator" value=","/>-->
        <add key="TosMaxUpdateRows" value="100"/>
        <add key="TosMinUpdateTime" value="10000"/>
        <add key="TosMaxUpdateTime" value="20000"/>
        <add key="tos.rtdMaxTotalTopics" value="100000"/>
        <add key="tos.rtdMaxUpdateRows" value="500"/>
        <add key="tos.rtdMinUpdateTime" value="5000"/>
        <add key="tos.rtdMaxUpdateTime" value="10000"/>
        <add key="tos.rtdIsDynamicCalls" value="True"/>
        <!--<add key="NoDataLimit" value="20"/>-->
        <!--<add key="DataProcessor" value="DataProcessorCS.dll"/>-->
    </appSettings>
    <connectionStrings>
        <add name="rtd-mssql"
            connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=RTD;Integrated Security=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>

Configuration file settings:

AppCulture: This string value defines the application culture used for user interface translation.
AutoStart: This boolean value defines the immediate start of data updating after the program start.
Start the application with administrator privileges for updating data from DDE servers that require such privileges (TOS, VFX).
ConfigurationFileEditor: This string value defines the application used to edit the RTD.DB application configuration file.
The default value is notepad.exe.
ConnectionTimeout: This integer value defines the server connection timeout in seconds.
CommandTimeout: This integer value defines the timeout of command execution in seconds.
InstanceName: This string value defines the instance name used to select table configurations using the RTD_INSTANCE_NAME field.
MinimizeToTray: This boolean value allows minimizing the application window in the system tray.
RefreshTimerInterval: This integer value defines the interval of data refreshing in milliseconds.
RefreshTaskInterval: This integer value defines the interval of checking changes in task tables specified in the LOAD_CODE field of the real_time_tables table.
ServersAsAdmin: This string value defines RTD and DDE servers that require administrator privileges.
RTD.DB requests elevating for these servers.
TwsUserName: This string value defines a username for InteractiveBrokers Trader Workstation (TWS).
This name is used in real-time formulas like =S<TwsUserName> by default if the =S server is specified only.
DecimalSeparator: This string value defines the decimal separator.
Use it as <Server>DecimalSeparator like TosDecimalSeparator for the Tos DDE server.
GroupSeparator: This string value defines the thousand group separator.
Use it as <Server>GroupSeparator like TosGroupSeparator for the Tos DDE server.
MaxTotalTopics: This integer value defines the maximum number of topics created for the RTD server.
RTD.DB restarts the RTD client when it requires more topics.
Use it as <Server>MaxTotalTopics like tos.rtdMaxTotalTopics for the tos.rtd server.
This option addresses the bug of Thinkorswim that allows creating about 200000 topics and then raises the 'pure virtual function call' exception.
MaxUpdateRows: This integer value defines the maximum number of active tickers connected to the server.
This option prevents server overhead. RTD.DB changes the tickers cyclically.
Use it as <Server>MaxUpdateRows like tos.rtdMaxUpdateRows for the tos.rtd server.
MinUpdateTime: This integer value defines a minimum number of milliseconds that a ticker must be connected to the server before replacing it with a new one when the total number of tickers is more than MaxUpdateRows.
Use it as <Server>MinUpdateTime like tos.rtdMinUpdateTime for the tos.rtd server.
MaxUpdateTime: This integer value defines a maximum number of milliseconds that a ticker can be connected to the server before replacing it with a new one when the total number of tickers is more than MaxUpdateRows.
Use it as <Server>MaxUpdateTime like tos.rtdMaxUpdateTime for the tos.rtd server.
IsDynamicCalls: This boolean value defines a calling model for the RTD server: IRtdServer typed calls or dynamic calls.
thinkorswim thinkDesktop requires the dynamic model if Microsoft Excel is not installed.
Use it as <Server>IsDynamicCalls like tos.rtdIsDynamicCalls for the tos.rtd server.
NoDataLimit: This integer value defines the maximum number of refresh cycles without data refresh that starts reconnecting to a server.
Use this option if the server must return real-time data every time but can have issues.
DataProcessor: This string value defines an RTD.DB add-in used to preprocess data.
See RTD.DB Add-Ins.