Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Average 20 day volume Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
jrixey
Posted : Wednesday, February 29, 2012 1:55:52 PM
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!
Bruce_L
Posted : Wednesday, February 29, 2012 1:57:44 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
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
jrixey
Posted : Wednesday, February 29, 2012 2:03:56 PM
Registered User
Joined: 10/7/2004
Posts: 45
Thanks, Bruce! What is the ".z" after the "x" in so many of the formulas?Thanks
Bruce_L
Posted : Wednesday, February 29, 2012 2:05:46 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
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
855MRZILLA
Posted : Thursday, November 16, 2017 7:15:39 AM

Registered User
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
Bruce_L
Posted : Thursday, November 16, 2017 9:27:24 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

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
hagereseb
Posted : Thursday, October 4, 2018 12:15:15 AM
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?

Bruce_L
Posted : Thursday, October 4, 2018 8:31:40 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Please try the following condition formula.

V >2.5 * AVGV20.1



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.