| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 5/17/2006
Posts: 493
|
hi bruce, thx for the previous pcf help, i need help with one more pcf.
1. anytime the 10 period simple moving average crosses to the upside the 30 period simple moving average and anytime after that including the day of, the bar closes lower than when the cross happened. this will only happen with a max up to 5 days after the cross.
2. anytime the 10 period simple moving average crosses to the downside the 30 period simple moving average and anytime after that including the day of, the bar closes higher than when the cross happened. this will happen only max up to 5 days after the cross.
|
|
Registered User
Joined: 5/17/2006
Posts: 493
|
bruce, one modification,
1. anytime the 10 period simple moving average crosses to the upside the 30 period simple moving average and anytime after that , the bar closes lower than the previous bar from the time of the cross. example on 7-27-09, ticker URS had the 10 cross the 30 ma, it kept moving higher and on 7-29-09, the bar closed lower than the previous bar and the next day, the price penetradted the highof the bar that closed down, thats what i'm looking for up to a max of 5 days after the ma cross. can this be done?
2. same thing but to the downside ma cross.
|
|
Registered User
Joined: 5/17/2006
Posts: 493
|
so one more example to the downside bruce,
ticker SNDA, on 6-24-09, the 10ma crossed the 30 to the downside, that bar was actually up, so was the next bar and so was the next bar, on 6-29-09, the price penetrated the low of the bar from the previous day, thats what i would like the pcf to catch, same to the upside ma cross as detailed above,
thanks,
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try one or more of the following Personal Criteria Formulas:
Negative Net Change and SMA10 xUp SMA30 from current Bar to 5-Bars Ago (matches URS example):
C < C1 AND ((AVGC10 > AVGC30 AND AVGC10.1 <= AVGC30.1) OR (AVGC10.1 > AVGC30.1 AND AVGC10.2 <= AVGC30.2) OR (AVGC10.2 > AVGC30.2 AND AVGC10.3 <= AVGC30.3) OR (AVGC10.3 > AVGC30.3 AND AVGC10.4 <= AVGC30.4) OR (AVGC10.4 > AVGC30.4 AND AVGC10.5 <= AVGC30.5) OR (AVGC10.5 > AVGC30.5 AND AVGC10.6 <= AVGC30.6))
Positive Net Change and SMA10 xUp SMA30 from current Bar to 5-Bars Ago (matches SDNA example):
C > C1 AND ((AVGC10 > AVGC30 AND AVGC10.1 <= AVGC30.1) OR (AVGC10.1 > AVGC30.1 AND AVGC10.2 <= AVGC30.2) OR (AVGC10.2 > AVGC30.2 AND AVGC10.3 <= AVGC30.3) OR (AVGC10.3 > AVGC30.3 AND AVGC10.4 <= AVGC30.4) OR (AVGC10.4 > AVGC30.4 AND AVGC10.5 <= AVGC30.5) OR (AVGC10.5 > AVGC30.5 AND AVGC10.6 <= AVGC30.6))
Negative Net Change and SMA10 xDn SMA30 from current Bar to 5-Bars Ago:
C < C1 AND ((AVGC10 < AVGC30 AND AVGC10.1 >= AVGC30.1) OR (AVGC10.1 < AVGC30.1 AND AVGC10.2 >= AVGC30.2) OR (AVGC10.2 < AVGC30.2 AND AVGC10.3 >= AVGC30.3) OR (AVGC10.3 < AVGC30.3 AND AVGC10.4 >= AVGC30.4) OR (AVGC10.4 < AVGC30.4 AND AVGC10.5 >= AVGC30.5) OR (AVGC10.5 < AVGC30.5 AND AVGC10.6 >= AVGC30.6))
Positive Net Change and SMA10 xDn SMA30 from current Bar to 5-Bars Ago:
C > C1 AND ((AVGC10 < AVGC30 AND AVGC10.1 >= AVGC30.1) OR (AVGC10.1 < AVGC30.1 AND AVGC10.2 >= AVGC30.2) OR (AVGC10.2 < AVGC30.2 AND AVGC10.3 >= AVGC30.3) OR (AVGC10.3 < AVGC30.3 AND AVGC10.4 >= AVGC30.4) OR (AVGC10.4 < AVGC30.4 AND AVGC10.5 >= AVGC30.5) OR (AVGC10.5 < AVGC30.5 AND AVGC10.6 >= AVGC30.6))
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: 5/17/2006
Posts: 493
|
thx bruce, amazing job...
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |