Worden Discussion Forum

Welcome Guest, please sign in to participate in a discussion.

Worden Discussion Forum » Customer Training & Support » PCFs, EasyScan and Custom Indicators » Linear Regression Channel PCF

Linear Regression Channel PCF

Rate this Topic:

Previous Topic · Next Topic

Watch this topic · Print this topic ·

ronbary

Posted : Saturday, October 27, 2007 5:34:25 PM

Registered User
Joined: 5/27/2005
Posts: 35

Hello support ,

please help me to write PCF 's based on Linear Regression Channel ( 100,25,25 )

My Linear Regression Channel parameters : Period = 100 , Extention = 25 , Width =25

This channel has 3 lines ( upper line , middle line , lower line )

i'm interesting in 3 PCFs

1) stocks that just crossing today the lower line of the channel from below to the upside , that's mean the price now just above the lower line of the channel and just crossed it to the upside .

2) stocks that just crossing today the middle line of the channel from below to the upside , that's mean the price now just above the middle line of the channel and just crossed it to the upside .

3) stocks that just crossing today the upper line of the channel from below to the upside , that's mean the price now just above the upper line of the channel and just crossed it to the upside .

thanks in advanced

Tech

Bruce_L

Posted : Monday, October 29, 2007 9:35:42 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Because the Linear Regression Lines change from Period to Period, I can think of two obvious interprations of all three formulas. One that checks for a "visual cross" where Price crosses the current Linear Regression Lines and it can be seen on the chart. The other checks for an "actual cross" where Price was on one side of the Linear Regression Lines as drawn yesterday but on the other side of the Linear Regression Lines as drawn to day. In the second case, Price may not appear to cross the Linear Regression Lines when looking at the charts. Please try as many of the following as apply:

Warning: Long Personal Criteria Formulas can dramatically increase the time it takes to update your PCFs.

The first batch is for a "visual cross" and deals entirely with the current Linear Regression Channel:

Current Price > Current Lower LR Channel and Previous Price <= Current Lower LR Channel:

C > AVGC100.25 + 74.5 * (49.5 * C25 + 48.5 * C26 + 47.5 * C27 + 46.5 * C28 + 45.5 * C29 + 44.5 * C30 + 43.5 * C31 + 42.5 * C32 + 41.5 * C33 + 40.5 * C34 + 39.5 * C35 + 38.5 * C36 + 37.5 * C37 + 36.5 * C38 + 35.5 * C39 + 34.5 * C40 + 33.5 * C41 + 32.5 * C42 + 31.5 * C43 + 30.5 * C44 + 29.5 * C45 + 28.5 * C46 + 27.5 * C47 + 26.5 * C48 + 25.5 * C49 + 24.5 * C50 + 23.5 * C51 + 22.5 * C52 + 21.5 * C53 + 20.5 * C54 + 19.5 * C55 + 18.5 * C56 + 17.5 * C57 + 16.5 * C58 + 15.5 * C59 + 14.5 * C60 + 13.5 * C61 + 12.5 * C62 + 11.5 * C63 + 10.5 * C64 + 9.5 * C65 + 8.5 * C66 + 7.5 * C67 + 6.5 * C68 + 5.5 * C69 + 4.5 * C70 + 3.5 * C71 + 2.5 * C72 + 1.5 * C73 + .5 * C74 - .5 * C75 - 1.5 * C76 - 2.5 * C77 - 3.5 * C78 - 4.5 * C79 - 5.5 * C80 - 6.5 * C81 - 7.5 * C82 - 8.5 * C83 - 9.5 * C84 - 10.5 * C85 - 11.5 * C86 - 12.5 * C87 - 13.5 * C88 - 14.5 * C89 - 15.5 * C90 - 16.5 * C91 - 17.5 * C92 - 18.5 * C93 - 19.5 * C94 - 20.5 * C95 - 21.5 * C96 - 22.5 * C97 - 23.5 * C98 - 24.5 * C99 - 25.5 * C100 - 26.5 * C101 - 27.5 * C102 - 28.5 * C103 - 29.5 * C104 - 30.5 * C105 - 31.5 * C106 - 32.5 * C107 - 33.5 * C108 - 34.5 * C109 - 35.5 * C110 - 36.5 * C111 - 37.5 * C112 - 38.5 * C113 - 39.5 * C114 - 40.5 * C115 - 41.5 * C116 - 42.5 * C117 - 43.5 * C118 - 44.5 * C119 - 45.5 * C120 - 46.5 * C121 - 47.5 * C122 - 48.5 * C123 - 49.5 * C124) / 83325 - 25 * (ABS(C123 - AVGC2.123) + ABS(C122 - AVGC3.122) + ABS(C121 - AVGC4.121) + ABS(C120 - AVGC5.120) + ABS(C119 - AVGC6.119) + ABS(C118 - AVGC7.118) + ABS(C117 - AVGC8.117) + ABS(C116 - AVGC9.116) + ABS(C115 - AVGC10.115) + ABS(C114 - AVGC11.114) + ABS(C113 - AVGC12.113) + ABS(C112 - AVGC13.112) + ABS(C111 - AVGC14.111) + ABS(C110 - AVGC15.110) + ABS(C109 - AVGC16.109) + ABS(C108 - AVGC17.108) + ABS(C107 - AVGC18.107) + ABS(C106 - AVGC19.106) + ABS(C105 - AVGC20.105) + ABS(C104 - AVGC21.104) + ABS(C103 - AVGC22.103) + ABS(C102 - AVGC23.102) + ABS(C101 - AVGC24.101) + ABS(C100 - AVGC25.100) + ABS(C99 - AVGC26.99) + ABS(C98 - AVGC27.98) + ABS(C97 - AVGC28.97) + ABS(C96 - AVGC29.96) + ABS(C95 - AVGC30.95) + ABS(C94 - AVGC31.94) + ABS(C93 - AVGC32.93) + ABS(C92 - AVGC33.92) + ABS(C91 - AVGC34.91) + ABS(C90 - AVGC35.90) + ABS(C89 - AVGC36.89) + ABS(C88 - AVGC37.88) + ABS(C87 - AVGC38.87) + ABS(C86 - AVGC39.86) + ABS(C85 - AVGC40.85) + ABS(C84 - AVGC41.84) + ABS(C83 - AVGC42.83) + ABS(C82 - AVGC43.82) + ABS(C81 - AVGC44.81) + ABS(C80 - AVGC45.80) + ABS(C79 - AVGC46.79) + ABS(C78 - AVGC47.78) + ABS(C77 - AVGC48.77) + ABS(C76 - AVGC49.76) + ABS(C75 - AVGC50.75) + ABS(C74 - AVGC51.74) + ABS(C73 - AVGC52.73) + ABS(C72 - AVGC53.72) + ABS(C71 - AVGC54.71) + ABS(C70 - AVGC55.70) + ABS(C69 - AVGC56.69) + ABS(C68 - AVGC57.68) + ABS(C67 - AVGC58.67) + ABS(C66 - AVGC59.66) + ABS(C65 - AVGC60.65) + ABS(C64 - AVGC61.64) + ABS(C63 - AVGC62.63) + ABS(C62 - AVGC63.62) + ABS(C61 - AVGC64.61) + ABS(C60 - AVGC65.60) + ABS(C59 - AVGC66.59) + ABS(C58 - AVGC67.58) + ABS(C57 - AVGC68.57) + ABS(C56 - AVGC69.56) + ABS(C55 - AVGC70.55) + ABS(C54 - AVGC71.54) + ABS(C53 - AVGC72.53) + ABS(C52 - AVGC73.52) + ABS(C51 - AVGC74.51) + ABS(C50 - AVGC75.50) + ABS(C49 - AVGC76.49) + ABS(C48 - AVGC77.48) + ABS(C47 - AVGC78.47) + ABS(C46 - AVGC79.46) + ABS(C45 - AVGC80.45) + ABS(C44 - AVGC81.44) + ABS(C43 - AVGC82.43) + ABS(C42 - AVGC83.42) + ABS(C41 - AVGC84.41) + ABS(C40 - AVGC85.40) + ABS(C39 - AVGC86.39) + ABS(C38 - AVGC87.38) + ABS(C37 - AVGC88.37) + ABS(C36 - AVGC89.36) + ABS(C35 - AVGC90.35) + ABS(C34 - AVGC91.34) + ABS(C33 - AVGC92.33) + ABS(C32 - AVGC93.32) + ABS(C31 - AVGC94.31) + ABS(C30 - AVGC95.30) + ABS(C29 - AVGC96.29) + ABS(C28 - AVGC97.28) + ABS(C27 - AVGC98.27) + ABS(C26 - AVGC99.26) + ABS(C25 - AVGC100.25)) / 2000 AND C1 <= AVGC100.25 + 73.5 * (49.5 * C25 + 48.5 * C26 + 47.5 * C27 + 46.5 * C28 + 45.5 * C29 + 44.5 * C30 + 43.5 * C31 + 42.5 * C32 + 41.5 * C33 + 40.5 * C34 + 39.5 * C35 + 38.5 * C36 + 37.5 * C37 + 36.5 * C38 + 35.5 * C39 + 34.5 * C40 + 33.5 * C41 + 32.5 * C42 + 31.5 * C43 + 30.5 * C44 + 29.5 * C45 + 28.5 * C46 + 27.5 * C47 + 26.5 * C48 + 25.5 * C49 + 24.5 * C50 + 23.5 * C51 + 22.5 * C52 + 21.5 * C53 + 20.5 * C54 + 19.5 * C55 + 18.5 * C56 + 17.5 * C57 + 16.5 * C58 + 15.5 * C59 + 14.5 * C60 + 13.5 * C61 + 12.5 * C62 + 11.5 * C63 + 10.5 * C64 + 9.5 * C65 + 8.5 * C66 + 7.5 * C67 + 6.5 * C68 + 5.5 * C69 + 4.5 * C70 + 3.5 * C71 + 2.5 * C72 + 1.5 * C73 + .5 * C74 - .5 * C75 - 1.5 * C76 - 2.5 * C77 - 3.5 * C78 - 4.5 * C79 - 5.5 * C80 - 6.5 * C81 - 7.5 * C82 - 8.5 * C83 - 9.5 * C84 - 10.5 * C85 - 11.5 * C86 - 12.5 * C87 - 13.5 * C88 - 14.5 * C89 - 15.5 * C90 - 16.5 * C91 - 17.5 * C92 - 18.5 * C93 - 19.5 * C94 - 20.5 * C95 - 21.5 * C96 - 22.5 * C97 - 23.5 * C98 - 24.5 * C99 - 25.5 * C100 - 26.5 * C101 - 27.5 * C102 - 28.5 * C103 - 29.5 * C104 - 30.5 * C105 - 31.5 * C106 - 32.5 * C107 - 33.5 * C108 - 34.5 * C109 - 35.5 * C110 - 36.5 * C111 - 37.5 * C112 - 38.5 * C113 - 39.5 * C114 - 40.5 * C115 - 41.5 * C116 - 42.5 * C117 - 43.5 * C118 - 44.5 * C119 - 45.5 * C120 - 46.5 * C121 - 47.5 * C122 - 48.5 * C123 - 49.5 * C124) / 83325 - 25 * (ABS(C123 - AVGC2.123) + ABS(C122 - AVGC3.122) + ABS(C121 - AVGC4.121) + ABS(C120 - AVGC5.120) + ABS(C119 - AVGC6.119) + ABS(C118 - AVGC7.118) + ABS(C117 - AVGC8.117) + ABS(C116 - AVGC9.116) + ABS(C115 - AVGC10.115) + ABS(C114 - AVGC11.114) + ABS(C113 - AVGC12.113) + ABS(C112 - AVGC13.112) + ABS(C111 - AVGC14.111) + ABS(C110 - AVGC15.110) + ABS(C109 - AVGC16.109) + ABS(C108 - AVGC17.108) + ABS(C107 - AVGC18.107) + ABS(C106 - AVGC19.106) + ABS(C105 - AVGC20.105) + ABS(C104 - AVGC21.104) + ABS(C103 - AVGC22.103) + ABS(C102 - AVGC23.102) + ABS(C101 - AVGC24.101) + ABS(C100 - AVGC25.100) + ABS(C99 - AVGC26.99) + ABS(C98 - AVGC27.98) + ABS(C97 - AVGC28.97) + ABS(C96 - AVGC29.96) + ABS(C95 - AVGC30.95) + ABS(C94 - AVGC31.94) + ABS(C93 - AVGC32.93) + ABS(C92 - AVGC33.92) + ABS(C91 - AVGC34.91) + ABS(C90 - AVGC35.90) + ABS(C89 - AVGC36.89) + ABS(C88 - AVGC37.88) + ABS(C87 - AVGC38.87) + ABS(C86 - AVGC39.86) + ABS(C85 - AVGC40.85) + ABS(C84 - AVGC41.84) + ABS(C83 - AVGC42.83) + ABS(C82 - AVGC43.82) + ABS(C81 - AVGC44.81) + ABS(C80 - AVGC45.80) + ABS(C79 - AVGC46.79) + ABS(C78 - AVGC47.78) + ABS(C77 - AVGC48.77) + ABS(C76 - AVGC49.76) + ABS(C75 - AVGC50.75) + ABS(C74 - AVGC51.74) + ABS(C73 - AVGC52.73) + ABS(C72 - AVGC53.72) + ABS(C71 - AVGC54.71) + ABS(C70 - AVGC55.70) + ABS(C69 - AVGC56.69) + ABS(C68 - AVGC57.68) + ABS(C67 - AVGC58.67) + ABS(C66 - AVGC59.66) + ABS(C65 - AVGC60.65) + ABS(C64 - AVGC61.64) + ABS(C63 - AVGC62.63) + ABS(C62 - AVGC63.62) + ABS(C61 - AVGC64.61) + ABS(C60 - AVGC65.60) + ABS(C59 - AVGC66.59) + ABS(C58 - AVGC67.58) + ABS(C57 - AVGC68.57) + ABS(C56 - AVGC69.56) + ABS(C55 - AVGC70.55) + ABS(C54 - AVGC71.54) + ABS(C53 - AVGC72.53) + ABS(C52 - AVGC73.52) + ABS(C51 - AVGC74.51) + ABS(C50 - AVGC75.50) + ABS(C49 - AVGC76.49) + ABS(C48 - AVGC77.48) + ABS(C47 - AVGC78.47) + ABS(C46 - AVGC79.46) + ABS(C45 - AVGC80.45) + ABS(C44 - AVGC81.44) + ABS(C43 - AVGC82.43) + ABS(C42 - AVGC83.42) + ABS(C41 - AVGC84.41) + ABS(C40 - AVGC85.40) + ABS(C39 - AVGC86.39) + ABS(C38 - AVGC87.38) + ABS(C37 - AVGC88.37) + ABS(C36 - AVGC89.36) + ABS(C35 - AVGC90.35) + ABS(C34 - AVGC91.34) + ABS(C33 - AVGC92.33) + ABS(C32 - AVGC93.32) + ABS(C31 - AVGC94.31) + ABS(C30 - AVGC95.30) + ABS(C29 - AVGC96.29) + ABS(C28 - AVGC97.28) + ABS(C27 - AVGC98.27) + ABS(C26 - AVGC99.26) + ABS(C25 - AVGC100.25)) / 2000

Current Price > Current LR Line and Previous Price <= Current LR Line:

C > AVGC100.25 + 74.5 * (49.5 * C25 + 48.5 * C26 + 47.5 * C27 + 46.5 * C28 + 45.5 * C29 + 44.5 * C30 + 43.5 * C31 + 42.5 * C32 + 41.5 * C33 + 40.5 * C34 + 39.5 * C35 + 38.5 * C36 + 37.5 * C37 + 36.5 * C38 + 35.5 * C39 + 34.5 * C40 + 33.5 * C41 + 32.5 * C42 + 31.5 * C43 + 30.5 * C44 + 29.5 * C45 + 28.5 * C46 + 27.5 * C47 + 26.5 * C48 + 25.5 * C49 + 24.5 * C50 + 23.5 * C51 + 22.5 * C52 + 21.5 * C53 + 20.5 * C54 + 19.5 * C55 + 18.5 * C56 + 17.5 * C57 + 16.5 * C58 + 15.5 * C59 + 14.5 * C60 + 13.5 * C61 + 12.5 * C62 + 11.5 * C63 + 10.5 * C64 + 9.5 * C65 + 8.5 * C66 + 7.5 * C67 + 6.5 * C68 + 5.5 * C69 + 4.5 * C70 + 3.5 * C71 + 2.5 * C72 + 1.5 * C73 + .5 * C74 - .5 * C75 - 1.5 * C76 - 2.5 * C77 - 3.5 * C78 - 4.5 * C79 - 5.5 * C80 - 6.5 * C81 - 7.5 * C82 - 8.5 * C83 - 9.5 * C84 - 10.5 * C85 - 11.5 * C86 - 12.5 * C87 - 13.5 * C88 - 14.5 * C89 - 15.5 * C90 - 16.5 * C91 - 17.5 * C92 - 18.5 * C93 - 19.5 * C94 - 20.5 * C95 - 21.5 * C96 - 22.5 * C97 - 23.5 * C98 - 24.5 * C99 - 25.5 * C100 - 26.5 * C101 - 27.5 * C102 - 28.5 * C103 - 29.5 * C104 - 30.5 * C105 - 31.5 * C106 - 32.5 * C107 - 33.5 * C108 - 34.5 * C109 - 35.5 * C110 - 36.5 * C111 - 37.5 * C112 - 38.5 * C113 - 39.5 * C114 - 40.5 * C115 - 41.5 * C116 - 42.5 * C117 - 43.5 * C118 - 44.5 * C119 - 45.5 * C120 - 46.5 * C121 - 47.5 * C122 - 48.5 * C123 - 49.5 * C124) / 83325 AND C1 <= AVGC100.25 + 73.5 * (49.5 * C25 + 48.5 * C26 + 47.5 * C27 + 46.5 * C28 + 45.5 * C29 + 44.5 * C30 + 43.5 * C31 + 42.5 * C32 + 41.5 * C33 + 40.5 * C34 + 39.5 * C35 + 38.5 * C36 + 37.5 * C37 + 36.5 * C38 + 35.5 * C39 + 34.5 * C40 + 33.5 * C41 + 32.5 * C42 + 31.5 * C43 + 30.5 * C44 + 29.5 * C45 + 28.5 * C46 + 27.5 * C47 + 26.5 * C48 + 25.5 * C49 + 24.5 * C50 + 23.5 * C51 + 22.5 * C52 + 21.5 * C53 + 20.5 * C54 + 19.5 * C55 + 18.5 * C56 + 17.5 * C57 + 16.5 * C58 + 15.5 * C59 + 14.5 * C60 + 13.5 * C61 + 12.5 * C62 + 11.5 * C63 + 10.5 * C64 + 9.5 * C65 + 8.5 * C66 + 7.5 * C67 + 6.5 * C68 + 5.5 * C69 + 4.5 * C70 + 3.5 * C71 + 2.5 * C72 + 1.5 * C73 + .5 * C74 - .5 * C75 - 1.5 * C76 - 2.5 * C77 - 3.5 * C78 - 4.5 * C79 - 5.5 * C80 - 6.5 * C81 - 7.5 * C82 - 8.5 * C83 - 9.5 * C84 - 10.5 * C85 - 11.5 * C86 - 12.5 * C87 - 13.5 * C88 - 14.5 * C89 - 15.5 * C90 - 16.5 * C91 - 17.5 * C92 - 18.5 * C93 - 19.5 * C94 - 20.5 * C95 - 21.5 * C96 - 22.5 * C97 - 23.5 * C98 - 24.5 * C99 - 25.5 * C100 - 26.5 * C101 - 27.5 * C102 - 28.5 * C103 - 29.5 * C104 - 30.5 * C105 - 31.5 * C106 - 32.5 * C107 - 33.5 * C108 - 34.5 * C109 - 35.5 * C110 - 36.5 * C111 - 37.5 * C112 - 38.5 * C113 - 39.5 * C114 - 40.5 * C115 - 41.5 * C116 - 42.5 * C117 - 43.5 * C118 - 44.5 * C119 - 45.5 * C120 - 46.5 * C121 - 47.5 * C122 - 48.5 * C123 - 49.5 * C124) / 83325

Current Price > Current Upper LR Channel and Previous Price <= Current Upper LR Channel:

C > AVGC100.25 + 74.5 * (49.5 * C25 + 48.5 * C26 + 47.5 * C27 + 46.5 * C28 + 45.5 * C29 + 44.5 * C30 + 43.5 * C31 + 42.5 * C32 + 41.5 * C33 + 40.5 * C34 + 39.5 * C35 + 38.5 * C36 + 37.5 * C37 + 36.5 * C38 + 35.5 * C39 + 34.5 * C40 + 33.5 * C41 + 32.5 * C42 + 31.5 * C43 + 30.5 * C44 + 29.5 * C45 + 28.5 * C46 + 27.5 * C47 + 26.5 * C48 + 25.5 * C49 + 24.5 * C50 + 23.5 * C51 + 22.5 * C52 + 21.5 * C53 + 20.5 * C54 + 19.5 * C55 + 18.5 * C56 + 17.5 * C57 + 16.5 * C58 + 15.5 * C59 + 14.5 * C60 + 13.5 * C61 + 12.5 * C62 + 11.5 * C63 + 10.5 * C64 + 9.5 * C65 + 8.5 * C66 + 7.5 * C67 + 6.5 * C68 + 5.5 * C69 + 4.5 * C70 + 3.5 * C71 + 2.5 * C72 + 1.5 * C73 + .5 * C74 - .5 * C75 - 1.5 * C76 - 2.5 * C77 - 3.5 * C78 - 4.5 * C79 - 5.5 * C80 - 6.5 * C81 - 7.5 * C82 - 8.5 * C83 - 9.5 * C84 - 10.5 * C85 - 11.5 * C86 - 12.5 * C87 - 13.5 * C88 - 14.5 * C89 - 15.5 * C90 - 16.5 * C91 - 17.5 * C92 - 18.5 * C93 - 19.5 * C94 - 20.5 * C95 - 21.5 * C96 - 22.5 * C97 - 23.5 * C98 - 24.5 * C99 - 25.5 * C100 - 26.5 * C101 - 27.5 * C102 - 28.5 * C103 - 29.5 * C104 - 30.5 * C105 - 31.5 * C106 - 32.5 * C107 - 33.5 * C108 - 34.5 * C109 - 35.5 * C110 - 36.5 * C111 - 37.5 * C112 - 38.5 * C113 - 39.5 * C114 - 40.5 * C115 - 41.5 * C116 - 42.5 * C117 - 43.5 * C118 - 44.5 * C119 - 45.5 * C120 - 46.5 * C121 - 47.5 * C122 - 48.5 * C123 - 49.5 * C124) / 83325 + 25 * (ABS(C123 - AVGC2.123) + ABS(C122 - AVGC3.122) + ABS(C121 - AVGC4.121) + ABS(C120 - AVGC5.120) + ABS(C119 - AVGC6.119) + ABS(C118 - AVGC7.118) + ABS(C117 - AVGC8.117) + ABS(C116 - AVGC9.116) + ABS(C115 - AVGC10.115) + ABS(C114 - AVGC11.114) + ABS(C113 - AVGC12.113) + ABS(C112 - AVGC13.112) + ABS(C111 - AVGC14.111) + ABS(C110 - AVGC15.110) + ABS(C109 - AVGC16.109) + ABS(C108 - AVGC17.108) + ABS(C107 - AVGC18.107) + ABS(C106 - AVGC19.106) + ABS(C105 - AVGC20.105) + ABS(C104 - AVGC21.104) + ABS(C103 - AVGC22.103) + ABS(C102 - AVGC23.102) + ABS(C101 - AVGC24.101) + ABS(C100 - AVGC25.100) + ABS(C99 - AVGC26.99) + ABS(C98 - AVGC27.98) + ABS(C97 - AVGC28.97) + ABS(C96 - AVGC29.96) + ABS(C95 - AVGC30.95) + ABS(C94 - AVGC31.94) + ABS(C93 - AVGC32.93) + ABS(C92 - AVGC33.92) + ABS(C91 - AVGC34.91) + ABS(C90 - AVGC35.90) + ABS(C89 - AVGC36.89) + ABS(C88 - AVGC37.88) + ABS(C87 - AVGC38.87) + ABS(C86 - AVGC39.86) + ABS(C85 - AVGC40.85) + ABS(C84 - AVGC41.84) + ABS(C83 - AVGC42.83) + ABS(C82 - AVGC43.82) + ABS(C81 - AVGC44.81) + ABS(C80 - AVGC45.80) + ABS(C79 - AVGC46.79) + ABS(C78 - AVGC47.78) + ABS(C77 - AVGC48.77) + ABS(C76 - AVGC49.76) + ABS(C75 - AVGC50.75) + ABS(C74 - AVGC51.74) + ABS(C73 - AVGC52.73) + ABS(C72 - AVGC53.72) + ABS(C71 - AVGC54.71) + ABS(C70 - AVGC55.70) + ABS(C69 - AVGC56.69) + ABS(C68 - AVGC57.68) + ABS(C67 - AVGC58.67) + ABS(C66 - AVGC59.66) + ABS(C65 - AVGC60.65) + ABS(C64 - AVGC61.64) + ABS(C63 - AVGC62.63) + ABS(C62 - AVGC63.62) + ABS(C61 - AVGC64.61) + ABS(C60 - AVGC65.60) + ABS(C59 - AVGC66.59) + ABS(C58 - AVGC67.58) + ABS(C57 - AVGC68.57) + ABS(C56 - AVGC69.56) + ABS(C55 - AVGC70.55) + ABS(C54 - AVGC71.54) + ABS(C53 - AVGC72.53) + ABS(C52 - AVGC73.52) + ABS(C51 - AVGC74.51) + ABS(C50 - AVGC75.50) + ABS(C49 - AVGC76.49) + ABS(C48 - AVGC77.48) + ABS(C47 - AVGC78.47) + ABS(C46 - AVGC79.46) + ABS(C45 - AVGC80.45) + ABS(C44 - AVGC81.44) + ABS(C43 - AVGC82.43) + ABS(C42 - AVGC83.42) + ABS(C41 - AVGC84.41) + ABS(C40 - AVGC85.40) + ABS(C39 - AVGC86.39) + ABS(C38 - AVGC87.38) + ABS(C37 - AVGC88.37) + ABS(C36 - AVGC89.36) + ABS(C35 - AVGC90.35) + ABS(C34 - AVGC91.34) + ABS(C33 - AVGC92.33) + ABS(C32 - AVGC93.32) + ABS(C31 - AVGC94.31) + ABS(C30 - AVGC95.30) + ABS(C29 - AVGC96.29) + ABS(C28 - AVGC97.28) + ABS(C27 - AVGC98.27) + ABS(C26 - AVGC99.26) + ABS(C25 - AVGC100.25)) / 2000 AND C1 <= AVGC100.25 + 73.5 * (49.5 * C25 + 48.5 * C26 + 47.5 * C27 + 46.5 * C28 + 45.5 * C29 + 44.5 * C30 + 43.5 * C31 + 42.5 * C32 + 41.5 * C33 + 40.5 * C34 + 39.5 * C35 + 38.5 * C36 + 37.5 * C37 + 36.5 * C38 + 35.5 * C39 + 34.5 * C40 + 33.5 * C41 + 32.5 * C42 + 31.5 * C43 + 30.5 * C44 + 29.5 * C45 + 28.5 * C46 + 27.5 * C47 + 26.5 * C48 + 25.5 * C49 + 24.5 * C50 + 23.5 * C51 + 22.5 * C52 + 21.5 * C53 + 20.5 * C54 + 19.5 * C55 + 18.5 * C56 + 17.5 * C57 + 16.5 * C58 + 15.5 * C59 + 14.5 * C60 + 13.5 * C61 + 12.5 * C62 + 11.5 * C63 + 10.5 * C64 + 9.5 * C65 + 8.5 * C66 + 7.5 * C67 + 6.5 * C68 + 5.5 * C69 + 4.5 * C70 + 3.5 * C71 + 2.5 * C72 + 1.5 * C73 + .5 * C74 - .5 * C75 - 1.5 * C76 - 2.5 * C77 - 3.5 * C78 - 4.5 * C79 - 5.5 * C80 - 6.5 * C81 - 7.5 * C82 - 8.5 * C83 - 9.5 * C84 - 10.5 * C85 - 11.5 * C86 - 12.5 * C87 - 13.5 * C88 - 14.5 * C89 - 15.5 * C90 - 16.5 * C91 - 17.5 * C92 - 18.5 * C93 - 19.5 * C94 - 20.5 * C95 - 21.5 * C96 - 22.5 * C97 - 23.5 * C98 - 24.5 * C99 - 25.5 * C100 - 26.5 * C101 - 27.5 * C102 - 28.5 * C103 - 29.5 * C104 - 30.5 * C105 - 31.5 * C106 - 32.5 * C107 - 33.5 * C108 - 34.5 * C109 - 35.5 * C110 - 36.5 * C111 - 37.5 * C112 - 38.5 * C113 - 39.5 * C114 - 40.5 * C115 - 41.5 * C116 - 42.5 * C117 - 43.5 * C118 - 44.5 * C119 - 45.5 * C120 - 46.5 * C121 - 47.5 * C122 - 48.5 * C123 - 49.5 * C124) / 83325 + 25 * (ABS(C123 - AVGC2.123) + ABS(C122 - AVGC3.122) + ABS(C121 - AVGC4.121) + ABS(C120 - AVGC5.120) + ABS(C119 - AVGC6.119) + ABS(C118 - AVGC7.118) + ABS(C117 - AVGC8.117) + ABS(C116 - AVGC9.116) + ABS(C115 - AVGC10.115) + ABS(C114 - AVGC11.114) + ABS(C113 - AVGC12.113) + ABS(C112 - AVGC13.112) + ABS(C111 - AVGC14.111) + ABS(C110 - AVGC15.110) + ABS(C109 - AVGC16.109) + ABS(C108 - AVGC17.108) + ABS(C107 - AVGC18.107) + ABS(C106 - AVGC19.106) + ABS(C105 - AVGC20.105) + ABS(C104 - AVGC21.104) + ABS(C103 - AVGC22.103) + ABS(C102 - AVGC23.102) + ABS(C101 - AVGC24.101) + ABS(C100 - AVGC25.100) + ABS(C99 - AVGC26.99) + ABS(C98 - AVGC27.98) + ABS(C97 - AVGC28.97) + ABS(C96 - AVGC29.96) + ABS(C95 - AVGC30.95) + ABS(C94 - AVGC31.94) + ABS(C93 - AVGC32.93) + ABS(C92 - AVGC33.92) + ABS(C91 - AVGC34.91) + ABS(C90 - AVGC35.90) + ABS(C89 - AVGC36.89) + ABS(C88 - AVGC37.88) + ABS(C87 - AVGC38.87) + ABS(C86 - AVGC39.86) + ABS(C85 - AVGC40.85) + ABS(C84 - AVGC41.84) + ABS(C83 - AVGC42.83) + ABS(C82 - AVGC43.82) + ABS(C81 - AVGC44.81) + ABS(C80 - AVGC45.80) + ABS(C79 - AVGC46.79) + ABS(C78 - AVGC47.78) + ABS(C77 - AVGC48.77) + ABS(C76 - AVGC49.76) + ABS(C75 - AVGC50.75) + ABS(C74 - AVGC51.74) + ABS(C73 - AVGC52.73) + ABS(C72 - AVGC53.72) + ABS(C71 - AVGC54.71) + ABS(C70 - AVGC55.70) + ABS(C69 - AVGC56.69) + ABS(C68 - AVGC57.68) + ABS(C67 - AVGC58.67) + ABS(C66 - AVGC59.66) + ABS(C65 - AVGC60.65) + ABS(C64 - AVGC61.64) + ABS(C63 - AVGC62.63) + ABS(C62 - AVGC63.62) + ABS(C61 - AVGC64.61) + ABS(C60 - AVGC65.60) + ABS(C59 - AVGC66.59) + ABS(C58 - AVGC67.58) + ABS(C57 - AVGC68.57) + ABS(C56 - AVGC69.56) + ABS(C55 - AVGC70.55) + ABS(C54 - AVGC71.54) + ABS(C53 - AVGC72.53) + ABS(C52 - AVGC73.52) + ABS(C51 - AVGC74.51) + ABS(C50 - AVGC75.50) + ABS(C49 - AVGC76.49) + ABS(C48 - AVGC77.48) + ABS(C47 - AVGC78.47) + ABS(C46 - AVGC79.46) + ABS(C45 - AVGC80.45) + ABS(C44 - AVGC81.44) + ABS(C43 - AVGC82.43) + ABS(C42 - AVGC83.42) + ABS(C41 - AVGC84.41) + ABS(C40 - AVGC85.40) + ABS(C39 - AVGC86.39) + ABS(C38 - AVGC87.38) + ABS(C37 - AVGC88.37) + ABS(C36 - AVGC89.36) + ABS(C35 - AVGC90.35) + ABS(C34 - AVGC91.34) + ABS(C33 - AVGC92.33) + ABS(C32 - AVGC93.32) + ABS(C31 - AVGC94.31) + ABS(C30 - AVGC95.30) + ABS(C29 - AVGC96.29) + ABS(C28 - AVGC97.28) + ABS(C27 - AVGC98.27) + ABS(C26 - AVGC99.26) + ABS(C25 - AVGC100.25)) / 2000

The second batch is for an "actual cross" and deals with both the current and previous Linear Regression Channels:

Current Price > Current Lower LR Channel and Previous Price <= Previous Lower LR Channel:

C > AVGC100.25 + 74.5 * (49.5 * C25 + 48.5 * C26 + 47.5 * C27 + 46.5 * C28 + 45.5 * C29 + 44.5 * C30 + 43.5 * C31 + 42.5 * C32 + 41.5 * C33 + 40.5 * C34 + 39.5 * C35 + 38.5 * C36 + 37.5 * C37 + 36.5 * C38 + 35.5 * C39 + 34.5 * C40 + 33.5 * C41 + 32.5 * C42 + 31.5 * C43 + 30.5 * C44 + 29.5 * C45 + 28.5 * C46 + 27.5 * C47 + 26.5 * C48 + 25.5 * C49 + 24.5 * C50 + 23.5 * C51 + 22.5 * C52 + 21.5 * C53 + 20.5 * C54 + 19.5 * C55 + 18.5 * C56 + 17.5 * C57 + 16.5 * C58 + 15.5 * C59 + 14.5 * C60 + 13.5 * C61 + 12.5 * C62 + 11.5 * C63 + 10.5 * C64 + 9.5 * C65 + 8.5 * C66 + 7.5 * C67 + 6.5 * C68 + 5.5 * C69 + 4.5 * C70 + 3.5 * C71 + 2.5 * C72 + 1.5 * C73 + .5 * C74 - .5 * C75 - 1.5 * C76 - 2.5 * C77 - 3.5 * C78 - 4.5 * C79 - 5.5 * C80 - 6.5 * C81 - 7.5 * C82 - 8.5 * C83 - 9.5 * C84 - 10.5 * C85 - 11.5 * C86 - 12.5 * C87 - 13.5 * C88 - 14.5 * C89 - 15.5 * C90 - 16.5 * C91 - 17.5 * C92 - 18.5 * C93 - 19.5 * C94 - 20.5 * C95 - 21.5 * C96 - 22.5 * C97 - 23.5 * C98 - 24.5 * C99 - 25.5 * C100 - 26.5 * C101 - 27.5 * C102 - 28.5 * C103 - 29.5 * C104 - 30.5 * C105 - 31.5 * C106 - 32.5 * C107 - 33.5 * C108 - 34.5 * C109 - 35.5 * C110 - 36.5 * C111 - 37.5 * C112 - 38.5 * C113 - 39.5 * C114 - 40.5 * C115 - 41.5 * C116 - 42.5 * C117 - 43.5 * C118 - 44.5 * C119 - 45.5 * C120 - 46.5 * C121 - 47.5 * C122 - 48.5 * C123 - 49.5 * C124) / 83325 - 25 * (ABS(C123 - AVGC2.123) + ABS(C122 - AVGC3.122) + ABS(C121 - AVGC4.121) + ABS(C120 - AVGC5.120) + ABS(C119 - AVGC6.119) + ABS(C118 - AVGC7.118) + ABS(C117 - AVGC8.117) + ABS(C116 - AVGC9.116) + ABS(C115 - AVGC10.115) + ABS(C114 - AVGC11.114) + ABS(C113 - AVGC12.113) + ABS(C112 - AVGC13.112) + ABS(C111 - AVGC14.111) + ABS(C110 - AVGC15.110) + ABS(C109 - AVGC16.109) + ABS(C108 - AVGC17.108) + ABS(C107 - AVGC18.107) + ABS(C106 - AVGC19.106) + ABS(C105 - AVGC20.105) + ABS(C104 - AVGC21.104) + ABS(C103 - AVGC22.103) + ABS(C102 - AVGC23.102) + ABS(C101 - AVGC24.101) + ABS(C100 - AVGC25.100) + ABS(C99 - AVGC26.99) + ABS(C98 - AVGC27.98) + ABS(C97 - AVGC28.97) + ABS(C96 - AVGC29.96) + ABS(C95 - AVGC30.95) + ABS(C94 - AVGC31.94) + ABS(C93 - AVGC32.93) + ABS(C92 - AVGC33.92) + ABS(C91 - AVGC34.91) + ABS(C90 - AVGC35.90) + ABS(C89 - AVGC36.89) + ABS(C88 - AVGC37.88) + ABS(C87 - AVGC38.87) + ABS(C86 - AVGC39.86) + ABS(C85 - AVGC40.85) + ABS(C84 - AVGC41.84) + ABS(C83 - AVGC42.83) + ABS(C82 - AVGC43.82) + ABS(C81 - AVGC44.81) + ABS(C80 - AVGC45.80) + ABS(C79 - AVGC46.79) + ABS(C78 - AVGC47.78) + ABS(C77 - AVGC48.77) + ABS(C76 - AVGC49.76) + ABS(C75 - AVGC50.75) + ABS(C74 - AVGC51.74) + ABS(C73 - AVGC52.73) + ABS(C72 - AVGC53.72) + ABS(C71 - AVGC54.71) + ABS(C70 - AVGC55.70) + ABS(C69 - AVGC56.69) + ABS(C68 - AVGC57.68) + ABS(C67 - AVGC58.67) + ABS(C66 - AVGC59.66) + ABS(C65 - AVGC60.65) + ABS(C64 - AVGC61.64) + ABS(C63 - AVGC62.63) + ABS(C62 - AVGC63.62) + ABS(C61 - AVGC64.61) + ABS(C60 - AVGC65.60) + ABS(C59 - AVGC66.59) + ABS(C58 - AVGC67.58) + ABS(C57 - AVGC68.57) + ABS(C56 - AVGC69.56) + ABS(C55 - AVGC70.55) + ABS(C54 - AVGC71.54) + ABS(C53 - AVGC72.53) + ABS(C52 - AVGC73.52) + ABS(C51 - AVGC74.51) + ABS(C50 - AVGC75.50) + ABS(C49 - AVGC76.49) + ABS(C48 - AVGC77.48) + ABS(C47 - AVGC78.47) + ABS(C46 - AVGC79.46) + ABS(C45 - AVGC80.45) + ABS(C44 - AVGC81.44) + ABS(C43 - AVGC82.43) + ABS(C42 - AVGC83.42) + ABS(C41 - AVGC84.41) + ABS(C40 - AVGC85.40) + ABS(C39 - AVGC86.39) + ABS(C38 - AVGC87.38) + ABS(C37 - AVGC88.37) + ABS(C36 - AVGC89.36) + ABS(C35 - AVGC90.35) + ABS(C34 - AVGC91.34) + ABS(C33 - AVGC92.33) + ABS(C32 - AVGC93.32) + ABS(C31 - AVGC94.31) + ABS(C30 - AVGC95.30) + ABS(C29 - AVGC96.29) + ABS(C28 - AVGC97.28) + ABS(C27 - AVGC98.27) + ABS(C26 - AVGC99.26) + ABS(C25 - AVGC100.25)) / 2000 AND C1 <= AVGC100.26 + 74.5 * (49.5 * C26 + 48.5 * C27 + 47.5 * C28 + 46.5 * C29 + 45.5 * C30 + 44.5 * C31 + 43.5 * C32 + 42.5 * C33 + 41.5 * C34 + 40.5 * C35 + 39.5 * C36 + 38.5 * C37 + 37.5 * C38 + 36.5 * C39 + 35.5 * C40 + 34.5 * C41 + 33.5 * C42 + 32.5 * C43 + 31.5 * C44 + 30.5 * C45 + 29.5 * C46 + 28.5 * C47 + 27.5 * C48 + 26.5 * C49 + 25.5 * C50 + 24.5 * C51 + 23.5 * C52 + 22.5 * C53 + 21.5 * C54 + 20.5 * C55 + 19.5 * C56 + 18.5 * C57 + 17.5 * C58 + 16.5 * C59 + 15.5 * C60 + 14.5 * C61 + 13.5 * C62 + 12.5 * C63 + 11.5 * C64 + 10.5 * C65 + 9.5 * C66 + 8.5 * C67 + 7.5 * C68 + 6.5 * C69 + 5.5 * C70 + 4.5 * C71 + 3.5 * C72 + 2.5 * C73 + 1.5 * C74 + .5 * C75 - .5 * C76 - 1.5 * C77 - 2.5 * C78 - 3.5 * C79 - 4.5 * C80 - 5.5 * C81 - 6.5 * C82 - 7.5 * C83 - 8.5 * C84 - 9.5 * C85 - 10.5 * C86 - 11.5 * C87 - 12.5 * C88 - 13.5 * C89 - 14.5 * C90 - 15.5 * C91 - 16.5 * C92 - 17.5 * C93 - 18.5 * C94 - 19.5 * C95 - 20.5 * C96 - 21.5 * C97 - 22.5 * C98 - 23.5 * C99 - 24.5 * C100 - 25.5 * C101 - 26.5 * C102 - 27.5 * C103 - 28.5 * C104 - 29.5 * C105 - 30.5 * C106 - 31.5 * C107 - 32.5 * C108 - 33.5 * C109 - 34.5 * C110 - 35.5 * C111 - 36.5 * C112 - 37.5 * C113 - 38.5 * C114 - 39.5 * C115 - 40.5 * C116 - 41.5 * C117 - 42.5 * C118 - 43.5 * C119 - 44.5 * C120 - 45.5 * C121 - 46.5 * C122 - 47.5 * C123 - 48.5 * C124 - 49.5 * C125) / 83325 - 25 * (ABS(C124 - AVGC2.124) + ABS(C123 - AVGC3.123) + ABS(C122 - AVGC4.122) + ABS(C121 - AVGC5.121) + ABS(C120 - AVGC6.120) + ABS(C119 - AVGC7.119) + ABS(C118 - AVGC8.118) + ABS(C117 - AVGC9.117) + ABS(C116 - AVGC10.116) + ABS(C115 - AVGC11.115) + ABS(C114 - AVGC12.114) + ABS(C113 - AVGC13.113) + ABS(C112 - AVGC14.112) + ABS(C111 - AVGC15.111) + ABS(C110 - AVGC16.110) + ABS(C109 - AVGC17.109) + ABS(C108 - AVGC18.108) + ABS(C107 - AVGC19.107) + ABS(C106 - AVGC20.106) + ABS(C105 - AVGC21.105) + ABS(C104 - AVGC22.104) + ABS(C103 - AVGC23.103) + ABS(C102 - AVGC24.102) + ABS(C101 - AVGC25.101) + ABS(C100 - AVGC26.100) + ABS(C99 - AVGC27.99) + ABS(C98 - AVGC28.98) + ABS(C97 - AVGC29.97) + ABS(C96 - AVGC30.96) + ABS(C95 - AVGC31.95) + ABS(C94 - AVGC32.94) + ABS(C93 - AVGC33.93) + ABS(C92 - AVGC34.92) + ABS(C91 - AVGC35.91) + ABS(C90 - AVGC36.90) + ABS(C89 - AVGC37.89) + ABS(C88 - AVGC38.88) + ABS(C87 - AVGC39.87) + ABS(C86 - AVGC40.86) + ABS(C85 - AVGC41.85) + ABS(C84 - AVGC42.84) + ABS(C83 - AVGC43.83) + ABS(C82 - AVGC44.82) + ABS(C81 - AVGC45.81) + ABS(C80 - AVGC46.80) + ABS(C79 - AVGC47.79) + ABS(C78 - AVGC48.78) + ABS(C77 - AVGC49.77) + ABS(C76 - AVGC50.76) + ABS(C75 - AVGC51.75) + ABS(C74 - AVGC52.74) + ABS(C73 - AVGC53.73) + ABS(C72 - AVGC54.72) + ABS(C71 - AVGC55.71) + ABS(C70 - AVGC56.70) + ABS(C69 - AVGC57.69) + ABS(C68 - AVGC58.68) + ABS(C67 - AVGC59.67) + ABS(C66 - AVGC60.66) + ABS(C65 - AVGC61.65) + ABS(C64 - AVGC62.64) + ABS(C63 - AVGC63.63) + ABS(C62 - AVGC64.62) + ABS(C61 - AVGC65.61) + ABS(C60 - AVGC66.60) + ABS(C59 - AVGC67.59) + ABS(C58 - AVGC68.58) + ABS(C57 - AVGC69.57) + ABS(C56 - AVGC70.56) + ABS(C55 - AVGC71.55) + ABS(C54 - AVGC72.54) + ABS(C53 - AVGC73.53) + ABS(C52 - AVGC74.52) + ABS(C51 - AVGC75.51) + ABS(C50 - AVGC76.50) + ABS(C49 - AVGC77.49) + ABS(C48 - AVGC78.48) + ABS(C47 - AVGC79.47) + ABS(C46 - AVGC80.46) + ABS(C45 - AVGC81.45) + ABS(C44 - AVGC82.44) + ABS(C43 - AVGC83.43) + ABS(C42 - AVGC84.42) + ABS(C41 - AVGC85.41) + ABS(C40 - AVGC86.40) + ABS(C39 - AVGC87.39) + ABS(C38 - AVGC88.38) + ABS(C37 - AVGC89.37) + ABS(C36 - AVGC90.36) + ABS(C35 - AVGC91.35) + ABS(C34 - AVGC92.34) + ABS(C33 - AVGC93.33) + ABS(C32 - AVGC94.32) + ABS(C31 - AVGC95.31) + ABS(C30 - AVGC96.30) + ABS(C29 - AVGC97.29) + ABS(C28 - AVGC98.28) + ABS(C27 - AVGC99.27) + ABS(C26 - AVGC100.26)) / 2000

Current Price > Current LR Line and Previous Price <= Previous LR Line:

C > AVGC100.25 + 74.5 * (49.5 * C25 + 48.5 * C26 + 47.5 * C27 + 46.5 * C28 + 45.5 * C29 + 44.5 * C30 + 43.5 * C31 + 42.5 * C32 + 41.5 * C33 + 40.5 * C34 + 39.5 * C35 + 38.5 * C36 + 37.5 * C37 + 36.5 * C38 + 35.5 * C39 + 34.5 * C40 + 33.5 * C41 + 32.5 * C42 + 31.5 * C43 + 30.5 * C44 + 29.5 * C45 + 28.5 * C46 + 27.5 * C47 + 26.5 * C48 + 25.5 * C49 + 24.5 * C50 + 23.5 * C51 + 22.5 * C52 + 21.5 * C53 + 20.5 * C54 + 19.5 * C55 + 18.5 * C56 + 17.5 * C57 + 16.5 * C58 + 15.5 * C59 + 14.5 * C60 + 13.5 * C61 + 12.5 * C62 + 11.5 * C63 + 10.5 * C64 + 9.5 * C65 + 8.5 * C66 + 7.5 * C67 + 6.5 * C68 + 5.5 * C69 + 4.5 * C70 + 3.5 * C71 + 2.5 * C72 + 1.5 * C73 + .5 * C74 - .5 * C75 - 1.5 * C76 - 2.5 * C77 - 3.5 * C78 - 4.5 * C79 - 5.5 * C80 - 6.5 * C81 - 7.5 * C82 - 8.5 * C83 - 9.5 * C84 - 10.5 * C85 - 11.5 * C86 - 12.5 * C87 - 13.5 * C88 - 14.5 * C89 - 15.5 * C90 - 16.5 * C91 - 17.5 * C92 - 18.5 * C93 - 19.5 * C94 - 20.5 * C95 - 21.5 * C96 - 22.5 * C97 - 23.5 * C98 - 24.5 * C99 - 25.5 * C100 - 26.5 * C101 - 27.5 * C102 - 28.5 * C103 - 29.5 * C104 - 30.5 * C105 - 31.5 * C106 - 32.5 * C107 - 33.5 * C108 - 34.5 * C109 - 35.5 * C110 - 36.5 * C111 - 37.5 * C112 - 38.5 * C113 - 39.5 * C114 - 40.5 * C115 - 41.5 * C116 - 42.5 * C117 - 43.5 * C118 - 44.5 * C119 - 45.5 * C120 - 46.5 * C121 - 47.5 * C122 - 48.5 * C123 - 49.5 * C124) / 83325 AND C1 <= AVGC100.26 + 74.5 * (49.5 * C26 + 48.5 * C27 + 47.5 * C28 + 46.5 * C29 + 45.5 * C30 + 44.5 * C31 + 43.5 * C32 + 42.5 * C33 + 41.5 * C34 + 40.5 * C35 + 39.5 * C36 + 38.5 * C37 + 37.5 * C38 + 36.5 * C39 + 35.5 * C40 + 34.5 * C41 + 33.5 * C42 + 32.5 * C43 + 31.5 * C44 + 30.5 * C45 + 29.5 * C46 + 28.5 * C47 + 27.5 * C48 + 26.5 * C49 + 25.5 * C50 + 24.5 * C51 + 23.5 * C52 + 22.5 * C53 + 21.5 * C54 + 20.5 * C55 + 19.5 * C56 + 18.5 * C57 + 17.5 * C58 + 16.5 * C59 + 15.5 * C60 + 14.5 * C61 + 13.5 * C62 + 12.5 * C63 + 11.5 * C64 + 10.5 * C65 + 9.5 * C66 + 8.5 * C67 + 7.5 * C68 + 6.5 * C69 + 5.5 * C70 + 4.5 * C71 + 3.5 * C72 + 2.5 * C73 + 1.5 * C74 + .5 * C75 - .5 * C76 - 1.5 * C77 - 2.5 * C78 - 3.5 * C79 - 4.5 * C80 - 5.5 * C81 - 6.5 * C82 - 7.5 * C83 - 8.5 * C84 - 9.5 * C85 - 10.5 * C86 - 11.5 * C87 - 12.5 * C88 - 13.5 * C89 - 14.5 * C90 - 15.5 * C91 - 16.5 * C92 - 17.5 * C93 - 18.5 * C94 - 19.5 * C95 - 20.5 * C96 - 21.5 * C97 - 22.5 * C98 - 23.5 * C99 - 24.5 * C100 - 25.5 * C101 - 26.5 * C102 - 27.5 * C103 - 28.5 * C104 - 29.5 * C105 - 30.5 * C106 - 31.5 * C107 - 32.5 * C108 - 33.5 * C109 - 34.5 * C110 - 35.5 * C111 - 36.5 * C112 - 37.5 * C113 - 38.5 * C114 - 39.5 * C115 - 40.5 * C116 - 41.5 * C117 - 42.5 * C118 - 43.5 * C119 - 44.5 * C120 - 45.5 * C121 - 46.5 * C122 - 47.5 * C123 - 48.5 * C124 - 49.5 * C125) / 83325

Current Price > Current Upper LR Channel and Previous Price <= Previous Upper LR Channel:

C > AVGC100.25 + 74.5 * (49.5 * C25 + 48.5 * C26 + 47.5 * C27 + 46.5 * C28 + 45.5 * C29 + 44.5 * C30 + 43.5 * C31 + 42.5 * C32 + 41.5 * C33 + 40.5 * C34 + 39.5 * C35 + 38.5 * C36 + 37.5 * C37 + 36.5 * C38 + 35.5 * C39 + 34.5 * C40 + 33.5 * C41 + 32.5 * C42 + 31.5 * C43 + 30.5 * C44 + 29.5 * C45 + 28.5 * C46 + 27.5 * C47 + 26.5 * C48 + 25.5 * C49 + 24.5 * C50 + 23.5 * C51 + 22.5 * C52 + 21.5 * C53 + 20.5 * C54 + 19.5 * C55 + 18.5 * C56 + 17.5 * C57 + 16.5 * C58 + 15.5 * C59 + 14.5 * C60 + 13.5 * C61 + 12.5 * C62 + 11.5 * C63 + 10.5 * C64 + 9.5 * C65 + 8.5 * C66 + 7.5 * C67 + 6.5 * C68 + 5.5 * C69 + 4.5 * C70 + 3.5 * C71 + 2.5 * C72 + 1.5 * C73 + .5 * C74 - .5 * C75 - 1.5 * C76 - 2.5 * C77 - 3.5 * C78 - 4.5 * C79 - 5.5 * C80 - 6.5 * C81 - 7.5 * C82 - 8.5 * C83 - 9.5 * C84 - 10.5 * C85 - 11.5 * C86 - 12.5 * C87 - 13.5 * C88 - 14.5 * C89 - 15.5 * C90 - 16.5 * C91 - 17.5 * C92 - 18.5 * C93 - 19.5 * C94 - 20.5 * C95 - 21.5 * C96 - 22.5 * C97 - 23.5 * C98 - 24.5 * C99 - 25.5 * C100 - 26.5 * C101 - 27.5 * C102 - 28.5 * C103 - 29.5 * C104 - 30.5 * C105 - 31.5 * C106 - 32.5 * C107 - 33.5 * C108 - 34.5 * C109 - 35.5 * C110 - 36.5 * C111 - 37.5 * C112 - 38.5 * C113 - 39.5 * C114 - 40.5 * C115 - 41.5 * C116 - 42.5 * C117 - 43.5 * C118 - 44.5 * C119 - 45.5 * C120 - 46.5 * C121 - 47.5 * C122 - 48.5 * C123 - 49.5 * C124) / 83325 + 25 * (ABS(C123 - AVGC2.123) + ABS(C122 - AVGC3.122) + ABS(C121 - AVGC4.121) + ABS(C120 - AVGC5.120) + ABS(C119 - AVGC6.119) + ABS(C118 - AVGC7.118) + ABS(C117 - AVGC8.117) + ABS(C116 - AVGC9.116) + ABS(C115 - AVGC10.115) + ABS(C114 - AVGC11.114) + ABS(C113 - AVGC12.113) + ABS(C112 - AVGC13.112) + ABS(C111 - AVGC14.111) + ABS(C110 - AVGC15.110) + ABS(C109 - AVGC16.109) + ABS(C108 - AVGC17.108) + ABS(C107 - AVGC18.107) + ABS(C106 - AVGC19.106) + ABS(C105 - AVGC20.105) + ABS(C104 - AVGC21.104) + ABS(C103 - AVGC22.103) + ABS(C102 - AVGC23.102) + ABS(C101 - AVGC24.101) + ABS(C100 - AVGC25.100) + ABS(C99 - AVGC26.99) + ABS(C98 - AVGC27.98) + ABS(C97 - AVGC28.97) + ABS(C96 - AVGC29.96) + ABS(C95 - AVGC30.95) + ABS(C94 - AVGC31.94) + ABS(C93 - AVGC32.93) + ABS(C92 - AVGC33.92) + ABS(C91 - AVGC34.91) + ABS(C90 - AVGC35.90) + ABS(C89 - AVGC36.89) + ABS(C88 - AVGC37.88) + ABS(C87 - AVGC38.87) + ABS(C86 - AVGC39.86) + ABS(C85 - AVGC40.85) + ABS(C84 - AVGC41.84) + ABS(C83 - AVGC42.83) + ABS(C82 - AVGC43.82) + ABS(C81 - AVGC44.81) + ABS(C80 - AVGC45.80) + ABS(C79 - AVGC46.79) + ABS(C78 - AVGC47.78) + ABS(C77 - AVGC48.77) + ABS(C76 - AVGC49.76) + ABS(C75 - AVGC50.75) + ABS(C74 - AVGC51.74) + ABS(C73 - AVGC52.73) + ABS(C72 - AVGC53.72) + ABS(C71 - AVGC54.71) + ABS(C70 - AVGC55.70) + ABS(C69 - AVGC56.69) + ABS(C68 - AVGC57.68) + ABS(C67 - AVGC58.67) + ABS(C66 - AVGC59.66) + ABS(C65 - AVGC60.65) + ABS(C64 - AVGC61.64) + ABS(C63 - AVGC62.63) + ABS(C62 - AVGC63.62) + ABS(C61 - AVGC64.61) + ABS(C60 - AVGC65.60) + ABS(C59 - AVGC66.59) + ABS(C58 - AVGC67.58) + ABS(C57 - AVGC68.57) + ABS(C56 - AVGC69.56) + ABS(C55 - AVGC70.55) + ABS(C54 - AVGC71.54) + ABS(C53 - AVGC72.53) + ABS(C52 - AVGC73.52) + ABS(C51 - AVGC74.51) + ABS(C50 - AVGC75.50) + ABS(C49 - AVGC76.49) + ABS(C48 - AVGC77.48) + ABS(C47 - AVGC78.47) + ABS(C46 - AVGC79.46) + ABS(C45 - AVGC80.45) + ABS(C44 - AVGC81.44) + ABS(C43 - AVGC82.43) + ABS(C42 - AVGC83.42) + ABS(C41 - AVGC84.41) + ABS(C40 - AVGC85.40) + ABS(C39 - AVGC86.39) + ABS(C38 - AVGC87.38) + ABS(C37 - AVGC88.37) + ABS(C36 - AVGC89.36) + ABS(C35 - AVGC90.35) + ABS(C34 - AVGC91.34) + ABS(C33 - AVGC92.33) + ABS(C32 - AVGC93.32) + ABS(C31 - AVGC94.31) + ABS(C30 - AVGC95.30) + ABS(C29 - AVGC96.29) + ABS(C28 - AVGC97.28) + ABS(C27 - AVGC98.27) + ABS(C26 - AVGC99.26) + ABS(C25 - AVGC100.25)) / 2000 AND C1 <= AVGC100.26 + 74.5 * (49.5 * C26 + 48.5 * C27 + 47.5 * C28 + 46.5 * C29 + 45.5 * C30 + 44.5 * C31 + 43.5 * C32 + 42.5 * C33 + 41.5 * C34 + 40.5 * C35 + 39.5 * C36 + 38.5 * C37 + 37.5 * C38 + 36.5 * C39 + 35.5 * C40 + 34.5 * C41 + 33.5 * C42 + 32.5 * C43 + 31.5 * C44 + 30.5 * C45 + 29.5 * C46 + 28.5 * C47 + 27.5 * C48 + 26.5 * C49 + 25.5 * C50 + 24.5 * C51 + 23.5 * C52 + 22.5 * C53 + 21.5 * C54 + 20.5 * C55 + 19.5 * C56 + 18.5 * C57 + 17.5 * C58 + 16.5 * C59 + 15.5 * C60 + 14.5 * C61 + 13.5 * C62 + 12.5 * C63 + 11.5 * C64 + 10.5 * C65 + 9.5 * C66 + 8.5 * C67 + 7.5 * C68 + 6.5 * C69 + 5.5 * C70 + 4.5 * C71 + 3.5 * C72 + 2.5 * C73 + 1.5 * C74 + .5 * C75 - .5 * C76 - 1.5 * C77 - 2.5 * C78 - 3.5 * C79 - 4.5 * C80 - 5.5 * C81 - 6.5 * C82 - 7.5 * C83 - 8.5 * C84 - 9.5 * C85 - 10.5 * C86 - 11.5 * C87 - 12.5 * C88 - 13.5 * C89 - 14.5 * C90 - 15.5 * C91 - 16.5 * C92 - 17.5 * C93 - 18.5 * C94 - 19.5 * C95 - 20.5 * C96 - 21.5 * C97 - 22.5 * C98 - 23.5 * C99 - 24.5 * C100 - 25.5 * C101 - 26.5 * C102 - 27.5 * C103 - 28.5 * C104 - 29.5 * C105 - 30.5 * C106 - 31.5 * C107 - 32.5 * C108 - 33.5 * C109 - 34.5 * C110 - 35.5 * C111 - 36.5 * C112 - 37.5 * C113 - 38.5 * C114 - 39.5 * C115 - 40.5 * C116 - 41.5 * C117 - 42.5 * C118 - 43.5 * C119 - 44.5 * C120 - 45.5 * C121 - 46.5 * C122 - 47.5 * C123 - 48.5 * C124 - 49.5 * C125) / 83325 + 25 * (ABS(C124 - AVGC2.124) + ABS(C123 - AVGC3.123) + ABS(C122 - AVGC4.122) + ABS(C121 - AVGC5.121) + ABS(C120 - AVGC6.120) + ABS(C119 - AVGC7.119) + ABS(C118 - AVGC8.118) + ABS(C117 - AVGC9.117) + ABS(C116 - AVGC10.116) + ABS(C115 - AVGC11.115) + ABS(C114 - AVGC12.114) + ABS(C113 - AVGC13.113) + ABS(C112 - AVGC14.112) + ABS(C111 - AVGC15.111) + ABS(C110 - AVGC16.110) + ABS(C109 - AVGC17.109) + ABS(C108 - AVGC18.108) + ABS(C107 - AVGC19.107) + ABS(C106 - AVGC20.106) + ABS(C105 - AVGC21.105) + ABS(C104 - AVGC22.104) + ABS(C103 - AVGC23.103) + ABS(C102 - AVGC24.102) + ABS(C101 - AVGC25.101) + ABS(C100 - AVGC26.100) + ABS(C99 - AVGC27.99) + ABS(C98 - AVGC28.98) + ABS(C97 - AVGC29.97) + ABS(C96 - AVGC30.96) + ABS(C95 - AVGC31.95) + ABS(C94 - AVGC32.94) + ABS(C93 - AVGC33.93) + ABS(C92 - AVGC34.92) + ABS(C91 - AVGC35.91) + ABS(C90 - AVGC36.90) + ABS(C89 - AVGC37.89) + ABS(C88 - AVGC38.88) + ABS(C87 - AVGC39.87) + ABS(C86 - AVGC40.86) + ABS(C85 - AVGC41.85) + ABS(C84 - AVGC42.84) + ABS(C83 - AVGC43.83) + ABS(C82 - AVGC44.82) + ABS(C81 - AVGC45.81) + ABS(C80 - AVGC46.80) + ABS(C79 - AVGC47.79) + ABS(C78 - AVGC48.78) + ABS(C77 - AVGC49.77) + ABS(C76 - AVGC50.76) + ABS(C75 - AVGC51.75) + ABS(C74 - AVGC52.74) + ABS(C73 - AVGC53.73) + ABS(C72 - AVGC54.72) + ABS(C71 - AVGC55.71) + ABS(C70 - AVGC56.70) + ABS(C69 - AVGC57.69) + ABS(C68 - AVGC58.68) + ABS(C67 - AVGC59.67) + ABS(C66 - AVGC60.66) + ABS(C65 - AVGC61.65) + ABS(C64 - AVGC62.64) + ABS(C63 - AVGC63.63) + ABS(C62 - AVGC64.62) + ABS(C61 - AVGC65.61) + ABS(C60 - AVGC66.60) + ABS(C59 - AVGC67.59) + ABS(C58 - AVGC68.58) + ABS(C57 - AVGC69.57) + ABS(C56 - AVGC70.56) + ABS(C55 - AVGC71.55) + ABS(C54 - AVGC72.54) + ABS(C53 - AVGC73.53) + ABS(C52 - AVGC74.52) + ABS(C51 - AVGC75.51) + ABS(C50 - AVGC76.50) + ABS(C49 - AVGC77.49) + ABS(C48 - AVGC78.48) + ABS(C47 - AVGC79.47) + ABS(C46 - AVGC80.46) + ABS(C45 - AVGC81.45) + ABS(C44 - AVGC82.44) + ABS(C43 - AVGC83.43) + ABS(C42 - AVGC84.42) + ABS(C41 - AVGC85.41) + ABS(C40 - AVGC86.40) + ABS(C39 - AVGC87.39) + ABS(C38 - AVGC88.38) + ABS(C37 - AVGC89.37) + ABS(C36 - AVGC90.36) + ABS(C35 - AVGC91.35) + ABS(C34 - AVGC92.34) + ABS(C33 - AVGC93.33) + ABS(C32 - AVGC94.32) + ABS(C31 - AVGC95.31) + ABS(C30 - AVGC96.30) + ABS(C29 - AVGC97.29) + ABS(C28 - AVGC98.28) + ABS(C27 - AVGC99.27) + ABS(C26 - AVGC100.26)) / 2000

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
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

ronbary

Posted : Thursday, November 1, 2007 7:30:21 PM

Registered User
Joined: 5/27/2005
Posts: 35

Thanks Bruce , that's what i want ,

Can you help me also with the opposite PCFs when price crossing down the Linear Regression lines

i want to find for the first Batch "Visaul Cross"   for the 3 PCFs   when price crossing down

1) Price crossing down today the Upper Line of Regression Channel    ( 100,25,25 )
2) Price crossing down today the  Middle Line of Regression Channel    ( 100,25,25 )
3) Price crossing down today the  Lower Line of Regression Channel    ( 100,25,25 )

thanks in advance

Tech

Bruce_L

Posted : Friday, November 2, 2007 9:20:33 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

It's just a matter of reversing the > and < signs in the formulas. Please try as many of the following as apply:

Warning: Long Personal Criteria Formulas can dramatically increase the time it takes to update your PCFs.

Current Price < Current Lower LR Channel and Previous Price >= Current Lower LR Channel:

C < AVGC100.25 + 74.5 * (49.5 * C25 + 48.5 * C26 + 47.5 * C27 + 46.5 * C28 + 45.5 * C29 + 44.5 * C30 + 43.5 * C31 + 42.5 * C32 + 41.5 * C33 + 40.5 * C34 + 39.5 * C35 + 38.5 * C36 + 37.5 * C37 + 36.5 * C38 + 35.5 * C39 + 34.5 * C40 + 33.5 * C41 + 32.5 * C42 + 31.5 * C43 + 30.5 * C44 + 29.5 * C45 + 28.5 * C46 + 27.5 * C47 + 26.5 * C48 + 25.5 * C49 + 24.5 * C50 + 23.5 * C51 + 22.5 * C52 + 21.5 * C53 + 20.5 * C54 + 19.5 * C55 + 18.5 * C56 + 17.5 * C57 + 16.5 * C58 + 15.5 * C59 + 14.5 * C60 + 13.5 * C61 + 12.5 * C62 + 11.5 * C63 + 10.5 * C64 + 9.5 * C65 + 8.5 * C66 + 7.5 * C67 + 6.5 * C68 + 5.5 * C69 + 4.5 * C70 + 3.5 * C71 + 2.5 * C72 + 1.5 * C73 + .5 * C74 - .5 * C75 - 1.5 * C76 - 2.5 * C77 - 3.5 * C78 - 4.5 * C79 - 5.5 * C80 - 6.5 * C81 - 7.5 * C82 - 8.5 * C83 - 9.5 * C84 - 10.5 * C85 - 11.5 * C86 - 12.5 * C87 - 13.5 * C88 - 14.5 * C89 - 15.5 * C90 - 16.5 * C91 - 17.5 * C92 - 18.5 * C93 - 19.5 * C94 - 20.5 * C95 - 21.5 * C96 - 22.5 * C97 - 23.5 * C98 - 24.5 * C99 - 25.5 * C100 - 26.5 * C101 - 27.5 * C102 - 28.5 * C103 - 29.5 * C104 - 30.5 * C105 - 31.5 * C106 - 32.5 * C107 - 33.5 * C108 - 34.5 * C109 - 35.5 * C110 - 36.5 * C111 - 37.5 * C112 - 38.5 * C113 - 39.5 * C114 - 40.5 * C115 - 41.5 * C116 - 42.5 * C117 - 43.5 * C118 - 44.5 * C119 - 45.5 * C120 - 46.5 * C121 - 47.5 * C122 - 48.5 * C123 - 49.5 * C124) / 83325 - 25 * (ABS(C123 - AVGC2.123) + ABS(C122 - AVGC3.122) + ABS(C121 - AVGC4.121) + ABS(C120 - AVGC5.120) + ABS(C119 - AVGC6.119) + ABS(C118 - AVGC7.118) + ABS(C117 - AVGC8.117) + ABS(C116 - AVGC9.116) + ABS(C115 - AVGC10.115) + ABS(C114 - AVGC11.114) + ABS(C113 - AVGC12.113) + ABS(C112 - AVGC13.112) + ABS(C111 - AVGC14.111) + ABS(C110 - AVGC15.110) + ABS(C109 - AVGC16.109) + ABS(C108 - AVGC17.108) + ABS(C107 - AVGC18.107) + ABS(C106 - AVGC19.106) + ABS(C105 - AVGC20.105) + ABS(C104 - AVGC21.104) + ABS(C103 - AVGC22.103) + ABS(C102 - AVGC23.102) + ABS(C101 - AVGC24.101) + ABS(C100 - AVGC25.100) + ABS(C99 - AVGC26.99) + ABS(C98 - AVGC27.98) + ABS(C97 - AVGC28.97) + ABS(C96 - AVGC29.96) + ABS(C95 - AVGC30.95) + ABS(C94 - AVGC31.94) + ABS(C93 - AVGC32.93) + ABS(C92 - AVGC33.92) + ABS(C91 - AVGC34.91) + ABS(C90 - AVGC35.90) + ABS(C89 - AVGC36.89) + ABS(C88 - AVGC37.88) + ABS(C87 - AVGC38.87) + ABS(C86 - AVGC39.86) + ABS(C85 - AVGC40.85) + ABS(C84 - AVGC41.84) + ABS(C83 - AVGC42.83) + ABS(C82 - AVGC43.82) + ABS(C81 - AVGC44.81) + ABS(C80 - AVGC45.80) + ABS(C79 - AVGC46.79) + ABS(C78 - AVGC47.78) + ABS(C77 - AVGC48.77) + ABS(C76 - AVGC49.76) + ABS(C75 - AVGC50.75) + ABS(C74 - AVGC51.74) + ABS(C73 - AVGC52.73) + ABS(C72 - AVGC53.72) + ABS(C71 - AVGC54.71) + ABS(C70 - AVGC55.70) + ABS(C69 - AVGC56.69) + ABS(C68 - AVGC57.68) + ABS(C67 - AVGC58.67) + ABS(C66 - AVGC59.66) + ABS(C65 - AVGC60.65) + ABS(C64 - AVGC61.64) + ABS(C63 - AVGC62.63) + ABS(C62 - AVGC63.62) + ABS(C61 - AVGC64.61) + ABS(C60 - AVGC65.60) + ABS(C59 - AVGC66.59) + ABS(C58 - AVGC67.58) + ABS(C57 - AVGC68.57) + ABS(C56 - AVGC69.56) + ABS(C55 - AVGC70.55) + ABS(C54 - AVGC71.54) + ABS(C53 - AVGC72.53) + ABS(C52 - AVGC73.52) + ABS(C51 - AVGC74.51) + ABS(C50 - AVGC75.50) + ABS(C49 - AVGC76.49) + ABS(C48 - AVGC77.48) + ABS(C47 - AVGC78.47) + ABS(C46 - AVGC79.46) + ABS(C45 - AVGC80.45) + ABS(C44 - AVGC81.44) + ABS(C43 - AVGC82.43) + ABS(C42 - AVGC83.42) + ABS(C41 - AVGC84.41) + ABS(C40 - AVGC85.40) + ABS(C39 - AVGC86.39) + ABS(C38 - AVGC87.38) + ABS(C37 - AVGC88.37) + ABS(C36 - AVGC89.36) + ABS(C35 - AVGC90.35) + ABS(C34 - AVGC91.34) + ABS(C33 - AVGC92.33) + ABS(C32 - AVGC93.32) + ABS(C31 - AVGC94.31) + ABS(C30 - AVGC95.30) + ABS(C29 - AVGC96.29) + ABS(C28 - AVGC97.28) + ABS(C27 - AVGC98.27) + ABS(C26 - AVGC99.26) + ABS(C25 - AVGC100.25)) / 2000 AND C1 >= AVGC100.25 + 73.5 * (49.5 * C25 + 48.5 * C26 + 47.5 * C27 + 46.5 * C28 + 45.5 * C29 + 44.5 * C30 + 43.5 * C31 + 42.5 * C32 + 41.5 * C33 + 40.5 * C34 + 39.5 * C35 + 38.5 * C36 + 37.5 * C37 + 36.5 * C38 + 35.5 * C39 + 34.5 * C40 + 33.5 * C41 + 32.5 * C42 + 31.5 * C43 + 30.5 * C44 + 29.5 * C45 + 28.5 * C46 + 27.5 * C47 + 26.5 * C48 + 25.5 * C49 + 24.5 * C50 + 23.5 * C51 + 22.5 * C52 + 21.5 * C53 + 20.5 * C54 + 19.5 * C55 + 18.5 * C56 + 17.5 * C57 + 16.5 * C58 + 15.5 * C59 + 14.5 * C60 + 13.5 * C61 + 12.5 * C62 + 11.5 * C63 + 10.5 * C64 + 9.5 * C65 + 8.5 * C66 + 7.5 * C67 + 6.5 * C68 + 5.5 * C69 + 4.5 * C70 + 3.5 * C71 + 2.5 * C72 + 1.5 * C73 + .5 * C74 - .5 * C75 - 1.5 * C76 - 2.5 * C77 - 3.5 * C78 - 4.5 * C79 - 5.5 * C80 - 6.5 * C81 - 7.5 * C82 - 8.5 * C83 - 9.5 * C84 - 10.5 * C85 - 11.5 * C86 - 12.5 * C87 - 13.5 * C88 - 14.5 * C89 - 15.5 * C90 - 16.5 * C91 - 17.5 * C92 - 18.5 * C93 - 19.5 * C94 - 20.5 * C95 - 21.5 * C96 - 22.5 * C97 - 23.5 * C98 - 24.5 * C99 - 25.5 * C100 - 26.5 * C101 - 27.5 * C102 - 28.5 * C103 - 29.5 * C104 - 30.5 * C105 - 31.5 * C106 - 32.5 * C107 - 33.5 * C108 - 34.5 * C109 - 35.5 * C110 - 36.5 * C111 - 37.5 * C112 - 38.5 * C113 - 39.5 * C114 - 40.5 * C115 - 41.5 * C116 - 42.5 * C117 - 43.5 * C118 - 44.5 * C119 - 45.5 * C120 - 46.5 * C121 - 47.5 * C122 - 48.5 * C123 - 49.5 * C124) / 83325 - 25 * (ABS(C123 - AVGC2.123) + ABS(C122 - AVGC3.122) + ABS(C121 - AVGC4.121) + ABS(C120 - AVGC5.120) + ABS(C119 - AVGC6.119) + ABS(C118 - AVGC7.118) + ABS(C117 - AVGC8.117) + ABS(C116 - AVGC9.116) + ABS(C115 - AVGC10.115) + ABS(C114 - AVGC11.114) + ABS(C113 - AVGC12.113) + ABS(C112 - AVGC13.112) + ABS(C111 - AVGC14.111) + ABS(C110 - AVGC15.110) + ABS(C109 - AVGC16.109) + ABS(C108 - AVGC17.108) + ABS(C107 - AVGC18.107) + ABS(C106 - AVGC19.106) + ABS(C105 - AVGC20.105) + ABS(C104 - AVGC21.104) + ABS(C103 - AVGC22.103) + ABS(C102 - AVGC23.102) + ABS(C101 - AVGC24.101) + ABS(C100 - AVGC25.100) + ABS(C99 - AVGC26.99) + ABS(C98 - AVGC27.98) + ABS(C97 - AVGC28.97) + ABS(C96 - AVGC29.96) + ABS(C95 - AVGC30.95) + ABS(C94 - AVGC31.94) + ABS(C93 - AVGC32.93) + ABS(C92 - AVGC33.92) + ABS(C91 - AVGC34.91) + ABS(C90 - AVGC35.90) + ABS(C89 - AVGC36.89) + ABS(C88 - AVGC37.88) + ABS(C87 - AVGC38.87) + ABS(C86 - AVGC39.86) + ABS(C85 - AVGC40.85) + ABS(C84 - AVGC41.84) + ABS(C83 - AVGC42.83) + ABS(C82 - AVGC43.82) + ABS(C81 - AVGC44.81) + ABS(C80 - AVGC45.80) + ABS(C79 - AVGC46.79) + ABS(C78 - AVGC47.78) + ABS(C77 - AVGC48.77) + ABS(C76 - AVGC49.76) + ABS(C75 - AVGC50.75) + ABS(C74 - AVGC51.74) + ABS(C73 - AVGC52.73) + ABS(C72 - AVGC53.72) + ABS(C71 - AVGC54.71) + ABS(C70 - AVGC55.70) + ABS(C69 - AVGC56.69) + ABS(C68 - AVGC57.68) + ABS(C67 - AVGC58.67) + ABS(C66 - AVGC59.66) + ABS(C65 - AVGC60.65) + ABS(C64 - AVGC61.64) + ABS(C63 - AVGC62.63) + ABS(C62 - AVGC63.62) + ABS(C61 - AVGC64.61) + ABS(C60 - AVGC65.60) + ABS(C59 - AVGC66.59) + ABS(C58 - AVGC67.58) + ABS(C57 - AVGC68.57) + ABS(C56 - AVGC69.56) + ABS(C55 - AVGC70.55) + ABS(C54 - AVGC71.54) + ABS(C53 - AVGC72.53) + ABS(C52 - AVGC73.52) + ABS(C51 - AVGC74.51) + ABS(C50 - AVGC75.50) + ABS(C49 - AVGC76.49) + ABS(C48 - AVGC77.48) + ABS(C47 - AVGC78.47) + ABS(C46 - AVGC79.46) + ABS(C45 - AVGC80.45) + ABS(C44 - AVGC81.44) + ABS(C43 - AVGC82.43) + ABS(C42 - AVGC83.42) + ABS(C41 - AVGC84.41) + ABS(C40 - AVGC85.40) + ABS(C39 - AVGC86.39) + ABS(C38 - AVGC87.38) + ABS(C37 - AVGC88.37) + ABS(C36 - AVGC89.36) + ABS(C35 - AVGC90.35) + ABS(C34 - AVGC91.34) + ABS(C33 - AVGC92.33) + ABS(C32 - AVGC93.32) + ABS(C31 - AVGC94.31) + ABS(C30 - AVGC95.30) + ABS(C29 - AVGC96.29) + ABS(C28 - AVGC97.28) + ABS(C27 - AVGC98.27) + ABS(C26 - AVGC99.26) + ABS(C25 - AVGC100.25)) / 2000

Current Price < Current LR Line and Previous Price >= Current LR Line:

C < AVGC100.25 + 74.5 * (49.5 * C25 + 48.5 * C26 + 47.5 * C27 + 46.5 * C28 + 45.5 * C29 + 44.5 * C30 + 43.5 * C31 + 42.5 * C32 + 41.5 * C33 + 40.5 * C34 + 39.5 * C35 + 38.5 * C36 + 37.5 * C37 + 36.5 * C38 + 35.5 * C39 + 34.5 * C40 + 33.5 * C41 + 32.5 * C42 + 31.5 * C43 + 30.5 * C44 + 29.5 * C45 + 28.5 * C46 + 27.5 * C47 + 26.5 * C48 + 25.5 * C49 + 24.5 * C50 + 23.5 * C51 + 22.5 * C52 + 21.5 * C53 + 20.5 * C54 + 19.5 * C55 + 18.5 * C56 + 17.5 * C57 + 16.5 * C58 + 15.5 * C59 + 14.5 * C60 + 13.5 * C61 + 12.5 * C62 + 11.5 * C63 + 10.5 * C64 + 9.5 * C65 + 8.5 * C66 + 7.5 * C67 + 6.5 * C68 + 5.5 * C69 + 4.5 * C70 + 3.5 * C71 + 2.5 * C72 + 1.5 * C73 + .5 * C74 - .5 * C75 - 1.5 * C76 - 2.5 * C77 - 3.5 * C78 - 4.5 * C79 - 5.5 * C80 - 6.5 * C81 - 7.5 * C82 - 8.5 * C83 - 9.5 * C84 - 10.5 * C85 - 11.5 * C86 - 12.5 * C87 - 13.5 * C88 - 14.5 * C89 - 15.5 * C90 - 16.5 * C91 - 17.5 * C92 - 18.5 * C93 - 19.5 * C94 - 20.5 * C95 - 21.5 * C96 - 22.5 * C97 - 23.5 * C98 - 24.5 * C99 - 25.5 * C100 - 26.5 * C101 - 27.5 * C102 - 28.5 * C103 - 29.5 * C104 - 30.5 * C105 - 31.5 * C106 - 32.5 * C107 - 33.5 * C108 - 34.5 * C109 - 35.5 * C110 - 36.5 * C111 - 37.5 * C112 - 38.5 * C113 - 39.5 * C114 - 40.5 * C115 - 41.5 * C116 - 42.5 * C117 - 43.5 * C118 - 44.5 * C119 - 45.5 * C120 - 46.5 * C121 - 47.5 * C122 - 48.5 * C123 - 49.5 * C124) / 83325 AND C1 >= AVGC100.25 + 73.5 * (49.5 * C25 + 48.5 * C26 + 47.5 * C27 + 46.5 * C28 + 45.5 * C29 + 44.5 * C30 + 43.5 * C31 + 42.5 * C32 + 41.5 * C33 + 40.5 * C34 + 39.5 * C35 + 38.5 * C36 + 37.5 * C37 + 36.5 * C38 + 35.5 * C39 + 34.5 * C40 + 33.5 * C41 + 32.5 * C42 + 31.5 * C43 + 30.5 * C44 + 29.5 * C45 + 28.5 * C46 + 27.5 * C47 + 26.5 * C48 + 25.5 * C49 + 24.5 * C50 + 23.5 * C51 + 22.5 * C52 + 21.5 * C53 + 20.5 * C54 + 19.5 * C55 + 18.5 * C56 + 17.5 * C57 + 16.5 * C58 + 15.5 * C59 + 14.5 * C60 + 13.5 * C61 + 12.5 * C62 + 11.5 * C63 + 10.5 * C64 + 9.5 * C65 + 8.5 * C66 + 7.5 * C67 + 6.5 * C68 + 5.5 * C69 + 4.5 * C70 + 3.5 * C71 + 2.5 * C72 + 1.5 * C73 + .5 * C74 - .5 * C75 - 1.5 * C76 - 2.5 * C77 - 3.5 * C78 - 4.5 * C79 - 5.5 * C80 - 6.5 * C81 - 7.5 * C82 - 8.5 * C83 - 9.5 * C84 - 10.5 * C85 - 11.5 * C86 - 12.5 * C87 - 13.5 * C88 - 14.5 * C89 - 15.5 * C90 - 16.5 * C91 - 17.5 * C92 - 18.5 * C93 - 19.5 * C94 - 20.5 * C95 - 21.5 * C96 - 22.5 * C97 - 23.5 * C98 - 24.5 * C99 - 25.5 * C100 - 26.5 * C101 - 27.5 * C102 - 28.5 * C103 - 29.5 * C104 - 30.5 * C105 - 31.5 * C106 - 32.5 * C107 - 33.5 * C108 - 34.5 * C109 - 35.5 * C110 - 36.5 * C111 - 37.5 * C112 - 38.5 * C113 - 39.5 * C114 - 40.5 * C115 - 41.5 * C116 - 42.5 * C117 - 43.5 * C118 - 44.5 * C119 - 45.5 * C120 - 46.5 * C121 - 47.5 * C122 - 48.5 * C123 - 49.5 * C124) / 83325

Current Price < Current Upper LR Channel and Previous Price >= Current Upper LR Channel:

C < AVGC100.25 + 74.5 * (49.5 * C25 + 48.5 * C26 + 47.5 * C27 + 46.5 * C28 + 45.5 * C29 + 44.5 * C30 + 43.5 * C31 + 42.5 * C32 + 41.5 * C33 + 40.5 * C34 + 39.5 * C35 + 38.5 * C36 + 37.5 * C37 + 36.5 * C38 + 35.5 * C39 + 34.5 * C40 + 33.5 * C41 + 32.5 * C42 + 31.5 * C43 + 30.5 * C44 + 29.5 * C45 + 28.5 * C46 + 27.5 * C47 + 26.5 * C48 + 25.5 * C49 + 24.5 * C50 + 23.5 * C51 + 22.5 * C52 + 21.5 * C53 + 20.5 * C54 + 19.5 * C55 + 18.5 * C56 + 17.5 * C57 + 16.5 * C58 + 15.5 * C59 + 14.5 * C60 + 13.5 * C61 + 12.5 * C62 + 11.5 * C63 + 10.5 * C64 + 9.5 * C65 + 8.5 * C66 + 7.5 * C67 + 6.5 * C68 + 5.5 * C69 + 4.5 * C70 + 3.5 * C71 + 2.5 * C72 + 1.5 * C73 + .5 * C74 - .5 * C75 - 1.5 * C76 - 2.5 * C77 - 3.5 * C78 - 4.5 * C79 - 5.5 * C80 - 6.5 * C81 - 7.5 * C82 - 8.5 * C83 - 9.5 * C84 - 10.5 * C85 - 11.5 * C86 - 12.5 * C87 - 13.5 * C88 - 14.5 * C89 - 15.5 * C90 - 16.5 * C91 - 17.5 * C92 - 18.5 * C93 - 19.5 * C94 - 20.5 * C95 - 21.5 * C96 - 22.5 * C97 - 23.5 * C98 - 24.5 * C99 - 25.5 * C100 - 26.5 * C101 - 27.5 * C102 - 28.5 * C103 - 29.5 * C104 - 30.5 * C105 - 31.5 * C106 - 32.5 * C107 - 33.5 * C108 - 34.5 * C109 - 35.5 * C110 - 36.5 * C111 - 37.5 * C112 - 38.5 * C113 - 39.5 * C114 - 40.5 * C115 - 41.5 * C116 - 42.5 * C117 - 43.5 * C118 - 44.5 * C119 - 45.5 * C120 - 46.5 * C121 - 47.5 * C122 - 48.5 * C123 - 49.5 * C124) / 83325 + 25 * (ABS(C123 - AVGC2.123) + ABS(C122 - AVGC3.122) + ABS(C121 - AVGC4.121) + ABS(C120 - AVGC5.120) + ABS(C119 - AVGC6.119) + ABS(C118 - AVGC7.118) + ABS(C117 - AVGC8.117) + ABS(C116 - AVGC9.116) + ABS(C115 - AVGC10.115) + ABS(C114 - AVGC11.114) + ABS(C113 - AVGC12.113) + ABS(C112 - AVGC13.112) + ABS(C111 - AVGC14.111) + ABS(C110 - AVGC15.110) + ABS(C109 - AVGC16.109) + ABS(C108 - AVGC17.108) + ABS(C107 - AVGC18.107) + ABS(C106 - AVGC19.106) + ABS(C105 - AVGC20.105) + ABS(C104 - AVGC21.104) + ABS(C103 - AVGC22.103) + ABS(C102 - AVGC23.102) + ABS(C101 - AVGC24.101) + ABS(C100 - AVGC25.100) + ABS(C99 - AVGC26.99) + ABS(C98 - AVGC27.98) + ABS(C97 - AVGC28.97) + ABS(C96 - AVGC29.96) + ABS(C95 - AVGC30.95) + ABS(C94 - AVGC31.94) + ABS(C93 - AVGC32.93) + ABS(C92 - AVGC33.92) + ABS(C91 - AVGC34.91) + ABS(C90 - AVGC35.90) + ABS(C89 - AVGC36.89) + ABS(C88 - AVGC37.88) + ABS(C87 - AVGC38.87) + ABS(C86 - AVGC39.86) + ABS(C85 - AVGC40.85) + ABS(C84 - AVGC41.84) + ABS(C83 - AVGC42.83) + ABS(C82 - AVGC43.82) + ABS(C81 - AVGC44.81) + ABS(C80 - AVGC45.80) + ABS(C79 - AVGC46.79) + ABS(C78 - AVGC47.78) + ABS(C77 - AVGC48.77) + ABS(C76 - AVGC49.76) + ABS(C75 - AVGC50.75) + ABS(C74 - AVGC51.74) + ABS(C73 - AVGC52.73) + ABS(C72 - AVGC53.72) + ABS(C71 - AVGC54.71) + ABS(C70 - AVGC55.70) + ABS(C69 - AVGC56.69) + ABS(C68 - AVGC57.68) + ABS(C67 - AVGC58.67) + ABS(C66 - AVGC59.66) + ABS(C65 - AVGC60.65) + ABS(C64 - AVGC61.64) + ABS(C63 - AVGC62.63) + ABS(C62 - AVGC63.62) + ABS(C61 - AVGC64.61) + ABS(C60 - AVGC65.60) + ABS(C59 - AVGC66.59) + ABS(C58 - AVGC67.58) + ABS(C57 - AVGC68.57) + ABS(C56 - AVGC69.56) + ABS(C55 - AVGC70.55) + ABS(C54 - AVGC71.54) + ABS(C53 - AVGC72.53) + ABS(C52 - AVGC73.52) + ABS(C51 - AVGC74.51) + ABS(C50 - AVGC75.50) + ABS(C49 - AVGC76.49) + ABS(C48 - AVGC77.48) + ABS(C47 - AVGC78.47) + ABS(C46 - AVGC79.46) + ABS(C45 - AVGC80.45) + ABS(C44 - AVGC81.44) + ABS(C43 - AVGC82.43) + ABS(C42 - AVGC83.42) + ABS(C41 - AVGC84.41) + ABS(C40 - AVGC85.40) + ABS(C39 - AVGC86.39) + ABS(C38 - AVGC87.38) + ABS(C37 - AVGC88.37) + ABS(C36 - AVGC89.36) + ABS(C35 - AVGC90.35) + ABS(C34 - AVGC91.34) + ABS(C33 - AVGC92.33) + ABS(C32 - AVGC93.32) + ABS(C31 - AVGC94.31) + ABS(C30 - AVGC95.30) + ABS(C29 - AVGC96.29) + ABS(C28 - AVGC97.28) + ABS(C27 - AVGC98.27) + ABS(C26 - AVGC99.26) + ABS(C25 - AVGC100.25)) / 2000 AND C1 >= AVGC100.25 + 73.5 * (49.5 * C25 + 48.5 * C26 + 47.5 * C27 + 46.5 * C28 + 45.5 * C29 + 44.5 * C30 + 43.5 * C31 + 42.5 * C32 + 41.5 * C33 + 40.5 * C34 + 39.5 * C35 + 38.5 * C36 + 37.5 * C37 + 36.5 * C38 + 35.5 * C39 + 34.5 * C40 + 33.5 * C41 + 32.5 * C42 + 31.5 * C43 + 30.5 * C44 + 29.5 * C45 + 28.5 * C46 + 27.5 * C47 + 26.5 * C48 + 25.5 * C49 + 24.5 * C50 + 23.5 * C51 + 22.5 * C52 + 21.5 * C53 + 20.5 * C54 + 19.5 * C55 + 18.5 * C56 + 17.5 * C57 + 16.5 * C58 + 15.5 * C59 + 14.5 * C60 + 13.5 * C61 + 12.5 * C62 + 11.5 * C63 + 10.5 * C64 + 9.5 * C65 + 8.5 * C66 + 7.5 * C67 + 6.5 * C68 + 5.5 * C69 + 4.5 * C70 + 3.5 * C71 + 2.5 * C72 + 1.5 * C73 + .5 * C74 - .5 * C75 - 1.5 * C76 - 2.5 * C77 - 3.5 * C78 - 4.5 * C79 - 5.5 * C80 - 6.5 * C81 - 7.5 * C82 - 8.5 * C83 - 9.5 * C84 - 10.5 * C85 - 11.5 * C86 - 12.5 * C87 - 13.5 * C88 - 14.5 * C89 - 15.5 * C90 - 16.5 * C91 - 17.5 * C92 - 18.5 * C93 - 19.5 * C94 - 20.5 * C95 - 21.5 * C96 - 22.5 * C97 - 23.5 * C98 - 24.5 * C99 - 25.5 * C100 - 26.5 * C101 - 27.5 * C102 - 28.5 * C103 - 29.5 * C104 - 30.5 * C105 - 31.5 * C106 - 32.5 * C107 - 33.5 * C108 - 34.5 * C109 - 35.5 * C110 - 36.5 * C111 - 37.5 * C112 - 38.5 * C113 - 39.5 * C114 - 40.5 * C115 - 41.5 * C116 - 42.5 * C117 - 43.5 * C118 - 44.5 * C119 - 45.5 * C120 - 46.5 * C121 - 47.5 * C122 - 48.5 * C123 - 49.5 * C124) / 83325 + 25 * (ABS(C123 - AVGC2.123) + ABS(C122 - AVGC3.122) + ABS(C121 - AVGC4.121) + ABS(C120 - AVGC5.120) + ABS(C119 - AVGC6.119) + ABS(C118 - AVGC7.118) + ABS(C117 - AVGC8.117) + ABS(C116 - AVGC9.116) + ABS(C115 - AVGC10.115) + ABS(C114 - AVGC11.114) + ABS(C113 - AVGC12.113) + ABS(C112 - AVGC13.112) + ABS(C111 - AVGC14.111) + ABS(C110 - AVGC15.110) + ABS(C109 - AVGC16.109) + ABS(C108 - AVGC17.108) + ABS(C107 - AVGC18.107) + ABS(C106 - AVGC19.106) + ABS(C105 - AVGC20.105) + ABS(C104 - AVGC21.104) + ABS(C103 - AVGC22.103) + ABS(C102 - AVGC23.102) + ABS(C101 - AVGC24.101) + ABS(C100 - AVGC25.100) + ABS(C99 - AVGC26.99) + ABS(C98 - AVGC27.98) + ABS(C97 - AVGC28.97) + ABS(C96 - AVGC29.96) + ABS(C95 - AVGC30.95) + ABS(C94 - AVGC31.94) + ABS(C93 - AVGC32.93) + ABS(C92 - AVGC33.92) + ABS(C91 - AVGC34.91) + ABS(C90 - AVGC35.90) + ABS(C89 - AVGC36.89) + ABS(C88 - AVGC37.88) + ABS(C87 - AVGC38.87) + ABS(C86 - AVGC39.86) + ABS(C85 - AVGC40.85) + ABS(C84 - AVGC41.84) + ABS(C83 - AVGC42.83) + ABS(C82 - AVGC43.82) + ABS(C81 - AVGC44.81) + ABS(C80 - AVGC45.80) + ABS(C79 - AVGC46.79) + ABS(C78 - AVGC47.78) + ABS(C77 - AVGC48.77) + ABS(C76 - AVGC49.76) + ABS(C75 - AVGC50.75) + ABS(C74 - AVGC51.74) + ABS(C73 - AVGC52.73) + ABS(C72 - AVGC53.72) + ABS(C71 - AVGC54.71) + ABS(C70 - AVGC55.70) + ABS(C69 - AVGC56.69) + ABS(C68 - AVGC57.68) + ABS(C67 - AVGC58.67) + ABS(C66 - AVGC59.66) + ABS(C65 - AVGC60.65) + ABS(C64 - AVGC61.64) + ABS(C63 - AVGC62.63) + ABS(C62 - AVGC63.62) + ABS(C61 - AVGC64.61) + ABS(C60 - AVGC65.60) + ABS(C59 - AVGC66.59) + ABS(C58 - AVGC67.58) + ABS(C57 - AVGC68.57) + ABS(C56 - AVGC69.56) + ABS(C55 - AVGC70.55) + ABS(C54 - AVGC71.54) + ABS(C53 - AVGC72.53) + ABS(C52 - AVGC73.52) + ABS(C51 - AVGC74.51) + ABS(C50 - AVGC75.50) + ABS(C49 - AVGC76.49) + ABS(C48 - AVGC77.48) + ABS(C47 - AVGC78.47) + ABS(C46 - AVGC79.46) + ABS(C45 - AVGC80.45) + ABS(C44 - AVGC81.44) + ABS(C43 - AVGC82.43) + ABS(C42 - AVGC83.42) + ABS(C41 - AVGC84.41) + ABS(C40 - AVGC85.40) + ABS(C39 - AVGC86.39) + ABS(C38 - AVGC87.38) + ABS(C37 - AVGC88.37) + ABS(C36 - AVGC89.36) + ABS(C35 - AVGC90.35) + ABS(C34 - AVGC91.34) + ABS(C33 - AVGC92.33) + ABS(C32 - AVGC93.32) + ABS(C31 - AVGC94.31) + ABS(C30 - AVGC95.30) + ABS(C29 - AVGC96.29) + ABS(C28 - AVGC97.28) + ABS(C27 - AVGC98.27) + ABS(C26 - AVGC99.26) + ABS(C25 - AVGC100.25)) / 2000

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

hicraig3

Posted : Friday, November 2, 2007 9:36:32 AM

Registered User
Joined: 12/27/2005
Posts: 83

Bruce,

I like to use the LRC 65. To change the previous postings from 100 to 65, how do I do that?

Thanks,
Craig

hicraig3

Posted : Friday, November 2, 2007 9:39:26 AM

Registered User
Joined: 12/27/2005
Posts: 83

Let me be more specific:

My Linear Regression Channel parameters : Period = 65, Extention = 0, Width =20

Thanks,
Craig

Bruce_L

Posted : Friday, November 2, 2007 9:58:56 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The second two topics referenced in my first response explain the details of how you would write these formulas using different periods:

Using Linear Regression vs Classical Peaks/Valleys for Divergence Analysis
Linear regression channel calculations

Please try as many of the following as apply:

Warning: Long Personal Criteria Formulas can dramatically increase the time it takes to update your PCFs.

Current Price > Current Lower LR Channel and Previous Price <= Current Lower LR Channel:

C > AVGC65 + 32 * (32 * C + 31 * C1 + 30 * C2 + 29 * C3 + 28 * C4 + 27 * C5 + 26 * C6 + 25 * C7 + 24 * C8 + 23 * C9 + 22 * C10 + 21 * C11 + 20 * C12 + 19 * C13 + 18 * C14 + 17 * C15 + 16 * C16 + 15 * C17 + 14 * C18 + 13 * C19 + 12 * C20 + 11 * C21 + 10 * C22 + 9 * C23 + 8 * C24 + 7 * C25 + 6 * C26 + 5 * C27 + 4 * C28 + 3 * C29 + 2 * C30 + C31 - C33 - 2 * C34 - 3 * C35 - 4 * C36 - 5 * C37 - 6 * C38 - 7 * C39 - 8 * C40 - 9 * C41 - 10 * C42 - 11 * C43 - 12 * C44 - 13 * C45 - 14 * C46 - 15 * C47 - 16 * C48 - 17 * C49 - 18 * C50 - 19 * C51 - 20 * C52 - 21 * C53 - 22 * C54 - 23 * C55 - 24 * C56 - 25 * C57 - 26 * C58 - 27 * C59 - 28 * C60 - 29 * C61 - 30 * C62 - 31 * C63 - 32 * C64) / 22880 - 20 * (ABS(C63 - AVGC2.63) + ABS(C62 - AVGC3.62) + ABS(C61 - AVGC4.61) + ABS(C60 - AVGC5.60) + ABS(C59 - AVGC6.59) + ABS(C58 - AVGC7.58) + ABS(C57 - AVGC8.57) + ABS(C56 - AVGC9.56) + ABS(C55 - AVGC10.55) + ABS(C54 - AVGC11.54) + ABS(C53 - AVGC12.53) + ABS(C52 - AVGC13.52) + ABS(C51 - AVGC14.51) + ABS(C50 - AVGC15.50) + ABS(C49 - AVGC16.49) + ABS(C48 - AVGC17.48) + ABS(C47 - AVGC18.47) + ABS(C46 - AVGC19.46) + ABS(C45 - AVGC20.45) + ABS(C44 - AVGC21.44) + ABS(C43 - AVGC22.43) + ABS(C42 - AVGC23.42) + ABS(C41 - AVGC24.41) + ABS(C40 - AVGC25.40) + ABS(C39 - AVGC26.39) + ABS(C38 - AVGC27.38) + ABS(C37 - AVGC28.37) + ABS(C36 - AVGC29.36) + ABS(C35 - AVGC30.35) + ABS(C34 - AVGC31.34) + ABS(C33 - AVGC32.33) + ABS(C32 - AVGC33.32) + ABS(C31 - AVGC34.31) + ABS(C30 - AVGC35.30) + ABS(C29 - AVGC36.29) + ABS(C28 - AVGC37.28) + ABS(C27 - AVGC38.27) + ABS(C26 - AVGC39.26) + ABS(C25 - AVGC40.25) + ABS(C24 - AVGC41.24) + ABS(C23 - AVGC42.23) + ABS(C22 - AVGC43.22) + ABS(C21 - AVGC44.21) + ABS(C20 - AVGC45.20) + ABS(C19 - AVGC46.19) + ABS(C18 - AVGC47.18) + ABS(C17 - AVGC48.17) + ABS(C16 - AVGC49.16) + ABS(C15 - AVGC50.15) + ABS(C14 - AVGC51.14) + ABS(C13 - AVGC52.13) + ABS(C12 - AVGC53.12) + ABS(C11 - AVGC54.11) + ABS(C10 - AVGC55.10) + ABS(C9 - AVGC56.9) + ABS(C8 - AVGC57.8) + ABS(C7 - AVGC58.7) + ABS(C6 - AVGC59.6) + ABS(C5 - AVGC60.5) + ABS(C4 - AVGC61.4) + ABS(C3 - AVGC62.3) + ABS(C2 - AVGC63.2) + ABS(C1 - AVGC64.1) + ABS(C - AVGC65)) / 1300 AND C1 <= AVGC65 + 31 * (32 * C + 31 * C1 + 30 * C2 + 29 * C3 + 28 * C4 + 27 * C5 + 26 * C6 + 25 * C7 + 24 * C8 + 23 * C9 + 22 * C10 + 21 * C11 + 20 * C12 + 19 * C13 + 18 * C14 + 17 * C15 + 16 * C16 + 15 * C17 + 14 * C18 + 13 * C19 + 12 * C20 + 11 * C21 + 10 * C22 + 9 * C23 + 8 * C24 + 7 * C25 + 6 * C26 + 5 * C27 + 4 * C28 + 3 * C29 + 2 * C30 + C31 - C33 - 2 * C34 - 3 * C35 - 4 * C36 - 5 * C37 - 6 * C38 - 7 * C39 - 8 * C40 - 9 * C41 - 10 * C42 - 11 * C43 - 12 * C44 - 13 * C45 - 14 * C46 - 15 * C47 - 16 * C48 - 17 * C49 - 18 * C50 - 19 * C51 - 20 * C52 - 21 * C53 - 22 * C54 - 23 * C55 - 24 * C56 - 25 * C57 - 26 * C58 - 27 * C59 - 28 * C60 - 29 * C61 - 30 * C62 - 31 * C63 - 32 * C64) / 22880 - 20 * (ABS(C63 - AVGC2.63) + ABS(C62 - AVGC3.62) + ABS(C61 - AVGC4.61) + ABS(C60 - AVGC5.60) + ABS(C59 - AVGC6.59) + ABS(C58 - AVGC7.58) + ABS(C57 - AVGC8.57) + ABS(C56 - AVGC9.56) + ABS(C55 - AVGC10.55) + ABS(C54 - AVGC11.54) + ABS(C53 - AVGC12.53) + ABS(C52 - AVGC13.52) + ABS(C51 - AVGC14.51) + ABS(C50 - AVGC15.50) + ABS(C49 - AVGC16.49) + ABS(C48 - AVGC17.48) + ABS(C47 - AVGC18.47) + ABS(C46 - AVGC19.46) + ABS(C45 - AVGC20.45) + ABS(C44 - AVGC21.44) + ABS(C43 - AVGC22.43) + ABS(C42 - AVGC23.42) + ABS(C41 - AVGC24.41) + ABS(C40 - AVGC25.40) + ABS(C39 - AVGC26.39) + ABS(C38 - AVGC27.38) + ABS(C37 - AVGC28.37) + ABS(C36 - AVGC29.36) + ABS(C35 - AVGC30.35) + ABS(C34 - AVGC31.34) + ABS(C33 - AVGC32.33) + ABS(C32 - AVGC33.32) + ABS(C31 - AVGC34.31) + ABS(C30 - AVGC35.30) + ABS(C29 - AVGC36.29) + ABS(C28 - AVGC37.28) + ABS(C27 - AVGC38.27) + ABS(C26 - AVGC39.26) + ABS(C25 - AVGC40.25) + ABS(C24 - AVGC41.24) + ABS(C23 - AVGC42.23) + ABS(C22 - AVGC43.22) + ABS(C21 - AVGC44.21) + ABS(C20 - AVGC45.20) + ABS(C19 - AVGC46.19) + ABS(C18 - AVGC47.18) + ABS(C17 - AVGC48.17) + ABS(C16 - AVGC49.16) + ABS(C15 - AVGC50.15) + ABS(C14 - AVGC51.14) + ABS(C13 - AVGC52.13) + ABS(C12 - AVGC53.12) + ABS(C11 - AVGC54.11) + ABS(C10 - AVGC55.10) + ABS(C9 - AVGC56.9) + ABS(C8 - AVGC57.8) + ABS(C7 - AVGC58.7) + ABS(C6 - AVGC59.6) + ABS(C5 - AVGC60.5) + ABS(C4 - AVGC61.4) + ABS(C3 - AVGC62.3) + ABS(C2 - AVGC63.2) + ABS(C1 - AVGC64.1) + ABS(C - AVGC65)) / 1300

Current Price > Current LR Line and Previous Price <= Current LR Line:

C > AVGC65 + 32 * (32 * C + 31 * C1 + 30 * C2 + 29 * C3 + 28 * C4 + 27 * C5 + 26 * C6 + 25 * C7 + 24 * C8 + 23 * C9 + 22 * C10 + 21 * C11 + 20 * C12 + 19 * C13 + 18 * C14 + 17 * C15 + 16 * C16 + 15 * C17 + 14 * C18 + 13 * C19 + 12 * C20 + 11 * C21 + 10 * C22 + 9 * C23 + 8 * C24 + 7 * C25 + 6 * C26 + 5 * C27 + 4 * C28 + 3 * C29 + 2 * C30 + C31 - C33 - 2 * C34 - 3 * C35 - 4 * C36 - 5 * C37 - 6 * C38 - 7 * C39 - 8 * C40 - 9 * C41 - 10 * C42 - 11 * C43 - 12 * C44 - 13 * C45 - 14 * C46 - 15 * C47 - 16 * C48 - 17 * C49 - 18 * C50 - 19 * C51 - 20 * C52 - 21 * C53 - 22 * C54 - 23 * C55 - 24 * C56 - 25 * C57 - 26 * C58 - 27 * C59 - 28 * C60 - 29 * C61 - 30 * C62 - 31 * C63 - 32 * C64) / 22880 AND C1 <= AVGC65 + 31 * (32 * C + 31 * C1 + 30 * C2 + 29 * C3 + 28 * C4 + 27 * C5 + 26 * C6 + 25 * C7 + 24 * C8 + 23 * C9 + 22 * C10 + 21 * C11 + 20 * C12 + 19 * C13 + 18 * C14 + 17 * C15 + 16 * C16 + 15 * C17 + 14 * C18 + 13 * C19 + 12 * C20 + 11 * C21 + 10 * C22 + 9 * C23 + 8 * C24 + 7 * C25 + 6 * C26 + 5 * C27 + 4 * C28 + 3 * C29 + 2 * C30 + C31 - C33 - 2 * C34 - 3 * C35 - 4 * C36 - 5 * C37 - 6 * C38 - 7 * C39 - 8 * C40 - 9 * C41 - 10 * C42 - 11 * C43 - 12 * C44 - 13 * C45 - 14 * C46 - 15 * C47 - 16 * C48 - 17 * C49 - 18 * C50 - 19 * C51 - 20 * C52 - 21 * C53 - 22 * C54 - 23 * C55 - 24 * C56 - 25 * C57 - 26 * C58 - 27 * C59 - 28 * C60 - 29 * C61 - 30 * C62 - 31 * C63 - 32 * C64) / 22880

Current Price > Current Upper LR Channel and Previous Price <= Current Upper LR Channel:

C > AVGC65 + 32 * (32 * C + 31 * C1 + 30 * C2 + 29 * C3 + 28 * C4 + 27 * C5 + 26 * C6 + 25 * C7 + 24 * C8 + 23 * C9 + 22 * C10 + 21 * C11 + 20 * C12 + 19 * C13 + 18 * C14 + 17 * C15 + 16 * C16 + 15 * C17 + 14 * C18 + 13 * C19 + 12 * C20 + 11 * C21 + 10 * C22 + 9 * C23 + 8 * C24 + 7 * C25 + 6 * C26 + 5 * C27 + 4 * C28 + 3 * C29 + 2 * C30 + C31 - C33 - 2 * C34 - 3 * C35 - 4 * C36 - 5 * C37 - 6 * C38 - 7 * C39 - 8 * C40 - 9 * C41 - 10 * C42 - 11 * C43 - 12 * C44 - 13 * C45 - 14 * C46 - 15 * C47 - 16 * C48 - 17 * C49 - 18 * C50 - 19 * C51 - 20 * C52 - 21 * C53 - 22 * C54 - 23 * C55 - 24 * C56 - 25 * C57 - 26 * C58 - 27 * C59 - 28 * C60 - 29 * C61 - 30 * C62 - 31 * C63 - 32 * C64) / 22880 + 20 * (ABS(C63 - AVGC2.63) + ABS(C62 - AVGC3.62) + ABS(C61 - AVGC4.61) + ABS(C60 - AVGC5.60) + ABS(C59 - AVGC6.59) + ABS(C58 - AVGC7.58) + ABS(C57 - AVGC8.57) + ABS(C56 - AVGC9.56) + ABS(C55 - AVGC10.55) + ABS(C54 - AVGC11.54) + ABS(C53 - AVGC12.53) + ABS(C52 - AVGC13.52) + ABS(C51 - AVGC14.51) + ABS(C50 - AVGC15.50) + ABS(C49 - AVGC16.49) + ABS(C48 - AVGC17.48) + ABS(C47 - AVGC18.47) + ABS(C46 - AVGC19.46) + ABS(C45 - AVGC20.45) + ABS(C44 - AVGC21.44) + ABS(C43 - AVGC22.43) + ABS(C42 - AVGC23.42) + ABS(C41 - AVGC24.41) + ABS(C40 - AVGC25.40) + ABS(C39 - AVGC26.39) + ABS(C38 - AVGC27.38) + ABS(C37 - AVGC28.37) + ABS(C36 - AVGC29.36) + ABS(C35 - AVGC30.35) + ABS(C34 - AVGC31.34) + ABS(C33 - AVGC32.33) + ABS(C32 - AVGC33.32) + ABS(C31 - AVGC34.31) + ABS(C30 - AVGC35.30) + ABS(C29 - AVGC36.29) + ABS(C28 - AVGC37.28) + ABS(C27 - AVGC38.27) + ABS(C26 - AVGC39.26) + ABS(C25 - AVGC40.25) + ABS(C24 - AVGC41.24) + ABS(C23 - AVGC42.23) + ABS(C22 - AVGC43.22) + ABS(C21 - AVGC44.21) + ABS(C20 - AVGC45.20) + ABS(C19 - AVGC46.19) + ABS(C18 - AVGC47.18) + ABS(C17 - AVGC48.17) + ABS(C16 - AVGC49.16) + ABS(C15 - AVGC50.15) + ABS(C14 - AVGC51.14) + ABS(C13 - AVGC52.13) + ABS(C12 - AVGC53.12) + ABS(C11 - AVGC54.11) + ABS(C10 - AVGC55.10) + ABS(C9 - AVGC56.9) + ABS(C8 - AVGC57.8) + ABS(C7 - AVGC58.7) + ABS(C6 - AVGC59.6) + ABS(C5 - AVGC60.5) + ABS(C4 - AVGC61.4) + ABS(C3 - AVGC62.3) + ABS(C2 - AVGC63.2) + ABS(C1 - AVGC64.1) + ABS(C - AVGC65)) / 1300 AND C1 <= AVGC65 + 31 * (32 * C + 31 * C1 + 30 * C2 + 29 * C3 + 28 * C4 + 27 * C5 + 26 * C6 + 25 * C7 + 24 * C8 + 23 * C9 + 22 * C10 + 21 * C11 + 20 * C12 + 19 * C13 + 18 * C14 + 17 * C15 + 16 * C16 + 15 * C17 + 14 * C18 + 13 * C19 + 12 * C20 + 11 * C21 + 10 * C22 + 9 * C23 + 8 * C24 + 7 * C25 + 6 * C26 + 5 * C27 + 4 * C28 + 3 * C29 + 2 * C30 + C31 - C33 - 2 * C34 - 3 * C35 - 4 * C36 - 5 * C37 - 6 * C38 - 7 * C39 - 8 * C40 - 9 * C41 - 10 * C42 - 11 * C43 - 12 * C44 - 13 * C45 - 14 * C46 - 15 * C47 - 16 * C48 - 17 * C49 - 18 * C50 - 19 * C51 - 20 * C52 - 21 * C53 - 22 * C54 - 23 * C55 - 24 * C56 - 25 * C57 - 26 * C58 - 27 * C59 - 28 * C60 - 29 * C61 - 30 * C62 - 31 * C63 - 32 * C64) / 22880 + 20 * (ABS(C63 - AVGC2.63) + ABS(C62 - AVGC3.62) + ABS(C61 - AVGC4.61) + ABS(C60 - AVGC5.60) + ABS(C59 - AVGC6.59) + ABS(C58 - AVGC7.58) + ABS(C57 - AVGC8.57) + ABS(C56 - AVGC9.56) + ABS(C55 - AVGC10.55) + ABS(C54 - AVGC11.54) + ABS(C53 - AVGC12.53) + ABS(C52 - AVGC13.52) + ABS(C51 - AVGC14.51) + ABS(C50 - AVGC15.50) + ABS(C49 - AVGC16.49) + ABS(C48 - AVGC17.48) + ABS(C47 - AVGC18.47) + ABS(C46 - AVGC19.46) + ABS(C45 - AVGC20.45) + ABS(C44 - AVGC21.44) + ABS(C43 - AVGC22.43) + ABS(C42 - AVGC23.42) + ABS(C41 - AVGC24.41) + ABS(C40 - AVGC25.40) + ABS(C39 - AVGC26.39) + ABS(C38 - AVGC27.38) + ABS(C37 - AVGC28.37) + ABS(C36 - AVGC29.36) + ABS(C35 - AVGC30.35) + ABS(C34 - AVGC31.34) + ABS(C33 - AVGC32.33) + ABS(C32 - AVGC33.32) + ABS(C31 - AVGC34.31) + ABS(C30 - AVGC35.30) + ABS(C29 - AVGC36.29) + ABS(C28 - AVGC37.28) + ABS(C27 - AVGC38.27) + ABS(C26 - AVGC39.26) + ABS(C25 - AVGC40.25) + ABS(C24 - AVGC41.24) + ABS(C23 - AVGC42.23) + ABS(C22 - AVGC43.22) + ABS(C21 - AVGC44.21) + ABS(C20 - AVGC45.20) + ABS(C19 - AVGC46.19) + ABS(C18 - AVGC47.18) + ABS(C17 - AVGC48.17) + ABS(C16 - AVGC49.16) + ABS(C15 - AVGC50.15) + ABS(C14 - AVGC51.14) + ABS(C13 - AVGC52.13) + ABS(C12 - AVGC53.12) + ABS(C11 - AVGC54.11) + ABS(C10 - AVGC55.10) + ABS(C9 - AVGC56.9) + ABS(C8 - AVGC57.8) + ABS(C7 - AVGC58.7) + ABS(C6 - AVGC59.6) + ABS(C5 - AVGC60.5) + ABS(C4 - AVGC61.4) + ABS(C3 - AVGC62.3) + ABS(C2 - AVGC63.2) + ABS(C1 - AVGC64.1) + ABS(C - AVGC65)) / 1300

Current Price < Current Lower LR Channel and Previous Price >= Current Lower LR Channel:

C < AVGC65 + 32 * (32 * C + 31 * C1 + 30 * C2 + 29 * C3 + 28 * C4 + 27 * C5 + 26 * C6 + 25 * C7 + 24 * C8 + 23 * C9 + 22 * C10 + 21 * C11 + 20 * C12 + 19 * C13 + 18 * C14 + 17 * C15 + 16 * C16 + 15 * C17 + 14 * C18 + 13 * C19 + 12 * C20 + 11 * C21 + 10 * C22 + 9 * C23 + 8 * C24 + 7 * C25 + 6 * C26 + 5 * C27 + 4 * C28 + 3 * C29 + 2 * C30 + C31 - C33 - 2 * C34 - 3 * C35 - 4 * C36 - 5 * C37 - 6 * C38 - 7 * C39 - 8 * C40 - 9 * C41 - 10 * C42 - 11 * C43 - 12 * C44 - 13 * C45 - 14 * C46 - 15 * C47 - 16 * C48 - 17 * C49 - 18 * C50 - 19 * C51 - 20 * C52 - 21 * C53 - 22 * C54 - 23 * C55 - 24 * C56 - 25 * C57 - 26 * C58 - 27 * C59 - 28 * C60 - 29 * C61 - 30 * C62 - 31 * C63 - 32 * C64) / 22880 - 20 * (ABS(C63 - AVGC2.63) + ABS(C62 - AVGC3.62) + ABS(C61 - AVGC4.61) + ABS(C60 - AVGC5.60) + ABS(C59 - AVGC6.59) + ABS(C58 - AVGC7.58) + ABS(C57 - AVGC8.57) + ABS(C56 - AVGC9.56) + ABS(C55 - AVGC10.55) + ABS(C54 - AVGC11.54) + ABS(C53 - AVGC12.53) + ABS(C52 - AVGC13.52) + ABS(C51 - AVGC14.51) + ABS(C50 - AVGC15.50) + ABS(C49 - AVGC16.49) + ABS(C48 - AVGC17.48) + ABS(C47 - AVGC18.47) + ABS(C46 - AVGC19.46) + ABS(C45 - AVGC20.45) + ABS(C44 - AVGC21.44) + ABS(C43 - AVGC22.43) + ABS(C42 - AVGC23.42) + ABS(C41 - AVGC24.41) + ABS(C40 - AVGC25.40) + ABS(C39 - AVGC26.39) + ABS(C38 - AVGC27.38) + ABS(C37 - AVGC28.37) + ABS(C36 - AVGC29.36) + ABS(C35 - AVGC30.35) + ABS(C34 - AVGC31.34) + ABS(C33 - AVGC32.33) + ABS(C32 - AVGC33.32) + ABS(C31 - AVGC34.31) + ABS(C30 - AVGC35.30) + ABS(C29 - AVGC36.29) + ABS(C28 - AVGC37.28) + ABS(C27 - AVGC38.27) + ABS(C26 - AVGC39.26) + ABS(C25 - AVGC40.25) + ABS(C24 - AVGC41.24) + ABS(C23 - AVGC42.23) + ABS(C22 - AVGC43.22) + ABS(C21 - AVGC44.21) + ABS(C20 - AVGC45.20) + ABS(C19 - AVGC46.19) + ABS(C18 - AVGC47.18) + ABS(C17 - AVGC48.17) + ABS(C16 - AVGC49.16) + ABS(C15 - AVGC50.15) + ABS(C14 - AVGC51.14) + ABS(C13 - AVGC52.13) + ABS(C12 - AVGC53.12) + ABS(C11 - AVGC54.11) + ABS(C10 - AVGC55.10) + ABS(C9 - AVGC56.9) + ABS(C8 - AVGC57.8) + ABS(C7 - AVGC58.7) + ABS(C6 - AVGC59.6) + ABS(C5 - AVGC60.5) + ABS(C4 - AVGC61.4) + ABS(C3 - AVGC62.3) + ABS(C2 - AVGC63.2) + ABS(C1 - AVGC64.1) + ABS(C - AVGC65)) / 1300 AND C1 >= AVGC65 + 31 * (32 * C + 31 * C1 + 30 * C2 + 29 * C3 + 28 * C4 + 27 * C5 + 26 * C6 + 25 * C7 + 24 * C8 + 23 * C9 + 22 * C10 + 21 * C11 + 20 * C12 + 19 * C13 + 18 * C14 + 17 * C15 + 16 * C16 + 15 * C17 + 14 * C18 + 13 * C19 + 12 * C20 + 11 * C21 + 10 * C22 + 9 * C23 + 8 * C24 + 7 * C25 + 6 * C26 + 5 * C27 + 4 * C28 + 3 * C29 + 2 * C30 + C31 - C33 - 2 * C34 - 3 * C35 - 4 * C36 - 5 * C37 - 6 * C38 - 7 * C39 - 8 * C40 - 9 * C41 - 10 * C42 - 11 * C43 - 12 * C44 - 13 * C45 - 14 * C46 - 15 * C47 - 16 * C48 - 17 * C49 - 18 * C50 - 19 * C51 - 20 * C52 - 21 * C53 - 22 * C54 - 23 * C55 - 24 * C56 - 25 * C57 - 26 * C58 - 27 * C59 - 28 * C60 - 29 * C61 - 30 * C62 - 31 * C63 - 32 * C64) / 22880 - 20 * (ABS(C63 - AVGC2.63) + ABS(C62 - AVGC3.62) + ABS(C61 - AVGC4.61) + ABS(C60 - AVGC5.60) + ABS(C59 - AVGC6.59) + ABS(C58 - AVGC7.58) + ABS(C57 - AVGC8.57) + ABS(C56 - AVGC9.56) + ABS(C55 - AVGC10.55) + ABS(C54 - AVGC11.54) + ABS(C53 - AVGC12.53) + ABS(C52 - AVGC13.52) + ABS(C51 - AVGC14.51) + ABS(C50 - AVGC15.50) + ABS(C49 - AVGC16.49) + ABS(C48 - AVGC17.48) + ABS(C47 - AVGC18.47) + ABS(C46 - AVGC19.46) + ABS(C45 - AVGC20.45) + ABS(C44 - AVGC21.44) + ABS(C43 - AVGC22.43) + ABS(C42 - AVGC23.42) + ABS(C41 - AVGC24.41) + ABS(C40 - AVGC25.40) + ABS(C39 - AVGC26.39) + ABS(C38 - AVGC27.38) + ABS(C37 - AVGC28.37) + ABS(C36 - AVGC29.36) + ABS(C35 - AVGC30.35) + ABS(C34 - AVGC31.34) + ABS(C33 - AVGC32.33) + ABS(C32 - AVGC33.32) + ABS(C31 - AVGC34.31) + ABS(C30 - AVGC35.30) + ABS(C29 - AVGC36.29) + ABS(C28 - AVGC37.28) + ABS(C27 - AVGC38.27) + ABS(C26 - AVGC39.26) + ABS(C25 - AVGC40.25) + ABS(C24 - AVGC41.24) + ABS(C23 - AVGC42.23) + ABS(C22 - AVGC43.22) + ABS(C21 - AVGC44.21) + ABS(C20 - AVGC45.20) + ABS(C19 - AVGC46.19) + ABS(C18 - AVGC47.18) + ABS(C17 - AVGC48.17) + ABS(C16 - AVGC49.16) + ABS(C15 - AVGC50.15) + ABS(C14 - AVGC51.14) + ABS(C13 - AVGC52.13) + ABS(C12 - AVGC53.12) + ABS(C11 - AVGC54.11) + ABS(C10 - AVGC55.10) + ABS(C9 - AVGC56.9) + ABS(C8 - AVGC57.8) + ABS(C7 - AVGC58.7) + ABS(C6 - AVGC59.6) + ABS(C5 - AVGC60.5) + ABS(C4 - AVGC61.4) + ABS(C3 - AVGC62.3) + ABS(C2 - AVGC63.2) + ABS(C1 - AVGC64.1) + ABS(C - AVGC65)) / 1300

Current Price < Current LR Line and Previous Price >= Current LR Line:

C < AVGC65 + 32 * (32 * C + 31 * C1 + 30 * C2 + 29 * C3 + 28 * C4 + 27 * C5 + 26 * C6 + 25 * C7 + 24 * C8 + 23 * C9 + 22 * C10 + 21 * C11 + 20 * C12 + 19 * C13 + 18 * C14 + 17 * C15 + 16 * C16 + 15 * C17 + 14 * C18 + 13 * C19 + 12 * C20 + 11 * C21 + 10 * C22 + 9 * C23 + 8 * C24 + 7 * C25 + 6 * C26 + 5 * C27 + 4 * C28 + 3 * C29 + 2 * C30 + C31 - C33 - 2 * C34 - 3 * C35 - 4 * C36 - 5 * C37 - 6 * C38 - 7 * C39 - 8 * C40 - 9 * C41 - 10 * C42 - 11 * C43 - 12 * C44 - 13 * C45 - 14 * C46 - 15 * C47 - 16 * C48 - 17 * C49 - 18 * C50 - 19 * C51 - 20 * C52 - 21 * C53 - 22 * C54 - 23 * C55 - 24 * C56 - 25 * C57 - 26 * C58 - 27 * C59 - 28 * C60 - 29 * C61 - 30 * C62 - 31 * C63 - 32 * C64) / 22880 AND C1 >= AVGC65 + 31 * (32 * C + 31 * C1 + 30 * C2 + 29 * C3 + 28 * C4 + 27 * C5 + 26 * C6 + 25 * C7 + 24 * C8 + 23 * C9 + 22 * C10 + 21 * C11 + 20 * C12 + 19 * C13 + 18 * C14 + 17 * C15 + 16 * C16 + 15 * C17 + 14 * C18 + 13 * C19 + 12 * C20 + 11 * C21 + 10 * C22 + 9 * C23 + 8 * C24 + 7 * C25 + 6 * C26 + 5 * C27 + 4 * C28 + 3 * C29 + 2 * C30 + C31 - C33 - 2 * C34 - 3 * C35 - 4 * C36 - 5 * C37 - 6 * C38 - 7 * C39 - 8 * C40 - 9 * C41 - 10 * C42 - 11 * C43 - 12 * C44 - 13 * C45 - 14 * C46 - 15 * C47 - 16 * C48 - 17 * C49 - 18 * C50 - 19 * C51 - 20 * C52 - 21 * C53 - 22 * C54 - 23 * C55 - 24 * C56 - 25 * C57 - 26 * C58 - 27 * C59 - 28 * C60 - 29 * C61 - 30 * C62 - 31 * C63 - 32 * C64) / 22880

Current Price < Current Upper LR Channel and Previous Price >= Current Upper LR Channel:

C < AVGC65 + 32 * (32 * C + 31 * C1 + 30 * C2 + 29 * C3 + 28 * C4 + 27 * C5 + 26 * C6 + 25 * C7 + 24 * C8 + 23 * C9 + 22 * C10 + 21 * C11 + 20 * C12 + 19 * C13 + 18 * C14 + 17 * C15 + 16 * C16 + 15 * C17 + 14 * C18 + 13 * C19 + 12 * C20 + 11 * C21 + 10 * C22 + 9 * C23 + 8 * C24 + 7 * C25 + 6 * C26 + 5 * C27 + 4 * C28 + 3 * C29 + 2 * C30 + C31 - C33 - 2 * C34 - 3 * C35 - 4 * C36 - 5 * C37 - 6 * C38 - 7 * C39 - 8 * C40 - 9 * C41 - 10 * C42 - 11 * C43 - 12 * C44 - 13 * C45 - 14 * C46 - 15 * C47 - 16 * C48 - 17 * C49 - 18 * C50 - 19 * C51 - 20 * C52 - 21 * C53 - 22 * C54 - 23 * C55 - 24 * C56 - 25 * C57 - 26 * C58 - 27 * C59 - 28 * C60 - 29 * C61 - 30 * C62 - 31 * C63 - 32 * C64) / 22880 + 20 * (ABS(C63 - AVGC2.63) + ABS(C62 - AVGC3.62) + ABS(C61 - AVGC4.61) + ABS(C60 - AVGC5.60) + ABS(C59 - AVGC6.59) + ABS(C58 - AVGC7.58) + ABS(C57 - AVGC8.57) + ABS(C56 - AVGC9.56) + ABS(C55 - AVGC10.55) + ABS(C54 - AVGC11.54) + ABS(C53 - AVGC12.53) + ABS(C52 - AVGC13.52) + ABS(C51 - AVGC14.51) + ABS(C50 - AVGC15.50) + ABS(C49 - AVGC16.49) + ABS(C48 - AVGC17.48) + ABS(C47 - AVGC18.47) + ABS(C46 - AVGC19.46) + ABS(C45 - AVGC20.45) + ABS(C44 - AVGC21.44) + ABS(C43 - AVGC22.43) + ABS(C42 - AVGC23.42) + ABS(C41 - AVGC24.41) + ABS(C40 - AVGC25.40) + ABS(C39 - AVGC26.39) + ABS(C38 - AVGC27.38) + ABS(C37 - AVGC28.37) + ABS(C36 - AVGC29.36) + ABS(C35 - AVGC30.35) + ABS(C34 - AVGC31.34) + ABS(C33 - AVGC32.33) + ABS(C32 - AVGC33.32) + ABS(C31 - AVGC34.31) + ABS(C30 - AVGC35.30) + ABS(C29 - AVGC36.29) + ABS(C28 - AVGC37.28) + ABS(C27 - AVGC38.27) + ABS(C26 - AVGC39.26) + ABS(C25 - AVGC40.25) + ABS(C24 - AVGC41.24) + ABS(C23 - AVGC42.23) + ABS(C22 - AVGC43.22) + ABS(C21 - AVGC44.21) + ABS(C20 - AVGC45.20) + ABS(C19 - AVGC46.19) + ABS(C18 - AVGC47.18) + ABS(C17 - AVGC48.17) + ABS(C16 - AVGC49.16) + ABS(C15 - AVGC50.15) + ABS(C14 - AVGC51.14) + ABS(C13 - AVGC52.13) + ABS(C12 - AVGC53.12) + ABS(C11 - AVGC54.11) + ABS(C10 - AVGC55.10) + ABS(C9 - AVGC56.9) + ABS(C8 - AVGC57.8) + ABS(C7 - AVGC58.7) + ABS(C6 - AVGC59.6) + ABS(C5 - AVGC60.5) + ABS(C4 - AVGC61.4) + ABS(C3 - AVGC62.3) + ABS(C2 - AVGC63.2) + ABS(C1 - AVGC64.1) + ABS(C - AVGC65)) / 1300 AND C1 >= AVGC65 + 31 * (32 * C + 31 * C1 + 30 * C2 + 29 * C3 + 28 * C4 + 27 * C5 + 26 * C6 + 25 * C7 + 24 * C8 + 23 * C9 + 22 * C10 + 21 * C11 + 20 * C12 + 19 * C13 + 18 * C14 + 17 * C15 + 16 * C16 + 15 * C17 + 14 * C18 + 13 * C19 + 12 * C20 + 11 * C21 + 10 * C22 + 9 * C23 + 8 * C24 + 7 * C25 + 6 * C26 + 5 * C27 + 4 * C28 + 3 * C29 + 2 * C30 + C31 - C33 - 2 * C34 - 3 * C35 - 4 * C36 - 5 * C37 - 6 * C38 - 7 * C39 - 8 * C40 - 9 * C41 - 10 * C42 - 11 * C43 - 12 * C44 - 13 * C45 - 14 * C46 - 15 * C47 - 16 * C48 - 17 * C49 - 18 * C50 - 19 * C51 - 20 * C52 - 21 * C53 - 22 * C54 - 23 * C55 - 24 * C56 - 25 * C57 - 26 * C58 - 27 * C59 - 28 * C60 - 29 * C61 - 30 * C62 - 31 * C63 - 32 * C64) / 22880 + 20 * (ABS(C63 - AVGC2.63) + ABS(C62 - AVGC3.62) + ABS(C61 - AVGC4.61) + ABS(C60 - AVGC5.60) + ABS(C59 - AVGC6.59) + ABS(C58 - AVGC7.58) + ABS(C57 - AVGC8.57) + ABS(C56 - AVGC9.56) + ABS(C55 - AVGC10.55) + ABS(C54 - AVGC11.54) + ABS(C53 - AVGC12.53) + ABS(C52 - AVGC13.52) + ABS(C51 - AVGC14.51) + ABS(C50 - AVGC15.50) + ABS(C49 - AVGC16.49) + ABS(C48 - AVGC17.48) + ABS(C47 - AVGC18.47) + ABS(C46 - AVGC19.46) + ABS(C45 - AVGC20.45) + ABS(C44 - AVGC21.44) + ABS(C43 - AVGC22.43) + ABS(C42 - AVGC23.42) + ABS(C41 - AVGC24.41) + ABS(C40 - AVGC25.40) + ABS(C39 - AVGC26.39) + ABS(C38 - AVGC27.38) + ABS(C37 - AVGC28.37) + ABS(C36 - AVGC29.36) + ABS(C35 - AVGC30.35) + ABS(C34 - AVGC31.34) + ABS(C33 - AVGC32.33) + ABS(C32 - AVGC33.32) + ABS(C31 - AVGC34.31) + ABS(C30 - AVGC35.30) + ABS(C29 - AVGC36.29) + ABS(C28 - AVGC37.28) + ABS(C27 - AVGC38.27) + ABS(C26 - AVGC39.26) + ABS(C25 - AVGC40.25) + ABS(C24 - AVGC41.24) + ABS(C23 - AVGC42.23) + ABS(C22 - AVGC43.22) + ABS(C21 - AVGC44.21) + ABS(C20 - AVGC45.20) + ABS(C19 - AVGC46.19) + ABS(C18 - AVGC47.18) + ABS(C17 - AVGC48.17) + ABS(C16 - AVGC49.16) + ABS(C15 - AVGC50.15) + ABS(C14 - AVGC51.14) + ABS(C13 - AVGC52.13) + ABS(C12 - AVGC53.12) + ABS(C11 - AVGC54.11) + ABS(C10 - AVGC55.10) + ABS(C9 - AVGC56.9) + ABS(C8 - AVGC57.8) + ABS(C7 - AVGC58.7) + ABS(C6 - AVGC59.6) + ABS(C5 - AVGC60.5) + ABS(C4 - AVGC61.4) + ABS(C3 - AVGC62.3) + ABS(C2 - AVGC63.2) + ABS(C1 - AVGC64.1) + ABS(C - AVGC65)) / 1300

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

amberpax

Posted : Sunday, December 30, 2007 8:29:56 PM

Registered User
Joined: 12/30/2004
Posts: 369

Hello Trainers,

Please create a pcf, where the price is just above the lower regression line, and another pcf where the price is just below the upper regression line.
My settings are : Period 63, No Extension, Width 40.
Thank you,
-amberpax

Bruce_L

Posted : Monday, December 31, 2007 9:51:21 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

amberpax,
You will need to provide a more objective description of "just above" and "just below" for us to help you write this type of Personal Criteria Formula, but the following should incorporate your conditions with the exception of "just":

Price Above Lower Regression Line:

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 - 40 * (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

Price Below Upper Regression Line:

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 + 40 * (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

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

amberpax

Posted : Monday, December 31, 2007 5:22:19 PM

Registered User
Joined: 12/30/2004
Posts: 369

amberpax,
You will need to provide a more objective description of "just above" and "just below" for us to help you write this type of Personal Criteria Formula, but the following should incorporate your conditions with the exception of "just":
------------------------------------------------------------------------------------------------------
Bruce,
I understand!!
I think what I want is for the price to be bellow and above the Regression channels.
My setting are to remain the same.
Thanks,
-amberpax

Bruce_L

Posted : Tuesday, January 1, 2008 9:03:58 AM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

amberpax,
Please try the following:

Price Below Lower Regression Line:

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 - 40 * (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

Price Above Upper Regression Line:

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 + 40 * (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

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

amberpax

Posted : Tuesday, January 1, 2008 1:54:51 PM

Registered User
Joined: 12/30/2004
Posts: 369

Works Great!
Thank you Bruce.
-amberpax

Bruce_L

Posted : Tuesday, January 1, 2008 2:01:24 PM

Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles

Users browsing this topic

Guest-1

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.