Real-Time Views for Microsoft Excel

Real-Time Views for Microsoft Excel

Overview

RealTimeToDB allows updating databases with real-time data.

RealTimeToExcel, an included companion product, allows getting real-time data from databases into Microsoft Excel.

You can refresh data in Excel in an easy way.

Getting Data Using SaveToDB Add-In

The RTD database contains preconfigured views with Excel formulas for RealTimeToExcel with the SaveToDB add-in installed.

The SaveToDB add-in converts text formulas from views into native Excel formulas. Just open any view in Excel.

Pasting Formulas into Excel

Also, you can copy formulas using Copy or (Copy) Transposed links and insert formulas into Microsoft Excel.

Select commas or semicolons depend on a separator in your version of Microsoft Excel.

Then adapt the data provider name to your database connections.
For example, change rtd-mysql to rtd-ora if you use Oracle Database.

Configuring RealTimeToExcel Providers

RealTimeToExcel has predefined data providers for every database server:

  • rtd-mssql for Microsoft SQL Server.
  • rtd-sqlce for Microsoft SQL Server Compact.
  • rtd-mysql for Oracle MySQL or SkySQL MariaDB.
  • rtd-ora for Oracle Database.
  • rtd-db2 for IBM DB2.
  • rtd-nuodb for NuoDB.
  • rtd-pgsql for PostgreSQL.

These providers are used in the formulas.

You have to specify a correct connection string before the first use.

Edit connection properties for your database in the data provider configuration file in the DataProviders directory.

Preconfigured Real-Time Data Views

SQL Server and SQL Server CompactMySQL, MariaDB, and PostgreSQLOracle Database, IBM DB2, and NuoDB
FundamentalsDayHistoryYahoofundamentals_day_history_yahooFUNDAMENTALS_DAY_HISTORY_YAHOO
FundamentalsYahoofundamentals_yahooFUNDAMENTALS_YAHOO
OptionDayHistoryTOSoption_day_history_tosOPTION_DAY_HISTORY_TOS
OptionDayHistoryTWSoption_day_history_twsOPTION_DAY_HISTORY_TWS
OptionDayHistoryYahoooption_day_history_yahooOPTION_DAY_HISTORY_YAHOO
OptionDayHistoryGoogleoption_day_history_googleOPTION_DAY_HISTORY_GOOGLE
OptionDayHistoryMsnMoneyoption_day_history_msnmoneyOPTION_DAY_HISTORY_MSNMONEY
OptionsTOSoptions_tosOPTIONS_TOS
OptionsTWSoptions_twsOPTIONS_TWS
OptionsYahoooptions_yahooOPTIONS_YAHOO
OptionsGoogleoptions_googleOPTIONS_GOOGLE
OptionsMsnMoneyoptions_msnmoneyOPTIONS_MSNMONEY
QuoteDayHistoryESquote_day_history_esQUOTE_DAY_HISTORY_ES
QuoteDayHistoryTOSquote_day_history_tosQUOTE_DAY_HISTORY_TOS
QuoteDayHistoryTWSquote_day_history_twsQUOTE_DAY_HISTORY_TWS
QuoteDayHistoryVFXquote_day_history_vfxQUOTE_DAY_HISTORY_VFX
QuoteDayHistoryYahooquote_day_history_yahooQUOTE_DAY_HISTORY_YAHOO
QuoteDayHistoryMsnMoneyquote_day_history_msnmoneyQUOTE_DAY_HISTORY_MSNMONEY
QuotesESquotes_esQUOTES_ES
QuotesTOSquotes_tosQUOTES_TOS
QuotesTWSquotes_twsQUOTES_TWS
QuotesVFXquotes_vfxQUOTES_VFX
QuotesYahooquotes_yahooQUOTES_YAHOO
QuotesMsnMoneyquotes_msnmoneyQUOTES_MSNMONEY
StocksYahoostocks_yahooSTOCKS_YAHOO
CurrenciesDayHistoryYahoocurrencies_day_history_yahooQUOTE_DAY_HISTORY_YAHOO
CurrenciesDayHistoryMsnMoneycurrencies_day_history_msnmoneyQUOTE_DAY_HISTORY_MSNMONEY
CurrenciesYahoocurrencies_yahooQUOTES_YAHOO
CurrenciesMsnMoneycurrencies_msnmoneyQUOTES_MSNMONEY

* Click on the view name to go to the view description.