Registered User
Joined: 3/9/2005
Posts: 20
|
Is there a PCF that will find stocks in an up trend that have pulled back to the botton line in a linear regression line. The values for linear regression would be period 42, extension 7, and width 36
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
20.5 * C7 + 19.5 * C8 + 18.5 * C9 + 17.5 * C10 + 16.5 * C11 + 15.5 * C12 + 14.5 * C13 + 13.5 * C14 + 12.5 * C15 + 11.5 * C16 + 10.5 * C17 + 9.5 * C18 + 8.5 * C19 + 7.5 * C20 + 6.5 * C21 + 5.5 * C22 + 4.5 * C23 + 3.5 * C24 + 2.5 * C25 + 1.5 * C26 + .5 * C27 - .5 * C28 - 1.5 * C29 - 2.5 * C30 - 3.5 * C31 - 4.5 * C32 - 5.5 * C33 - 6.5 * C34 - 7.5 * C35 - 8.5 * C36 - 9.5 * C37 - 10.5 * C38 - 11.5 * C39 - 12.5 * C40 - 13.5 * C41 - 14.5 * C42 - 15.5 * C43 - 16.5 * C44 - 17.5 * C45 - 18.5 * C46 - 19.5 * C47 - 20.5 * C48 > 0 AND C <= AVGC42.7 + 27.5 * (20.5 * C7 + 19.5 * C8 + 18.5 * C9 + 17.5 * C10 + 16.5 * C11 + 15.5 * C12 + 14.5 * C13 + 13.5 * C14 + 12.5 * C15 + 11.5 * C16 + 10.5 * C17 + 9.5 * C18 + 8.5 * C19 + 7.5 * C20 + 6.5 * C21 + 5.5 * C22 + 4.5 * C23 + 3.5 * C24 + 2.5 * C25 + 1.5 * C26 + .5 * C27 - .5 * C28 - 1.5 * C29 - 2.5 * C30 - 3.5 * C31 - 4.5 * C32 - 5.5 * C33 - 6.5 * C34 - 7.5 * C35 - 8.5 * C36 - 9.5 * C37 - 10.5 * C38 - 11.5 * C39 - 12.5 * C40 - 13.5 * C41 - 14.5 * C42 - 15.5 * C43 - 16.5 * C44 - 17.5 * C45 - 18.5 * C46 - 19.5 * C47 - 20.5 * C48) / 6170.5 - 36 * (ABS(C47 - AVGC2.47) + ABS(C46 - AVGC3.46) + ABS(C45 - AVGC4.45) + ABS(C44 - AVGC5.44) + ABS(C43 - AVGC6.43) + ABS(C42 - AVGC7.42) + ABS(C41 - AVGC8.41) + ABS(C40 - AVGC9.40) + ABS(C39 - AVGC10.39) + ABS(C38 - AVGC11.38) + ABS(C37 - AVGC12.37) + ABS(C36 - AVGC13.36) + ABS(C35 - AVGC14.35) + ABS(C34 - AVGC15.34) + ABS(C33 - AVGC16.33) + ABS(C32 - AVGC17.32) + ABS(C31 - AVGC18.31) + ABS(C30 - AVGC19.30) + ABS(C29 - AVGC20.29) + ABS(C28 - AVGC21.28) + ABS(C27 - AVGC22.27) + ABS(C26 - AVGC23.26) + ABS(C25 - AVGC24.25) + ABS(C24 - AVGC25.24) + ABS(C23 - AVGC26.23) + ABS(C22 - AVGC27.22) + ABS(C21 - AVGC28.21) + ABS(C20 - AVGC29.20) + ABS(C19 - AVGC30.19) + ABS(C18 - AVGC31.18) + ABS(C17 - AVGC32.17) + ABS(C16 - AVGC33.16) + ABS(C15 - AVGC34.15) + ABS(C14 - AVGC35.14) + ABS(C13 - AVGC36.13) + ABS(C12 - AVGC37.12) + ABS(C11 - AVGC38.11) + ABS(C10 - AVGC39.10) + ABS(C9 - AVGC40.9) + ABS(C8 - AVGC41.8) + ABS(C7 - AVGC42.7)) / 840
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Spotting trend changes using linear regression channel sorts
Using Linear Regression vs Classical Peaks/Valleys for Divergence Analysis
Linear regression channel calculations
Handy PCF example formulas to help you learn the syntax of PCFs!
PCF Formula Descriptions
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|