| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 8/4/2008
Posts: 12
|
The following PCF seems to be formulated correctly and gives correct results,
H > O * 1.034 AND H1 > O1 * 1.034 AND H2 > O2 * 1.034 AND H3 > O3 * 1.034 AND H4 > O4 * 1.034 AND AVGV5 > 800 AND C > 3.6 AND C < 200
I try to use the same format and change both the % (up over the open) and number of days. This new PCF triggers Syntax Error. Can you explain what I am doing wrong?
H > O * 1.0258 AND H1 > O1 * 1.0258 AND H2 > O2 * 1.0258 AND H3 > O3 * 1.0258 AND H4 > O4 * 1.0258 AND H5 > O5 * 1.0258 AND H6 > O6 * 1.0258 AND H7 > O7 * 1.0258 AND H8 > O8 * 1.0258 AND H9 > O9 * 1.0258 AND H10 > O10 * ANDH11> O11 * 1.0258 AND H12 > O12 * 1.0258 AND AVGV5 > 800 AND C > 3.5 AND C < 200
Thanks - Chato
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The H10 > O10 * term is missing the 1.0258. Please try the following instead:
H > O * 1.0258 AND H1 > O1 * 1.0258 AND H2 > O2 * 1.0258 AND H3 > O3 * 1.0258 AND H4 > O4 * 1.0258 AND H5 > O5 * 1.0258 AND H6 > O6 * 1.0258 AND H7 > O7 * 1.0258 AND H8 > O8 * 1.0258 AND H9 > O9 * 1.0258 AND H10 > O10 * 1.0258 AND H11> O11 * 1.0258 AND H12 > O12 * 1.0258 AND AVGV5 > 800 AND C > 3.5 AND C < 200
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
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: 8/4/2008
Posts: 12
|
Many thanks Bruce, I am finally getting the hang of it - Chato
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |