Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 10/7/2004 Posts: 13
|
I'm looking for a PCF that produces a 2 std dev plot of the 20 day volume average.Essentially this is like the upper Bollinger Band of the volume average. Can you help? Thanks.
Larry
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
A formula for the Upper Bollinger Band 20,20 applied to a 20-Period Moving Average of Volume would be (assuming the Volume Bars are not Truncated):
AVG(AVGV20,20) + 2 * SQR(ABS(AVGV20 ^ 2 + AVGV20.1 ^ 2 + AVGV20.2 ^ 2 + AVGV20.3 ^ 2 + AVGV20.4 ^ 2 + AVGV20.5 ^ 2 + AVGV20.6 ^ 2 + AVGV20.7 ^ 2 + AVGV20.8 ^ 2 + AVGV20.9 ^ 2 + AVGV20.10 ^ 2 + AVGV20.11 ^ 2 + AVGV20.12 ^ 2 + AVGV20.13 ^ 2 + AVGV20.14 ^ 2 + AVGV20.15 ^ 2 + AVGV20.16 ^ 2 + AVGV20.17 ^ 2 + AVGV20.18 ^ 2 + AVGV20.19 ^ 2 - 20 * AVG(AVGV20,20) ^ 2) / 19)
The Standard Deviation portion of this would be:
2 * SQR(ABS(AVGV20 ^ 2 + AVGV20.1 ^ 2 + AVGV20.2 ^ 2 + AVGV20.3 ^ 2 + AVGV20.4 ^ 2 + AVGV20.5 ^ 2 + AVGV20.6 ^ 2 + AVGV20.7 ^ 2 + AVGV20.8 ^ 2 + AVGV20.9 ^ 2 + AVGV20.10 ^ 2 + AVGV20.11 ^ 2 + AVGV20.12 ^ 2 + AVGV20.13 ^ 2 + AVGV20.14 ^ 2 + AVGV20.15 ^ 2 + AVGV20.16 ^ 2 + AVGV20.17 ^ 2 + AVGV20.18 ^ 2 + AVGV20.19 ^ 2 - 20 * AVG(AVGV20,20) ^ 2) / 19)
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF) Modelling Bollinger Bands (& Standard Deviation) in a TC PCF Handy PCF example formulas to help you learn the syntax of PCFs! PCF Formula Descriptions
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/7/2004 Posts: 13
|
Thanks Bruce.
Larry
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |