The DDE feature allows you to stream
Live Desktop Streamer information into your Excel spreadsheet. This
information can be used as part of a formula that will display
real-time information that you have analyzed and is based off of live
information.
The DDE feature is no longer supported by Microsoft Excel. To use the DDE feature, we would recommend using Open Office.
To use the DDE feature, please follow the steps below:
Open the Live Desktop Streamer Application in "Administrator Mode". To open the live desktop application in "Administrator Mode", right-clicking on the “Live Desktop Streamer” icon and then select “Run as Administrator”.
-
Your computer may ask for permission for this program to make changes to computer. If you are asked for permission, please click “Yes”.
- Run Open Office in "Administrator Mode" by following the instructions above.
- To enter live information into a cell, enter this formula below into a cell:
=DDE("quotestream";"symbol";"information").
- Replace symbol, in the formula above, with the symbol that you would like information on. For example, MSFT would be entered as the symbol for Microsoft. Next, replace information with the type of information that you would like on the symbol, such as Last for the last known value of the symbol.
- Please be sure to enter the symbol and information type surrounded by quotation marks, as the information requires that the quotation marks surround the entries in the formula.
Live information should now appear in the open office spreadsheet cells.