DDE Links to Excel

Top  Previous  Next

Description

Realtime symbol data may be accessed from other applications (such as Excel) via Dynamic Data Exchange  (DDE) or Real Time Data (RTD).

Both these mechanisms provide access to the same information, but RTD is a newer protocol that offers several advantages over DDE, including more flexibility and better performance and reliability.

Please note

The DDE Links is only available for symbol quote data – not for trades, history, news or other information
Please note that the program must be running in order to provide DDE links
Make sure that the application has been started and completely logged in before opening any spreadsheets containing DDE links.

Creating DDE links from windows

Highlight the areas you would like to have updated in Excel from the Market window, Composite window or Orderbook.

dde_links

From the main menu select Edit | Copy DDE Link, or just select CTRL+E after you have selected the area.

 

Select Edit | Paste in Excel. Now you have a link to live data in Excel.

Embedding DDE formulas in Excel

The DDE formula has the following format in Excel:

=ontrade|quote!'Symbol&Feed.Field[Level]'

Application|Topic

Always set to "ontrade.quote"

Feed

The feed code (e.g. SSE)

Symbol

The symbol ticker code (e.g. ERIC B)

Field

The field to be displayed (e.g. "last")

[Level]

Optional numeric parameter (used for orderbook levels)

 

Note that in a DDE formula, the parameters may not contain cell references. For more flexible formulas that does allow cell formulas, use RTD links instead.

Sample DDE formulas

=ontrade|quote!'ERIC B&SSE.last'

=ontrade|quote!'NHY&OSS.changepct'

=ontrade|quote!'NOK1V&HSS.turnover'

 

Note: DDE is supported in all Excel versions. If you have Excel 2002 or later, consider using RTD links instead.




Mail us feedback on this topic! 

01/02/2017