Registered User Joined: 6/28/2013 Posts: 8
|
Hi
Could someone please help me.
I am trying to write a pcf that looks at the incidene of an event over the past x number of day.
As an example. I have a condition for looking for stocks that had volume 3 times average (V>3*AVGV20.1).
I want to write a pcf where the condition is any incidence of 3 times average volume over the past 5 days.
Thanks for your help
Afam
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
In TC2000 v17 this can be written as follows.
CountTrue(V > 3 * AVGV20.1, 5) > 0
In earlier versions of TC2000 you can use the following fomula.
V > 3 * AVG20.1 OR V1 > 3 * AVGV20.2 OR V2 > 3 * AVGV20.3 OR V3 > 3 * AVGV20.4 OR V4 > 3 * AVGV20.5
You could also use the following technique to create the condition usin more steps but just your original formula.
Condition True at Least Once Over x Bars (v16)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 6/28/2013 Posts: 8
|
Hi Bruce
Thanks for your help. Iappreciate it
Afam
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|