[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

--- In equismetastock@xxxxxxxxxxxxxxx, pumrysh <no_reply@xxx> 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/