Announcement

Collapse
No announcement yet.

DDE Output - Get Studies value into Excel

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • juju075
    started a topic DDE Output - Get Studies value into Excel

    DDE Output - Get Studies value into Excel

    Hello

    I'm trying to retrieve my DDE output data into excel (moving average)

    This script works fine (running as insert study in my chart) but i cannot get the return
    in my spreadsheet with recommended formula

    =eSignal|EFS!movavgIBM

    Thanks for your help.

    ///////////////////////////////////////////////////////

    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;
    }

  • ACM
    replied
    juju075
    Seems to be working at my end (see image enclosed below)
    Alex






    Originally posted by juju075 View Post
    Hello

    I'm trying to retrieve my DDE output data into excel (moving average)

    This script works fine (running as insert study in my chart) but i cannot get the return
    in my spreadsheet with recommended formula

    =eSignal|EFS!movavgIBM

    Thanks for your help.

    ///////////////////////////////////////////////////////

    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;
    }

    Leave a comment:

Working...
X