I'm back with new questions: I've been looking at your CMO plot for ASND in Metstock, and I realize I've been using absCMO in WOW. Excel uses AbsCMO in the calculation of Vidya, and I was using a WOW translation of that formula for CMO. But CMO has negative values, and is different than absCMO, of course.
TASC describes CMO as:
CMO=100*((Su-Sd)/(Su+Sd)
Or:
CMO=100* ((Sum of prices on up days - sum of prices on down days)/ (Sum of prices on up days + sum of prices on down days))
And TASC gives the Excel formulas for the sum of up days and down days. They're basically binary and sum formulas, and I've translated them into WOW as:
Vid1: if (c>ref(c,-1), c - ref(c,-1),0) Vid 2: if (c<ref(c,-1), c - ref(c,-1),0)
Vid3: sum(fml("Vid1"),9) Vid4: sum(fml("Vid2"),9)
CMO, then, can be translated as:
100*((sum(fml("Vid1"),9)-sum(fml("Vid2"),9))/ (sum(fml("Vid1"),9)+sum(fml("Vid2"),9)))
This works in WOW, but the plot is not quite like the one for CMO in your Metastock chart. Am I missing something, or is there a more complete formula for CMO that TASC didn't give in the Vidya article? Does Chande give a more accurate formula?
The WOW formula gives an oscillator ranging in value from -100 to 100. |