Registered User Joined: 12/11/2004 Posts: 8
|
What is the PCF that will identify stocks that traded today in the top or bottom third of yesterday's range? Meaning between the high of yesterday and 1./3 below the high or the low of yesterday and 1/3 above the low.
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Condition Formula:
((L1 + 2 * H1) / 3 <= L AND H <= H1) OR (L1 <= L AND H <= (2 * L1 + H1) / 3)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|