RealTimeToDB Application Configuration

RealTimeToDB loads application settings from the RealTimeToDB.exe.config file at the application start.

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

You can edit the connection strings using the Connection Manager. Use the File, Open Connection Manager menu item.

On the Start operation, RealTimeToDB opens all available connections, seeks database configuration tables, and starts updating configured tables.

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="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.rtdMaxUpdateRows" value="100"/>
        <add key="tos.rtdMinUpdateTime" value="10000"/>
        <add key="tos.rtdMaxUpdateTime" value="20000"/>
        <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).

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.

RefreshTimerInterval

This integer value defines the interval of checking changes in task tables specified in the LOAD_CODE field of the RealTimeTables table.

ServersAsAdmin

This string value defines RTD and DDE servers that require administrator privileges.
RealTimeToDB 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.

<DDE Server>DecimalSeparator

This char value defines a decimal separator in DDE return values.
You have to specify it if RealTimeToDB can't detect it automatically.

<DDE Server>GroupSeparator

This char value defines a group separator in DDE return values.
You have to specify it if RealTimeToDB can't detect it automatically.

<Server>MaxUpdateRows

This integer value defines a maximum number of active tickers connected to the server.
This option prevents server overhead. RealTimeToDB changes the tickers cyclically.

<Server>MinUpdateTime

This integer value defines a minimum number of milliseconds that a ticker must be connected to the server before it is replaced with a new one when the total number of tickers is more than MaxUpdateRows.

<Server>MaxUpdateTime

This integer value defines a maximum number of milliseconds that a ticker can be connected to the server before it is replaced with a new one when the total number of tickers is more than MaxUpdateRows.

<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.

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 a RealTimeToDB add-in used to preprocess data.
See RealTimeToDB Add-Ins.