RTQuotesXL

RTQuotesXL

Compatibility: MS Excel 2000, 2003, 2007, 2010 (32-bit only)
Current version: 6.1.39 (2012-09-16)
Available in: DownloaderXL, AnalyzerXL, TraderXL Pro packages (compare)



RTQuotesXL downloads free real-time and 15-minutes delayed quotes for stocks, indexes, futures, and mutual funds from Yahoo Finance into Microsoft Excel spreadsheets. Data is available from more than 50 worldwide markets, including the US, Canada, UK, Germany, France, Italy, Australia, and India.

RTQuotesXL automatically draws and updates charts in real-time. The color of the chart title and individual chart elements changes based on the latest price movement. This helps the investor better monitor the current market situation in real-time.

For your convenience, RTQuotesXL downloads data to two spreadsheets: "Quotes" and "Quotes (Vertical)." The "Quotes" spreadsheet is for real-time quote tracking, while "Quotes (Vertical)" is intended for real-time charting and real-time technical analysis. The "Quotes (Vertical)" spreadsheet can be updated in two ways: rolling and appending. Rolling will add new quotes to the bottom and remove old quotes from the top for each update, while Appending will only add new quotes to the bottom, leaving old quotes intact.

Key features summary:

  • Free real-time and 15-minute delayed quotes from Yahoo!Finance
  • Powerful charting capabilities
  • Quotes continuously updated as a background process
  • Two worksheets update simultaneously: one for quote tracking, and the other for charting and data collection.