 Gold Customer
Joined: 3/24/2005
Posts: 18
|
Need some help writing a PCF (2007) to show which stocks did at least five times their average 50 day volume at least one day in the past twenty days.
For example if a stock's 50 day average volume was 200K/day, I want the PCF to identify if there was at least one day in the past twenty trading days when it did more then 1 million shares (five times the average daily volume of 200K)
Thanks
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
V >= 5 * AVGV50 OR V1 >= 5 * AVGV50 OR V2 >= 5 * AVGV50 OR V3 >= 5 * AVGV50 OR V4 >= 5 * AVGV50 OR V5 >= 5 * AVGV50 OR V6 >= 5 * AVGV50 OR V7 >= 5 * AVGV50 OR V8 >= 5 * AVGV50 OR V9 >= 5 * AVGV50 OR V10 >= 5 * AVGV50 OR V11 >= 5 * AVGV50 OR V12 >= 5 * AVGV50 OR V13 >= 5 * AVGV50 OR V14 >= 5 * AVGV50 OR V15 >= 5 * AVGV50 OR V16 >= 5 * AVGV50 OR V17 >= 5 * AVGV50 OR V18 >= 5 * AVGV50 OR V19 >= 5 * AVGV50
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|