Databases

Databases

RealTimeToExcel allows refreshing data from databases in Microsoft Excel using RTD formulas.

Getting Real-Time Data from Databases into Microsoft Excel

This feature is useful when you need to refresh the data in complex models that have non-regular structures.

Otherwise, you can load and refresh the data using native Excel features.

See Database Providers about configuring connections.

 

The second scenario is saving data from Yahoo! Finance, Google Finance, and MSN Money in databases.

Yahoo! Finance data in Microsoft Excel

You can use a companion product, RealTimeToDB, that loads data from RealTimeToExcel and saves the data to databases.

RealTimeToDB includes preconfigured databases. So you can quickly get a working process.

See Real-Time Database.