Here it is, Claud's formula translated into WOW. Thank you so much for sending me the chart, Richard, so I could see what the graph was supposed to look like. I've put the resulting chart at the Web page I created to help with this absorbing task of translation: members.aol.com
Maybe I'll expand the site into a TA site. Actually, the ultimate TA site wouldn't need any expanding; it would consist of only one link:
to Andy's page at geocities.com
Anyway, without further ado, here is the BB formula for WOW:
((4*(Std(C,20))/Mov(C,20,S))-
Llv((4*(Std(C,20)/Mov(C,20,S))),260))/
(Hhv((4*(Std(C,20)/Mov(C,20,S))),260)-
Llv((4*(Std(C,20)/Mov(C,20,S))),260)+.001)*100
This is Claud's:
((4*(Std(C,20))/Mov(C,20,S))-
Lowest(4*(Std(C,20))/Mov(C,20,S)))/
(Highest(4*(Std(C,20))/Mov(C,20,S))-
Lowest(4*(Std(C,20))/Mov(C,20,S))+.001)*100
WOW, for anyone wondering -- Richard, I know you know all this -- doesn't read "Lowest" or "Highest." It uses "llv" and "hhv," meaning lowest low value and highest high (aka manic depression or bipolar disorder).
Llv and hhv have to be defined over periods -- llv(data array, periods) -- wherein lies the rub with this formula. Does MSWIN assume a period encompassing the whole chart for "Lowest"?
I tried assuming 20 days for the period in which this mess: 4*(Std(C,20)/Mov(C,20,S)
was at its lowest, but that didn't give a result like the one in the chart Richard sent me. Then I changed it to a period of a year: Llv((4*(Std(C,20)/Mov(C,20,S))),260))
and that gave me a chart like the one with the original formula. Some values are just a hair off, because I don't think I'm using exactly the same period there, but it's close enough. One problem with WOW's need for a period with llv/hhv is that the line doesn't begin on the chart until the period has passed, so the graph doesn't start for 260 days in this case.
I went over the parentheses in Claud's formula with colored pencils, to find out exactly what they were defining. My formula is now faithful to his, I hope. It has more parentheses only to allow for the extra variables with llv and hhv.
Now I think I'll hire a private detective to locate my family, which appears to have moved out. No wait, it appears that I've been moved out -- where am I? How did they manage to send me so far away while keeping my computer plugged in? |
