Platinum Customer
Joined: 7/3/2007 Posts: 27
|
Hi. I need some help to make these PCF's work for an exponential moving average. Thanks!
(STOC50.22 >= AVG(STOC50.22,10) AND STOC50.22.1 < AVG(STOC50.22.1,10))
(STOC50.22 < AVG(STOC50.22,10) AND STOC50.22.1 >= AVG(STOC50.22.1,10))
STOC50.22
AVG(STOC50.22,10)
STOC50.22 - AVG(STOC50.22,10)
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
QUOTE (tryn2makit4u) (STOC50.22 >= AVG(STOC50.22,10) AND STOC50.22.1 < AVG(STOC50.22.1,10))
XAVG(STOC50,22) <= XAVG(STOC50,10) AND XAVG(STOC50.1.1,22) > XAVG(STOC50.1.1,10)
QUOTE (tryn2makit4u) (STOC50.22 < AVG(STOC50.22,10) AND STOC50.22.1 >= AVG(STOC50.22.1,10))
XAVG(STOC50,22) > XAVG(STOC50,10) AND XAVG(STOC50.1.1,22) <= XAVG(STOC50.1.1,10)
QUOTE (tryn2makit4u) STOC50.22
XAVG(STOC50,22)
QUOTE (tryn2makit4u) AVG(STOC50.22,10)
(21 * XAVG(STOC50,22) - 9 * XAVG(STOC50,10)) / 12
Or:
(7 * XAVG(STOC50,22) - 3 * XAVG(STOC50,10)) / 4
QUOTE (tryn2makit4u) STOC50.22 - AVG(STOC50.22,10)
XAVG(STOC50,22) - (21 * XAVG(STOC50,22) - 9 * XAVG(STOC50,10)) / 12
Or:
3 * (XAVG(STOC50,10) - XAVG(STOC50,22)) / 4
You may wish to review the following:
Cascades of Moving Averages
Understanding Stochastics
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
|
Platinum Customer
Joined: 7/3/2007 Posts: 27
|
Thank you! I appreciate it.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|