DDEOutput Object

ICE Data Services -

DDEOutput Object

 

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

 

Example:

 

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

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

 

function preMain() {

setPriceStudy(true);

}

 

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.