Registered User
Joined: 12/29/2013
Posts: 71
|
Hi Bruce , I am trying to write a PCF to show stocks that traded 10 % above its average weekly volume in the past 5 days .
Thanks, L.C.
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You can't mix daily and weekly time frames and I'm not quite sure what you mean, so I'll make two guesses.
At least once during the most recent 5 trading days, volume was at least 10% higher than its own 1 week (5 trading day) average volume.
CountTrue(V >= 1.1 * AVGV5, 5) > 0
At least once during the most recent 5 trading days, volume at at least 10% higher than the average (let's say 10 week) of its total weekly volume.
CountTrue(V >= 1.1 * AVG(SUM(V, 5), 50)) > 0
Something else entirely?
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 12/29/2013
Posts: 71
|
The first one worked fine .
Thank you Bruce
L.C.
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|