[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,

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@xxx> 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/