|
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:
- Select the cell in which you would like
to create the link.
- 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
|
