DDEOutput Object

ICE Data Services -

DDEOutput Object


The DDEOutput Object allows EFS to output formula data to Excel via a DDE interface.




var study = new MAStudy(10, 0, "Close", MAStudy.SIMPLE);

var dde = new DDEOutput("movavg" + getSymbol());


function preMain() {




function main() {

var vRet = study.getValue(MAStudy.MA);

if(vRet != null) dde.set(vRet);

return vRet;




Setup instructions for Excel:


  •  EFS formula with DDEOutput object must be running.
  •  In Excel, enter a DDE formula with the following format:  =eSignal|EFS!movavgIBM


The Excel configuration above would require that the example formula above be running on a chart of IBM.  When the DDEOutput object is initialized in the EFS script (i.e., var dde = new DDEOutput(sItem)), 'sItem' becomes the string that needs to be referenced in the Excel formula.  In our example above sItem becomes "movavgIBM".


You can create multiple DDE objects within a single script. For example, if you implement a script that calculates 5 different indicators, you could create a DDEOutput Object for each indicator (remember to assign each DDEObject a unique string identifier) and then retrieve that same information from within an Excel spreadsheet.