• Download software • Tutorial videos
• Subscription & data-feed pricing • Class schedule


• New account application • Trading resources
• Margin rates • Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » When did XbarC sma cross YbarC sma

When did XbarC sma cross YbarC sma Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dgarbis
Posted : Tuesday, October 2, 2007 3:53:06 PM
Registered User
Joined: 1/3/2005
Posts: 1
 TC2K has the ability to find MIN and MAX of certain occurrences. I would like to know if TC2K can find [within the last 8 months] WHEN the 20 bar SMA crossed (up or down) the 50 bar SMA.
Thank you (email removed by moderator)
Back to top
Bruce_L
Posted : Tuesday, October 2, 2007 4:34:40 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 The following Personal Criteria Formula looks checks the most recent 168 Trading Days to find when SMA20 is crossing SMA40 in either direction. The value returned is the number of Trading Days Ago that the most recent cross occurred. 0 = Today, 167 = 167 Trading Days Ago. The formula returns -1 if the Moving Averages did not cross during the test period and does not return a Value if there are not enough Trading Days to calculate the formula.

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

ABS(SGN(AVGC20 - AVGC50) <> SGN(AVGC20.1 - AVGC50.1)) * (0) + ABS(SGN(AVGC20 - AVGC50) = SGN(AVGC20.1 - AVGC50.1)) * (ABS(SGN(AVGC20.1 - AVGC50.1) <> SGN(AVGC20.2 - AVGC50.2)) * (1) + ABS(SGN(AVGC20.1 - AVGC50.1) = SGN(AVGC20.2 - AVGC50.2)) * (ABS(SGN(AVGC20.2 - AVGC50.2) <> SGN(AVGC20.3 - AVGC50.3)) * (2) + ABS(SGN(AVGC20.2 - AVGC50.2) = SGN(AVGC20.3 - AVGC50.3)) * (ABS(SGN(AVGC20.3 - AVGC50.3) <> SGN(AVGC20.4 - AVGC50.4)) * (3) + ABS(SGN(AVGC20.3 - AVGC50.3) = SGN(AVGC20.4 - AVGC50.4)) * (ABS(SGN(AVGC20.4 - AVGC50.4) <> SGN(AVGC20.5 - AVGC50.5)) * (4) + ABS(SGN(AVGC20.4 - AVGC50.4) = SGN(AVGC20.5 - AVGC50.5)) * (ABS(SGN(AVGC20.5 - AVGC50.5) <> SGN(AVGC20.6 - AVGC50.6)) * (5) + ABS(SGN(AVGC20.5 - AVGC50.5) = SGN(AVGC20.6 - AVGC50.6)) * (ABS(SGN(AVGC20.6 - AVGC50.6) <> SGN(AVGC20.7 - AVGC50.7)) * (6 ) + ABS(SGN(AVGC20.6 - AVGC50.6) = SGN(AVGC20.7 - AVGC50.7)) * (ABS(SGN(AVGC20.7 - AVGC50.7) <> SGN(AVGC20.8 - AVGC50.8)) * (7) + ABS(SGN(AVGC20.7 - AVGC50.7) = SGN(AVGC20.8 - AVGC50.8)) * (ABS(SGN(AVGC20.8 - AVGC50.8) <> SGN(AVGC20.9 - AVGC50.9)) * (8) + ABS(SGN(AVGC20.8 - AVGC50.8) = SGN(AVGC20.9 - AVGC50.9)) * (ABS(SGN(AVGC20.9 - AVGC50.9) <> SGN(AVGC20.10 - AVGC50.10)) * (9) + ABS(SGN(AVGC20.9 - AVGC50.9) = SGN(AVGC20.10 - AVGC50.10)) * (ABS(SGN(AVGC20.10 - AVGC50.10) <> SGN(AVGC20.11 - AVGC50.11)) * (10) + ABS(SGN(AVGC20.10 - AVGC50.10) = SGN(AVGC20.11 - AVGC50.11)) * (ABS(SGN(AVGC20.11 - AVGC50.11) <> SGN(AVGC20.12 - AVGC50.12)) * (11) + ABS(SGN(AVGC20.11 - AVGC50.11) = SGN(AVGC20.12 - AVGC50.12)) * (ABS(SGN(AVGC20.12 - AVGC50.12) <> SGN(AVGC20.13 - AVGC50.13)) * (12) + ABS(SGN(AVGC20.12 - AVGC50.12) = SGN(AVGC20.13 - AVGC50.13)) * (ABS(SGN(AVGC20.13 - AVGC50.13) <> SGN(AVGC20.14 - AVGC50.14)) * (13) + ABS(SGN(AVGC20.13 - AVGC50.13) = SGN(AVGC20.14 - AVGC50.14)) * (ABS(SGN(AVGC20.14 - AVGC50.14) <> SGN(AVGC20.15 - AVGC50.15)) * (14) + ABS(SGN(AVGC20.14 - AVGC50.14) = SGN(AVGC20.15 - AVGC50.15)) * (ABS(SGN(AVGC20.15 - AVGC50.15) <> SGN(AVGC20.16 - AVGC50.16)) * (15) + ABS(SGN(AVGC20.15 - AVGC50.15) = SGN(AVGC20.16 - AVGC50.16)) * (ABS(SGN(AVGC20.16 - AVGC50.16) <> SGN(AVGC20.17 - AVGC50.17)) * (16) + ABS(SGN(AVGC20.16 - AVGC50.16) = SGN(AVGC20.17 - AVGC50.17)) * (ABS(SGN(AVGC20.17 - AVGC50.17) <> SGN(AVGC20.18 - AVGC50.18)) * (17) + ABS(SGN(AVGC20.17 - AVGC50.17) = SGN(AVGC20.18 - AVGC50.18)) * (ABS(SGN(AVGC20.18 - AVGC50.18) <> SGN(AVGC20.19 - AVGC50.19)) * (18) + ABS(SGN(AVGC20.18 - AVGC50.18) = SGN(AVGC20.19 - AVGC50.19)) * (ABS(SGN(AVGC20.19 - AVGC50.19) <> SGN(AVGC20.20 - AVGC50.20)) * (19) + ABS(SGN(AVGC20.19 - AVGC50.19) = SGN(AVGC20.20 - AVGC50.20)) * (ABS(SGN(AVGC20.20 - AVGC50.20) <> SGN(AVGC20.21 - AVGC50.21)) * (20) + ABS(SGN(AVGC20.20 - AVGC50.20) = SGN(AVGC20.21 - AVGC50.21)) * (ABS(SGN(AVGC20.21 - AVGC50.21) <> SGN(AVGC20.22 - AVGC50.22)) * (21) + ABS(SGN(AVGC20.21 - AVGC50.21) = SGN(AVGC20.22 - AVGC50.22)) * (ABS(SGN(AVGC20.22 - AVGC50.22) <> SGN(AVGC20.23 - AVGC50.23)) * (22) + ABS(SGN(AVGC20.22 - AVGC50.22) = SGN(AVGC20.23 - AVGC50.23)) * (ABS(SGN(AVGC20.23 - AVGC50.23) <> SGN(AVGC20.24 - AVGC50.24)) * (23) + ABS(SGN(AVGC20.23 - AVGC50.23) = SGN(AVGC20.24 - AVGC50.24)) * (ABS(SGN(AVGC20.24 - AVGC50.24) <> SGN(AVGC20.25 - AVGC50.25)) * (24) + ABS(SGN(AVGC20.24 - AVGC50.24) = SGN(AVGC20.25 - AVGC50.25)) * (ABS(SGN(AVGC20.25 - AVGC50.25) <> SGN(AVGC20.26 - AVGC50.26)) * (25) + ABS(SGN(AVGC20.25 - AVGC50.25) = SGN(AVGC20.26 - AVGC50.26)) * (ABS(SGN(AVGC20.26 - AVGC50.26) <> SGN(AVGC20.27 - AVGC50.27)) * (26) + ABS(SGN(AVGC20.26 - AVGC50.26) = SGN(AVGC20.27 - AVGC50.27)) * (ABS(SGN(AVGC20.27 - AVGC50.27) <> SGN(AVGC20.28 - AVGC50.28)) * (27) + ABS(SGN(AVGC20.27 - AVGC50.27) = SGN(AVGC20.28 - AVGC50.28)) * (ABS(SGN(AVGC20.28 - AVGC50.28) <> SGN(AVGC20.29 - AVGC50.29)) * (28) + ABS(SGN(AVGC20.28 - AVGC50.28) = SGN(AVGC20.29 - AVGC50.29)) * (ABS(SGN(AVGC20.29 - AVGC50.29) <> SGN(AVGC20.30 - AVGC50.30)) * (29) + ABS(SGN(AVGC20.29 - AVGC50.29) = SGN(AVGC20.30 - AVGC50.30)) * (ABS(SGN(AVGC20.30 - AVGC50.30) <> SGN(AVGC20.31 - AVGC50.31)) * (30) + ABS(SGN(AVGC20.30 - AVGC50.30) = SGN(AVGC20.31 - AVGC50.31)) * (ABS(SGN(AVGC20.31 - AVGC50.31) <> SGN(AVGC20.32 - AVGC50.32)) * (31) + ABS(SGN(AVGC20.31 - AVGC50.31) = SGN(AVGC20.32 - AVGC50.32)) * (ABS(SGN(AVGC20.32 - AVGC50.32) <> SGN(AVGC20.33 - AVGC50.33)) * (32) + ABS(SGN(AVGC20.32 - AVGC50.32) = SGN(AVGC20.33 - AVGC50.33)) * (ABS(SGN(AVGC20.33 - AVGC50.33) <> SGN(AVGC20.34 - AVGC50.34)) * (33) + ABS(SGN(AVGC20.33 - AVGC50.33) = SGN(AVGC20.34 - AVGC50.34)) * (ABS(SGN(AVGC20.34 - AVGC50.34) <> SGN(AVGC20.35 - AVGC50.35)) * (34) + ABS(SGN(AVGC20.34 - AVGC50.34) = SGN(AVGC20.35 - AVGC50.35)) * (ABS(SGN(AVGC20.35 - AVGC50.35) <> SGN(AVGC20.36 - AVGC50.36)) * (35) + ABS(SGN(AVGC20.35 - AVGC50.35) = SGN(AVGC20.36 - AVGC50.36)) * (ABS(SGN(AVGC20.36 - AVGC50.36) <> SGN(AVGC20.37 - AVGC50.37)) * (36) + ABS(SGN(AVGC20.36 - AVGC50.36) = SGN(AVGC20.37 - AVGC50.37)) * (ABS(SGN(AVGC20.37 - AVGC50.37) <> SGN(AVGC20.38 - AVGC50.38)) * (37) + ABS(SGN(AVGC20.37 - AVGC50.37) = SGN(AVGC20.38 - AVGC50.38)) * (ABS(SGN(AVGC20.38 - AVGC50.38) <> SGN(AVGC20.39 - AVGC50.39)) * (38) + ABS(SGN(AVGC20.38 - AVGC50.38) = SGN(AVGC20.39 - AVGC50.39)) * (ABS(SGN(AVGC20.39 - AVGC50.39) <> SGN(AVGC20.40 - AVGC50.40)) * (39) + ABS(SGN(AVGC20.39 - AVGC50.39) = SGN(AVGC20.40 - AVGC50.40)) * (ABS(SGN(AVGC20.40 - AVGC50.40) <> SGN(AVGC20.41 - AVGC50.41)) * (40) + ABS(SGN(AVGC20.40 - AVGC50.40) = SGN(AVGC20.41 - AVGC50.41)) * (ABS(SGN(AVGC20.41 - AVGC50.41) <> SGN(AVGC20.42 - AVGC50.42)) * (41) + ABS(SGN(AVGC20.41 - AVGC50.41) = SGN(AVGC20.42 - AVGC50.42)) * (ABS(SGN(AVGC20.42 - AVGC50.42) <> SGN(AVGC20.43 - AVGC50.43)) * (42) + ABS(SGN(AVGC20.42 - AVGC50.42) = SGN(AVGC20.43 - AVGC50.43)) * (ABS(SGN(AVGC20.43 - AVGC50.43) <> SGN(AVGC20.44 - AVGC50.44)) * (43) + ABS(SGN(AVGC20.43 - AVGC50.43) = SGN(AVGC20.44 - AVGC50.44)) * (ABS(SGN(AVGC20.44 - AVGC50.44) <> SGN(AVGC20.45 - AVGC50.45)) * (44) + ABS(SGN(AVGC20.44 - AVGC50.44) = SGN(AVGC20.45 - AVGC50.45)) * (ABS(SGN(AVGC20.45 - AVGC50.45) <> SGN(AVGC20.46 - AVGC50.46)) * (45) + ABS(SGN(AVGC20.45 - AVGC50.45) = SGN(AVGC20.46 - AVGC50.46)) * (ABS(SGN(AVGC20.46 - AVGC50.46) <> SGN(AVGC20.47 - AVGC50.47)) * (46) + ABS(SGN(AVGC20.46 - AVGC50.46) = SGN(AVGC20.47 - AVGC50.47)) * (ABS(SGN(AVGC20.47 - AVGC50.47) <> SGN(AVGC20.48 - AVGC50.48)) * (47) + ABS(SGN(AVGC20.47 - AVGC50.47) = SGN(AVGC20.48 - AVGC50.48)) * (ABS(SGN(AVGC20.48 - AVGC50.48) <> SGN(AVGC20.49 - AVGC50.49)) * (48) + ABS(SGN(AVGC20.48 - AVGC50.48) = SGN(AVGC20.49 - AVGC50.49)) * (ABS(SGN(AVGC20.49 - AVGC50.49) <> SGN(AVGC20.50 - AVGC50.50)) * (49) + ABS(SGN(AVGC20.49 - AVGC50.49) = SGN(AVGC20.50 - AVGC50.50)) * (ABS(SGN(AVGC20.50 - AVGC50.50) <> SGN(AVGC20.51 - AVGC50.51)) * (50) + ABS(SGN(AVGC20.50 - AVGC50.50) = SGN(AVGC20.51 - AVGC50.51)) * (ABS(SGN(AVGC20.51 - AVGC50.51) <> SGN(AVGC20.52 - AVGC50.52)) * (51) + ABS(SGN(AVGC20.51 - AVGC50.51) = SGN(AVGC20.52 - AVGC50.52)) * (ABS(SGN(AVGC20.52 - AVGC50.52) <> SGN(AVGC20.53 - AVGC50.53)) * (52) + ABS(SGN(AVGC20.52 - AVGC50.52) = SGN(AVGC20.53 - AVGC50.53)) * (ABS(SGN(AVGC20.53 - AVGC50.53) <> SGN(AVGC20.54 - AVGC50.54)) * (53) + ABS(SGN(AVGC20.53 - AVGC50.53) = SGN(AVGC20.54 - AVGC50.54)) * (ABS(SGN(AVGC20.54 - AVGC50.54) <> SGN(AVGC20.55 - AVGC50.55)) * (54) + ABS(SGN(AVGC20.54 - AVGC50.54) = SGN(AVGC20.55 - AVGC50.55)) * (ABS(SGN(AVGC20.55 - AVGC50.55) <> SGN(AVGC20.56 - AVGC50.56)) * (55) + ABS(SGN(AVGC20.55 - AVGC50.55) = SGN(AVGC20.56 - AVGC50.56)) * (ABS(SGN(AVGC20.56 - AVGC50.56) <> SGN(AVGC20.57 - AVGC50.57)) * (56) + ABS(SGN(AVGC20.56 - AVGC50.56) = SGN(AVGC20.57 - AVGC50.57)) * (ABS(SGN(AVGC20.57 - AVGC50.57) <> SGN(AVGC20.58 - AVGC50.58)) * (57) + ABS(SGN(AVGC20.57 - AVGC50.57) = SGN(AVGC20.58 - AVGC50.58)) * (ABS(SGN(AVGC20.58 - AVGC50.58) <> SGN(AVGC20.59 - AVGC50.59)) * (58) + ABS(SGN(AVGC20.58 - AVGC50.58) = SGN(AVGC20.59 - AVGC50.59)) * (ABS(SGN(AVGC20.59 - AVGC50.59) <> SGN(AVGC20.60 - AVGC50.60)) * (59) + ABS(SGN(AVGC20.59 - AVGC50.59) = SGN(AVGC20.60 - AVGC50.60)) * (ABS(SGN(AVGC20.60 - AVGC50.60) <> SGN(AVGC20.61 - AVGC50.61)) * (60) + ABS(SGN(AVGC20.60 - AVGC50.60) = SGN(AVGC20.61 - AVGC50.61)) * (ABS(SGN(AVGC20.61 - AVGC50.61) <> SGN(AVGC20.62 - AVGC50.62)) * (61) + ABS(SGN(AVGC20.61 - AVGC50.61) = SGN(AVGC20.62 - AVGC50.62)) * (ABS(SGN(AVGC20.62 - AVGC50.62) <> SGN(AVGC20.63 - AVGC50.63)) * (62) + ABS(SGN(AVGC20.62 - AVGC50.62) = SGN(AVGC20.63 - AVGC50.63)) * (ABS(SGN(AVGC20.63 - AVGC50.63) <> SGN(AVGC20.64 - AVGC50.64)) * (63) + ABS(SGN(AVGC20.63 - AVGC50.63) = SGN(AVGC20.64 - AVGC50.64)) * (ABS(SGN(AVGC20.64 - AVGC50.64) <> SGN(AVGC20.65 - AVGC50.65)) * (64) + ABS(SGN(AVGC20.64 - AVGC50.64) = SGN(AVGC20.65 - AVGC50.65)) * (ABS(SGN(AVGC20.65 - AVGC50.65) <> SGN(AVGC20.66 - AVGC50.66)) * (65) + ABS(SGN(AVGC20.65 - AVGC50.65) = SGN(AVGC20.66 - AVGC50.66)) * (ABS(SGN(AVGC20.66 - AVGC50.66) <> SGN(AVGC20.67 - AVGC50.67)) * (66) + ABS(SGN(AVGC20.66 - AVGC50.66) = SGN(AVGC20.67 - AVGC50.67)) * (ABS(SGN(AVGC20.67 - AVGC50.67) <> SGN(AVGC20.68 - AVGC50.68)) * (67) + ABS(SGN(AVGC20.67 - AVGC50.67) = SGN(AVGC20.68 - AVGC50.68)) * (ABS(SGN(AVGC20.68 - AVGC50.68) <> SGN(AVGC20.69 - AVGC50.69)) * (68) + ABS(SGN(AVGC20.68 - AVGC50.68) = SGN(AVGC20.69 - AVGC50.69)) * (ABS(SGN(AVGC20.69 - AVGC50.69) <> SGN(AVGC20.70 - AVGC50.70)) * (69) + ABS(SGN(AVGC20.69 - AVGC50.69) = SGN(AVGC20.70 - AVGC50.70)) * (ABS(SGN(AVGC20.70 - AVGC50.70) <> SGN(AVGC20.71 - AVGC50.71)) * (70) + ABS(SGN(AVGC20.70 - AVGC50.70) = SGN(AVGC20.71 - AVGC50.71)) * (ABS(SGN(AVGC20.71 - AVGC50.71) <> SGN(AVGC20.72 - AVGC50.72)) * (71) + ABS(SGN(AVGC20.71 - AVGC50.71) = SGN(AVGC20.72 - AVGC50.72)) * (ABS(SGN(AVGC20.72 - AVGC50.72) <> SGN(AVGC20.73 - AVGC50.73)) * (72) + ABS(SGN(AVGC20.72 - AVGC50.72) = SGN(AVGC20.73 - AVGC50.73)) * (ABS(SGN(AVGC20.73 - AVGC50.73) <> SGN(AVGC20.74 - AVGC50.74)) * (73) + ABS(SGN(AVGC20.73 - AVGC50.73) = SGN(AVGC20.74 - AVGC50.74)) * (ABS(SGN(AVGC20.74 - AVGC50.74) <> SGN(AVGC20.75 - AVGC50.75)) * (74) + ABS(SGN(AVGC20.74 - AVGC50.74) = SGN(AVGC20.75 - AVGC50.75)) * (ABS(SGN(AVGC20.75 - AVGC50.75) <> SGN(AVGC20.76 - AVGC50.76)) * (75) + ABS(SGN(AVGC20.75 - AVGC50.75) = SGN(AVGC20.76 - AVGC50.76)) * (ABS(SGN(AVGC20.76 - AVGC50.76) <> SGN(AVGC20.77 - AVGC50.77)) * (76) + ABS(SGN(AVGC20.76 - AVGC50.76) = SGN(AVGC20.77 - AVGC50.77)) * (ABS(SGN(AVGC20.77 - AVGC50.77) <> SGN(AVGC20.78 - AVGC50.78)) * (77) + ABS(SGN(AVGC20.77 - AVGC50.77) = SGN(AVGC20.78 - AVGC50.78)) * (ABS(SGN(AVGC20.78 - AVGC50.78) <> SGN(AVGC20.79 - AVGC50.79)) * (78) + ABS(SGN(AVGC20.78 - AVGC50.78) = SGN(AVGC20.79 - AVGC50.79)) * (ABS(SGN(AVGC20.79 - AVGC50.79) <> SGN(AVGC20.80 - AVGC50.80)) * (79) + ABS(SGN(AVGC20.79 - AVGC50.79) = SGN(AVGC20.80 - AVGC50.80)) * (ABS(SGN(AVGC20.80 - AVGC50.80) <> SGN(AVGC20.81 - AVGC50.81)) * (80) + ABS(SGN(AVGC20.80 - AVGC50.80) = SGN(AVGC20.81 - AVGC50.81)) * (ABS(SGN(AVGC20.81 - AVGC50.81) <> SGN(AVGC20.82 - AVGC50.82)) * (81) + ABS(SGN(AVGC20.81 - AVGC50.81) = SGN(AVGC20.82 - AVGC50.82)) * (ABS(SGN(AVGC20.82 - AVGC50.82) <> SGN(AVGC20.83 - AVGC50.83)) * (82) + ABS(SGN(AVGC20.82 - AVGC50.82) = SGN(AVGC20.83 - AVGC50.83)) * (ABS(SGN(AVGC20.83 - AVGC50.83) <> SGN(AVGC20.84 - AVGC50.84)) * (83) + ABS(SGN(AVGC20.83 - AVGC50.83) = SGN(AVGC20.84 - AVGC50.84)) * (ABS(SGN(AVGC20.84 - AVGC50.84) <> SGN(AVGC20.85 - AVGC50.85)) * (84) + ABS(SGN(AVGC20.84 - AVGC50.84) = SGN(AVGC20.85 - AVGC50.85)) * (ABS(SGN(AVGC20.85 - AVGC50.85) <> SGN(AVGC20.86 - AVGC50.86)) * (85) + ABS(SGN(AVGC20.85 - AVGC50.85) = SGN(AVGC20.86 - AVGC50.86)) * (ABS(SGN(AVGC20.86 - AVGC50.86) <> SGN(AVGC20.87 - AVGC50.87)) * (86) + ABS(SGN(AVGC20.86 - AVGC50.86) = SGN(AVGC20.87 - AVGC50.87)) * (ABS(SGN(AVGC20.87 - AVGC50.87) <> SGN(AVGC20.88 - AVGC50.88)) * (87) + ABS(SGN(AVGC20.87 - AVGC50.87) = SGN(AVGC20.88 - AVGC50.88)) * (ABS(SGN(AVGC20.88 - AVGC50.88) <> SGN(AVGC20.89 - AVGC50.89)) * (88) + ABS(SGN(AVGC20.88 - AVGC50.88) = SGN(AVGC20.89 - AVGC50.89)) * (ABS(SGN(AVGC20.89 - AVGC50.89) <> SGN(AVGC20.90 - AVGC50.90)) * (89) + ABS(SGN(AVGC20.89 - AVGC50.89) = SGN(AVGC20.90 - AVGC50.90)) * (ABS(SGN(AVGC20.90 - AVGC50.90) <> SGN(AVGC20.91 - AVGC50.91)) * (90) + ABS(SGN(AVGC20.90 - AVGC50.90) = SGN(AVGC20.91 - AVGC50.91)) * (ABS(SGN(AVGC20.91 - AVGC50.91) <> SGN(AVGC20.92 - AVGC50.92)) * (91) + ABS(SGN(AVGC20.91 - AVGC50.91) = SGN(AVGC20.92 - AVGC50.92)) * (ABS(SGN(AVGC20.92 - AVGC50.92) <> SGN(AVGC20.93 - AVGC50.93)) * (92) + ABS(SGN(AVGC20.92 - AVGC50.92) = SGN(AVGC20.93 - AVGC50.93)) * (ABS(SGN(AVGC20.93 - AVGC50.93) <> SGN(AVGC20.94 - AVGC50.94)) * (93) + ABS(SGN(AVGC20.93 - AVGC50.93) = SGN(AVGC20.94 - AVGC50.94)) * (ABS(SGN(AVGC20.94 - AVGC50.94) <> SGN(AVGC20.95 - AVGC50.95)) * (94) + ABS(SGN(AVGC20.94 - AVGC50.94) = SGN(AVGC20.95 - AVGC50.95)) * (ABS(SGN(AVGC20.95 - AVGC50.95) <> SGN(AVGC20.96 - AVGC50.96)) * (95) + ABS(SGN(AVGC20.95 - AVGC50.95) = SGN(AVGC20.96 - AVGC50.96)) * (ABS(SGN(AVGC20.96 - AVGC50.96) <> SGN(AVGC20.97 - AVGC50.97)) * (96) + ABS(SGN(AVGC20.96 - AVGC50.96) = SGN(AVGC20.97 - AVGC50.97)) * (ABS(SGN(AVGC20.97 - AVGC50.97) <> SGN(AVGC20.98 - AVGC50.98)) * (97) + ABS(SGN(AVGC20.97 - AVGC50.97) = SGN(AVGC20.98 - AVGC50.98)) * (ABS(SGN(AVGC20.98 - AVGC50.98) <> SGN(AVGC20.99 - AVGC50.99)) * (98) + ABS(SGN(AVGC20.98 - AVGC50.98) = SGN(AVGC20.99 - AVGC50.99)) * (ABS(SGN(AVGC20.99 - AVGC50.99) <> SGN(AVGC20.100 - AVGC50.100)) * (99) + ABS(SGN(AVGC20.99 - AVGC50.99) = SGN(AVGC20.100 - AVGC50.100)) * (ABS(SGN(AVGC20.100 - AVGC50.100) <> SGN(AVGC20.101 - AVGC50.101)) * (100) + ABS(SGN(AVGC20.100 - AVGC50.100) = SGN(AVGC20.101 - AVGC50.101)) * (ABS(SGN(AVGC20.101 - AVGC50.101) <> SGN(AVGC20.102 - AVGC50.102)) * (101) + ABS(SGN(AVGC20.101 - AVGC50.101) = SGN(AVGC20.102 - AVGC50.102)) * (ABS(SGN(AVGC20.102 - AVGC50.102) <> SGN(AVGC20.103 - AVGC50.103)) * (102) + ABS(SGN(AVGC20.102 - AVGC50.102) = SGN(AVGC20.103 - AVGC50.103)) * (ABS(SGN(AVGC20.103 - AVGC50.103) <> SGN(AVGC20.104 - AVGC50.104)) * (103) + ABS(SGN(AVGC20.103 - AVGC50.103) = SGN(AVGC20.104 - AVGC50.104)) * (ABS(SGN(AVGC20.104 - AVGC50.104) <> SGN(AVGC20.105 - AVGC50.105)) * (104) + ABS(SGN(AVGC20.104 - AVGC50.104) = SGN(AVGC20.105 - AVGC50.105)) * (ABS(SGN(AVGC20.105 - AVGC50.105) <> SGN(AVGC20.106 - AVGC50.106)) * (105) + ABS(SGN(AVGC20.105 - AVGC50.105) = SGN(AVGC20.106 - AVGC50.106)) * (ABS(SGN(AVGC20.106 - AVGC50.106) <> SGN(AVGC20.107 - AVGC50.107)) * (106) + ABS(SGN(AVGC20.106 - AVGC50.106) = SGN(AVGC20.107 - AVGC50.107)) * (ABS(SGN(AVGC20.107 - AVGC50.107) <> SGN(AVGC20.108 - AVGC50.108)) * (107) + ABS(SGN(AVGC20.107 - AVGC50.107) = SGN(AVGC20.108 - AVGC50.108)) * (ABS(SGN(AVGC20.108 - AVGC50.108) <> SGN(AVGC20.109 - AVGC50.109)) * (108) + ABS(SGN(AVGC20.108 - AVGC50.108) = SGN(AVGC20.109 - AVGC50.109)) * (ABS(SGN(AVGC20.109 - AVGC50.109) <> SGN(AVGC20.110 - AVGC50.110)) * (109) + ABS(SGN(AVGC20.109 - AVGC50.109) = SGN(AVGC20.110 - AVGC50.110)) * (ABS(SGN(AVGC20.110 - AVGC50.110) <> SGN(AVGC20.111 - AVGC50.111)) * (110) + ABS(SGN(AVGC20.110 - AVGC50.110) = SGN(AVGC20.111 - AVGC50.111)) * (ABS(SGN(AVGC20.111 - AVGC50.111) <> SGN(AVGC20.112 - AVGC50.112)) * (111) + ABS(SGN(AVGC20.111 - AVGC50.111) = SGN(AVGC20.112 - AVGC50.112)) * (ABS(SGN(AVGC20.112 - AVGC50.112) <> SGN(AVGC20.113 - AVGC50.113)) * (112) + ABS(SGN(AVGC20.112 - AVGC50.112) = SGN(AVGC20.113 - AVGC50.113)) * (ABS(SGN(AVGC20.113 - AVGC50.113) <> SGN(AVGC20.114 - AVGC50.114)) * (113) + ABS(SGN(AVGC20.113 - AVGC50.113) = SGN(AVGC20.114 - AVGC50.114)) * (ABS(SGN(AVGC20.114 - AVGC50.114) <> SGN(AVGC20.115 - AVGC50.115)) * (114) + ABS(SGN(AVGC20.114 - AVGC50.114) = SGN(AVGC20.115 - AVGC50.115)) * (ABS(SGN(AVGC20.115 - AVGC50.115) <> SGN(AVGC20.116 - AVGC50.116)) * (115) + ABS(SGN(AVGC20.115 - AVGC50.115) = SGN(AVGC20.116 - AVGC50.116)) * (ABS(SGN(AVGC20.116 - AVGC50.116) <> SGN(AVGC20.117 - AVGC50.117)) * (116) + ABS(SGN(AVGC20.116 - AVGC50.116) = SGN(AVGC20.117 - AVGC50.117)) * (ABS(SGN(AVGC20.117 - AVGC50.117) <> SGN(AVGC20.118 - AVGC50.118)) * (117) + ABS(SGN(AVGC20.117 - AVGC50.117) = SGN(AVGC20.118 - AVGC50.118)) * (ABS(SGN(AVGC20.118 - AVGC50.118) <> SGN(AVGC20.119 - AVGC50.119)) * (118) + ABS(SGN(AVGC20.118 - AVGC50.118) = SGN(AVGC20.119 - AVGC50.119)) * (ABS(SGN(AVGC20.119 - AVGC50.119) <> SGN(AVGC20.120 - AVGC50.120)) * (119) + ABS(SGN(AVGC20.119 - AVGC50.119) = SGN(AVGC20.120 - AVGC50.120)) * (ABS(SGN(AVGC20.120 - AVGC50.120) <> SGN(AVGC20.121 - AVGC50.121)) * (120) + ABS(SGN(AVGC20.120 - AVGC50.120) = SGN(AVGC20.121 - AVGC50.121)) * (ABS(SGN(AVGC20.121 - AVGC50.121) <> SGN(AVGC20.122 - AVGC50.122)) * (121) + ABS(SGN(AVGC20.121 - AVGC50.121) = SGN(AVGC20.122 - AVGC50.122)) * (ABS(SGN(AVGC20.122 - AVGC50.122) <> SGN(AVGC20.123 - AVGC50.123)) * (122) + ABS(SGN(AVGC20.122 - AVGC50.122) = SGN(AVGC20.123 - AVGC50.123)) * (ABS(SGN(AVGC20.123 - AVGC50.123) <> SGN(AVGC20.124 - AVGC50.124)) * (123) + ABS(SGN(AVGC20.123 - AVGC50.123) = SGN(AVGC20.124 - AVGC50.124)) * (ABS(SGN(AVGC20.124 - AVGC50.124) <> SGN(AVGC20.125 - AVGC50.125)) * (124) + ABS(SGN(AVGC20.124 - AVGC50.124) = SGN(AVGC20.125 - AVGC50.125)) * (ABS(SGN(AVGC20.125 - AVGC50.125) <> SGN(AVGC20.126 - AVGC50.126)) * (125) + ABS(SGN(AVGC20.125 - AVGC50.125) = SGN(AVGC20.126 - AVGC50.126)) * (ABS(SGN(AVGC20.126 - AVGC50.126) <> SGN(AVGC20.127 - AVGC50.127)) * (126) + ABS(SGN(AVGC20.126 - AVGC50.126) = SGN(AVGC20.127 - AVGC50.127)) * (ABS(SGN(AVGC20.127 - AVGC50.127) <> SGN(AVGC20.128 - AVGC50.128)) * (127) + ABS(SGN(AVGC20.127 - AVGC50.127) = SGN(AVGC20.128 - AVGC50.128)) * (ABS(SGN(AVGC20.128 - AVGC50.128) <> SGN(AVGC20.129 - AVGC50.129)) * (128) + ABS(SGN(AVGC20.128 - AVGC50.128) = SGN(AVGC20.129 - AVGC50.129)) * (ABS(SGN(AVGC20.129 - AVGC50.129) <> SGN(AVGC20.130 - AVGC50.130)) * (129) + ABS(SGN(AVGC20.129 - AVGC50.129) = SGN(AVGC20.130 - AVGC50.130)) * (ABS(SGN(AVGC20.130 - AVGC50.130) <> SGN(AVGC20.131 - AVGC50.131)) * (130) + ABS(SGN(AVGC20.130 - AVGC50.130) = SGN(AVGC20.131 - AVGC50.131)) * (ABS(SGN(AVGC20.131 - AVGC50.131) <> SGN(AVGC20.132 - AVGC50.132)) * (131) + ABS(SGN(AVGC20.131 - AVGC50.131) = SGN(AVGC20.132 - AVGC50.132)) * (ABS(SGN(AVGC20.132 - AVGC50.132) <> SGN(AVGC20.133 - AVGC50.133)) * (132) + ABS(SGN(AVGC20.132 - AVGC50.132) = SGN(AVGC20.133 - AVGC50.133)) * (ABS(SGN(AVGC20.133 - AVGC50.133) <> SGN(AVGC20.134 - AVGC50.134)) * (133) + ABS(SGN(AVGC20.133 - AVGC50.133) = SGN(AVGC20.134 - AVGC50.134)) * (ABS(SGN(AVGC20.134 - AVGC50.134) <> SGN(AVGC20.135 - AVGC50.135)) * (134) + ABS(SGN(AVGC20.134 - AVGC50.134) = SGN(AVGC20.135 - AVGC50.135)) * (ABS(SGN(AVGC20.135 - AVGC50.135) <> SGN(AVGC20.136 - AVGC50.136)) * (135) + ABS(SGN(AVGC20.135 - AVGC50.135) = SGN(AVGC20.136 - AVGC50.136)) * (ABS(SGN(AVGC20.136 - AVGC50.136) <> SGN(AVGC20.137 - AVGC50.137)) * (136) + ABS(SGN(AVGC20.136 - AVGC50.136) = SGN(AVGC20.137 - AVGC50.137)) * (ABS(SGN(AVGC20.137 - AVGC50.137) <> SGN(AVGC20.138 - AVGC50.138)) * (137) + ABS(SGN(AVGC20.137 - AVGC50.137) = SGN(AVGC20.138 - AVGC50.138)) * (ABS(SGN(AVGC20.138 - AVGC50.138) <> SGN(AVGC20.139 - AVGC50.139)) * (138) + ABS(SGN(AVGC20.138 - AVGC50.138) = SGN(AVGC20.139 - AVGC50.139)) * (ABS(SGN(AVGC20.139 - AVGC50.139) <> SGN(AVGC20.140 - AVGC50.140)) * (139) + ABS(SGN(AVGC20.139 - AVGC50.139) = SGN(AVGC20.140 - AVGC50.140)) * (ABS(SGN(AVGC20.140 - AVGC50.140) <> SGN(AVGC20.141 - AVGC50.141)) * (140) + ABS(SGN(AVGC20.140 - AVGC50.140) = SGN(AVGC20.141 - AVGC50.141)) * (ABS(SGN(AVGC20.141 - AVGC50.141) <> SGN(AVGC20.142 - AVGC50.142)) * (141) + ABS(SGN(AVGC20.141 - AVGC50.141) = SGN(AVGC20.142 - AVGC50.142)) * (ABS(SGN(AVGC20.142 - AVGC50.142) <> SGN(AVGC20.143 - AVGC50.143)) * (142) + ABS(SGN(AVGC20.142 - AVGC50.142) = SGN(AVGC20.143 - AVGC50.143)) * (ABS(SGN(AVGC20.143 - AVGC50.143) <> SGN(AVGC20.144 - AVGC50.144)) * (143) + ABS(SGN(AVGC20.143 - AVGC50.143) = SGN(AVGC20.144 - AVGC50.144)) * (ABS(SGN(AVGC20.144 - AVGC50.144) <> SGN(AVGC20.145 - AVGC50.145)) * (144) + ABS(SGN(AVGC20.144 - AVGC50.144) = SGN(AVGC20.145 - AVGC50.145)) * (ABS(SGN(AVGC20.145 - AVGC50.145) <> SGN(AVGC20.146 - AVGC50.146)) * (145) + ABS(SGN(AVGC20.145 - AVGC50.145) = SGN(AVGC20.146 - AVGC50.146)) * (ABS(SGN(AVGC20.146 - AVGC50.146) <> SGN(AVGC20.147 - AVGC50.147)) * (146) + ABS(SGN(AVGC20.146 - AVGC50.146) = SGN(AVGC20.147 - AVGC50.147)) * (ABS(SGN(AVGC20.147 - AVGC50.147) <> SGN(AVGC20.148 - AVGC50.148)) * (147) + ABS(SGN(AVGC20.147 - AVGC50.147) = SGN(AVGC20.148 - AVGC50.148)) * (ABS(SGN(AVGC20.148 - AVGC50.148) <> SGN(AVGC20.149 - AVGC50.149)) * (148) + ABS(SGN(AVGC20.148 - AVGC50.148) = SGN(AVGC20.149 - AVGC50.149)) * (ABS(SGN(AVGC20.149 - AVGC50.149) <> SGN(AVGC20.150 - AVGC50.150)) * (149) + ABS(SGN(AVGC20.149 - AVGC50.149) = SGN(AVGC20.150 - AVGC50.150)) * (ABS(SGN(AVGC20.150 - AVGC50.150) <> SGN(AVGC20.151 - AVGC50.151)) * (150) + ABS(SGN(AVGC20.150 - AVGC50.150) = SGN(AVGC20.151 - AVGC50.151)) * (ABS(SGN(AVGC20.151 - AVGC50.151) <> SGN(AVGC20.152 - AVGC50.152)) * (151) + ABS(SGN(AVGC20.151 - AVGC50.151) = SGN(AVGC20.152 - AVGC50.152)) * (ABS(SGN(AVGC20.152 - AVGC50.152) <> SGN(AVGC20.153 - AVGC50.153)) * (152) + ABS(SGN(AVGC20.152 - AVGC50.152) = SGN(AVGC20.153 - AVGC50.153)) * (ABS(SGN(AVGC20.153 - AVGC50.153) <> SGN(AVGC20.154 - AVGC50.154)) * (153) + ABS(SGN(AVGC20.153 - AVGC50.153) = SGN(AVGC20.154 - AVGC50.154)) * (ABS(SGN(AVGC20.154 - AVGC50.154) <> SGN(AVGC20.155 - AVGC50.155)) * (154) + ABS(SGN(AVGC20.154 - AVGC50.154) = SGN(AVGC20.155 - AVGC50.155)) * (ABS(SGN(AVGC20.155 - AVGC50.155) <> SGN(AVGC20.156 - AVGC50.156)) * (155) + ABS(SGN(AVGC20.155 - AVGC50.155) = SGN(AVGC20.156 - AVGC50.156)) * (ABS(SGN(AVGC20.156 - AVGC50.156) <> SGN(AVGC20.157 - AVGC50.157)) * (156) + ABS(SGN(AVGC20.156 - AVGC50.156) = SGN(AVGC20.157 - AVGC50.157)) * (ABS(SGN(AVGC20.157 - AVGC50.157) <> SGN(AVGC20.158 - AVGC50.158)) * (157) + ABS(SGN(AVGC20.157 - AVGC50.157) = SGN(AVGC20.158 - AVGC50.158)) * (ABS(SGN(AVGC20.158 - AVGC50.158) <> SGN(AVGC20.159 - AVGC50.159)) * (158) + ABS(SGN(AVGC20.158 - AVGC50.158) = SGN(AVGC20.159 - AVGC50.159)) * (ABS(SGN(AVGC20.159 - AVGC50.159) <> SGN(AVGC20.160 - AVGC50.160)) * (159) + ABS(SGN(AVGC20.159 - AVGC50.159) = SGN(AVGC20.160 - AVGC50.160)) * (ABS(SGN(AVGC20.160 - AVGC50.160) <> SGN(AVGC20.161 - AVGC50.161)) * (160) + ABS(SGN(AVGC20.160 - AVGC50.160) = SGN(AVGC20.161 - AVGC50.161)) * (ABS(SGN(AVGC20.161 - AVGC50.161) <> SGN(AVGC20.162 - AVGC50.162)) * (161) + ABS(SGN(AVGC20.161 - AVGC50.161) = SGN(AVGC20.162 - AVGC50.162)) * (ABS(SGN(AVGC20.162 - AVGC50.162) <> SGN(AVGC20.163 - AVGC50.163)) * (162) + ABS(SGN(AVGC20.162 - AVGC50.162) = SGN(AVGC20.163 - AVGC50.163)) * (ABS(SGN(AVGC20.163 - AVGC50.163) <> SGN(AVGC20.164 - AVGC50.164)) * (163) + ABS(SGN(AVGC20.163 - AVGC50.163) = SGN(AVGC20.164 - AVGC50.164)) * (ABS(SGN(AVGC20.164 - AVGC50.164) <> SGN(AVGC20.165 - AVGC50.165)) * (164) + ABS(SGN(AVGC20.164 - AVGC50.164) = SGN(AVGC20.165 - AVGC50.165)) * (ABS(SGN(AVGC20.165 - AVGC50.165) <> SGN(AVGC20.166 - AVGC50.166)) * (165) + ABS(SGN(AVGC20.165 - AVGC50.165) = SGN(AVGC20.166 - AVGC50.166)) * (ABS(SGN(AVGC20.166 - AVGC50.166) <> SGN(AVGC20.167 - AVGC50.167)) * (166) + ABS(SGN(AVGC20.166 - AVGC50.166) = SGN(AVGC20.167 - AVGC50.167)) * (ABS(SGN(AVGC20.167 - AVGC50.167) <> SGN(AVGC20.168 - AVGC50.168)) * (167) + ABS(SGN(AVGC20.167 - AVGC50.167) = SGN(AVGC20.168 - AVGC50.168)) * ( - 1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
Days Since Last Peak (or other day-counting needs)
Handy PCF example formulas to help you learn the syntax of PCFs!
PCF Formula Descriptions
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
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.