Using RealTimeToDB

Using RealTimeToDB

Installing Application

See details in the Install and Uninstall topic.

Configuring Application

RealTimeToDB allows getting real-time data from RTD or DDE servers and saving the data into databases like this:

Saving Real-Time Data to Database

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.

Configuration Steps

  1. Create database tables for real-time data.
  2. Create RealTimeToDB configuration database tables.
  3. Create configurations for real-time data tables.
  4. Edit the application configuration file.

Ready-To-Use Databases

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 may start getting real-time data for personal use immediately after install.

Real-Time Data Providers

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

Updating Database with Yahoo! Finance data

The RTD database includes preconfigured tables for several real-time data providers including RealTimeToExcel.

Database Platforms

RealTimeToDB supports:

  • Microsoft Azure SQL Database
  • Microsoft SQL Server including Express LocalDB
  • Microsoft SQL Server Compact
  • SkySQL MariaDB
  • Oracle MySQL
  • Oracle Database
  • IBM DB2
  • NuoDB
  • PostgreSQL

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.

Running Application

Starting Steps

  1. Start required RTD or DDE servers.
  2. Start the RealTimeToDB application.
  3. Start updating data.

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

RealTimeToDB Interface

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.

Getting data from a database in Excel using RealTimeToExcel

Click the Help, RealTimeToExcel, Help menu item for details.

The RTD Database contains preconfigured views with real-time formulas.

Registering Application

RealTimeToDB has several editions with different features.

Use the Help, Register Product menu item to register the product.