Mystery solved (mostly) - the following WOW/MSWIN formula appears to be compatible with QP2 / MSWIN Standard CCI (13 period) output:
(typ() - mov(typ(),13,s))/(.015*( abs(ref(typ(),0) - mov(typ(),13,s)) + abs(ref(typ(),-1) - mov(typ(),13,s))+ abs(ref(typ(),-2) - mov(typ(),13,s)) + abs(ref(typ(),-3) - mov(typ(),13,s))+ abs(ref(typ(),-4) - mov(typ(),13,s)) + abs(ref(typ(),-5) - mov(typ(),13,s))+ abs(ref(typ(),-6) - mov(typ(),13,s)) + abs(ref(typ(),-7) - mov(typ(),13,s))+ abs(ref(typ(),-8) - mov(typ(),13,s)) + abs(ref(typ(),-9) - mov(typ(),13,s))+ abs(ref(typ(),-10) - mov(typ(),13,s)) + abs(ref(typ(),-11) - mov(typ(),13,s))+ abs(ref(typ(),-12) - mov(typ(),13,s)) )/13)
Ah, if only I had for loops in WOW it would be easy to make this generic for different periods.
Michael |