Registered User Joined: 7/29/2010 Posts: 417
|
Hi Bruce,
Could you please expand this 21 Ema rising bars PCF that I adapted from your work out to 60 bars.
The current 30 bars often tops out.
Thank you.
Don
ABS(XAVGC21 > XAVGC21.1) * (ABS(XAVGC21.1 <= XAVGC21.2) + ABS(XAVGC21.1 > XAVGC21.2) * (ABS(XAVGC21.2 <= XAVGC21.3) * 2 + ABS(XAVGC21.2 > XAVGC21.3) * (ABS(XAVGC21.3 <= XAVGC21.4) * 3 + ABS(XAVGC21.3 > XAVGC21.4) * (ABS(XAVGC21.4 <= XAVGC21.5) * 4 + ABS(XAVGC21.4 > XAVGC21.5) * (ABS(XAVGC21.5 <= XAVGC21.6) * 5 + ABS(XAVGC21.5 > XAVGC21.6) * (ABS(XAVGC21.6 <= XAVGC21.7) * 6 + ABS(XAVGC21.6 > XAVGC21.7) * (ABS(XAVGC21.7 <= XAVGC21.8) * 7 + ABS(XAVGC21.7 > XAVGC21.8) * (ABS(XAVGC21.8 <= XAVGC21.9) * 8 + ABS(XAVGC21.8 > XAVGC21.9) * (ABS(XAVGC21.9 <= XAVGC21.10) * 9 + ABS(XAVGC21.9 > XAVGC21.10) * (ABS(XAVGC21.10 <= XAVGC21.11) * 10 + ABS(XAVGC21.10 > XAVGC21.11) * (ABS(XAVGC21.11 <= XAVGC21.12) * 11 + ABS(XAVGC21.11 > XAVGC21.12) * (ABS(XAVGC21.12 <= XAVGC21.13) * 12 + ABS(XAVGC21.12 > XAVGC21.13) * (ABS(XAVGC21.13 <= XAVGC21.14) * 13 + ABS(XAVGC21.13 > XAVGC21.14) * (ABS(XAVGC21.14 <= XAVGC21.15) * 14 + ABS(XAVGC21.14 > XAVGC21.15) * (ABS(XAVGC21.15 <= XAVGC21.16) * 15 + ABS(XAVGC21.15 > XAVGC21.16) * (ABS(XAVGC21.16 <= XAVGC21.17) * 16 + ABS(XAVGC21.16 > XAVGC21.17) * (ABS(XAVGC21.17 <= XAVGC21.18) * 17 + ABS(XAVGC21.17 > XAVGC21.18) * (ABS(XAVGC21.18 <= XAVGC21.19) * 18 + ABS(XAVGC21.18 > XAVGC21.19) * (ABS(XAVGC21.19 <= XAVGC21.20) * 19 + ABS(XAVGC21.19 > XAVGC21.20) * (ABS(XAVGC21.20 <= XAVGC21.21) * 20 + ABS(XAVGC21.20 > XAVGC21.21) * (ABS(XAVGC21.21 <= XAVGC21.22) * 21 + ABS(XAVGC21.21 > XAVGC21.22) * (ABS(XAVGC21.22 <= XAVGC21.23) * 22 + ABS(XAVGC21.22 > XAVGC21.23) * (ABS(XAVGC21.23 <= XAVGC21.24) * 23 + ABS(XAVGC21.23 > XAVGC21.24) * (ABS(XAVGC21.24 <= XAVGC21.25) * 24 + ABS(XAVGC21.24 > XAVGC21.25) * (ABS(XAVGC21.25 <= XAVGC21.26) * 25 + ABS(XAVGC21.25 > XAVGC21.26) * (ABS(XAVGC21.26 <= XAVGC21.27) * 26 + ABS(XAVGC21.26 > XAVGC21.27) * (ABS(XAVGC21.27 <= XAVGC21.28) * 27 + ABS(XAVGC21.27 > XAVGC21.28) * (ABS(XAVGC21.28 <= XAVGC21.29) * 28 + ABS(XAVGC21.28 > XAVGC21.29) * (ABS(XAVGC21.29 <= XAVGC21.30) * 29 + ABS(XAVGC21.29 > XAVGC21.30) * 30)))))))))))))))))))))))))))))
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Just a note that there will be a much shorter way to write this soon. The following syntax is preliminary and could change before the production release.
TrueInRow(XAVGC21 > XAVGC21.1,60)
The current way to write this out to 60 bars would be the following.
ABS(XAVGC21 > XAVGC21.1) * (ABS(XAVGC21.1 <= XAVGC21.2) + ABS(XAVGC21.1 > XAVGC21.2) * (ABS(XAVGC21.2 <= XAVGC21.3) * 2 + ABS(XAVGC21.2 > XAVGC21.3) * (ABS(XAVGC21.3 <= XAVGC21.4) * 3 + ABS(XAVGC21.3 > XAVGC21.4) * (ABS(XAVGC21.4 <= XAVGC21.5) * 4 + ABS(XAVGC21.4 > XAVGC21.5) * (ABS(XAVGC21.5 <= XAVGC21.6) * 5 + ABS(XAVGC21.5 > XAVGC21.6) * (ABS(XAVGC21.6 <= XAVGC21.7) * 6 + ABS(XAVGC21.6 > XAVGC21.7) * (ABS(XAVGC21.7 <= XAVGC21.8) * 7 + ABS(XAVGC21.7 > XAVGC21.8) * (ABS(XAVGC21.8 <= XAVGC21.9) * 8 + ABS(XAVGC21.8 > XAVGC21.9) * (ABS(XAVGC21.9 <= XAVGC21.10) * 9 + ABS(XAVGC21.9 > XAVGC21.10) * (ABS(XAVGC21.10 <= XAVGC21.11) * 10 + ABS(XAVGC21.10 > XAVGC21.11) * (ABS(XAVGC21.11 <= XAVGC21.12) * 11 + ABS(XAVGC21.11 > XAVGC21.12) * (ABS(XAVGC21.12 <= XAVGC21.13) * 12 + ABS(XAVGC21.12 > XAVGC21.13) * (ABS(XAVGC21.13 <= XAVGC21.14) * 13 + ABS(XAVGC21.13 > XAVGC21.14) * (ABS(XAVGC21.14 <= XAVGC21.15) * 14 + ABS(XAVGC21.14 > XAVGC21.15) * (ABS(XAVGC21.15 <= XAVGC21.16) * 15 + ABS(XAVGC21.15 > XAVGC21.16) * (ABS(XAVGC21.16 <= XAVGC21.17) * 16 + ABS(XAVGC21.16 > XAVGC21.17) * (ABS(XAVGC21.17 <= XAVGC21.18) * 17 + ABS(XAVGC21.17 > XAVGC21.18) * (ABS(XAVGC21.18 <= XAVGC21.19) * 18 + ABS(XAVGC21.18 > XAVGC21.19) * (ABS(XAVGC21.19 <= XAVGC21.20) * 19 + ABS(XAVGC21.19 > XAVGC21.20) * (ABS(XAVGC21.20 <= XAVGC21.21) * 20 + ABS(XAVGC21.20 > XAVGC21.21) * (ABS(XAVGC21.21 <= XAVGC21.22) * 21 + ABS(XAVGC21.21 > XAVGC21.22) * (ABS(XAVGC21.22 <= XAVGC21.23) * 22 + ABS(XAVGC21.22 > XAVGC21.23) * (ABS(XAVGC21.23 <= XAVGC21.24) * 23 + ABS(XAVGC21.23 > XAVGC21.24) * (ABS(XAVGC21.24 <= XAVGC21.25) * 24 + ABS(XAVGC21.24 > XAVGC21.25) * (ABS(XAVGC21.25 <= XAVGC21.26) * 25 + ABS(XAVGC21.25 > XAVGC21.26) * (ABS(XAVGC21.26 <= XAVGC21.27) * 26 + ABS(XAVGC21.26 > XAVGC21.27) * (ABS(XAVGC21.27 <= XAVGC21.28) * 27 + ABS(XAVGC21.27 > XAVGC21.28) * (ABS(XAVGC21.28 <= XAVGC21.29) * 28 + ABS(XAVGC21.28 > XAVGC21.29) * (ABS(XAVGC21.29 <= XAVGC21.30) * 29 + ABS(XAVGC21.29 > XAVGC21.30) * (ABS(XAVGC21.30 <= XAVGC21.31) * 30 + ABS(XAVGC21.30 > XAVGC21.31) * (ABS(XAVGC21.31 <= XAVGC21.32) * 31 + ABS(XAVGC21.31 > XAVGC21.32) * (ABS(XAVGC21.32 <= XAVGC21.33) * 32 + ABS(XAVGC21.32 > XAVGC21.33) * (ABS(XAVGC21.33 <= XAVGC21.34) * 33 + ABS(XAVGC21.33 > XAVGC21.34) * (ABS(XAVGC21.34 <= XAVGC21.35) * 34 + ABS(XAVGC21.34 > XAVGC21.35) * (ABS(XAVGC21.35 <= XAVGC21.36) * 35 + ABS(XAVGC21.35 > XAVGC21.36) * (ABS(XAVGC21.36 <= XAVGC21.37) * 36 + ABS(XAVGC21.36 > XAVGC21.37) * (ABS(XAVGC21.37 <= XAVGC21.38) * 37 + ABS(XAVGC21.37 > XAVGC21.38) * (ABS(XAVGC21.38 <= XAVGC21.39) * 38 + ABS(XAVGC21.38 > XAVGC21.39) * (ABS(XAVGC21.39 <= XAVGC21.40) * 39 + ABS(XAVGC21.39 > XAVGC21.40) * (ABS(XAVGC21.40 <= XAVGC21.41) * 40 + ABS(XAVGC21.40 > XAVGC21.41) * (ABS(XAVGC21.41 <= XAVGC21.42) * 41 + ABS(XAVGC21.41 > XAVGC21.42) * (ABS(XAVGC21.42 <= XAVGC21.43) * 42 + ABS(XAVGC21.42 > XAVGC21.43) * (ABS(XAVGC21.43 <= XAVGC21.44) * 43 + ABS(XAVGC21.43 > XAVGC21.44) * (ABS(XAVGC21.44 <= XAVGC21.45) * 44 + ABS(XAVGC21.44 > XAVGC21.45) * (ABS(XAVGC21.45 <= XAVGC21.46) * 45 + ABS(XAVGC21.45 > XAVGC21.46) * (ABS(XAVGC21.46 <= XAVGC21.47) * 46 + ABS(XAVGC21.46 > XAVGC21.47) * (ABS(XAVGC21.47 <= XAVGC21.48) * 47 + ABS(XAVGC21.47 > XAVGC21.48) * (ABS(XAVGC21.48 <= XAVGC21.49) * 48 + ABS(XAVGC21.48 > XAVGC21.49) * (ABS(XAVGC21.49 <= XAVGC21.50) * 49 + ABS(XAVGC21.49 > XAVGC21.50) * (ABS(XAVGC21.50 <= XAVGC21.51) * 50 + ABS(XAVGC21.50 > XAVGC21.51) * (ABS(XAVGC21.51 <= XAVGC21.52) * 51 + ABS(XAVGC21.51 > XAVGC21.52) * (ABS(XAVGC21.52 <= XAVGC21.53) * 52 + ABS(XAVGC21.52 > XAVGC21.53) * (ABS(XAVGC21.53 <= XAVGC21.54) * 53 + ABS(XAVGC21.53 > XAVGC21.54) * (ABS(XAVGC21.54 <= XAVGC21.55) * 54 + ABS(XAVGC21.54 > XAVGC21.55) * (ABS(XAVGC21.55 <= XAVGC21.56) * 55 + ABS(XAVGC21.55 > XAVGC21.56) * (ABS(XAVGC21.56 <= XAVGC21.57) * 56 + ABS(XAVGC21.56 > XAVGC21.57) * (ABS(XAVGC21.57 <= XAVGC21.58) * 57 + ABS(XAVGC21.57 > XAVGC21.58) * (ABS(XAVGC21.58 <= XAVGC21.59) * 58 + ABS(XAVGC21.58 > XAVGC21.59) * (ABS(XAVGC21.59 <= XAVGC21.60) * 59 + ABS(XAVGC21.59 > XAVGC21.60) * 60)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 7/29/2010 Posts: 417
|
Bruce,
Many thanks.
The new syntax looks very powerful, simpler, and much more elegant.
Don
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|