Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.

 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

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
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 04, 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 04, 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 Customer Training & Support - Ask a Trainer - TC2000 version 12/18 - Ask a Trainer - TC2000 version 7 - Ask a Trainer - StockFinder 5.0 - PCFs, EasyScan and Custom Indicators General Discussions - Stock and Market Talk - TC2000 version 12 or 18 - TC2000 version 7 - StockFinder 5.0 - RealCode for StockFinder 5.0 Tutorial Videos - TC2000 version 12 tutorial videos - TC2000 version 7 tutorial videos 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.