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 |

PCF to Specify an Amount of Time since New High Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
jbalesh01
Posted : Thursday, January 4, 2007 4:46:37 PM
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!
Bruce_L
Posted : Thursday, January 4, 2007 5:49:22 PM


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
jbalesh01
Posted : Thursday, January 4, 2007 10:54:29 PM
Registered User
Joined: 7/11/2005
Posts: 12
Thank you, Bruce!
Bruce_L
Posted : Friday, January 5, 2007 7:11:07 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

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