Getting Started with RealTimeToExcel

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 may 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:

  1. Getting real-time or delayed data from Yahoo! Finance, Google Finance, MSN Money, and other websites into Microsoft Excel.
  2. 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 may also save loaded data into databases using the companion product, RealTimeToDB.

You may start learning about RealTimeToExcel on the following topics: