Announcement

Collapse
No announcement yet.

DDE Output - Get Studies value into Excel

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

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

  • #2
    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;
    }

    Comment

    Working...
    X