[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EquisMetaStock Group] Re: Value in explorer is not equal with those in chart



PureBytes Links

Trading Reference Links

Jeff,

I knew it wasn't right when I posted it. I just wanted to point out 
what was going on with the original code. I think Roy cleared the 
air about the code with his revision and showed how it actually 
worked.

More importantly, I wanted to let you know that I indeed was able to 
get the exploration/chart error to appear but it was only after I 
set the exploration options to "Load Minimum Records". At a setting 
of 13000 records I DO NOT get the error.


Preston

  

--- In equismetastock@xxxxxxxxxxxxxxx, "jwlcfp" <jeff@xxx> wrote:
>
> --- In equismetastock@xxxxxxxxxxxxxxx, pumrysh <no_reply@> wrote:
> >Preston,
> I appreciate all of your effort and information. Unfortunately, 
the 
> revision followed my linear regression line, but didn't go into 
the 
> stop mode.  Roy's revision duplicates the trendline. 
> Thanks again,
> Jeff
> > Jeff,
> > 
> > Looking at your formula it does not make sense.
> > Here it is broken down:
> > 
> > If(LinearReg(C,13)>PREV,
> > If(LinearReg(C,13)-(ATR(13)*2)>PREV,
> > LinearReg(C,13)-(ATR(13)*2),PREV),LinearReg(C,13));
> > 
> > There are two If arguments and thus we need two parentheses at 
the 
> > end to close the argument. We have those but now we are short 
one 
> > due to the last LinearReg(C,13) which requires a closing 
> > parenthesis. Referring back to the last PREV you will notice we 
> have 
> > a parenthesis before the last comma. That is where the 
calculation 
> > is drawing its reference for the needed parenthesis. My quess is 
> > that the last prev is actually holding the ATR(13)*2 argument 
true.
> > 
> > Try this formula instead and see if it makes any more sense:
> > 
> > A:= LinearReg(C,13);
> > B:=  LinearReg(C,13)-(ATR(13)*2);
> > If(A and B > PREV,B,A);
> > 
> > This does plot differently so it may not be what you want though.
> > 
> > 
> > As far as the calculation on the chart not being the same as the 
> > explorer I'm going to guess that part of the problem is the prev 
> > argument that I mentioned above. The other may be the 
construction 
> > of the Linear Regession Indicator itself which uses a slope 
> > calculation to derive its final value. Here is a formula that is 
> > pretty close to the canned metastock indicator:
> > 
> > {Linear Regression Indicator}
> > pds:=Input("LinReg periods)",2,5000,20);
> > {Linear Reg calc}
> > y:=pds*Sum(C*Cum(1),pds)
> > -Sum(Cum(1),pds)*Sum(C,pds);
> > z:=pds*Sum(Pwr(Cum(1),2),pds)
> > -Pwr(Sum(Cum(1),pds),2);
> > {Linear Reg Slope}
> > LRS:=y/Max(z,.00001);
> > {Linear Reg Indicator}
> > LRI:=LRS*Cum(1)
> > -LRS*Mov(Cum(1),pds,TIMESERIES)
> > +Mov(C,pds,TIMESERIES);
> > LRI;{end}
> > 
> > 
> > Hope this helps,
> > 
> > Preston
> >  
> > 
> > 
> > 
> > 
> > --- In equismetastock@xxxxxxxxxxxxxxx, "jwlcfp" <jeff@> wrote:
> > >
> > > 
> > > Preston,
> > > 
> > > Here is the indicator:
> > > 
> > > If(LinearReg(C,13)>PREV,If(LinearReg(C,13)-(ATR(13)*2)
> > > >PREV,LinearReg(C,13)-(ATR(13)*2),PREV),LinearReg(C,13));
> > > 
> > > In addition, I am trying to revise the formula without the PREV
> > > function.  I have tried the Ref(ind, -1) but I have been 
> > unsuccessful to
> > > date.
> > > 
> > > Jeff
> > > 
> > > 
> > > --- In equismetastock@xxxxxxxxxxxxxxx, pumrysh <no_reply@> 
wrote:
> > > >
> > > > Jeff,
> > > >
> > > > As I have pointed out to jao, the exploration problems 
usually
> > > > relate to calculations of the exponential or Wilders based
> > > > indicators and having an adequate amount of time for the
> > > > calculations to take place.
> > > >
> > > > I can duplicate jao's problems but only if I use an 
> exploration 
> > data
> > > > period that is too short.
> > > >
> > > > In your case I don't know what indicators you are using but 
I 
> > would
> > > > bet there are some exponential based indicators in there. If 
> you
> > > > want us to take a look we would be happy to.
> > > >
> > > > Double checking your exploration against the chart value is
> > > > certainly a good idea and should be part of a standard 
> operating
> > > > procedure. It just makes good sense.
> > > >
> > > >
> > > > Preston
> > > >
> > > >
> > > >
> > > >
> > > > --- In equismetastock@xxxxxxxxxxxxxxx, "jwlcfp" jeff@ wrote:
> > > > >
> > > > >
> > > > > I have experienced this problem also. I have been working 
> with
> > > > Equis on
> > > > > it off and on for the past 6 months and I have not been 
able 
> to
> > > > resolve
> > > > > the issue. I have sent them my "holy grail" formulas and 
they
> > > > have not
> > > > > been able to solve the issue. They had me try the things 
that
> > > > have been
> > > > > suggested here and they had me remove my program and start 
> > with a
> > > > new
> > > > > version of metastock. I had numerous updates. They said 
they
> > > > > periodically change the way formulas are calculated in 
> > different
> > > > > versions. They could not tell me what formulas were 
changed 
> > with
> > > > the
> > > > > various versions to see if my "holy grail" formulas were 
> > impacted.
> > > > > Never the less, this did not fix the problem.
> > > > >
> > > > > I noticed the problem in a custom formulas- a binary wave 
> that
> > > > would
> > > > > produce a 1 for buy, 0 for hold and -1 for sell. In 
addition 
> I
> > > > will
> > > > > sometimes receive different answers using the same data on
> > > > different
> > > > > computers. Daily I double check the daily, weekly and 
monthly
> > > > > explorer results with the graph results on my current 
> > holdings -
> > > > approx
> > > > > 20 investments. The errors are not consistent- by 
> investment, 
> > time
> > > > > period or frequency. Out of approximately 60 data points 
(20
> > > > > investments x 3 time periods per exploration) there will be
> > > > between zero
> > > > > to 6 errors on a daily basis. The average is 2. I make it a
> > > > standard
> > > > > procedure to double check my exploration.
> > > > >
> > > > > I love Metastock, but this problem does concern me. I wish 
I 
> > could
> > > > > resolve it!
> > > > >
> > > > > Jeff
> > > > > --- In equismetastock@xxxxxxxxxxxxxxx, "strade_hn" 
> <strade_hn@>
> > > > > wrote:
> > > > > >
> > > > > > Hi all,
> > > > > > I used explored to scan my stock, but value return in 
> > explorer is
> > > > > > quite different with one in chart. I use RSI(C,14) in 
> > explorer
> > > > returns
> > > > > 50
> > > > > > while in chart it's 63.
> > > > > > Can anyone help me with this problem?????
> > > > > >
> > > > >
> > > >
> > >
> >
>




 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/equismetastock/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:equismetastock-digest@xxxxxxxxxxxxxxx 
    mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/