Registered User Joined: 11/10/2014 Posts: 5
|
Is there a formula to show stocks that are within x amount of cents from a moving average? I have a formula for pivot points that works great but not certain if the above is doable.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you wanted price to be within 10 cents from a 20 period simple moving average you could use the following.
ABS(C - AVGC20) <= .10
You can adjust the moving average and the number of cents as desired.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|