Registered User
Joined: 9/20/2005
Posts: 149
|
I need a formula that will give me a numerical column for this formula (((MAXC21-L)/MAXC21) * 100) where it is positioned within the bollinger bands. Thanks in advance.
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The following assumes simple Bollinger Bands 20, 2.00 as applied to the formula with 0 as the bottom and 100 as the top.
100 * ((1 - L / MAXC21 - AVG(1 - L / MAXC21, 20)) / 4 / SQR(ABS(SUM((1 - L / MAXC21) ^ 2, 20)- 20 * AVG(1 - L / MAXC21, 20) ^ 2) / 20) + .5)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|