Registered User Joined: 8/21/2014 Posts: 2
|
I'm looking to create a scan/pcf for the followingÂ
open is near high of previous day (by near I mean a % from hod)
close is near high of day (near would be a %)
ive been trying to figure this out but I'm stuck (and I stink at converting word problems into formulas)
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I'm going to use 1% for both of these. Since the open could be both above and below the high of the previous trading day, we need to check for both possibilities.
.99 * H1 <= O AND O <= 1.01 * H1
Which could also be written as follows.
ABS(O / H1 - 1) <= .01
The close can only be at or below the high of the trading day, so checking for it to be within 1% is a bit simpler.
.99 * H <= C
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|