| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 11/30/2004
Posts: 33
|
How would I write a pcf for the minmum low over the past 10 days that crossed below its moving average? I used MINL10 <= AVGC21 but that is using the moving average of the close instead of the moving average associated with the minimum low.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Assuming (based on your example formula) that you want a 21-Period Simple Moving Average, please try the following:
MINL10 xDn its own SMA21:
MINL10 < AVG(MINL10,21) AND MINL10.1 >= AVG(MINL10.1,21)
You may wish to review the following:
PCF Formula Descriptions
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/30/2004
Posts: 33
|
My formula doesn't seem to be working. Please explain how I can see the MinL trading between two averages such as the MinL10 less than its 5 day XMA but greater than it's 10 day XMA and the 5 day XMA of the minimum low greater than the 10 day XMA of the MinL10.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
EMA5 of MINL10 above MINL10 and MINL10 above EMA10 of MINL10:
XAVG(MINL10,5) > MINL10 AND MINL10 > XAVG(MINL10,10)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/30/2004
Posts: 33
|
Bruce. Thank you for your help. Tried again and failed. I think I haven't been clear regarding my intent and I apologize for any waste of your time. I was trying to find a way to isolate a pattern like- TRP, 10/25/07. The MinL10 is contained within the 10 and 21 day XMA's with the 10 XMA being greater than the 21 day XMA. Is this possible?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
My Thursday, February 14, 2008 1:50:34 PM ET post contains the formula for different Moving Averages if these Moving Averages are of MINL10. If these Moving Averages are of Price, you would use the following:
XAVGC10 > MINL10 AND MINL10 > XAVGC21
That said, while MINL10 was in this channel for TRP from 10/18/2007 through 10/22/2007, it was out by 10/25/2007.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |