|
PureBytes Links
Trading Reference Links
|
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/
|