[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [EquisMetaStock Group] Weirdness in formula



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/