Registered User
Joined: 9/22/2005
Posts: 849
|
I would like to have a PCF for the close to been greater than 0.99 and 1.01 of the top of the Linreg 34.30 channel.
I would also to have one for the close to be between minus 0.01 and plus 0.01 of the bottom of the channel.
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (bcraig73450) I would like to have a PCF for the close to been greater than 0.99 and 1.01 of the top of the Linreg 34.30 channel.
The following formula should return true when the closing price is within 1% of the Top Linear Regression Channel 34,30 in TeleChart 2007:
ABS(C / (AVGC34 + 16.5 * (16.5 * C + 15.5 * C1 + 14.5 * C2 + 13.5 * C3 + 12.5 * C4 + 11.5 * C5 + 10.5 * C6 + 9.5 * C7 + 8.5 * C8 + 7.5 * C9 + 6.5 * C10 + 5.5 * C11 + 4.5 * C12 + 3.5 * C13 + 2.5 * C14 + 1.5 * C15 + .5 * C16 - .5 * C17 - 1.5 * C18 - 2.5 * C19 - 3.5 * C20 - 4.5 * C21 - 5.5 * C22 - 6.5 * C23 - 7.5 * C24 - 8.5 * C25 - 9.5 * C26 - 10.5 * C27 - 11.5 * C28 - 12.5 * C29 - 13.5 * C30 - 14.5 * C31 - 15.5 * C32 - 16.5 * C33) / 3272.5 + 30 * (ABS(C32 - AVGC2.32) + ABS(C31 - AVGC3.31) + ABS(C30 - AVGC4.30) + ABS(C29 - AVGC5.29) + ABS(C28 - AVGC6.28) + ABS(C27 - AVGC7.27) + ABS(C26 - AVGC8.26) + ABS(C25 - AVGC9.25) + ABS(C24 - AVGC10.24) + ABS(C23 - AVGC11.23) + ABS(C22 - AVGC12.22) + ABS(C21 - AVGC13.21) + ABS(C20 - AVGC14.20) + ABS(C19 - AVGC15.19) + ABS(C18 - AVGC16.18) + ABS(C17 - AVGC17.17) + ABS(C16 - AVGC18.16) + ABS(C15 - AVGC19.15) + ABS(C14 - AVGC20.14) + ABS(C13 - AVGC21.13) + ABS(C12 - AVGC22.12) + ABS(C11 - AVGC23.11) + ABS(C10 - AVGC24.10) + ABS(C9 - AVGC25.9) + ABS(C8 - AVGC26.8) + ABS(C7 - AVGC27.7) + ABS(C6 - AVGC28.6) + ABS(C5 - AVGC29.5) + ABS(C4 - AVGC30.4) + ABS(C3 - AVGC31.3) + ABS(C2 - AVGC32.2) + ABS(C1 - AVGC33.1) + ABS(C - AVGC34)) / 680) - 1) <= .01
QUOTE (bcraig73450) I would also to have one for the close to be between minus 0.01 and plus 0.01 of the bottom of the channel.
The following formula should return true when the closing price is within 1% of the Bottom Linear Regression Channel 34,30 in TeleChart 2007:
ABS(C / (AVGC34 + 16.5 * (16.5 * C + 15.5 * C1 + 14.5 * C2 + 13.5 * C3 + 12.5 * C4 + 11.5 * C5 + 10.5 * C6 + 9.5 * C7 + 8.5 * C8 + 7.5 * C9 + 6.5 * C10 + 5.5 * C11 + 4.5 * C12 + 3.5 * C13 + 2.5 * C14 + 1.5 * C15 + .5 * C16 - .5 * C17 - 1.5 * C18 - 2.5 * C19 - 3.5 * C20 - 4.5 * C21 - 5.5 * C22 - 6.5 * C23 - 7.5 * C24 - 8.5 * C25 - 9.5 * C26 - 10.5 * C27 - 11.5 * C28 - 12.5 * C29 - 13.5 * C30 - 14.5 * C31 - 15.5 * C32 - 16.5 * C33) / 3272.5 - 30 * (ABS(C32 - AVGC2.32) + ABS(C31 - AVGC3.31) + ABS(C30 - AVGC4.30) + ABS(C29 - AVGC5.29) + ABS(C28 - AVGC6.28) + ABS(C27 - AVGC7.27) + ABS(C26 - AVGC8.26) + ABS(C25 - AVGC9.25) + ABS(C24 - AVGC10.24) + ABS(C23 - AVGC11.23) + ABS(C22 - AVGC12.22) + ABS(C21 - AVGC13.21) + ABS(C20 - AVGC14.20) + ABS(C19 - AVGC15.19) + ABS(C18 - AVGC16.18) + ABS(C17 - AVGC17.17) + ABS(C16 - AVGC18.16) + ABS(C15 - AVGC19.15) + ABS(C14 - AVGC20.14) + ABS(C13 - AVGC21.13) + ABS(C12 - AVGC22.12) + ABS(C11 - AVGC23.11) + ABS(C10 - AVGC24.10) + ABS(C9 - AVGC25.9) + ABS(C8 - AVGC26.8) + ABS(C7 - AVGC27.7) + ABS(C6 - AVGC28.6) + ABS(C5 - AVGC29.5) + ABS(C4 - AVGC30.4) + ABS(C3 - AVGC31.3) + ABS(C2 - AVGC32.2) + ABS(C1 - AVGC33.1) + ABS(C - AVGC34)) / 680) - 1) <= .01
Using Linear Regression vs Classical Peaks/Valleys for Divergence Analysis
Linear regression channel calculations
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|