Registered User
Joined: 12/9/2005
Posts: 27
|
After posting I realized to do what I want I would have to know the channel width. Is that possible, linear regression pcf's can get pretty complicated from what I see on the forum. I'm looking for stocks approching or better yet, bouncing off the bottom line. I would appreciate your help. Thanks, Lloyd
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The Personal Criteria Formula already provided in my Monday, November 12, 2007 1:00:48 PM ET post in Linear Regression Bottom Line already provides for a way to determine if Price is a specified Percentage above or below the Lower Linear Regression Line. 100 = at the Line, 98 = 2% below the line and 105 = 5% above the line. That said, these percentages are based on the value of the Lower Linear Regression Line and not on the width of the Linear Regression Channel. Here are two alternatives where the ranges run from either -100 to 100 or 0 to 100 where -100 or 0 equals the Lower LR Line and 100 equals the Upper LR Line:
-100 to 100 Version:
100 * (C - (AVGC63 + 31 * (31 * C + 30 * C1 + 29 * C2 + 28 * C3 + 27 * C4 + 26 * C5 + 25 * C6 + 24 * C7 + 23 * C8 + 22 * C9 + 21 * C10 + 20 * C11 + 19 * C12 + 18 * C13 + 17 * C14 + 16 * C15 + 15 * C16 + 14 * C17 + 13 * C18 + 12 * C19 + 11 * C20 + 10 * C21 + 9 * C22 + 8 * C23 + 7 * C24 + 6 * C25 + 5 * C26 + 4 * C27 + 3 * C28 + 2 * C29 + C30 - C32 - 2 * C33 - 3 * C34 - 4 * C35 - 5 * C36 - 6 * C37 - 7 * C38 - 8 * C39 - 9 * C40 - 10 * C41 - 11 * C42 - 12 * C43 - 13 * C44 - 14 * C45 - 15 * C46 - 16 * C47 - 17 * C48 - 18 * C49 - 19 * C50 - 20 * C51 - 21 * C52 - 22 * C53 - 23 * C54 - 24 * C55 - 25 * C56 - 26 * C57 - 27 * C58 - 28 * C59 - 29 * C60 - 30 * C61 - 31 * C62) / 20832)) / (45 * (ABS(C61 - AVGC2.61) + ABS(C60 - AVGC3.60) + ABS(C59 - AVGC4.59) + ABS(C58 - AVGC5.58) + ABS(C57 - AVGC6.57) + ABS(C56 - AVGC7.56) + ABS(C55 - AVGC8.55) + ABS(C54 - AVGC9.54) + ABS(C53 - AVGC10.53) + ABS(C52 - AVGC11.52) + ABS(C51 - AVGC12.51) + ABS(C50 - AVGC13.50) + ABS(C49 - AVGC14.49) + ABS(C48 - AVGC15.48) + ABS(C47 - AVGC16.47) + ABS(C46 - AVGC17.46) + ABS(C45 - AVGC18.45) + ABS(C44 - AVGC19.44) + ABS(C43 - AVGC20.43) + ABS(C42 - AVGC21.42) + ABS(C41 - AVGC22.41) + ABS(C40 - AVGC23.40) + ABS(C39 - AVGC24.39) + ABS(C38 - AVGC25.38) + ABS(C37 - AVGC26.37) + ABS(C36 - AVGC27.36) + ABS(C35 - AVGC28.35) + ABS(C34 - AVGC29.34) + ABS(C33 - AVGC30.33) + ABS(C32 - AVGC31.32) + ABS(C31 - AVGC32.31) + ABS(C30 - AVGC33.30) + ABS(C29 - AVGC34.29) + ABS(C28 - AVGC35.28) + ABS(C27 - AVGC36.27) + ABS(C26 - AVGC37.26) + ABS(C25 - AVGC38.25) + ABS(C24 - AVGC39.24) + ABS(C23 - AVGC40.23) + ABS(C22 - AVGC41.22) + ABS(C21 - AVGC42.21) + ABS(C20 - AVGC43.20) + ABS(C19 - AVGC44.19) + ABS(C18 - AVGC45.18) + ABS(C17 - AVGC46.17) + ABS(C16 - AVGC47.16) + ABS(C15 - AVGC48.15) + ABS(C14 - AVGC49.14) + ABS(C13 - AVGC50.13) + ABS(C12 - AVGC51.12) + ABS(C11 - AVGC52.11) + ABS(C10 - AVGC53.10) + ABS(C9 - AVGC54.9) + ABS(C8 - AVGC55.8) + ABS(C7 - AVGC56.7) + ABS(C6 - AVGC57.6) + ABS(C5 - AVGC58.5) + ABS(C4 - AVGC59.4) + ABS(C3 - AVGC60.3) + ABS(C2 - AVGC61.2) + ABS(C1 - AVGC62.1) + ABS(C - AVGC63)) / 1260)
0 to 100 Version:
50 * (C - (AVGC63 + 31 * (31 * C + 30 * C1 + 29 * C2 + 28 * C3 + 27 * C4 + 26 * C5 + 25 * C6 + 24 * C7 + 23 * C8 + 22 * C9 + 21 * C10 + 20 * C11 + 19 * C12 + 18 * C13 + 17 * C14 + 16 * C15 + 15 * C16 + 14 * C17 + 13 * C18 + 12 * C19 + 11 * C20 + 10 * C21 + 9 * C22 + 8 * C23 + 7 * C24 + 6 * C25 + 5 * C26 + 4 * C27 + 3 * C28 + 2 * C29 + C30 - C32 - 2 * C33 - 3 * C34 - 4 * C35 - 5 * C36 - 6 * C37 - 7 * C38 - 8 * C39 - 9 * C40 - 10 * C41 - 11 * C42 - 12 * C43 - 13 * C44 - 14 * C45 - 15 * C46 - 16 * C47 - 17 * C48 - 18 * C49 - 19 * C50 - 20 * C51 - 21 * C52 - 22 * C53 - 23 * C54 - 24 * C55 - 25 * C56 - 26 * C57 - 27 * C58 - 28 * C59 - 29 * C60 - 30 * C61 - 31 * C62) / 20832)) / (45 * (ABS(C61 - AVGC2.61) + ABS(C60 - AVGC3.60) + ABS(C59 - AVGC4.59) + ABS(C58 - AVGC5.58) + ABS(C57 - AVGC6.57) + ABS(C56 - AVGC7.56) + ABS(C55 - AVGC8.55) + ABS(C54 - AVGC9.54) + ABS(C53 - AVGC10.53) + ABS(C52 - AVGC11.52) + ABS(C51 - AVGC12.51) + ABS(C50 - AVGC13.50) + ABS(C49 - AVGC14.49) + ABS(C48 - AVGC15.48) + ABS(C47 - AVGC16.47) + ABS(C46 - AVGC17.46) + ABS(C45 - AVGC18.45) + ABS(C44 - AVGC19.44) + ABS(C43 - AVGC20.43) + ABS(C42 - AVGC21.42) + ABS(C41 - AVGC22.41) + ABS(C40 - AVGC23.40) + ABS(C39 - AVGC24.39) + ABS(C38 - AVGC25.38) + ABS(C37 - AVGC26.37) + ABS(C36 - AVGC27.36) + ABS(C35 - AVGC28.35) + ABS(C34 - AVGC29.34) + ABS(C33 - AVGC30.33) + ABS(C32 - AVGC31.32) + ABS(C31 - AVGC32.31) + ABS(C30 - AVGC33.30) + ABS(C29 - AVGC34.29) + ABS(C28 - AVGC35.28) + ABS(C27 - AVGC36.27) + ABS(C26 - AVGC37.26) + ABS(C25 - AVGC38.25) + ABS(C24 - AVGC39.24) + ABS(C23 - AVGC40.23) + ABS(C22 - AVGC41.22) + ABS(C21 - AVGC42.21) + ABS(C20 - AVGC43.20) + ABS(C19 - AVGC44.19) + ABS(C18 - AVGC45.18) + ABS(C17 - AVGC46.17) + ABS(C16 - AVGC47.16) + ABS(C15 - AVGC48.15) + ABS(C14 - AVGC49.14) + ABS(C13 - AVGC50.13) + ABS(C12 - AVGC51.12) + ABS(C11 - AVGC52.11) + ABS(C10 - AVGC53.10) + ABS(C9 - AVGC54.9) + ABS(C8 - AVGC55.8) + ABS(C7 - AVGC56.7) + ABS(C6 - AVGC57.6) + ABS(C5 - AVGC58.5) + ABS(C4 - AVGC59.4) + ABS(C3 - AVGC60.3) + ABS(C2 - AVGC61.2) + ABS(C1 - AVGC62.1) + ABS(C - AVGC63)) / 1260) + 50
On another note, it is generally better to ask related and follow-up questions in the existing topic and start new topics for new or unrelated questions. You may wish to review the following:
Learn how to use the forums: post a new topic, reply, Search existing topics
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|