Registered User Joined: 11/30/2004 Posts: 33
|
Is there a way to write a formula for the 20 month exponential moving average?
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Personal Criteria Formula:
.0953245136006837 * (C + 19 / 21 * (C21 + 19 / 21 * (C42 + 19 / 21 * (C63 + 19 / 21 * (C84 + 19 / 21 * (C105 + 19 / 21 * (C126 + 19 / 21 * (C147 + 19 / 21 * (C168 + 19 / 21 * (C189 + 19 / 21 * (C210 + 19 / 21 * (C231 + 19 / 21 * (C252 + 19 / 21 * (C273 + 19 / 21 * (C294 + 19 / 21 * (C315 + 19 / 21 * (C336 + 19 / 21 * (C357 + 19 / 21 * (C378 + 19 / 21 * (C399 + 19 / 21 * (C420 + 19 / 21 * (C441 + 19 / 21 * (C462 + 19 / 21 * (C483 + 19 / 21 * (C504 + 19 / 21 * (C525 + 19 / 21 * (C546 + 19 / 21 * (C567 + 19 / 21 * (C588 + 19 / 21 * (C609 + 19 / 21 * (C630 + 19 / 21 * (C651 + 19 / 21 * (C672 + 19 / 21 * (C693 + 19 / 21 * (C714 + 19 / 21 * (C735 + 19 / 21 * (C756 + 19 / 21 * (C777 + 19 / 21 * (C798 + 19 / 21 * (C819 + 19 / 21 * (C840 + 19 / 21 * (C861 + 19 / 21 * (C882 + 19 / 21 * (C903 + 19 / 21 * (C924 + 19 / 21 * (C945 + 19 / 21 * (C966 + 19 / 21 * (C987 + 19 / 21 * (C1008 + 19 / 21 * (C1029 + 19 / 21 * (C1050 + 19 / 21 * (C1071 + 19 / 21 * (C1092 + 19 / 21 * (C1113 + 19 / 21 * (C1134 + 19 / 21 * (C1155 + 19 / 21 * (C1176 + 19 / 21 * (C1197 + 19 / 21 * (C1218 + 19 / 21 * (C1239 + 19 / 21 * (C1260 + 19 / 21 * (C1281 + 19 / 21 * (C1302 + 19 / 21 * (C1323 + 19 / 21 * (C1344 + 19 / 21 * (C1365 + 19 / 21 * (C1386 + 19 / 21 * (C1407 + 19 / 21 * (C1428 + 19 / 21 * (C1449))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Cascades of Moving Averages
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|