Registered User Joined: 3/12/2017 Posts: 6
|
Hi, is it possible to write a formula that will determine if two moving averages are within a certain percentage of each other? For instance, the 10 day moving average is within 3% of the 20 day?
Thanks in advance.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following.
ABS(AVGC10 / AVGC20 - 1) <= .03
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 3/12/2017 Posts: 6
|
Nice. I will. Thanks for the quick reply.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|