RTQuotesXL

RTQuotesXL downloads real-time stock, index, futures and mutual fund quotes directly into Microsoft Excel spreadsheets. Free 15-minute delayed and fee-based real-time quotes for stocks, indices, and mutual funds are retrieved from Yahoo! Finance. 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.

Quotes can be provided to third party applications via Dynamic Data Exchange (DDE) links. RTQuotesXL can create DDE links to the latest price quotes located on the "Quotes" spreadsheet, or you can set up your own DDE links to any cell on any workbook.

Key features summary:

Free 15-minute delayed quotes from Yahoo! Finance
Fee-based real-time quotes from Yahoo! Finance and coming soon from Interactive Brokers
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
Provides real-time quotes to third party applications via DDE:
RTQuotesXL can be used as a Dynamic Data Exchange (DDE) Server, which allows it to provide real-time stock market information for any DDE-compliant client application. This could be a charting application, data mining application, or any other software with a use for the data. RTQuotesXL automatically creates DDE links to the latest price values in the "Quotes" spreadsheet. You can also set up DDE links for any other cell in your workbooks.

To find DDE link names created by RTQuotesXL, select a "Last Price" cell and then look at the Range Name box (left side of the formula bar). DDE Items will be listed such as "TICKER_Last":

General DDE Link format can be used in any 3rd party software that supports DDE links:
- DDE Server: Excel
- Topic: Spreadsheet name
- Item: Range name

Additional information:

Specifications for the "Yahoo" data source.
Demo screenshots of RTQuotesXL:
RTQuotesXL Toolbar:

RTQuotesXL Ticker Manager:

"Quotes (Vertical)" spreadsheet for real-time charting and real-time technical analysis. RTQuotesXL automatically builds and updates charts:

"Quotes" spreadsheet for real-time quote tracking: