 Gold Customer
Joined: 3/24/2005
Posts: 18
|
Hi,
I'm trying to write a PCF which would identify the stocks from my lists which have traded to the upside on volumes in excess of four times their 50 day moving average on any one of the past thirty trading days.
Any help would be appreciated,
Thanks!
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following Condition Formula:
V1 > 4 * AVGV50.1 OR V2 > 4 * AVGV50.2 OR V3 > 4 * AVGV50.3 OR V4 > 4 * AVGV50.4 OR V5 > 4 * AVGV50.5 OR V6 > 4 * AVGV50.6 OR V7 > 4 * AVGV50.7 OR V8 > 4 * AVGV50.8 OR V9 > 4 * AVGV50.9 OR V10 > 4 * AVGV50.10 OR V11 > 4 * AVGV50.11 OR V12 > 4 * AVGV50.12 OR V13 > 4 * AVGV50.13 OR V14 > 4 * AVGV50.14 OR V15 > 4 * AVGV50.15 OR V16 > 4 * AVGV50.16 OR V17 > 4 * AVGV50.17 OR V18 > 4 * AVGV50.18 OR V19 > 4 * AVGV50.19 OR V20 > 4 * AVGV50.20 OR V21 > 4 * AVGV50.21 OR V22 > 4 * AVGV50.22 OR V23 > 4 * AVGV50.23 OR V24 > 4 * AVGV50.24 OR V25 > 4 * AVGV50.25 OR V26 > 4 * AVGV50.26 OR V27 > 4 * AVGV50.27 OR V28 > 4 * AVGV50.28 OR V29 > 4 * AVGV50.29 OR V30 > 4 * AVGV50.30
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|