| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 7/11/2005
Posts: 12
|
Hello:
I'd like to set up a PCF that only picks those stocks whose last 200 day high was at least 8 weeks ago. I want to combine this scan with a PCF I currently have that scans for stocks that have reached a new 200 day high today (C > MAXH200.1) so that I only get stocks that have reached a new high after at least an 8 week basing process, not those stocks that are consistently hitting new 200-day highs in an uptrend. I have racked my brain to come up with a PCF that can identify those stocks that have not hit a new 200-day high for at least 8 weeks but cannot come up with an idea on how to do it. Again, I see these two PCFs working together to create an Easy Scan that picks out those stocks I'm interested in. Hope it makes sense.
Thanks for all your help!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If you want to just compare the last 40 trading days to the last 200 trading days, you could use something like the following:
MAXH40.1 < MAXH200.1
If you want to actually compare each of the last 40 trading days to the 200 days prior to the day being compared, each comparison would have to be made separately:
H1 < MAXH200.2 AND H2 < MAXH200.3 AND H3 < MAXH200.4 AND H4 < MAXH200.5 AND H5 < MAXH200.6 AND H6 < MAXH200.7 AND H7 < MAXH200.8 AND H8 < MAXH200.9 AND H9 < MAXH200.10 AND H10 < MAXH200.11 AND H11 < MAXH200.12 AND H12 < MAXH200.13 AND H13 < MAXH200.14 AND H14 < MAXH200.15 AND H15 < MAXH200.16 AND H16 < MAXH200.17 AND H17 < MAXH200.18 AND H18 < MAXH200.19 AND H19 < MAXH200.20 AND H20 < MAXH200.21 AND H21 < MAXH200.22 AND H22 < MAXH200.23 AND H23 < MAXH200.24 AND H24 < MAXH200.25 AND H25 < MAXH200.26 AND H26 < MAXH200.27 AND H27 < MAXH200.28 AND H28 < MAXH200.29 AND H29 < MAXH200.30 AND H30 < MAXH200.31 AND H31 < MAXH200.32 AND H32 < MAXH200.33 AND H33 < MAXH200.34 AND H34 < MAXH200.35 AND H35 < MAXH200.36 AND H36 < MAXH200.37 AND H37 < MAXH200.38 AND H38 < MAXH200.39 AND H39 < MAXH200.40 AND H40 < MAXH200.41
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
Days Since Last Peak (or other day-counting needs)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 7/11/2005
Posts: 12
|
Thank you, Bruce!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |