Registered User Joined: 2/28/2005 Posts: 30
|
In TC2000 v12. Would below be the pcf formula for volume ave over 1 million for 20 days? Thx.
(AVGC20*AVGV20)>=10000
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Multiplying the averages of price and volume does not give the same result as multiplying price and volume and taking the average (although it can be close). You would want something more like the following instead:
(C * V + C1 * V1 + C2 * V2 + C3 * V3 + C4 * V4 + C5 * V5 + C6 * V6 + C7 * V7 + C8 * V8 + C9 * V9 + C10 * V10 + C11 * V11 + C12 * V12 + C13 * V13 + C14 * V14 + C15 * V15 + C16 * V16 + C17 * V17 + C18 * V18 + C19 * V19) / 20 > 1000000
Note that in TC2000 version 12, volume is reported in actual shares, so we do not get rid of two zeros in the formulas would need to be done in TC2000 version 7 (where volume is reported in blocks of 100 shares).
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|