See details in the Install and Uninstall topic.
RealTimeToDB allows getting real-time data from RTD or DDE servers and saving the data into databases like this:
As you can see, RealTimeToDB must know what data to get and where to save.
RealTimeToDB can have multiple running instances.
Connection strings in application configuration files define databases to update for each instance.
Field configuration tables in databases define source real-time servers, target database tables, and formulas to update table columns with real-time data.
Table configuration tables in the databases allow tuning loading ticker lists, tables per instances, and temporary disabling certain tables.
- Create database tables for real-time data.
- Create RealTimeToDB configuration database tables.
- Create configurations for real-time data tables.
- Edit the application configuration file.
The RealTimeToDB setup package includes preconfigured RTD databases for supported database platforms.
Use it to create databases quickly and test working.
RealTimeToDB includes preconfigured and activated by default the Microsoft SQL Server Compact rtd.sdf database.
You can start getting real-time data for personal use immediately after install.
Real-Time Data Providers
You can use RTD and DDE servers from your trading applications or real-time data providers like eSignal.
RealTimeToDB includes a companion product, RealTimeToExcel, that can be used as an RTD server for getting data for stocks, options, and currencies from Yahoo! Finance, Google Finance, and MSN Money.
The RTD database includes preconfigured tables for several real-time data providers including RealTimeToExcel.
- Microsoft Azure SQL Database
- Microsoft SQL Server including Express LocalDB
- Microsoft SQL Server Compact
- SkySQL MariaDB
- Oracle MySQL
- Oracle Database
- IBM DB2
Installed IBM DB2 .NET Provider, IBM DB2 OleDB Provider or IBM DB2 ODBC driver is required for working with IBM DB2 databases.
Other platforms are supported by default using the embedded providers.
- Start required RTD or DDE servers.
- Start the RealTimeToDB application.
- Start updating data.
You can start multiple instances of RealTimeToDB. The default instance names are x86 for the 32-bit and x64 for 64-bit executables.
Operating and Monitoring
The main application form allows performing service operations and monitoring services.
The application can be minimized to the System Tray.
Reloading Ticker Lists
RealTimeToDB loads database data on starting and updates the data in real-time.
If you have modified the database data that should be updated, click the Reload button.
Getting Real-Time Data from Databases into Microsoft Excel
RealTimeToExcel, a companion product, allows getting real-time data from databases into Microsoft Excel.
Click the Help, RealTimeToExcel, Help menu item for details.
The RTD Database contains preconfigured views with real-time formulas.
RealTimeToDB has several editions with different features.
Use the Help, Register Product menu item to register the product.