Getting Started with RealTimeToExcel

Microsoft Excel has the "magic" RTD function that allows refreshing values from real-time data servers in Excel spreadsheets.

The RTD function can be used in regular Microsoft Excel formulas.

So you can use cell values as formula arguments and build powerful refreshable data sheets and models in a couple of minutes.

For example:

Example of Yahoo! Finance Quotes

Used formulas look like:

=RTD("gartle.rtd",,"YahooFinanceWatchList","AAPL","Open")
=RTD("gartle.rtd",,"YahooFinanceWatchList","AAPL","High")
=RTD("gartle.rtd",,"YahooFinanceWatchList","AAPL","Low")
=RTD("gartle.rtd",,"YahooFinanceWatchList","AAPL","Last")

=RTD("gartle.rtd",,"YahooFinanceQuotes","YHOO","EPSEstimateCurrentYear")
=RTD("gartle.rtd",,"YahooFinanceQuotes","YHOO","EPSEstimateNextYear")

YahooFinanceWatchList and YahooFinanceQuotes are data providers included in RealTimeToExcel.

RealTimeToExcel is an RTD server for Microsoft Excel that allows:

Getting real-time or delayed data from Yahoo! Finance, Google Finance, MSN Money, and other websites into Microsoft Excel.
Getting real-time or delayed data from databases into Microsoft Excel.

Getting Yahoo! Finance data into Microsoft Excel

Getting Real-Time Data from Databases into Microsoft Excel

Yahoo! Finance, Google Finance, and MSN Money publish delayed quotes and financial data from 60 world's exchanges free of charge for non-commercial use.

RealTimeToExcel is an intermediary that loads data from Yahoo! Finance, Google Finance, MSN Money, or other websites and refreshes data in Microsoft Excel.

RealTimeToExcel also allows refreshing data from database tables in Excel in an easy way, without coding.

You can also save loaded data into databases using the companion product, RealTimeToDB.

You can start learning about RealTimeToExcel on the following topics:

Database Providers