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

Re: [EquisMetaStock Group] Weirdness in formula



PureBytes Links

Trading Reference Links



I recall at one seminar it was suggested one would be better off using 
some variant of (in this instance) H/L<1.0001 rather than H=L to avoid 
issues of MS's treatment of numbers s well as some possible data feed 
issues.


mlaporte99 wrote:

>Hello,
>
>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.
>
>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/