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.