Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Minimum Low and Moving Average Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
ehop
Posted : Wednesday, February 13, 2008 1:01:00 PM
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.
Bruce_L
Posted : Wednesday, February 13, 2008 1:09:29 PM


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
ehop
Posted : Thursday, February 14, 2008 1:46:03 PM
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.
Bruce_L
Posted : Thursday, February 14, 2008 1:50:34 PM


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
ehop
Posted : Thursday, February 14, 2008 6:08:14 PM
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?
Bruce_L
Posted : Friday, February 15, 2008 9:36:00 AM


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
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.