Registered User Joined: 10/7/2004 Posts: 28
|
Can you help me with a PCF that will identify an xavgc, say 21 days, which is as nearly a straight line as possible? tedk
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
One option might be to search for narrow Bollinger Bands (low Standard Deviation). The following is for 20-Periods and is multiplied by 100 and divided by the Average:
100 * SQR(ABS(XAVGC21 ^ 2 + XAVGC21.1 ^ 2 + XAVGC21.2 ^ 2 + XAVGC21.3 ^ 2 + XAVGC21.4 ^ 2 + XAVGC21.5 ^ 2 + XAVGC21.6 ^ 2 + XAVGC21.7 ^ 2 + XAVGC21.8 ^ 2 + XAVGC21.9 ^ 2 + XAVGC21.10 ^ 2 + XAVGC21.11 ^ 2 + XAVGC21.12 ^ 2 + XAVGC21.13 ^ 2 + XAVGC21.14 ^ 2 + XAVGC21.15 ^ 2 + XAVGC21.16 ^ 2 + XAVGC21.17 ^ 2 + XAVGC21.18 ^ 2 + XAVGC21.19 ^ 2 - 20 * AVG(XAVGC21,20) ^ 2) / 19) / AVG(XAVGC21,20)
You would be looking for low values. This would just test for line "straightness". It would not determine if it was rising, falling or flat. You may wish to review the following:
Finding Expanding or Contracting Bollinger Bands Modelling Bollinger Bands (& Standard Deviation) in a TC PCF Need help writing a PCF for r-squared Chande Trend Index (CTI) LR vs K-RATIO CCI Clone & Bollinger Bands Handy PCF example formulas to help you learn the syntax of PCFs! How to create a Personal Criteria Forumula (PCF)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|