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 may 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 may open the workbook template from the External Tools wizard and get working examples.

The common schema looks like this:

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

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)
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.