Registered User
Joined: 3/8/2012
Posts: 12
|
Hi- could you please show me how to write a custom formula? I want to scan for prices that are below an Envelope Channel which is set to a 12-day SMA, 1 period, 3 standard deviations. Thanks!
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The Envelope Channels in TC2000 version 12 are actually the percentage above or below a Moving Average. So checking for Price being below the Lower Simple Envelope Channel 12, 3.00 would be:
C < .97 * AVGC12
If you are looking for price to be at least 3-Standard Deviations below the 12-Period Simple Moving Average, you would need to use Bollinger Bands 12, 3.00 instead:
C < AVGC12 - 3 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 - 12 * AVGC12 ^ 2) / 12)
I do not know how the Envelope Channels in TC2000 version 7 are calculated and cannot duplicate them or test for them using a Personal Criteria Formula.
Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|