Registered User Joined: 7/21/2012 Posts: 7
|
Hi Bruce!
How do I create a scan condition for locating stocks that have average volume in past 30 days > $1,000,000?
Thanks in advance!
Dan
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You can do it the short way and the results might be good enough.
AVGV30 * AVGC30 > 1000000
That said, calculating an average for each bar will get you closer to the average dollar volume:
(V * C + V1 * C1 + V2 * C2 + V3 * C3 + V4 * C4 + V5 * C5 + V6 * C6 + V7 * C7 + V8 * C8 + V9 * C9 + V10 * C10 + V11 * C11 + V12 * C12 + V13 * C13 + V14 * C14 + V15 * C15 + V16 * C16 + V17 * C17 + V18 * C18 + V19 * C19 + V20 * C20 + V21 * C21 + V22 * C22 + V23 * C23 + V24 * C24 + V25 * C25 + V26 * C26 + V27 * C27 + V28 * C28 + V29 * C29) / 30 > 1000000
But to exactly match the dollar volume, you would need to use tick data (which is not available in the quantities required for the calculations).
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|