Here are my translations of TASC's Excel formulas for Tushar Chande's Vidya and the Chande momentum oscillator. I hope the formulas, which are for WOW, are correct. Thank you so much for the TASC article, Claude..
The CMO looks useful -- and I suppose it could be interpreted in much the same way that RSI is. As for Vidya , which is a moving average, I don't really know what to do with it. How does Chande use the Vidya MA? Does anyone else have any ideas on this? I don't have the original TASC article, only the sidebar with the formulas.
In any case, here are the WOW formulas:
Vid1:
if (c>ref(c,-1), c- ref(c,-1),0)
Vid 2:
abs(if (c<ref(c,-1),c - ref(c,-1),0))
Vidya
((2/(pers+1))*(abs((sum(fml("Vid1"),pers2)-sum(fml("Vid2"),pers2))/
(sum(fml("Vid1"),pers2)+sum(fml("Vid2"),pers2))) )*c)
+((1-((2/(pers+1))*(abs((sum(fml("Vid1"),pers2)
-sum(fml("Vid2"),pers2))/
(sum(fml("Vid1"),pers2)+sum(fml("Vid2"),pers2))) )))*ref(c,-1))
Where pers = period for Vidya smoothing constant, with default at 12
and pers2 = pers for CMO, with default at 9
Chande's Momentum Oscillator (CMO)
100*(abs((sum(fml("Vid1"),pers2)-sum(fml("Vid2"),pers2))/
(sum(fml("Vid1"),pers2)+sum(fml("Vid2"),pers2))))
Vidya Uband (upper band):
ref(c,-1)*1.01
Vidya Lband (lower band):
That's it. I've got another version, which makes it easier to see what it's all about. The disadvantage with this version is that CMO and Vidya aren't variable. But this one is easier to follow:
Vid1:
if c>ref(c,-1), c - ref(c,-1),0)
Vid 2:
abs(if (c<ref(c,-1), c - ref(c,-1),0))
Vid3:
sum(fml("Vid1"),9)
where 9 is the period for CMO
Vid4:
sum(fml("Vid2"),9)
Vid5:
abs((fml("vid3")-fml("vid4"))/(fml("vid3")+fml("vid4")))
Vidya
(.1538*fml("vid5")*c)+((1-(.1538*fml("vid5")))*ref(c,-1))
where .1538 represents: 2/(12+1), where 12 is the variable period for Vidya
Vidya Uband:
ref(c,-1)*1.01
Vidya Lband:
ref(c,-1)*.99
That's it, kids. Have fun with it all. Get Vidya-tized. As I said, I hope there are no errors.
Brooke |
