PureBytes Links
Trading Reference Links
|
Roy,
No worries...appreciate the help.
Jeff
--- In equismetastock@xxxxxxxxxxxxxxx, "Roy Larsen" <rlarsen@xxx>
wrote:
>
> 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@> 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/
|