Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Gold Customer
Joined: 9/29/2007 Posts: 19
|
Hi, I am trying to make a PCF to give me stocks up on the session with volume higher than the max negative volume (stock closing lower) of the past ten sessions. This is what I came up with but I don't think (or know) if it's correct.
C > C1 AND ((V > MAXV10 AND C1 < C2) OR (V > MAXV10 AND C2 < C3) OR (V > MAXV10 AND C3 < C4) OR (V > MAXV10 AND C4 < C5) OR (V > MAXV10 AND C5 < C6) OR (V > MAXV10 AND C6 > C7) OR (V > MAXV10 AND C7 < C8) OR (V > MAXV10 AND C8 < C9) OR (V > MAXV10 AND C9 < C10) OR (V > MAXV10 AND C10 < C11))
Any help would be appreciated - thank you.
|
|
Gold Customer
Joined: 9/29/2007 Posts: 19
|
Slight Typo - sorry.
C > C1 AND ((V > MAXV10 AND C1 < C2) OR (V > MAXV10 AND C2 < C3) OR (V > MAXV10 AND C3 < C4) OR (V > MAXV10 AND C4 < C5) OR (V > MAXV10 AND C5 < C6) OR (V > MAXV10 AND C6 < C7) OR (V > MAXV10 AND C7 < C8) OR (V > MAXV10 AND C8 < C9) OR (V > MAXV10 AND C9 < C10) OR (V > MAXV10 AND C10 < C11))
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following instead:
C > C1 AND V > ABS(C1 < C2) * V1 AND V > ABS(C2 < C3) * V2 AND V > ABS(C3 < C4) * V3 AND V > ABS(C4 < C5) * V4 AND V > ABS(C5 < C6) * V5 AND V > ABS(C6 < C7) * V6 AND V > ABS(C7 < C8) * V7 AND V > ABS(C8 < C9) * V8 AND V > ABS(C9 < C10) * V9 AND V > ABS(C10 < C11) * V10
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Gold Customer
Joined: 9/29/2007 Posts: 19
|
Thank you very much Bruce. I appreciate your help. That seemed to do it.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/6/2005 Posts: 16
|
Bruce:
Can you write the PCF in real code so I can use it in stockfinder5?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The RealCode is provided in Need PCF Converted to S.F.. You just need to set the Period to 10.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |