DDEOutput Object |
Previous Top Next |
DDEOutput Object
The DDEOutput Object allows EFS to output formula data to Excel via a DDE interface.
DDEOutput Methods
set(value) |
pass value to the DDE client |
Usage
var study = null;
var dde = new DDEOutput( "movavg" + getSymbol() );
var bInit = false;
function preMain() {
setPriceStudy(true);
}
function main() {
var retVal;
if ( bInit==false ) {
//create an EMA study
study = ema( 10 );
bInit=true;
}
//gather the current value from the study
retVal = study.getValue(0);
//if it is not null, assign it to our DDE object
if ( retVal != null) dde.set( retVal );
return( retVal );
}
Setup instructions for Excel
1. | EFS formula with DDEOutput object must be running. |
2. | In Excel, enter a DDE formula with the following format: =eSignal|EFS!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.
Notes:
The identifier string used for the DDE formula in Excel cannot contain any special characters or spaces. If you use the get Symbol() function to build the identifier string, you can use the String.replace() method to parse these items from the string. Please visit the following thread, Moving Average from eSignal into Excel, to see a complete formula example.