That's the same formula I came up with, in my revised one, without the abs, believe it or not. There are just a few extra commas in Metastock's language. Here's the translation for WOW:
100*((Sum(If(C>Ref(C,-1),(C-Ref(C,-1)),0),14))-(Sum(If(C<REF(C,-1),(REF(C,-1)-C),0),14)))
/((Sum(If(C>Ref(C,-1),(C-Ref(C,-1)),0),14)+(Sum(If(C<REF(C,-1),(REF(C,-1)-C),0),14))))
I did it with periods ("pers")in WOW, so periods could be changed:
100*((Sum(If(C>Ref(C,-1),(C-Ref(C,-1)),0),pers))-(Sum(If(C<REF(C,-1),(REF(C,-1)-C),0),pers)))
/((Sum(If(C>Ref(C,-1),(C-Ref(C,-1)),0),pers)+(Sum(If(C<REF(C,-1),(REF(C,-1)-C),0),pers))))
I haven't posted a chart with this yet. You saw strange things in the chart I posted because it wasn't CMO; it was really absCMO, unbeknownst to me at the time.
The Equis formula, then, is the same as the Excel formula from TASC. My mistake a couple of days ago was adding absolute value, because I saw it added to CMO as part of the Excel formula for Vidya. |
