[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

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/