Registered User Joined: 4/14/2009 Posts: 20
|
Could you please help me with the pcf for Bollinger Bands of 13, 10 of TSV 26. I am trying to identify when TSV is above the upper band and another that will identify when TSV is below the lower band.
Thank you,
L
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try one or more of the following:
Simple TSV26 above its own Upper Bollinger Band 13,10:
TSV26 > AVG(TSV26,13) + SQR(ABS(TSV26 ^ 2 + TSV26.1 ^ 2 + TSV26.2 ^ 2 + TSV26.3 ^ 2 + TSV26.4 ^ 2 + TSV26.5 ^ 2 + TSV26.6 ^ 2 + TSV26.7 ^ 2 + TSV26.8 ^ 2 + TSV26.9 ^ 2 + TSV26.10 ^ 2 + TSV26.11 ^ 2 + TSV26.12 ^ 2 - 13 * AVG(TSV26,13) ^ 2) / 12)
Simple TSV26 below its own Lower Bollinger Band 13,10:
TSV26 < AVG(TSV26,13) - SQR(ABS(TSV26 ^ 2 + TSV26.1 ^ 2 + TSV26.2 ^ 2 + TSV26.3 ^ 2 + TSV26.4 ^ 2 + TSV26.5 ^ 2 + TSV26.6 ^ 2 + TSV26.7 ^ 2 + TSV26.8 ^ 2 + TSV26.9 ^ 2 + TSV26.10 ^ 2 + TSV26.11 ^ 2 + TSV26.12 ^ 2 - 13 * AVG(TSV26,13) ^ 2) / 12)
Exponential TSV26 above its own Upper Bollinger Band 13,10:
XAVG(TSV,26) > XAVG(TSV13,26) + SQR(ABS(XAVG(TSV,26) ^ 2 + XAVG(TSV1.1,26) ^ 2 + XAVG(TSV1.2,26) ^ 2 + XAVG(TSV1.3,26) ^ 2 + XAVG(TSV1.4,26) ^ 2 + XAVG(TSV1.5,26) ^ 2 + XAVG(TSV1.6,26) ^ 2 + XAVG(TSV1.7,26) ^ 2 + XAVG(TSV1.8,26) ^ 2 + XAVG(TSV1.9,26) ^ 2 + XAVG(TSV1.10,26) ^ 2 + XAVG(TSV1.11,26) ^ 2 + XAVG(TSV1.12,26) ^ 2 - 13 * XAVG(TSV13,26) ^ 2) / 12)
Exponential TSV26 below its own Lower Bollinger Band 13,10:
XAVG(TSV,26) < XAVG(TSV13,26) - SQR(ABS(XAVG(TSV,26) ^ 2 + XAVG(TSV1.1,26) ^ 2 + XAVG(TSV1.2,26) ^ 2 + XAVG(TSV1.3,26) ^ 2 + XAVG(TSV1.4,26) ^ 2 + XAVG(TSV1.5,26) ^ 2 + XAVG(TSV1.6,26) ^ 2 + XAVG(TSV1.7,26) ^ 2 + XAVG(TSV1.8,26) ^ 2 + XAVG(TSV1.9,26) ^ 2 + XAVG(TSV1.10,26) ^ 2 + XAVG(TSV1.11,26) ^ 2 + XAVG(TSV1.12,26) ^ 2 - 13 * XAVG(TSV13,26) ^ 2) / 12)
You may wish to review the following:
Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 4/14/2009 Posts: 20
|
Thank hun!
L
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|