Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following:
Warning: Long Personal Criteria Formulas can dramatically increase the time it takes to update your PCFs.
SMI(13,25,3,3) xUp Signal:
(12 * (XAVGC25 - (XAVG(MAXH13,25) + XAVG(MINL13,25)) / 2) - XAVGC3 + (XAVG(MAXH13,3) + XAVG(MINL13,3)) / 2) / (12 * (XAVG(MAXH13,25) - XAVG(MINL13,25)) - XAVG(MAXH13,3) + XAVG(MINL13,3)) > .500488758553275 * ((12 * (XAVGC25 - (XAVG(MAXH13,25) + XAVG(MINL13,25)) / 2) - XAVGC3 + (XAVG(MAXH13,3) + XAVG(MINL13,3)) / 2) / (12 * (XAVG(MAXH13,25) - XAVG(MINL13,25)) - XAVG(MAXH13,3) + XAVG(MINL13,3)) + .5 * ((12 * (XAVGC25.1 - (XAVG(MAXH13.1,25) + XAVG(MINL13.1,25)) / 2) - XAVGC3.1 + (XAVG(MAXH13.1,3) + XAVG(MINL13.1,3)) / 2) / (12 * (XAVG(MAXH13.1,25) - XAVG(MINL13.1,25)) - XAVG(MAXH13.1,3) + XAVG(MINL13.1,3)) + .5 * ((12 * (XAVGC25.2 - (XAVG(MAXH13.2,25) + XAVG(MINL13.2,25)) / 2) - XAVGC3.2 + (XAVG(MAXH13.2,3) + XAVG(MINL13.2,3)) / 2) / (12 * (XAVG(MAXH13.2,25) - XAVG(MINL13.2,25)) - XAVG(MAXH13.2,3) + XAVG(MINL13.2,3)) + .5 * ((12 * (XAVGC25.3 - (XAVG(MAXH13.3,25) + XAVG(MINL13.3,25)) / 2) - XAVGC3.3 + (XAVG(MAXH13.3,3) + XAVG(MINL13.3,3)) / 2) / (12 * (XAVG(MAXH13.3,25) - XAVG(MINL13.3,25)) - XAVG(MAXH13.3,3) + XAVG(MINL13.3,3)) + .5 * ((12 * (XAVGC25.4 - (XAVG(MAXH13.4,25) + XAVG(MINL13.4,25)) / 2) - XAVGC3.4 + (XAVG(MAXH13.4,3) + XAVG(MINL13.4,3)) / 2) / (12 * (XAVG(MAXH13.4,25) - XAVG(MINL13.4,25)) - XAVG(MAXH13.4,3) + XAVG(MINL13.4,3)) + .5 * ((12 * (XAVGC25.5 - (XAVG(MAXH13.5,25) + XAVG(MINL13.5,25)) / 2) - XAVGC3.5 + (XAVG(MAXH13.5,3) + XAVG(MINL13.5,3)) / 2) / (12 * (XAVG(MAXH13.5,25) - XAVG(MINL13.5,25)) - XAVG(MAXH13.5,3) + XAVG(MINL13.5,3)) + .5 * ((12 * (XAVGC25.6 - (XAVG(MAXH13.6,25) + XAVG(MINL13.6,25)) / 2) - XAVGC3.6 + (XAVG(MAXH13.6,3) + XAVG(MINL13.6,3)) / 2) / (12 * (XAVG(MAXH13.6,25) - XAVG(MINL13.6,25)) - XAVG(MAXH13.6,3) + XAVG(MINL13.6,3)) + .5 * ((12 * (XAVGC25.7 - (XAVG(MAXH13.7,25) + XAVG(MINL13.7,25)) / 2) - XAVGC3.7 + (XAVG(MAXH13.7,3) + XAVG(MINL13.7,3)) / 2) / (12 * (XAVG(MAXH13.7,25) - XAVG(MINL13.7,25)) - XAVG(MAXH13.7,3) + XAVG(MINL13.7,3)) + .5 * ((12 * (XAVGC25.8 - (XAVG(MAXH13.8,25) + XAVG(MINL13.8,25)) / 2) - XAVGC3.8 + (XAVG(MAXH13.8,3) + XAVG(MINL13.8,3)) / 2) / (12 * (XAVG(MAXH13.8,25) - XAVG(MINL13.8,25)) - XAVG(MAXH13.8,3) + XAVG(MINL13.8,3)) + .5 * ((12 * (XAVGC25.9 - (XAVG(MAXH13.9,25) + XAVG(MINL13.9,25)) / 2) - XAVGC3.9 + (XAVG(MAXH13.9,3) + XAVG(MINL13.9,3)) / 2) / (12 * (XAVG(MAXH13.9,25) - XAVG(MINL13.9,25)) - XAVG(MAXH13.9,3) + XAVG(MINL13.9,3)))))))))))) AND (12 * (XAVGC25.1 - (XAVG(MAXH13.1,25) + XAVG(MINL13.1,25)) / 2) - XAVGC3.1 + (XAVG(MAXH13.1,3) + XAVG(MINL13.1,3)) / 2) / (12 * (XAVG(MAXH13.1,25) - XAVG(MINL13.1,25)) - XAVG(MAXH13.1,3) + XAVG(MINL13.1,3)) <= .500488758553275 * ((12 * (XAVGC25.1 - (XAVG(MAXH13.1,25) + XAVG(MINL13.1,25)) / 2) - XAVGC3.1 + (XAVG(MAXH13.1,3) + XAVG(MINL13.1,3)) / 2) / (12 * (XAVG(MAXH13.1,25) - XAVG(MINL13.1,25)) - XAVG(MAXH13.1,3) + XAVG(MINL13.1,3)) + .5 * ((12 * (XAVGC25.2 - (XAVG(MAXH13.2,25) + XAVG(MINL13.2,25)) / 2) - XAVGC3.2 + (XAVG(MAXH13.2,3) + XAVG(MINL13.2,3)) / 2) / (12 * (XAVG(MAXH13.2,25) - XAVG(MINL13.2,25)) - XAVG(MAXH13.2,3) + XAVG(MINL13.2,3)) + .5 * ((12 * (XAVGC25.3 - (XAVG(MAXH13.3,25) + XAVG(MINL13.3,25)) / 2) - XAVGC3.3 + (XAVG(MAXH13.3,3) + XAVG(MINL13.3,3)) / 2) / (12 * (XAVG(MAXH13.3,25) - XAVG(MINL13.3,25)) - XAVG(MAXH13.3,3) + XAVG(MINL13.3,3)) + .5 * ((12 * (XAVGC25.4 - (XAVG(MAXH13.4,25) + XAVG(MINL13.4,25)) / 2) - XAVGC3.4 + (XAVG(MAXH13.4,3) + XAVG(MINL13.4,3)) / 2) / (12 * (XAVG(MAXH13.4,25) - XAVG(MINL13.4,25)) - XAVG(MAXH13.4,3) + XAVG(MINL13.4,3)) + .5 * ((12 * (XAVGC25.5 - (XAVG(MAXH13.5,25) + XAVG(MINL13.5,25)) / 2) - XAVGC3.5 + (XAVG(MAXH13.5,3) + XAVG(MINL13.5,3)) / 2) / (12 * (XAVG(MAXH13.5,25) - XAVG(MINL13.5,25)) - XAVG(MAXH13.5,3) + XAVG(MINL13.5,3)) + .5 * ((12 * (XAVGC25.6 - (XAVG(MAXH13.6,25) + XAVG(MINL13.6,25)) / 2) - XAVGC3.6 + (XAVG(MAXH13.6,3) + XAVG(MINL13.6,3)) / 2) / (12 * (XAVG(MAXH13.6,25) - XAVG(MINL13.6,25)) - XAVG(MAXH13.6,3) + XAVG(MINL13.6,3)) + .5 * ((12 * (XAVGC25.7 - (XAVG(MAXH13.7,25) + XAVG(MINL13.7,25)) / 2) - XAVGC3.7 + (XAVG(MAXH13.7,3) + XAVG(MINL13.7,3)) / 2) / (12 * (XAVG(MAXH13.7,25) - XAVG(MINL13.7,25)) - XAVG(MAXH13.7,3) + XAVG(MINL13.7,3)) + .5 * ((12 * (XAVGC25.8 - (XAVG(MAXH13.8,25) + XAVG(MINL13.8,25)) / 2) - XAVGC3.8 + (XAVG(MAXH13.8,3) + XAVG(MINL13.8,3)) / 2) / (12 * (XAVG(MAXH13.8,25) - XAVG(MINL13.8,25)) - XAVG(MAXH13.8,3) + XAVG(MINL13.8,3)) + .5 * ((12 * (XAVGC25.9 - (XAVG(MAXH13.9,25) + XAVG(MINL13.9,25)) / 2) - XAVGC3.9 + (XAVG(MAXH13.9,3) + XAVG(MINL13.9,3)) / 2) / (12 * (XAVG(MAXH13.9,25) - XAVG(MINL13.9,25)) - XAVG(MAXH13.9,3) + XAVG(MINL13.9,3) + .5 * ((12 * (XAVGC25.10 - (XAVG(MAXH13.10,25) + XAVG(MINL13.10,25)) / 2) - XAVGC3.10 + (XAVG(MAXH13.10,3) + XAVG(MINL13.10,3)) / 2) / (12 * (XAVG(MAXH13.10,25) - XAVG(MINL13.10,25)) - XAVG(MAXH13.10,3) + XAVG(MINL13.10,3)))))))))))))
SMI(13,25,3,3) xDn Signal:
(12 * (XAVGC25 - (XAVG(MAXH13,25) + XAVG(MINL13,25)) / 2) - XAVGC3 + (XAVG(MAXH13,3) + XAVG(MINL13,3)) / 2) / (12 * (XAVG(MAXH13,25) - XAVG(MINL13,25)) - XAVG(MAXH13,3) + XAVG(MINL13,3)) < .500488758553275 * ((12 * (XAVGC25 - (XAVG(MAXH13,25) + XAVG(MINL13,25)) / 2) - XAVGC3 + (XAVG(MAXH13,3) + XAVG(MINL13,3)) / 2) / (12 * (XAVG(MAXH13,25) - XAVG(MINL13,25)) - XAVG(MAXH13,3) + XAVG(MINL13,3)) + .5 * ((12 * (XAVGC25.1 - (XAVG(MAXH13.1,25) + XAVG(MINL13.1,25)) / 2) - XAVGC3.1 + (XAVG(MAXH13.1,3) + XAVG(MINL13.1,3)) / 2) / (12 * (XAVG(MAXH13.1,25) - XAVG(MINL13.1,25)) - XAVG(MAXH13.1,3) + XAVG(MINL13.1,3)) + .5 * ((12 * (XAVGC25.2 - (XAVG(MAXH13.2,25) + XAVG(MINL13.2,25)) / 2) - XAVGC3.2 + (XAVG(MAXH13.2,3) + XAVG(MINL13.2,3)) / 2) / (12 * (XAVG(MAXH13.2,25) - XAVG(MINL13.2,25)) - XAVG(MAXH13.2,3) + XAVG(MINL13.2,3)) + .5 * ((12 * (XAVGC25.3 - (XAVG(MAXH13.3,25) + XAVG(MINL13.3,25)) / 2) - XAVGC3.3 + (XAVG(MAXH13.3,3) + XAVG(MINL13.3,3)) / 2) / (12 * (XAVG(MAXH13.3,25) - XAVG(MINL13.3,25)) - XAVG(MAXH13.3,3) + XAVG(MINL13.3,3)) + .5 * ((12 * (XAVGC25.4 - (XAVG(MAXH13.4,25) + XAVG(MINL13.4,25)) / 2) - XAVGC3.4 + (XAVG(MAXH13.4,3) + XAVG(MINL13.4,3)) / 2) / (12 * (XAVG(MAXH13.4,25) - XAVG(MINL13.4,25)) - XAVG(MAXH13.4,3) + XAVG(MINL13.4,3)) + .5 * ((12 * (XAVGC25.5 - (XAVG(MAXH13.5,25) + XAVG(MINL13.5,25)) / 2) - XAVGC3.5 + (XAVG(MAXH13.5,3) + XAVG(MINL13.5,3)) / 2) / (12 * (XAVG(MAXH13.5,25) - XAVG(MINL13.5,25)) - XAVG(MAXH13.5,3) + XAVG(MINL13.5,3)) + .5 * ((12 * (XAVGC25.6 - (XAVG(MAXH13.6,25) + XAVG(MINL13.6,25)) / 2) - XAVGC3.6 + (XAVG(MAXH13.6,3) + XAVG(MINL13.6,3)) / 2) / (12 * (XAVG(MAXH13.6,25) - XAVG(MINL13.6,25)) - XAVG(MAXH13.6,3) + XAVG(MINL13.6,3)) + .5 * ((12 * (XAVGC25.7 - (XAVG(MAXH13.7,25) + XAVG(MINL13.7,25)) / 2) - XAVGC3.7 + (XAVG(MAXH13.7,3) + XAVG(MINL13.7,3)) / 2) / (12 * (XAVG(MAXH13.7,25) - XAVG(MINL13.7,25)) - XAVG(MAXH13.7,3) + XAVG(MINL13.7,3)) + .5 * ((12 * (XAVGC25.8 - (XAVG(MAXH13.8,25) + XAVG(MINL13.8,25)) / 2) - XAVGC3.8 + (XAVG(MAXH13.8,3) + XAVG(MINL13.8,3)) / 2) / (12 * (XAVG(MAXH13.8,25) - XAVG(MINL13.8,25)) - XAVG(MAXH13.8,3) + XAVG(MINL13.8,3)) + .5 * ((12 * (XAVGC25.9 - (XAVG(MAXH13.9,25) + XAVG(MINL13.9,25)) / 2) - XAVGC3.9 + (XAVG(MAXH13.9,3) + XAVG(MINL13.9,3)) / 2) / (12 * (XAVG(MAXH13.9,25) - XAVG(MINL13.9,25)) - XAVG(MAXH13.9,3) + XAVG(MINL13.9,3)))))))))))) AND (12 * (XAVGC25.1 - (XAVG(MAXH13.1,25) + XAVG(MINL13.1,25)) / 2) - XAVGC3.1 + (XAVG(MAXH13.1,3) + XAVG(MINL13.1,3)) / 2) / (12 * (XAVG(MAXH13.1,25) - XAVG(MINL13.1,25)) - XAVG(MAXH13.1,3) + XAVG(MINL13.1,3)) >= .500488758553275 * ((12 * (XAVGC25.1 - (XAVG(MAXH13.1,25) + XAVG(MINL13.1,25)) / 2) - XAVGC3.1 + (XAVG(MAXH13.1,3) + XAVG(MINL13.1,3)) / 2) / (12 * (XAVG(MAXH13.1,25) - XAVG(MINL13.1,25)) - XAVG(MAXH13.1,3) + XAVG(MINL13.1,3)) + .5 * ((12 * (XAVGC25.2 - (XAVG(MAXH13.2,25) + XAVG(MINL13.2,25)) / 2) - XAVGC3.2 + (XAVG(MAXH13.2,3) + XAVG(MINL13.2,3)) / 2) / (12 * (XAVG(MAXH13.2,25) - XAVG(MINL13.2,25)) - XAVG(MAXH13.2,3) + XAVG(MINL13.2,3)) + .5 * ((12 * (XAVGC25.3 - (XAVG(MAXH13.3,25) + XAVG(MINL13.3,25)) / 2) - XAVGC3.3 + (XAVG(MAXH13.3,3) + XAVG(MINL13.3,3)) / 2) / (12 * (XAVG(MAXH13.3,25) - XAVG(MINL13.3,25)) - XAVG(MAXH13.3,3) + XAVG(MINL13.3,3)) + .5 * ((12 * (XAVGC25.4 - (XAVG(MAXH13.4,25) + XAVG(MINL13.4,25)) / 2) - XAVGC3.4 + (XAVG(MAXH13.4,3) + XAVG(MINL13.4,3)) / 2) / (12 * (XAVG(MAXH13.4,25) - XAVG(MINL13.4,25)) - XAVG(MAXH13.4,3) + XAVG(MINL13.4,3)) + .5 * ((12 * (XAVGC25.5 - (XAVG(MAXH13.5,25) + XAVG(MINL13.5,25)) / 2) - XAVGC3.5 + (XAVG(MAXH13.5,3) + XAVG(MINL13.5,3)) / 2) / (12 * (XAVG(MAXH13.5,25) - XAVG(MINL13.5,25)) - XAVG(MAXH13.5,3) + XAVG(MINL13.5,3)) + .5 * ((12 * (XAVGC25.6 - (XAVG(MAXH13.6,25) + XAVG(MINL13.6,25)) / 2) - XAVGC3.6 + (XAVG(MAXH13.6,3) + XAVG(MINL13.6,3)) / 2) / (12 * (XAVG(MAXH13.6,25) - XAVG(MINL13.6,25)) - XAVG(MAXH13.6,3) + XAVG(MINL13.6,3)) + .5 * ((12 * (XAVGC25.7 - (XAVG(MAXH13.7,25) + XAVG(MINL13.7,25)) / 2) - XAVGC3.7 + (XAVG(MAXH13.7,3) + XAVG(MINL13.7,3)) / 2) / (12 * (XAVG(MAXH13.7,25) - XAVG(MINL13.7,25)) - XAVG(MAXH13.7,3) + XAVG(MINL13.7,3)) + .5 * ((12 * (XAVGC25.8 - (XAVG(MAXH13.8,25) + XAVG(MINL13.8,25)) / 2) - XAVGC3.8 + (XAVG(MAXH13.8,3) + XAVG(MINL13.8,3)) / 2) / (12 * (XAVG(MAXH13.8,25) - XAVG(MINL13.8,25)) - XAVG(MAXH13.8,3) + XAVG(MINL13.8,3)) + .5 * ((12 * (XAVGC25.9 - (XAVG(MAXH13.9,25) + XAVG(MINL13.9,25)) / 2) - XAVGC3.9 + (XAVG(MAXH13.9,3) + XAVG(MINL13.9,3)) / 2) / (12 * (XAVG(MAXH13.9,25) - XAVG(MINL13.9,25)) - XAVG(MAXH13.9,3) + XAVG(MINL13.9,3) + .5 * ((12 * (XAVGC25.10 - (XAVG(MAXH13.10,25) + XAVG(MINL13.10,25)) / 2) - XAVGC3.10 + (XAVG(MAXH13.10,3) + XAVG(MINL13.10,3)) / 2) / (12 * (XAVG(MAXH13.10,25) - XAVG(MINL13.10,25)) - XAVG(MAXH13.10,3) + XAVG(MINL13.10,3)))))))))))))
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|