Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Price within a set amount above/below moving average Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
tdd2672
Posted : Sunday, December 18, 2016 5:43:30 PM
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.

Bruce_L
Posted : Monday, December 19, 2016 10:06:04 AM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.