Dynamic Data Exchange
 Previous Top Next
Dynamic Data Exchange (DDE) is a feature that enables real-time automatic update of stock information from the application to any DDE enabled applications, e.g. Excel spreadsheet.

graphic


Setting up DDE links from the application
1.   Go to File -> Export DDE. Choose either
(a) Active Channel
(b) Whole Market
      
graphic


2.   A pop-out dialog is shown. Fill in the details and Click Export.

graphic


Setting up DDE links from Excel Spreadsheet
Type in the formula using the format below:

=SIDE|<Market Code>!'<Stock Code>;<Field Name>'
E.g.: =SIDE|MY!'1818.my;shortname'      =>   Bursa


Market and Field Name Supported

 
Market Code (IN CAPS)
Market
MY
Bursa Malaysia
WLD_INDX
World Indices


  
Field Name
Explanation
code
Counter's code
shortname
Counter's short name
fullname
Counter's full name
type
Counter's type (stocks, warrants, indices, etc.)
status
Counter's remarks (H, BI, CD, XD, etc.)
currency
Counter's traded currency (S$, US$, etc.)
last
Last Done Price
lastdonevolume
Last Done Volume
open
Open Price
high
High Price of the trading day
low
Low Price of the trading day
prevclose
Close Price of the previous trading day
bid
Buy Price
ask
Ask Price
bidsize
Buy Volume
asksize
Ask Volume
change
Change in Price (Last Done Price - Yesterday Close Price)
pctchange
Percentage Change in Price
turnover
Traded value (traded price x traded volume)
volume
Cumulative Traded volume
updatedtime
Last Traded Time
presessionprice
Pre-Session Price
presessionvolume
Pre-Session Volume