Registered User Joined: 5/28/2009 Posts: 39
|
Hi...I'm thinking of ways to scan for stocks that have been in a smooth uptrend over the last 12 months. Is it possible to write a PCF whereby:
1. high and low for month 2 > high and low for month 1
2. high and low for month 3 > high and low for month 2
etc. up to month 12?
Also...I'm sure you have been asked similar questions before so if you can point me to previous responses that would also be great.
Many thanks,
Piers
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following daily Condition Formula.
MAXH21 > MAXH21.21 AND MINL21 > MINL21.21 AND MAXH21.21 > MAXH21.42 AND MINL21.21 > MINL21.42 AND MAXH21.42 > MAXH21.63 AND MINL21.42 > MINL21.63 AND MAXH21.63 > MAXH21.84 AND MINL21.63 > MINL21.84 AND MAXH21.84 > MAXH21.105 AND MINL21.84 > MINL21.105 AND MAXH21.105 > MAXH21.126 AND MINL21.105 > MINL21.126 AND MAXH21.126 > MAXH21.147 AND MINL21.126 > MINL21.147 AND MAXH21.147 > MAXH21.168 AND MINL21.147 > MINL21.168 AND MAXH21.168 > MAXH21.189 AND MINL21.168 > MINL21.189 AND MAXH21.189 > MAXH21.210 AND MINL21.189 > MINL21.210 AND MAXH21.210 > MAXH21.231 AND MINL21.210 > MINL21.231 AND MAXH21.231 > MAXH21.252 AND MINL21.231 > MINL21.252
How to create and save a Condition (PCF) Formula
How to Create an EasyScan and save it to the Library
The above actually checks for the 12 months in a row being up. If you only want 11 months in a row being up as to not reference the 13 month at all then you would take off the last two terms of the above formula.
MAXH21 > MAXH21.21 AND MINL21 > MINL21.21 AND MAXH21.21 > MAXH21.42 AND MINL21.21 > MINL21.42 AND MAXH21.42 > MAXH21.63 AND MINL21.42 > MINL21.63 AND MAXH21.63 > MAXH21.84 AND MINL21.63 > MINL21.84 AND MAXH21.84 > MAXH21.105 AND MINL21.84 > MINL21.105 AND MAXH21.105 > MAXH21.126 AND MINL21.105 > MINL21.126 AND MAXH21.126 > MAXH21.147 AND MINL21.126 > MINL21.147 AND MAXH21.147 > MAXH21.168 AND MINL21.147 > MINL21.168 AND MAXH21.168 > MAXH21.189 AND MINL21.168 > MINL21.189 AND MAXH21.189 > MAXH21.210 AND MINL21.189 > MINL21.210 AND MAXH21.210 > MAXH21.231 AND MINL21.210 > MINL21.231
-Bruce Personal Criteria Formulas TC2000 Support Articles
|