Registered User Joined: 8/26/2011 Posts: 19
|
How do you say "average daily volume over the past 30 days is greater than $1mil"? Do you have to create a condition that adds v+v1+v2+v3 etc, all the way up to v29, and then divide by 30? Or does "avgv30" create the same answer? I want to create the PCF which states volume over a period of time and not just at one point of time in the past.
Thank you for your help
Ellen
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
AVGV30 should return exactly the same results (V + V1 + V2 + V3 + V4 + V5 + V6 + V7 + V8 + V9 + V10 + V11 + V12 + V13 + V14 + V15 + V16 + V17 + V18 + V19 + V20 + V21 + V22 + V23 + V24 + V25 + V26 + V27 + V28 + V29) / 30 returns.
So you should be able to write the following to check for the average volume over the most recent 30 bars being at least 1,000,000 shares:
AVGV30 >= 1000000
You did however mention $1mil instead of shares. This would be dollar volume. The short way to write this would be:
AVGV30 * AVGC30
But this is multiplying the average volume by the average price. You will get a different result if you multiply the closing price of each day by the volume of each day.
(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
But note that while this is a better approximation of dollar volume than the shorter version, it is still only an approximation.
You would need to use tick data to accurately calculate dollar volume and there is not enough tick data available in the program (even in Platinum) to do the calculations (nor would there be a good way to determine how many ticks to use for the calculation).
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 8/26/2011 Posts: 19
|
Bruce,
Thank you very much for your help. You have a knack for finding every mistake I make -- you not only patiently answer the question you think I intend to ask, but also provide an answer for what I did indeed ask. Yes I didn't want to ask about dollar volume; it was supposed to be "1 million shares".
Thank you for all you do and sorry to have created extra work for you! Your answer helped me a lot!
Have a good one
Ellen
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|