Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Acceleration Bands
Template (v17+)
Top Band
AVGHx + 4 * w * AVG(H * (H - L) / (H + L), x)
Bottom Band
AVGLx - 4 * w * AVG(L * (H - L) / (H + L), x)
Where x is the Period of the Acceleration Bands.
Where w is the Width setting of the Acceleration Bands.
Related Topics
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 4/30/2015
Posts: 197
|
Trying to apply on an actual chart using default settings for Acceleration Bands
This is how i inserted X and W, but my numbers on the charts are very different
What do i have incorrect?
Top Band
AVGH20 + 1 * AVG(H * (H - L) / (H + L), 20)
Bottom Band
AVGL20 - 1 * AVG(L * (H - L) / (H + L), 20)
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The issue was that w needs to be 4 times the Width setting of the Acceleration Bands and not just set to the Width setting itself. This has been corrected above.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
After a very short amount of additional thinking, just changed the template to include the 4 * instead of requiring calculating the correct value for w before writing the formula.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 4/30/2015
Posts: 197
|
Thanks i did see the 4 on the web included as well. Thanks
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|