Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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!
|
|
![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) 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
|
|
Registered User Joined: 10/7/2004 Posts: 45
|
Thanks, Bruce! What is the ".z" after the "x" in so many of the formulas?Thanks
|
|
![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) 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
|
|
![](/image.aspx?url=http%3a%2f%2fi38.photobucket.com%2falbums%2fe123%2f855MRZILLA%2fFor%2520The%2520Stock%2520Market_zpsjsc219fn.jpg&width=100&height=100) 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
|
|
![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) 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
|
|
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?
|
|
![](/image.aspx?url=http%3a%2f%2fvideos.worden.com%2fforums%2favatars%2fbruceavatar.gif&width=100&height=100)
![](/images/ranks/WordenWing.gif) 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
|
|
Guest-1 |