RTQuotesXL DDE Links

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."

The link we are about to create can be used by any third party software that is DDE-compliant.

To create a DDE link manually perform the following steps:

1. Select the cell in which you would like to create the link.
2. Enter an item name in the Range Name box (located on the left of the formula bar).

That's it - you can now use your newly created DDE link!

General DDE Link format

This link can be used in any 3rd party software, that supports DDE links:

• DDE Server: Excel
• Topic: Spreadsheet name
• Item: Range name

Please see also software products of AnalyzerXL, LLC