Announcement

Collapse
No announcement yet.

SMA in excel efs problem help

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

  • SMA in excel efs problem help

    Is there a version of this that works with QLink 3.0?
    Also is it possible to use this for spread symbols in Esignal 11.0 with Qlink2.0? I have been able to use spreads from 10.6, but not 11.0. Do I need to make some adjustments to the code, or its just not possible at the moment?

  • #2
    This isn't possible at the moment. The next version of QLink that we are working on releasing will be able to do this and it will work a lot better with eSignal's 11 series. I don't have any exact release date for this, just yet but it's something that we are working on.
    Thank you,
    Eric O.
    eSignal Support

    Comment


    • #3
      Originally posted by eostrom View Post
      This isn't possible at the moment. The next version of QLink that we are working on releasing will be able to do this and it will work a lot better with eSignal's 11 series. I don't have any exact release date for this, just yet but it's something that we are working on.
      Thank you very much for the reply. In which case I need to use Qlink 2.0 and Esignal 10.6. The issue I have now is Qlink 2.0 is no longer offered for download on the Esignal website. I spoke with Esignal Support staff yesterday who told me it had been removed as Qlink 3.0 could do everything and more.... Obviously not the case though... Is there somewhere I can download 2.0?

      Also, with the new version being worked on, will it be able to pull data for 1! symbol format?

      Thanks again!!

      Comment


      • #4
        I have tried to modify the script from the link in my first post to return the value for a different indicator. The indicator itself works ok and there doesnt seem to be any syntax errors. However When I load it on a chart I receive an error, "line 162: Type Error: ddeBands has no properties".

        The code below is as I have tried to run it. Am I just a couple of small fixes away from getting this to work? OR am I completely off the mark? Any direction on how to get this working would be much appreciated.

        Thanks!!

        Code:
        var ddeBands = null;
        var fpArray = new Array();
        
        var bInit = false;
        
        
        function preMain() {
            setPriceStudy(true);
        
            setShowCursorLabel(true);
        
            setShowTitleParameters(false);
        
            setStudyTitle("Keltner ATR Band");
        
            setCursorLabelName("Up Band", 0);
        
            setPlotType(PLOTTYPE_LINE, 0);
        
            setDefaultBarFgColor(Color.red, 0);
        
            setCursorLabelName("Dn Band", 1);    
        
            setPlotType(PLOTTYPE_LINE, 1);
        
            setDefaultBarFgColor(Color.red, 1);
        
            var x = 0;
        
            fpArray[x] = new FunctionParameter("SMALength", FunctionParameter.NUMBER);
        
            with(fpArray[x++]) {
        
                setLowerLimit(1);
        
                setDefault(50);
        
            }    
        
            fpArray[x] = new FunctionParameter("ATRMult", FunctionParameter.NUMBER);
        
            with(fpArray[x++]) {
        
                setLowerLimit(1);
        
                setDefault(3.75);
        
            }        
        
            fpArray[x] = new FunctionParameter("ATRLength", FunctionParameter.NUMBER);
        
            with(fpArray[x++]) {
        
                setLowerLimit(1);
        
                setDefault(3.75);
        
            }   
            
         }
        
        
        
        var xKUp = null;
        
        var xKDn = null;
        
        
        function main(SMALength,ATRLength, ATRMult) {
            if (ddeBands == null) {
                var sName = "ddeBands" + getSymbol() + getInterval();
                sName = sName.replace(/\$/g, ""); // remove $ from string
                sName = sName.replace(/\#/g, ""); // remove # from string
                sName = sName.replace(/\-/g, "");
                sName = sName.replace(/\(/g, "");
                sName = sName.replace(/\)/g, "");
                sName = sName.replace(/\ /g, "_") // replace space with underscore
                debugPrintln("DDE Link for Excel =eSignal|EFS!"+sName);
                ddeBands = new DDEOutput(sName);
            }
        
         var nBarState = getBarState();
        
        var nKU = 0;
        
        var nKL = 0;
        
            if (nBarState == BARSTATE_ALLBARS) {
        
                if(SMALength == null) SMALengthLength = 100;
                    
                 if(ATRMult == null) ATRLength = 80;
        
                if(ATRMult == null) ATRMult = 3.75;
                    
                
        
            }
        
            if (bInit == false) {
        
                xKUp = efsInternal("Calc_KeltnerBand", SMALength, ATRLength, ATRMult);
        
                xKDn = getSeries(xKUp, 1);
        
                bInit = true;
        
            }
        
            nKU = xKUp.getValue(0);
        
            nKL = xKDn.getValue(0);
        
            if (nKU == null || nKL == null) return;
        
            return new Array(nKU, nKL);
        
        }
        
        
        
        var bSecondInit = false;
        
        var xMA = null;
        
        var xATR = null;
        
        
        
        function Calc_KeltnerBand (SMALength, ATRLength, ATRMult) {
        
        var nResUp = 0;
        
        var nResDn = 0;
        
        var nMA = 0;
        
        var nATR = 0;
        
            if (bSecondInit == false) {
        
                xMA = sma(SMALength);
        
                xATR = atr(ATRLength);
        
                bSecondInit = true;
        
            }
        
            nMA = xMA.getValue(0);
        
            nATR = xATR.getValue(0);
        
            if (nMA == null || nATR == null) return;
        
            nResUp = nMA + (ATRMult * nATR);
        
            nResDn = nMA - (ATRMult * nATR);
            
            var KeltBands = new Array(nResUp, nResDn) 
            
            ddeBands.set(nResUp);
        
            return KeltBands;
        
            
        }
        Last edited by maninjapan; 07-23-2012, 04:14 AM.

        Comment


        • #5
          doesnt matter, was able to fix it

          Comment


          • #6
            Are there any updates on the progress of efs link to excel using Qlink 3.0/ v11 ?

            Thanks

            Originally posted by eostrom View Post
            This isn't possible at the moment. The next version of QLink that we are working on releasing will be able to do this and it will work a lot better with eSignal's 11 series. I don't have any exact release date for this, just yet but it's something that we are working on.

            Comment


            • #7
              I'm going to get some more information on this before I post anything detailed. Please stand by. Thank you
              Thank you,
              Eric O.
              eSignal Support

              Comment


              • #8
                Eric, were you able to find out anything on this?

                Thanks!!

                Comment


                • #9
                  Can someone please provide an update on this? I have been 'Standing by' for 2 weeks now......

                  Comment


                  • #10
                    We do not have an ETA on an update for QLink yet. We had a version that was not stable enough to release so it is being looked at again. I will hopefully have some more details soon. We want to release something that will be as bug free as possible.
                    Thank you,
                    Eric O.
                    eSignal Support

                    Comment


                    • #11
                      Ok, well at least thank you for the update.

                      Comment

                      Working...
                      X