Real-Time Database

Real-Time Database

Overview

RealTimeToExcel is deeply integrated with a companion product RealTimeToDB.

RealTimeToDB allows updating databases with real-time data from RTD and DDE servers including the RealTimeToExcel RTD server.

RealTimeToDB has preconfigured databases for all supported database platforms and several real-time data servers.

You can use these databases for getting real-time data in Microsoft Excel.

The default RTD database for Microsoft SQL Server Compact is integrated into the SaveToDB add-in and works by default.
You can open the workbook template from the External Tools wizard and get working examples.

The common schema looks like this:

Saving Real-Time Data to Database and Using Real-Time Data in Microsoft Excel

For Yahoo! Finance data, the schema looks like this:

Yahoo! Finance data in Microsoft Excel

Usage

See RealTimeToDB Help to get the complete list of available tables and Excel formulas.

From the RealTimeToExcel side, you have to configure the real-time database provider in the DataProviders directory.

Formulas to get the data are simple. For example:

=RTD("gartle.rtd",,"rtd-sqlce","QuotesYahoo","AAPL","Last")
=RTD("gartle.rtd",,"rtd-mysql","fundamentals_yahoo","AAPL","OneYearTargetPrice")

In the example above, the first formula uses the rtd-sqlce database provider, and the second one uses the rtd-mysql database provider.

The other formula parts are regular for the RealTimeToExcel and described in the RealTimeToDB help.

For example, RealTimeToDB 3.0 includes the following preconfigured real-time tables:

SQL Server and SQL Server CompactMySQL, MariaDB, and PostgreSQLOracle Database, IBM DB2, and NuoDB
FundamentalsYahoofundamentals_day_history_yahooFUNDAMENTALS_DAY_HISTORY_YAHOO
FundamentalsDayHistoryYahoofundamentals_yahooFUNDAMENTALS_YAHOO
StocksYahoostocks_yahooSTOCKS_YAHOO
QuotesYahooquotes_yahooQUOTES_YAHOO
QuoteDayHistoryYahooquote_day_history_yahooQUOTE_DAY_HISTORY_YAHOO
QuoteTimeHistoryYahooquote_time_history_yahooQUOTE_TIME_HISTORY_YAHOO
QuoteTickHistoryYahooquote_tick_history_yahooQUOTE_TICK_HISTORY_YAHOO
QuotesMsnMoneyquotes_msnmoneyQUOTES_MSNMONEY
QuoteDayHistoryMsnMoneyquote_day_history_msnmoneyQUOTE_DAY_HISTORY_MSNMONEY
QuoteTimeHistoryMsnMoneyquote_time_history_msnmoneyQUOTE_TIME_HISTORY_MSNMONEY
QuoteTickHistoryMsnMoneyquote_tick_history_msnmoneyQUOTE_TICK_HISTORY_MSNMONEY
OptionsYahoooptions_yahooOPTIONS_YAHOO
OptionDayHistoryYahoooption_day_history_yahooOPTION_DAY_HISTORY_YAHOO
OptionTickHistoryYahoooption_tick_history_yahooOPTION_TICK_HISTORY_YAHOO
OptionsGoogleoptions_googleOPTIONS_GOOGLE
OptionDayHistoryGoogleoption_day_history_googleOPTION_DAY_HISTORY_GOOGLE
OptionTickHistoryGoogleoption_tick_history_googleOPTION_TICK_HISTORY_GOOGLE
OptionsMsnMoneyoptions_msnmoneyOPTIONS_MSNMONEY
OptionDayHistoryMsnMoneyoption_day_history_msnmoneyOPTION_DAY_HISTORY_MSNMONEY
OptionTickHistoryMsnMoneyoption_tick_history_msnmoneyOPTION_TICK_HISTORY_MSNMONEY
QuotesESquotes_esQUOTES_ES
QuoteDayHistoryESquote_day_history_esQUOTE_DAY_HISTORY_ES
QuoteTimeHistoryESquote_time_history_esQUOTE_TIME_HISTORY_ES
QuoteTickHistoryESquote_tick_history_esQUOTE_TICK_HISTORY_ES
QuotesTOSquotes_tosQUOTES_TOS
QuoteDayHistoryTOSquote_day_history_tosQUOTE_DAY_HISTORY_TOS
QuoteTickHistoryTOSquote_tick_history_tosQUOTE_TICK_HISTORY_TOS
OptionsTOSoptions_tosOPTIONS_TOS
OptionDayHistoryTOSoption_day_history_tosOPTION_DAY_HISTORY_TOS
OptionTickHistoryTOSoption_tick_history_tosOPTION_TICK_HISTORY_TOS
QuotesTWSquotes_twsQUOTES_TWS
QuoteDayHistoryTWSquote_day_history_twsQUOTE_DAY_HISTORY_TWS
QuoteTickHistoryTWSquote_tick_history_twsQUOTE_TICK_HISTORY_TWS
OptionsTWSoptions_twsOPTIONS_TWS
OptionDayHistoryTWSoption_day_history_twsOPTION_DAY_HISTORY_TWS
OptionTickHistoryTWSoption_tick_history_twsOPTION_TICK_HISTORY_TWS
QuotesVFXquotes_vfxQUOTES_VFX
QuoteDayHistoryVFXquote_day_history_vfxQUOTE_DAY_HISTORY_VFX
QuoteTimeHistoryVFXquote_time_history_vfxQUOTE_TIME_HISTORY_VFX
QuoteTickHistoryVFXquote_tick_history_vfxQUOTE_TICK_HISTORY_VFX
CurrenciesYahoocurrencies_yahooCURRENCIES_YAHOO
CurrenciesDayHistoryYahoocurrencies_day_history_yahooCURRENCIES_DAY_HISTORY_YAHOO
CurrenciesTimeHistoryYahoocurrencies_time_history_yahooCURRENCIES_TIME_HISTORY_YAHOO
CurrenciesTickHistoryYahoocurrencies_tick_history_yahooCURRENCIES_TICK_HISTORY_YAHOO
CurrenciesMsnMoneycurrencies_msnmoneyCURRENCIES_MSNMONEY
CurrenciesDayHistoryMsnMoneycurrencies_day_history_msnmoneyCURRENCIES_DAY_HISTORY_MSNMONEY
CurrenciesTimeHistoryMsnMoneycurrencies_time_history_msnmoneyCURRENCIES_TIME_HISTORY_MSNMONEY
CurrenciesTickHistoryMsnMoneycurrencies_tick_history_msnmoneyCURRENCIES_TICK_HISTORY_MSNMONEY

Where:

YahooYahoo! Finance
GoogleGoogle Finance
MsnMoneyMSN Money
TOSThinkorswim thinkDesktop
TWSInteractiveBrokers Trader Workstation (TWS)
ESeSignal FutureSource
VFXHybrid Solutions VertexFX Trader (VFX)