PureBytes Links
Trading Reference Links
|
RANGE/(IF(VOLUME<>0, VOLUME, 0.001))
try this
there is nothing wrong with using if statements to make a formula work.
Harley
On Mon, 30 Jun 1997 20:42:49 -0400,
Carey Barnett wrote...
>On the Web site there are many formulae. One of these is the Market =
>Facilitation Index, MFI. The formula given is RANGE/VOLUME.
>
>Plugging this in causes many division by zero errors, as commodity =
>contracts can have a zero volume when they begin to trade. I've been =
>trying to get around this...
>
>RANGE/(IF(VOLUME<>0, VOLUME, 0))
>
> ...this is entirely unsatisfactory. Does anyone have =
>a better idea? Don't you think the choice to IGNORE DIVISION-BY-ZERO =
>errors would be nice?
>
>
>Carey Barnett
>
>"Burned bridges can't even be used for firewood." cb'94
>Yeah... I know about charcoal. Gimme a break!
>
>mailto:cbarnett@xxxxxxxxxxx
>http://webhome.idirect.com/~cbarnett
>Carey Barnett
>
>Remember "Burned bridges can't even be used for firewood." cb '94
>Yeah, I know about charcoal. Gimme a break!
>
>mailto:cbarnett@xxxxxxxxxxx
>http://webhome.idirect.com/~cbarnett/
>
>
Harley Meyer
meyer093@xxxxxxxxxx
|