Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Aces4Me,
Since you use TC2000 v17, you can use a shorter version of your formula than is required in TC2000 v7.
200 * XAVG(C - (MAXH15 + MINL15) / 2, 6) / XAVG(MAXH15 - MINL15, 6)
Checking for crossing above its own 5 period simple moving average can be written as follows.
XUP(200 * XAVG(C - (MAXH15 + MINL15) / 2, 6) / XAVG(MAXH15 - MINL15, 6), AVG(200 * XAVG(C - (MAXH15 + MINL15) / 2, 6) / XAVG(MAXH15 - MINL15, 6), 5))
Checking for this crossing down its own 5 period simple moving average can be written as follows.
XDOWN(200 * XAVG(C - (MAXH15 + MINL15) / 2, 6) / XAVG(MAXH15 - MINL15, 6), AVG(200 * XAVG(C - (MAXH15 + MINL15) / 2, 6) / XAVG(MAXH15 - MINL15, 6), 5))
Checking for this being above its own 5 period simple moving average can be written as follows.
200 * XAVG(C - (MAXH15 + MINL15) / 2, 6) / XAVG(MAXH15 - MINL15, 6) > AVG(200 * XAVG(C - (MAXH15 + MINL15) / 2, 6) / XAVG(MAXH15 - MINL15, 6), 5)
Checking for this being below its own 5 period simple moving average can be written as follows.
200 * XAVG(C - (MAXH15 + MINL15) / 2, 6) / XAVG(MAXH15 - MINL15, 6) < AVG(200 * XAVG(C - (MAXH15 + MINL15) / 2, 6) / XAVG(MAXH15 - MINL15, 6), 5)
The 1 bar ago version can be written as follows.
200 * XAVG(C1 - (MAXH15.1 + MINL15.1) / 2, 6) / XAVG(MAXH15.1 - MINL15.1, 6)
And the 2 bars ago version can be written as follows.
200 * XAVG(C2 - (MAXH15.2 + MINL15.2) / 2, 6) / XAVG(MAXH15.2 - MINL15.2, 6)
Moving up two bars in a row can be written as follows.
CountTrue(200 * XAVG(C - (MAXH15 + MINL15) / 2, 6) / XAVG(MAXH15 - MINL15, 6) > 200 * XAVG(C1 - (MAXH15.1 + MINL15.1) / 2, 6) / XAVG(MAXH15.1 - MINL15.1, 6), 2) = 2
Moving down two bars in a row can be written as follows.
CountTrue(200 * XAVG(C - (MAXH15 + MINL15) / 2, 6) / XAVG(MAXH15 - MINL15, 6) < 200 * XAVG(C1 - (MAXH15.1 + MINL15.1) / 2, 6) / XAVG(MAXH15.1 - MINL15.1, 6), 2) = 2
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Michaelc1507,
The formula for the 15-period exponential moving average of the non-double smoothed SMI15,6 would be fairly short in TC2000 v17.
XAVG(200 * XAVG(C - (MAXH15 + MINL15) / 2, 6) / XAVG(MAXH15 - MINL15, 6), 15)
But even an approximation is much longer in TC2000 v7.
25.024142 * ((XAVGC6 - (XAVG(MAXH15, 6) + XAVG(MINL15, 6)) / 2) / (XAVG(MAXH15, 6) - XAVG(MINL15, 6)) + .875 * ((XAVGC6.1 - (XAVG(MAXH15.1, 6) + XAVG(MINL15.1, 6)) / 2) / (XAVG(MAXH15.1, 6) - XAVG(MINL15.1, 6)) + .875 * ((XAVGC6.2 - (XAVG(MAXH15.2, 6) + XAVG(MINL15.2, 6)) / 2) / (XAVG(MAXH15.2, 6) - XAVG(MINL15.2, 6)) + .875 * ((XAVGC6.3 - (XAVG(MAXH15.3, 6) + XAVG(MINL15.3, 6)) / 2) / (XAVG(MAXH15.3, 6) - XAVG(MINL15.3, 6)) + .875 * ((XAVGC6.4 - (XAVG(MAXH15.4, 6) + XAVG(MINL15.4, 6)) / 2) / (XAVG(MAXH15.4, 6) - XAVG(MINL15.4, 6)) + .875 * ((XAVGC6.5 - (XAVG(MAXH15.5, 6) + XAVG(MINL15.5, 6)) / 2) / (XAVG(MAXH15.5, 6) - XAVG(MINL15.5, 6)) + .875 * ((XAVGC6.6 - (XAVG(MAXH15.6, 6) + XAVG(MINL15.6, 6)) / 2) / (XAVG(MAXH15.6, 6) - XAVG(MINL15.6, 6)) + .875 * ((XAVGC6.7 - (XAVG(MAXH15.7, 6) + XAVG(MINL15.7, 6)) / 2) / (XAVG(MAXH15.7, 6) - XAVG(MINL15.7, 6)) + .875 * ((XAVGC6.8 - (XAVG(MAXH15.8, 6) + XAVG(MINL15.8, 6)) / 2) / (XAVG(MAXH15.8, 6) - XAVG(MINL15.8, 6)) + .875 * ((XAVGC6.9 - (XAVG(MAXH15.9, 6) + XAVG(MINL15.9, 6)) / 2) / (XAVG(MAXH15.9, 6) - XAVG(MINL15.9, 6)) + .875 * ((XAVGC6.10 - (XAVG(MAXH15.10, 6) + XAVG(MINL15.10, 6)) / 2) / (XAVG(MAXH15.10, 6) - XAVG(MINL15.10, 6)) + .875 * ((XAVGC6.11 - (XAVG(MAXH15.11, 6) + XAVG(MINL15.11, 6)) / 2) / (XAVG(MAXH15.11, 6) - XAVG(MINL15.11, 6)) + .875 * ((XAVGC6.12 - (XAVG(MAXH15.12, 6) + XAVG(MINL15.12, 6)) / 2) / (XAVG(MAXH15.12, 6) - XAVG(MINL15.12, 6)) + .875 * ((XAVGC6.13 - (XAVG(MAXH15.13, 6) + XAVG(MINL15.13, 6)) / 2) / (XAVG(MAXH15.13, 6) - XAVG(MINL15.13, 6)) + .875 * ((XAVGC6.14 - (XAVG(MAXH15.14, 6) + XAVG(MINL15.14, 6)) / 2) / (XAVG(MAXH15.14, 6) - XAVG(MINL15.14, 6)) + .875 * ((XAVGC6.15 - (XAVG(MAXH15.15, 6) + XAVG(MINL15.15, 6)) / 2) / (XAVG(MAXH15.15, 6) - XAVG(MINL15.15, 6)) + .875 * ((XAVGC6.16 - (XAVG(MAXH15.16, 6) + XAVG(MINL15.16, 6)) / 2) / (XAVG(MAXH15.16, 6) - XAVG(MINL15.16, 6)) + .875 * ((XAVGC6.17 - (XAVG(MAXH15.17, 6) + XAVG(MINL15.17, 6)) / 2) / (XAVG(MAXH15.17, 6) - XAVG(MINL15.17, 6)) + .875 * ((XAVGC6.18 - (XAVG(MAXH15.18, 6) + XAVG(MINL15.18, 6)) / 2) / (XAVG(MAXH15.18, 6) - XAVG(MINL15.18, 6)) + .875 * ((XAVGC6.19 - (XAVG(MAXH15.19, 6) + XAVG(MINL15.19, 6)) / 2) / (XAVG(MAXH15.19, 6) - XAVG(MINL15.19, 6)) + .875 * ((XAVGC6.20 - (XAVG(MAXH15.20, 6) + XAVG(MINL15.20, 6)) / 2) / (XAVG(MAXH15.20, 6) - XAVG(MINL15.20, 6)) + .875 * ((XAVGC6.21 - (XAVG(MAXH15.21, 6) + XAVG(MINL15.21, 6)) / 2) / (XAVG(MAXH15.21, 6) - XAVG(MINL15.21, 6)) + .875 * ((XAVGC6.22 - (XAVG(MAXH15.22, 6) + XAVG(MINL15.22, 6)) / 2) / (XAVG(MAXH15.22, 6) - XAVG(MINL15.22, 6)) + .875 * ((XAVGC6.23 - (XAVG(MAXH15.23, 6) + XAVG(MINL15.23, 6)) / 2) / (XAVG(MAXH15.23, 6) - XAVG(MINL15.23, 6)) + .875 * ((XAVGC6.24 - (XAVG(MAXH15.24, 6) + XAVG(MINL15.24, 6)) / 2) / (XAVG(MAXH15.24, 6) - XAVG(MINL15.24, 6)) + .875 * ((XAVGC6.25 - (XAVG(MAXH15.25, 6) + XAVG(MINL15.25, 6)) / 2) / (XAVG(MAXH15.25, 6) - XAVG(MINL15.25, 6)) + .875 * ((XAVGC6.26 - (XAVG(MAXH15.26, 6) + XAVG(MINL15.26, 6)) / 2) / (XAVG(MAXH15.26, 6) - XAVG(MINL15.26, 6)) + .875 * ((XAVGC6.27 - (XAVG(MAXH15.27, 6) + XAVG(MINL15.27, 6)) / 2) / (XAVG(MAXH15.27, 6) - XAVG(MINL15.27, 6)) + .875 * ((XAVGC6.28 - (XAVG(MAXH15.28, 6) + XAVG(MINL15.28, 6)) / 2) / (XAVG(MAXH15.28, 6) - XAVG(MINL15.28, 6)) + .875 * ((XAVGC6.29 - (XAVG(MAXH15.29, 6) + XAVG(MINL15.29, 6)) / 2) / (XAVG(MAXH15.29, 6) - XAVG(MINL15.29, 6)) + .875 * ((XAVGC6.30 - (XAVG(MAXH15.30, 6) + XAVG(MINL15.30, 6)) / 2) / (XAVG(MAXH15.30, 6) - XAVG(MINL15.30, 6)) + .875 * ((XAVGC6.31 - (XAVG(MAXH15.31, 6) + XAVG(MINL15.31, 6)) / 2) / (XAVG(MAXH15.31, 6) - XAVG(MINL15.31, 6)) + .875 * ((XAVGC6.32 - (XAVG(MAXH15.32, 6) + XAVG(MINL15.32, 6)) / 2) / (XAVG(MAXH15.32, 6) - XAVG(MINL15.32, 6)) + .875 * ((XAVGC6.33 - (XAVG(MAXH15.33, 6) + XAVG(MINL15.33, 6)) / 2) / (XAVG(MAXH15.33, 6) - XAVG(MINL15.33, 6)) + .875 * ((XAVGC6.34 - (XAVG(MAXH15.34, 6) + XAVG(MINL15.34, 6)) / 2) / (XAVG(MAXH15.34, 6) - XAVG(MINL15.34, 6)) + .875 * ((XAVGC6.35 - (XAVG(MAXH15.35, 6) + XAVG(MINL15.35, 6)) / 2) / (XAVG(MAXH15.35, 6) - XAVG(MINL15.35, 6)) + .875 * ((XAVGC6.36 - (XAVG(MAXH15.36, 6) + XAVG(MINL15.36, 6)) / 2) / (XAVG(MAXH15.36, 6) - XAVG(MINL15.36, 6)) + .875 * ((XAVGC6.37 - (XAVG(MAXH15.37, 6) + XAVG(MINL15.37, 6)) / 2) / (XAVG(MAXH15.37, 6) - XAVG(MINL15.37, 6)) + .875 * ((XAVGC6.38 - (XAVG(MAXH15.38, 6) + XAVG(MINL15.38, 6)) / 2) / (XAVG(MAXH15.38, 6) - XAVG(MINL15.38, 6)) + .875 * ((XAVGC6.39 - (XAVG(MAXH15.39, 6) + XAVG(MINL15.39, 6)) / 2) / (XAVG(MAXH15.39, 6) - XAVG(MINL15.39, 6)) + .875 * ((XAVGC6.40 - (XAVG(MAXH15.40, 6) + XAVG(MINL15.40, 6)) / 2) / (XAVG(MAXH15.40, 6) - XAVG(MINL15.40, 6)) + .875 * ((XAVGC6.41 - (XAVG(MAXH15.41, 6) + XAVG(MINL15.41, 6)) / 2) / (XAVG(MAXH15.41, 6) - XAVG(MINL15.41, 6)) + .875 * ((XAVGC6.42 - (XAVG(MAXH15.42, 6) + XAVG(MINL15.42, 6)) / 2) / (XAVG(MAXH15.42, 6) - XAVG(MINL15.42, 6)) + .875 * ((XAVGC6.43 - (XAVG(MAXH15.43, 6) + XAVG(MINL15.43, 6)) / 2) / (XAVG(MAXH15.43, 6) - XAVG(MINL15.43, 6)) + .875 * ((XAVGC6.44 - (XAVG(MAXH15.44, 6) + XAVG(MINL15.44, 6)) / 2) / (XAVG(MAXH15.44, 6) - XAVG(MINL15.44, 6)) + .875 * ((XAVGC6.45 - (XAVG(MAXH15.45, 6) + XAVG(MINL15.45, 6)) / 2) / (XAVG(MAXH15.45, 6) - XAVG(MINL15.45, 6)) + .875 * ((XAVGC6.46 - (XAVG(MAXH15.46, 6) + XAVG(MINL15.46, 6)) / 2) / (XAVG(MAXH15.46, 6) - XAVG(MINL15.46, 6)) + .875 * ((XAVGC6.47 - (XAVG(MAXH15.47, 6) + XAVG(MINL15.47, 6)) / 2) / (XAVG(MAXH15.47, 6) - XAVG(MINL15.47, 6)) + .875 * ((XAVGC6.48 - (XAVG(MAXH15.48, 6) + XAVG(MINL15.48, 6)) / 2) / (XAVG(MAXH15.48, 6) - XAVG(MINL15.48, 6)) + .875 * ((XAVGC6.49 - (XAVG(MAXH15.49, 6) + XAVG(MINL15.49, 6)) / 2) / (XAVG(MAXH15.49, 6) - XAVG(MINL15.49, 6)) + .875 * ((XAVGC6.50 - (XAVG(MAXH15.50, 6) + XAVG(MINL15.50, 6)) / 2) / (XAVG(MAXH15.50, 6) - XAVG(MINL15.50, 6)) + .875 * ((XAVGC6.51 - (XAVG(MAXH15.51, 6) + XAVG(MINL15.51, 6)) / 2) / (XAVG(MAXH15.51, 6) - XAVG(MINL15.51, 6))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|