Registered User Joined: 10/7/2004 Posts: 45

Hi  If I want to write a condition in SF12 looking for situations where "todays" volume is 50% greater than the 20 day average volume, is the formula V>(Avg(V,20)*1.50)?Thanks very much!

Worden Trainer
Joined: 10/7/2004 Posts: 64,305

That should work in TC2000.
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
Bruce Personal Criteria Formulas TC2000 Support Articles

Registered User Joined: 10/7/2004 Posts: 45

Thanks, Bruce! What is the ".z" after the "x" in so many of the formulas?Thanks

Worden Trainer
Joined: 10/7/2004 Posts: 64,305

It is on optional parameter for the number of bars ago if you want to check a past value.
Bruce Personal Criteria Formulas TC2000 Support Articles

Gold Customer
Joined: 11/16/2015 Posts: 105

Bruce I would like to create this formula, Average 20 day volume 300K, I'm trying to add these other two formulas, this is the second one, minvol 20 > 200k is true daily, and then this is the third one,14 PERIOD ATR 0.30 Average, I think I got that first formula correct, cuz I'm trying to go into the page with what I want and see what I come up with but as usual it gets a little chaotic but I think this is right,
Average 20 day volume 300K
AVGH20  AVGL20 > 1 AND AVGV20 > 30000

Worden Trainer
Joined: 10/7/2004 Posts: 64,305

The first formula about the average 20 day volume greater than 300K is close, but missing a zero (or the 300K has an extra zero and should be 30K).
AVGV20 > 300000
The second formula about minvol 20 > 200k should be:
MINV20 > 200000
And the third one, 14 Period ATR > 0.30 can be writtes as follows in TC2000 v17.
ATR14 > .3
So if you wanted to combine them all into a singel formula, you would get the following.
ATR14 > .3 AND AVGV20 > 300000 AND MINV20 > 200000
Bruce Personal Criteria Formulas TC2000 Support Articles

Registered User Joined: 6/14/2016 Posts: 1

I am trying to find stocks with today's volume 2.5 times greater than the average volume in the past 20 days. Can you help?

Worden Trainer
Joined: 10/7/2004 Posts: 64,305

Please try the following condition formula.
V >2.5 * AVGV20.1
Bruce Personal Criteria Formulas TC2000 Support Articles
