| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 12/9/2004
Posts: 48
|
I would very much appreciate help to create the following formulas to use in a pcf:
1. Bar where the close > open, and high < than the highest high of the last 5 bars, and the close > 70% of its range.
2. Bar where close < open, and where it's low > the lowest low of the last 5 bars, and the close is below the lower 70% of its range.
3. Bar where the close > open, and the lowest high of the last 5 bars < SMA20.
4. Bar where the close < open, and the highest low of the last 5 bars > 40SMA
Thanks very much for your assistance....... Bill
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (odejonge) Bar where the close > open, and high < than the highest high of the last 5 bars, and the close > 70% of its range.
Note that "of the last 5 bars" in this context is limited to be the 5-Bars prior to the current Bar because it would otherwise be impossible for the current High to be lower. I've used the same definition for "of the last 5 bars" throughout the rest of my responses.
C > O AND H < MAXH5.1 AND C - L > .7 * (H - L)
QUOTE (odejonge) Bar where close < open, and where it's low > the lowest low of the last 5 bars, and the close is below the lower 70% of its range.
C < O AND L > MINL5.1 AND H - C > .7 * (H - L)
QUOTE (odejonge) Bar where the close > open, and the lowest high of the last 5 bars < SMA20.
C > O AND ((H1 = MINH5.1 AND H1 < AVGC20.1) OR (H2 = MINH5.1 AND H2 < AVGC20.2) OR (H3 = MINH5.1 AND H3 < AVGC20.3) OR (H4 = MINH5.1 AND H4 < AVGC20.4) OR (H5 = MINH5.1 AND H5 < AVGC20.5))
QUOTE (odejonge) Bar where the close < open, and the highest low of the last 5 bars > 40SMABar where the close < open, and the highest low of the last 5 bars > 40SMA
C < O AND ((L1 = MAXL5.1 AND L1 > AVGC40.1) OR (L2 = MAXL5.1 AND L2 > AVGC40.2) OR (L3 = MAXL5.1 AND L3 > AVGC40.3) OR (L4 = MAXL5.1 AND L4 > AVGC40.4) OR (L5 = MAXL5.1 AND L5 > AVGC40.5))
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: 12/9/2004
Posts: 48
|
Please also provide a formula for:
Bar where the highest low of the last 5 bars > SMA 20 (of the highest low five bar); OR the highest low of the last 5 bars > SMA 40 (as of the highest low five bar). I think I must have left something out on the original "quote".
Thanks again for your help.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
(L1 = MAXL5.1 AND (L1 > AVGC20.1 OR L1 > AVGC40.1)) OR (L2 = MAXL5.1 AND (L2 > AVGC20.2 OR L2 > AVGC40.2)) OR (L3 = MAXL5.1 AND (L3 > AVGC20.3 OR L3 > AVGC40.3)) OR (L4 = MAXL5.1 AND (L4 > AVGC20.4 OR L4 > AVGC40.4)) OR (L5 = MAXL5.1 AND(L5 > AVGC20.5 OR L5 > AVGC40.5))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/9/2004
Posts: 48
|
Thanks Bruce... so far looks like my pcf's are working out well. Now we'll see if they will work for "real".
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |