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:

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.

 

 

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: