RTD DB Version History

Version 5.26, May 28, 2025

Licensing Changes

Introduced a dual licensing model:
The free edition is now licensed under the MIT License.
The Personal, Standard, and Enterprise editions are licensed under the updated End-User License Agreement (EULA).
The free edition now supports saving data on up to ten tickers.

Breaking Changes

Removed the local CHM help file; use the online documentation instead.
Discontinued support for Oracle Database, DB2, NuoDB, and SQL Server Compact.

Improvements

Updated documentation.
Updated database templates.
Updated data providers: MySqlConnector, Npgsql, and SQLite.

Version 5.25, April 30, 2024

Bug fixes:

Resolved issues with MySqlConnector and Npgsql data providers.

Version 5.24, April 29, 2024

Improvements:

Added High DPI support.
Removed database templates and data providers for Oracle Database, IBM DB2, NuoDB, and SQL Server Compact.
RTD DB now includes the MySqlConnector data provider instead of the MySQL Data Provider.

Bug fixes:

Fixed issue where parameter values failed to convert from TimeSpan to DateTime.

Version 5.23, June 27, 2023

Bug fixes:

RTD DB does not call data processor add-in methods.

Version 5.22, February 21, 2023

Improvements:

RTD DB utilizes the MySql.Data.MySqlClient data provider installed on the system, replacing the previously bundled version. This allows for the installation and use of the latest provider version:
MySQL Connector/NET Download
RTD DB dynamically substitutes the missing MySql.Data.MySqlClient data provider with the built-in MySqlConnector provider.
Updated DBEdit tool.

Bug fixes:

Resolved exceptions when connecting to MySQL 8 using MySql.Data.MySqlClient.

Version 5.21, January 23, 2023

Important changes:

RTD DB databases are now licensed under the MIT license.

Improvements:

Updated DBEdit tool.
Updated Product Registration Wizard.
Updated AutoUpdate tool.

Version 5.20, December 20, 2022

Bug fixes:

Fixed issue where RTD DB did not load SQLite tables.
Resolved problem where RTD DB failed to save formula values if the source column did not exist in the table.

Version 5.19, December 13, 2022

Improvements:

Updated DBEdit tool.
Updated Product Registration Wizard.
Updated AutoUpdate tool.

Bug fixes:

The AutoUpdate tool incorrectly reported on DBEdit instead of RTD DB.

Version 5.18, July 5, 2022

New features:

RTD DB now includes the DBEdit tool for viewing and editing database data, including support for SQLite databases.

Improvements:

RTD DB is now available in Portuguese.
The registration wizard and AutoUpdate tool are available in Portuguese, Simplified Chinese, Traditional Chinese, Japanese, and Korean.

Version 5.17, March 22, 2021

New features:

RTD DB introduces the AutoUpdate tool for checking and installing updates. Launch the wizard manually via Help > Check Updates.
RTD DB supports PostgreSQL ODBC drivers. Install psqlodbc_13 for compatibility with PostgreSQL 13. Download drivers from PostgreSQL ODBC Releases.

Improvements:

RTD DB is compiled for .NET Framework 4.7.2.
PostgreSQL database scripts now include IF NOT EXIST rules for indexes.
The configuration editor now has a log page.
RTD DB includes an updated PostgreSQL .NET provider.
RTD DB embeds language files.

Bug fixes:

Resolved DateTime and TimeSpan conversion exceptions with older ODBC providers.
Fixed exception in the configuration editor when pasting values into empty tables.

Version 5.16, June 30, 2020

Improvements:

Added German translation.

Bug fixes:

Resolved NullReferenceException in the registration wizard.

Version 5.15, May 7, 2020

New features:

RTD DB now supports new application settings to define decimal and group separators in the following format:
<Server>DecimalSeparator
<Server>GroupSeparator

Example for thinkorswim desktop DDE:

    <add key="TosDecimalSeparator" value="." />
    <add key="TosGroupSeparator" value="," />

Bug fixes:

RTD DB now saves NaN values as NULL.

Version 5.14, February 28, 2020

Improvements:

Updated database templates include enhanced tables for thinkorswim desktop via DDE and SQL scripts for converting RTD formulas to DDE and vice versa. It is recommended to use thinkorswim desktop via DDE to avoid potential crashes when loading data for more than 500 tickers. Thinkorswim via DDE supports loading any number of tickers using cycling.
Improved registration wizard.
Enhanced activation process in virtual environments.

Version 5.13, September 17, 2018

New features:

Introduced new application setting <RTD Server>MaxTotalTopics, which defines the maximum number of topics created for the RTD server. RTD DB restarts the RTD client when more topics are required. This setting addresses the issue with thinkorswim, which allows the creation of approximately 200,000 topics, leading to a "pure virtual function call" exception.

Recommended settings for thinkorswim:

    <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="False"/>

Set tos.rtdIsDynamicCalls = True if Microsoft Excel is not installed.

Bug fixes:

Resolved NullReferenceException in the Configuration Editor.

Version 5.11, June 22, 2018

The free RTD DB edition is no longer available. Existing users of the free edition may continue to use it.

Version 5.10, May 24, 2018

Improvements:

Updated Product Registration Wizard.

Version 5.9, March 26, 2018

New features:

Introduced the new RTD DB Database Configuration Editor for editing database tables.
Added Symbol Helper for extracting stock and option symbols from RTD formulas and web pages. For example, copy Excel formulas from thinkorswim and paste them into the application.
Added SQLite support.
RTD DB now embeds SQLite and Microsoft SQL Server Compact databases, allowing users to try these databases before creating a target database in SQL Server, MySQL, or another supported platform. Use the SQLite ODBC driver to load data from the SQLite database. It is also recommended to use the free Database .NET application for database management. Download it at Database .NET.
Introduced new functions for retrieving 30-minute data: DateTime30 and Time30.

Improvements:

Redesigned RTD databases. Databases for Microsoft SQL Server and SQL Server Compact now use lowercase names for compatibility with MySQL, PostgreSQL, and SQLite. The real_time_tables and RealTimeFormulas tables have been renamed to real_time_tables and real_time_formulas.
RTD DB now uses notepad.exe as the default configuration file editor, launching it with administrator privileges if required. Users can change the editor using the ConfigurationFileEditor application setting.

Version 5.8, March 12, 2018

Improvements:

Enhanced default application settings for thinkorswim.
Improved default field settings for thinkorswim.

Bug fixes:

Fixed issue with empty values in the FrontExpectedMove, BackExpectedMove, and ExpectedMoveDiff fields in thinkorswim.

Version 5.7, February 7, 2018

Improvements:

Updated Product Registration Wizard.

Version 5.6, November 3, 2017

Bug fixes:

Resolved WebException in the registration wizard while in offline mode.

Version 5.5, August 22, 2017

Breaking changes:

Changed .NET platform from .NET Framework 4.0 Client Profile to .NET Framework 4.5.2.
Updated requirements for Windows 7, Windows Server 2008, and Windows Server 2008 R2.
Removed support for Windows XP.
Removed support for SQL Server 2000.
Removed support for MySQL versions 5.0, 5.1, and 5.2.
Removed support for MariaDB versions 5.1, 5.2, and 5.3.

Bug fixes:

Resolved issues with product registration.

Version 5.4, August 1, 2017

New features:

Added Azure Active Directory Integrated authentication.
Added Azure Active Directory Password authentication.

Version 5.3, July 5, 2017

Improvements:

Updated registration wizard.
Updated installer.

Bug fixes:

Corrected ticker limits in RTD DB Personal.

Version 5.2, May 31, 2017

Improvements:

Updated installer.
Updated documentation.

Version 5.1, May 11, 2017

Improvements:

Added support for ODBC Driver 13 for SQL Server.
Improved Spanish translation.
Enhanced documentation.

Version 5.0, May 1, 2017

RTD DB 5.0 is a major upgrade of RealTimeToDB. The new name reflects the primary function of saving data from RTD and DDE servers to databases.

Existing users can install RTD DB as a new product, evaluate it, and purchase the upgrade. See upgrade notes.

Licensing Changes

RTD DB now offers a free edition that allows data retrieval for up to ten tickers. Paid editions feature a simplified limit model, with increased limits for updated rows in the Personal and Standard editions.

Refer to Edition Comparison for details. The trial period has been reduced from 30 days to 15 days, and registration is required to initiate a trial. RTD DB is available via subscription, and major upgrades will incur a fee unless the Upgrade Warranty is purchased with new acquisitions.

Improvements:

Redesigned RTD database. See Database Templates.
Rewritten documentation. Refer to Concept and Configuring Tables.
OCC option codes, such as AAPL180119C0015000, can now be used in ticker tables for thinkorswim desktop. The application automatically converts these option codes to the thinkorswim format (e.g., .AAPL180119C150).
Expired option codes loaded from ticker tables are ignored.

Other Changes

RTD DB no longer includes the default SQL Server Compact database with activated RealTimeToExcel. The setup package no longer installs RealTimeToExcel or related menu topics, as most users utilize SQL Server and MySQL databases, loading data from trading platforms like thinkorswim or Trader Workstation, and from paid data sources like eSignal or Bloomberg.

The latest RTD DB version features a clear database structure and a well-defined concept for implementing these tasks with reduced effort.

Users can still utilize their SQL CE database, create new ones, and install RealTimeToExcel separately.