Registered User
Joined: 8/29/2007
Posts: 31
|
I am looking for a way to see if a closing price crosses up through a moviing average.
The tricky part (for me) is I want it to have been lower than the MA in any of the last 8 days or at least within 0.02%.
So If not yesterday well how about the day before, or the day before...
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I'm actually not sure from the question if this is what you want, but the following Personal Criteria Formula should return True if the Close is currently above the 20-Period Exponential Moving Average, but was below it at some point during the previous 8-Days:
C > XAVGC20 AND (C1 < XAVGC20.1 OR C2 < XAVGC20.2 OR C3 < XAVGC20.3 OR C4 < XAVGC20.4 OR C5 < XAVGC20.5 OR C6 < XAVGC20.6 OR C7 < XAVGC20.7 OR C8 < XAVGC20.8)
You may wish to review the following:
Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"
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
|
Registered User
Joined: 8/29/2007
Posts: 31
|
Bruce, that will get me where I want to be. thanks - While I wrote the original question, I was on the line with Tech support to fix a security problem that was preventing me from posting.
steve
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|