| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 6/25/2005
Posts: 441
|
i m not sure but there is a posibilty to create a pcf going like this.
price today gap up (L>H1) BUT during the last 21 days there is an open gap down
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If by Open Gap Down you mean:
O < L1
Then please try the following:
L > H1 AND (O1 < L2 OR O2 < L3 OR O3 < L4 OR O4 < L5 OR O5 < L6 OR O6 < L7 OR O7 < L8 OR O8 < L9 OR O9 < L10 OR O10 < L11 OR O11 < L12 OR O12 < L13 OR O13 < L14 OR O14 < L15 OR O15 < L16 OR O16 < L17 OR O17 < L18 OR O18 < L19 OR O19 < L20 OR O20 < L21 OR O21 < L22)
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 6/25/2005
Posts: 441
|
Bruce i just nmake this one can you check it if iots fine?
L>H1 AND H1<L2 OR H2<L3 OR H3<L4 OR H4<L5 OR H5<L6 OR H6<L7 OR H7<L8 OR H8<L9 OR H9<L10 OR H10<L11 OR H11<L12 OR H12<L13 OR H13<L14 OR L14<H15 OR H15<L16 ORH16<L17 OR H17<L18 OR H18<L19 OR H19<L20 OR H20<L21AND C1<H21
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You will want to put parentheses around the OR group:
L > H1 AND (H1 < L2 OR H2 < L3 OR H3 < L4 OR H4 < L5 OR H5 < L6 OR H6 < L7 OR H7 < L8 OR H8 < L9 OR H9 < L10 OR H10 < L11 OR H11 < L12 OR H12 < L13 OR H13 < L14 OR L14 < H15 OR H15 < L16 OR H16 < L17 OR H17 < L18 OR H18 < L19 OR H19 < L20 OR H20 < L21) AND C1 < H21
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 6/25/2005
Posts: 441
|
THX!!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |