Dynamic Data Exchange

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

Setting up DDE links from ShareInvestor Station

Step 1. Go to File, select Export DDE. Choose either "Active Channel…" or "Whole Market…".

Step 2. Fill in the details in the pop-up window and click Export.

Dynamic Data Exchange

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|SI!'T39.si;shortname' => SPH

Market and Field Name supported

Dynamic Data Exchange - Market Name Supported
Market Code (IN CAPS) Market
SI Singapore Exchange
MY Bursa Malaysia
WLD_INDX World Indices
Dynamic Data Exchange - Field Name Supported
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
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
lastdonevolume Last Volume Done

Template Saving in DDE

Having trouble to export different columns layout via DDE? With templates enabled in DDE, you can now save and load different templates when exporting data via DDE with ease.

Step 1: Open Microsoft DDE Excel Setup and locate "Template" button

Open DDE

DDE screen

Step 2: Choose columns to save as a template

Choose columns

Step 3: Click on "Template" button to reveal 3 options ("Save as Default", "Save as" and "Organize")

Template button

From this point on, we would be able to:

A. Save as Default Template

Save as Default template

Selecting this will create "Default" template. From this point on, everytime we choose to exporting DDE, "Default" will be choosen and its columns will be automatically added to "Columns To Be Displayed".

Default template

B. Save as / Overwrite

Save as

Selecting this option will prompt us to input template name and save it for future use.

Choose "Save As".

Save as

Input template name and save it.

Naming template

New template created.

Created Template

Overwrite

Repeat "Save as" steps above, but instead of input a template name, choose one of existing template to overwrite.

Overwrite Template

C. Organize

Select "Organize" to Edit template name or Delete a template

Organize Template

To edit template name, double click on template that we want to rename.

Edit Template

To delete a template, click on a template and click on red X button.

Delete Template