Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
One way to write a Personal Criteria Formula for a 5-Period TEMA would be:
3 * XAVGC5 - 3 * XAVG(XAVGC5,5) + .333559032545198 * (XAVG(XAVGC5,5) + 2 / 3 * (XAVG(XAVGC5.1,5) + 2 / 3 * (XAVG(XAVGC5.2,5) + 2 / 3 * (XAVG(XAVGC5.3,5) + 2 / 3 * (XAVG(XAVGC5.4,5) + 2 / 3 * (XAVG(XAVGC5.5,5) + 2 / 3 * (XAVG(XAVGC5.6,5) + 2 / 3 * (XAVG(XAVGC5.7,5) + 2 / 3 * (XAVG(XAVGC5.8,5) + 2 / 3 * (XAVG(XAVGC5.9,5) + 2 / 3 * (XAVG(XAVGC5.10,5) + 2 / 3 * (XAVG(XAVGC5.11,5) + 2 / 3 * (XAVG(XAVGC5.12,5) + 2 / 3 * (XAVG(XAVGC5.13,5) + 2 / 3 * (XAVG(XAVGC5.14,5) + 2 / 3 * (XAVG(XAVGC5.15,5) + 2 / 3 * (XAVG(XAVGC5.16,5) + 2 / 3 * (XAVG(XAVGC5.17,5)))))))))))))))))))
One way to write a Personal Criteria Formula for a 34-Period TEMA would be:
3 * XAVGC34 - 3 * XAVG(XAVGC34,34) + .0571980645061175 * (XAVG(XAVGC34,34) + 33 / 35 * (XAVG(XAVGC34.1,34) + 33 / 35 * (XAVG(XAVGC34.2,34) + 33 / 35 * (XAVG(XAVGC34.3,34) + 33 / 35 * (XAVG(XAVGC34.4,34) + 33 / 35 * (XAVG(XAVGC34.5,34) + 33 / 35 * (XAVG(XAVGC34.6,34) + 33 / 35 * (XAVG(XAVGC34.7,34) + 33 / 35 * (XAVG(XAVGC34.8,34) + 33 / 35 * (XAVG(XAVGC34.9,34) + 33 / 35 * (XAVG(XAVGC34.10,34) + 33 / 35 * (XAVG(XAVGC34.11,34) + 33 / 35 * (XAVG(XAVGC34.12,34) + 33 / 35 * (XAVG(XAVGC34.13,34) + 33 / 35 * (XAVG(XAVGC34.14,34) + 33 / 35 * (XAVG(XAVGC34.15,34) + 33 / 35 * (XAVG(XAVGC34.16,34) + 33 / 35 * (XAVG(XAVGC34.17,34) + 33 / 35 * (XAVG(XAVGC34.18,34) + 33 / 35 * (XAVG(XAVGC34.19,34) + 33 / 35 * (XAVG(XAVGC34.20,34) + 33 / 35 * (XAVG(XAVGC34.21,34) + 33 / 35 * (XAVG(XAVGC34.22,34) + 33 / 35 * (XAVG(XAVGC34.23,34) + 33 / 35 * (XAVG(XAVGC34.24,34) + 33 / 35 * (XAVG(XAVGC34.25,34) + 33 / 35 * (XAVG(XAVGC34.26,34) + 33 / 35 * (XAVG(XAVGC34.27,34) + 33 / 35 * (XAVG(XAVGC34.28,34) + 33 / 35 * (XAVG(XAVGC34.29,34) + 33 / 35 * (XAVG(XAVGC34.30,34) + 33 / 35 * (XAVG(XAVGC34.31,34) + 33 / 35 * (XAVG(XAVGC34.32,34) + 33 / 35 * (XAVG(XAVGC34.33,34) + 33 / 35 * (XAVG(XAVGC34.34,34) + 33 / 35 * (XAVG(XAVGC34.35,34) + 33 / 35 * (XAVG(XAVGC34.36,34) + 33 / 35 * (XAVG(XAVGC34.37,34) + 33 / 35 * (XAVG(XAVGC34.38,34) + 33 / 35 * (XAVG(XAVGC34.39,34) + 33 / 35 * (XAVG(XAVGC34.40,34) + 33 / 35 * (XAVG(XAVGC34.41,34) + 33 / 35 * (XAVG(XAVGC34.42,34) + 33 / 35 * (XAVG(XAVGC34.43,34) + 33 / 35 * (XAVG(XAVGC34.44,34) + 33 / 35 * (XAVG(XAVGC34.45,34) + 33 / 35 * (XAVG(XAVGC34.46,34) + 33 / 35 * (XAVG(XAVGC34.47,34) + 33 / 35 * (XAVG(XAVGC34.48,34) + 33 / 35 * (XAVG(XAVGC34.49,34) + 33 / 35 * (XAVG(XAVGC34.50,34) + 33 / 35 * (XAVG(XAVGC34.51,34) + 33 / 35 * (XAVG(XAVGC34.52,34) + 33 / 35 * (XAVG(XAVGC34.53,34) + 33 / 35 * (XAVG(XAVGC34.54,34) + 33 / 35 * (XAVG(XAVGC34.55,34) + 33 / 35 * (XAVG(XAVGC34.56,34) + 33 / 35 * (XAVG(XAVGC34.57,34) + 33 / 35 * (XAVG(XAVGC34.58,34) + 33 / 35 * (XAVG(XAVGC34.59,34) + 33 / 35 * (XAVG(XAVGC34.60,34) + 33 / 35 * (XAVG(XAVGC34.61,34) + 33 / 35 * (XAVG(XAVGC34.62,34) + 33 / 35 * (XAVG(XAVGC34.63,34) + 33 / 35 * (XAVG(XAVGC34.64,34) + 33 / 35 * (XAVG(XAVGC34.65,34) + 33 / 35 * (XAVG(XAVGC34.66,34) + 33 / 35 * (XAVG(XAVGC34.67,34) + 33 / 35 * (XAVG(XAVGC34.68,34) + 33 / 35 * (XAVG(XAVGC34.69,34) + 33 / 35 * (XAVG(XAVGC34.70,34) + 33 / 35 * (XAVG(XAVGC34.71,34) + 33 / 35 * (XAVG(XAVGC34.72,34) + 33 / 35 * (XAVG(XAVGC34.73,34) + 33 / 35 * (XAVG(XAVGC34.74,34) + 33 / 35 * (XAVG(XAVGC34.75,34) + 33 / 35 * (XAVG(XAVGC34.76,34) + 33 / 35 * (XAVG(XAVGC34.77,34) + 33 / 35 * (XAVG(XAVGC34.78,34) + 33 / 35 * (XAVG(XAVGC34.79,34) + 33 / 35 * (XAVG(XAVGC34.80,34) + 33 / 35 * (XAVG(XAVGC34.81,34) + 33 / 35 * (XAVG(XAVGC34.82,34) + 33 / 35 * (XAVG(XAVGC34.83,34) + 33 / 35 * (XAVG(XAVGC34.84,34) + 33 / 35 * (XAVG(XAVGC34.85,34) + 33 / 35 * (XAVG(XAVGC34.86,34) + 33 / 35 * (XAVG(XAVGC34.87,34) + 33 / 35 * (XAVG(XAVGC34.88,34) + 33 / 35 * (XAVG(XAVGC34.89,34) + 33 / 35 * (XAVG(XAVGC34.90,34) + 33 / 35 * (XAVG(XAVGC34.91,34) + 33 / 35 * (XAVG(XAVGC34.92,34) + 33 / 35 * (XAVG(XAVGC34.93,34) + 33 / 35 * (XAVG(XAVGC34.94,34) + 33 / 35 * (XAVG(XAVGC34.95,34) + 33 / 35 * (XAVG(XAVGC34.96,34) + 33 / 35 * (XAVG(XAVGC34.97,34) + 33 / 35 * (XAVG(XAVGC34.98,34) + 33 / 35 * (XAVG(XAVGC34.99,34) + 33 / 35 * (XAVG(XAVGC34.100,34) + 33 / 35 * (XAVG(XAVGC34.101,34) + 33 / 35 * (XAVG(XAVGC34.102,34) + 33 / 35 * (XAVG(XAVGC34.103,34) + 33 / 35 * (XAVG(XAVGC34.104,34) + 33 / 35 * (XAVG(XAVGC34.105,34) + 33 / 35 * (XAVG(XAVGC34.106,34) + 33 / 35 * (XAVG(XAVGC34.107,34) + 33 / 35 * (XAVG(XAVGC34.108,34) + 33 / 35 * (XAVG(XAVGC34.109,34) + 33 / 35 * (XAVG(XAVGC34.110,34) + 33 / 35 * (XAVG(XAVGC34.111,34) + 33 / 35 * (XAVG(XAVGC34.112,34) + 33 / 35 * (XAVG(XAVGC34.113,34) + 33 / 35 * (XAVG(XAVGC34.114,34) + 33 / 35 * (XAVG(XAVGC34.115,34) + 33 / 35 * (XAVG(XAVGC34.116,34) + 33 / 35 * (XAVG(XAVGC34.117,34)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
Cascades of Moving Averages
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
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
QUOTE (mjtran) requesting TEMA equation of 10 days...
3 * XAVGC10 - 3 * XAVG(XAVGC10,10) + .181980276277401 * (XAVG(XAVGC10,10) + 9 / 11 * (XAVG(XAVGC10.1,10) + 9 / 11 * (XAVG(XAVGC10.2,10) + 9 / 11 * (XAVG(XAVGC10.3,10) + 9 / 11 * (XAVG(XAVGC10.4,10) + 9 / 11 * (XAVG(XAVGC10.5,10) + 9 / 11 * (XAVG(XAVGC10.6,10) + 9 / 11 * (XAVG(XAVGC10.7,10) + 9 / 11 * (XAVG(XAVGC10.8,10) + 9 / 11 * (XAVG(XAVGC10.9,10) + 9 / 11 * (XAVG(XAVGC10.10,10) + 9 / 11 * (XAVG(XAVGC10.11,10) + 9 / 11 * (XAVG(XAVGC10.12,10) + 9 / 11 * (XAVG(XAVGC10.13,10) + 9 / 11 * (XAVG(XAVGC10.14,10) + 9 / 11 * (XAVG(XAVGC10.15,10) + 9 / 11 * (XAVG(XAVGC10.16,10) + 9 / 11 * (XAVG(XAVGC10.17,10) + 9 / 11 * (XAVG(XAVGC10.18,10) + 9 / 11 * (XAVG(XAVGC10.19,10) + 9 / 11 * (XAVG(XAVGC10.20,10) + 9 / 11 * (XAVG(XAVGC10.21,10) + 9 / 11 * (XAVG(XAVGC10.22,10) + 9 / 11 * (XAVG(XAVGC10.23,10) + 9 / 11 * (XAVG(XAVGC10.24,10) + 9 / 11 * (XAVG(XAVGC10.25,10) + 9 / 11 * (XAVG(XAVGC10.26,10) + 9 / 11 * (XAVG(XAVGC10.27,10) + 9 / 11 * (XAVG(XAVGC10.28,10) + 9 / 11 * (XAVG(XAVGC10.29,10) + 9 / 11 * (XAVG(XAVGC10.30,10) + 9 / 11 * (XAVG(XAVGC10.31,10) + 9 / 11 * (XAVG(XAVGC10.32,10) + 9 / 11 * (XAVG(XAVGC10.33,10) + 9 / 11 * (XAVG(XAVGC10.34,10))))))))))))))))))))))))))))))))))))
QUOTE (mjtran) ...and 15 days for TC.
3 * XAVGC15 - 3 * XAVG(XAVGC15,15) + .125120711309662 * (XAVG(XAVGC15,15) + .875 * (XAVG(XAVGC15.1,15) + .875 * (XAVG(XAVGC15.2,15) + .875 * (XAVG(XAVGC15.3,15) + .875 * (XAVG(XAVGC15.4,15) + .875 * (XAVG(XAVGC15.5,15) + .875 * (XAVG(XAVGC15.6,15) + .875 * (XAVG(XAVGC15.7,15) + .875 * (XAVG(XAVGC15.8,15) + .875 * (XAVG(XAVGC15.9,15) + .875 * (XAVG(XAVGC15.10,15) + .875 * (XAVG(XAVGC15.11,15) + .875 * (XAVG(XAVGC15.12,15) + .875 * (XAVG(XAVGC15.13,15) + .875 * (XAVG(XAVGC15.14,15) + .875 * (XAVG(XAVGC15.15,15) + .875 * (XAVG(XAVGC15.16,15) + .875 * (XAVG(XAVGC15.17,15) + .875 * (XAVG(XAVGC15.18,15) + .875 * (XAVG(XAVGC15.19,15) + .875 * (XAVG(XAVGC15.20,15) + .875 * (XAVG(XAVGC15.21,15) + .875 * (XAVG(XAVGC15.22,15) + .875 * (XAVG(XAVGC15.23,15) + .875 * (XAVG(XAVGC15.24,15) + .875 * (XAVG(XAVGC15.25,15) + .875 * (XAVG(XAVGC15.26,15) + .875 * (XAVG(XAVGC15.27,15) + .875 * (XAVG(XAVGC15.28,15) + .875 * (XAVG(XAVGC15.29,15) + .875 * (XAVG(XAVGC15.30,15) + .875 * (XAVG(XAVGC15.31,15) + .875 * (XAVG(XAVGC15.32,15) + .875 * (XAVG(XAVGC15.33,15) + .875 * (XAVG(XAVGC15.34,15) + .875 * (XAVG(XAVGC15.35,15) + .875 * (XAVG(XAVGC15.36,15) + .875 * (XAVG(XAVGC15.37,15) + .875 * (XAVG(XAVGC15.38,15) + .875 * (XAVG(XAVGC15.39,15) + .875 * (XAVG(XAVGC15.40,15) + .875 * (XAVG(XAVGC15.41,15) + .875 * (XAVG(XAVGC15.42,15) + .875 * (XAVG(XAVGC15.43,15) + .875 * (XAVG(XAVGC15.44,15) + .875 * (XAVG(XAVGC15.45,15) + .875 * (XAVG(XAVGC15.46,15) + .875 * (XAVG(XAVGC15.47,15) + .875 * (XAVG(XAVGC15.48,15) + .875 * (XAVG(XAVGC15.49,15) + .875 * (XAVG(XAVGC15.50,15) + .875 * (XAVG(XAVGC15.51,15)))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|