PureBytes Links
Trading Reference Links
|
Hi Jeff
My comments were not meant in any way as a personal criticism and I'm sorry if I conveyed that impression. As someone who answers the occasional MS question I really just wanted to make my own life a little less complicated in the future :-)
Regards
Roy
----- Original Message -----
From: jwlcfp
To: equismetastock@xxxxxxxxxxxxxxx
Sent: Friday, September 21, 2007 12:28 PM
Subject: [EquisMetaStock Group] Re: Value in explorer is not equal with those in chart
--- In equismetastock@xxxxxxxxxxxxxxx, pumrysh <no_reply@xxx> wrote:
>Roy,
First, thank you for "improving" the formula. Second, I appreciate
your suggestions on asking for help and I will comply in the
future. I agree having information drip-fed can be a painful
process. I just never imagined anyone in a group would put forth so
much effort. Which leads me to number three, thanks again to you
and to everyone else in the group for your valuable contributions.
It's very much appreciated.
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?????
> > > > >
> > > >
> > >
> >
>
__________ NOD32 2542 (20070921) Information __________
This message was checked by NOD32 antivirus system.
http://www.eset.com
[Non-text portions of this message have been removed]
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/
|