PureBytes Links
Trading Reference Links
|
Thank you all for your replies.
I will try your suggestions.
Martin
--- In equismetastock@xxxxxxxxxxxxxxx, "Roy Larsen" <rlarsen@xxxx>
wrote:
> Martin
>
> > I have a custom formula, and one of its line is as follow:
> > varA:= IF(H=L,0,Abs(O-C)/(H-L));
> >
> > Basically, I want to make sure that there is a difference between
> > High and Low on a given period before performing the calculation.
> >
> > My problem is that "Abs(O-C)/(H-L)" seems to get evaluated, even
if
> > H=L.
>
> This happens because of the precedence that expressions in a
formula are given when MS is
> calculating the result. The division by zero is performed (and
therefore reports the error) before
> the IF() function is evaluated. Put another way, what's in the
innermost brackets is calculated
> first. Any error will be reported to the next calculation that
evaluates the result. The If()
> function will not solve such a problem and it must be handled in
another way, such as the
> suggestions that have already been made.
>
> Roy
>
>
> > If H=L, the final result will be accurate, *BUT* I will still get
> > the "division by zero" error when opening the chart.
> >
> > Is there a workaround for this? Maybe a way to "tell" MetaStock
to
> > not look at a piece of code that does not match a condition?
> >
> > Thanks!
> > Martin
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/equismetastock/
<*> 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/
|