Registered User Joined: 12/31/2010 Posts: 81
|
Hello I am looking for a PCF that will show me stocks that are:
1) Positive at lease 5% for over the past 20 trading days
2) Over the past 20 trading days, the average volume on the positive days is greater than the volume on the negative days
3) Average daily volume over the past 50 trading days is 100,000 shares or above
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Condition Formula:
C >= 1.05 * C20 AND (ABS(C > C1) * V - (C1 > C2) * V1 - (C2 > C3) * V2 - (C3 > C4) * V3 - (C4 > C5) * V4 - (C5 > C6) * V5 - (C6 > C7) * V6 - (C7 > C8) * V7 - (C8 > C9) * V8 - (C9 > C10) * V9 - (C10 > C11) * V10 - (C11 > C12) * V11 - (C12 > C13) * V12 - (C13 > C14) * V13 - (C14 > C15) * V14 - (C15 > C16) * V15 - (C16 > C17) * V16 - (C17 > C18) * V17 - (C18 > C19) * V18 - (C19 > C20) * V19) / (ABS(C > C1) - (C1 > C2) - (C2 > C3) - (C3 > C4) - (C4 > C5) - (C5 > C6) - (C6 > C7) - (C7 > C8) - (C8 > C9) - (C9 > C10) - (C10 > C11) - (C11 > C12) - (C12 > C13) - (C13 > C14) - (C14 > C15) - (C15 > C16) - (C16 > C17) - (C17 > C18) - (C18 > C19) - (C19 > C20) + .0000001) > (ABS(C < C1) * V - (C1 < C2) * V1 - (C2 < C3) * V2 - (C3 < C4) * V3 - (C4 < C5) * V4 - (C5 < C6) * V5 - (C6 < C7) * V6 - (C7 < C8) * V7 - (C8 < C9) * V8 - (C9 < C10) * V9 - (C10 < C11) * V10 - (C11 < C12) * V11 - (C12 < C13) * V12 - (C13 < C14) * V13 - (C14 < C15) * V14 - (C15 < C16) * V15 - (C16 < C17) * V16 - (C17 < C18) * V17 - (C18 < C19) * V18 - (C19 < C20) * V19) / (ABS(C < C1) - (C1 < C2) - (C2 < C3) - (C3 < C4) - (C4 < C5) - (C5 < C6) - (C6 < C7) - (C7 < C8) - (C8 < C9) - (C9 < C10) - (C10 < C11) - (C11 < C12) - (C12 < C13) - (C13 < C14) - (C14 < C15) - (C15 < C16) - (C16 < C17) - (C17 < C18) - (C18 < C19) - (C19 < C20) + .0000001) AND AVGV50 >= 100000
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: 12/31/2010 Posts: 81
|
thank you so much
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|