New version 18 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Request PCF Formula Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
raider45
Posted : Friday, August 26, 2016 12:28:54 PM
Registered User
Joined: 9/30/2011
Posts: 630
 
I would like to know if you can have a Formula PCF with the signal on the Support and Resistance by Barry indicator, starting from the next candle Pin Bar.
 
5 * ABS (O - C) <= O - THE 5 * ABS (O - C) <= C - THE 2 + 2 * O * C> 3 * H + L and H - L> AVGH6 - AVGL6 EL = MINL6 and 5 * (C - C5) + 3 * (C1 - C4) + C2 <C3 and AVGC3 <AVGC3.3
 
 
Thank you in advance and greetings from Italy.
Rosario Columbro
Bruce_L
Posted : Friday, August 26, 2016 12:59:12 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

Do you want dots to start drawing at each Pin Bar until the next Pin Bar happens? If so, I will probably only be able to do so for a fairly limited number of bars (fewer than normally occur between Pin Bars).

Or do you want try to reproduce the Support and Resistance (Barry) indicator? I can probably draw dots from the most recent swing high and swing low (which is how I assume it works) but I don't know how many lower highs or higher lows need to happen before each swing. I also wouldn't be able to draw faded versions for the two prior swing highs and lows.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Friday, August 26, 2016 1:44:07 PM
Registered User
Joined: 9/30/2011
Posts: 630
Yes, the play Barry indicator with support and resistance.
Or do you want try to reproduce the Support and Resistance (Barry) indicator?
R.C.
Bruce_L
Posted : Friday, August 26, 2016 1:50:10 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

We can use a Custom PCF Indicator in the same pane and scale as price to plot the Swing High where it is detected.

- Plot Style: Dots
- Plot Color: Up to you.
- Period: 1
- Average Type: Doesn't matter (because the Period is 1).
- Formula: ABS(MAXH3 < H3 AND H3 > MAXH3.4) * H3 + ABS(MAXH3 >= H3 OR H3 <= MAXH3.4) * (ABS(MAXH3.1 < H4 AND H4 > MAXH3.5) * H4 + ABS(MAXH3.1 >= H4 OR H4 <= MAXH3.5) * (ABS(MAXH3.2 < H5 AND H5 > MAXH3.6) * H5 + ABS(MAXH3.2 >= H5 OR H5 <= MAXH3.6) * (ABS(MAXH3.3 < H6 AND H6 > MAXH3.7) * H6 + ABS(MAXH3.3 >= H6 OR H6 <= MAXH3.7) * (ABS(MAXH3.4 < H7 AND H7 > MAXH3.8) * H7 + ABS(MAXH3.4 >= H7 OR H7 <= MAXH3.8) * (ABS(MAXH3.5 < H8 AND H8 > MAXH3.9) * H8 + ABS(MAXH3.5 >= H8 OR H8 <= MAXH3.9) * (ABS(MAXH3.6 < H9 AND H9 > MAXH3.10) * H9 + ABS(MAXH3.6 >= H9 OR H9 <= MAXH3.10) * (ABS(MAXH3.7 < H10 AND H10 > MAXH3.11) * H10 + ABS(MAXH3.7 >= H10 OR H10 <= MAXH3.11) * (ABS(MAXH3.8 < H11 AND H11 > MAXH3.12) * H11 + ABS(MAXH3.8 >= H11 OR H11 <= MAXH3.12) * (ABS(MAXH3.9 < H12 AND H12 > MAXH3.13) * H12 + ABS(MAXH3.9 >= H12 OR H12 <= MAXH3.13) * (ABS(MAXH3.10 < H13 AND H13 > MAXH3.14) * H13 + ABS(MAXH3.10 >= H13 OR H13 <= MAXH3.14) * (ABS(MAXH3.11 < H14 AND H14 > MAXH3.15) * H14 + ABS(MAXH3.11 >= H14 OR H14 <= MAXH3.15) * (ABS(MAXH3.12 < H15 AND H15 > MAXH3.16) * H15 + ABS(MAXH3.12 >= H15 OR H15 <= MAXH3.16) * (ABS(MAXH3.13 < H16 AND H16 > MAXH3.17) * H16 + ABS(MAXH3.13 >= H16 OR H16 <= MAXH3.17) * (ABS(MAXH3.14 < H17 AND H17 > MAXH3.18) * H17 + ABS(MAXH3.14 >= H17 OR H17 <= MAXH3.18) * (ABS(MAXH3.15 < H18 AND H18 > MAXH3.19) * H18 + ABS(MAXH3.15 >= H18 OR H18 <= MAXH3.19) * (ABS(MAXH3.16 < H19 AND H19 > MAXH3.20) * H19 + ABS(MAXH3.16 >= H19 OR H19 <= MAXH3.20) * (ABS(MAXH3.17 < H20 AND H20 > MAXH3.21) * H20 + ABS(MAXH3.17 >= H20 OR H20 <= MAXH3.21) * (ABS(MAXH3.18 < H21 AND H21 > MAXH3.22) * H21 + ABS(MAXH3.18 >= H21 OR H21 <= MAXH3.22) * (ABS(MAXH3.19 < H22 AND H22 > MAXH3.23) * H22 + ABS(MAXH3.19 >= H22 OR H22 <= MAXH3.23) * (ABS(MAXH3.20 < H23 AND H23 > MAXH3.24) * H23 + ABS(MAXH3.20 >= H23 OR H23 <= MAXH3.24) * (ABS(MAXH3.21 < H24 AND H24 > MAXH3.25) * H24 + ABS(MAXH3.21 >= H24 OR H24 <= MAXH3.25) * (ABS(MAXH3.22 < H25 AND H25 > MAXH3.26) * H25 + ABS(MAXH3.22 >= H25 OR H25 <= MAXH3.26) * (ABS(MAXH3.23 < H26 AND H26 > MAXH3.27) * H26 + ABS(MAXH3.23 >= H26 OR H26 <= MAXH3.27) * (ABS(MAXH3.24 < H27 AND H27 > MAXH3.28) * H27 + ABS(MAXH3.24 >= H27 OR H27 <= MAXH3.28) * (ABS(MAXH3.25 < H28 AND H28 > MAXH3.29) * H28 + ABS(MAXH3.25 >= H28 OR H28 <= MAXH3.29) * (ABS(MAXH3.26 < H29 AND H29 > MAXH3.30) * H29 + ABS(MAXH3.26 >= H29 OR H29 <= MAXH3.30) * (ABS(MAXH3.27 < H30 AND H30 > MAXH3.31) * H30 + ABS(MAXH3.27 >= H30 OR H30 <= MAXH3.31) * (ABS(MAXH3.28 < H31 AND H31 > MAXH3.32) * H31 + ABS(MAXH3.28 >= H31 OR H31 <= MAXH3.32) * (ABS(MAXH3.29 < H32 AND H32 > MAXH3.33) * H32 + ABS(MAXH3.29 >= H32 OR H32 <= MAXH3.33) * (ABS(MAXH3.30 < H33 AND H33 > MAXH3.34) * H33 + ABS(MAXH3.30 >= H33 OR H33 <= MAXH3.34) * (ABS(MAXH3.31 < H34 AND H34 > MAXH3.35) * H34 + ABS(MAXH3.31 >= H34 OR H34 <= MAXH3.35) * (ABS(MAXH3.32 < H35 AND H35 > MAXH3.36) * H35 + ABS(MAXH3.32 >= H35 OR H35 <= MAXH3.36) * (ABS(MAXH3.33 < H36 AND H36 > MAXH3.37) * H36 + ABS(MAXH3.33 >= H36 OR H36 <= MAXH3.37) * (ABS(MAXH3.34 < H37 AND H37 > MAXH3.38) * H37 + ABS(MAXH3.34 >= H37 OR H37 <= MAXH3.38) * (ABS(MAXH3.35 < H38 AND H38 > MAXH3.39) * H38 + ABS(MAXH3.35 >= H38 OR H38 <= MAXH3.39) * (ABS(MAXH3.36 < H39 AND H39 > MAXH3.40) * H39 + ABS(MAXH3.36 >= H39 OR H39 <= MAXH3.40) * (ABS(MAXH3.37 < H40 AND H40 > MAXH3.41) * H40 + ABS(MAXH3.37 >= H40 OR H40 <= MAXH3.41) * (ABS(MAXH3.38 < H41 AND H41 > MAXH3.42) * H41 + ABS(MAXH3.38 >= H41 OR H41 <= MAXH3.42) * (ABS(MAXH3.39 < H42 AND H42 > MAXH3.43) * H42 + ABS(MAXH3.39 >= H42 OR H42 <= MAXH3.43) * (ABS(MAXH3.40 < H43 AND H43 > MAXH3.44) * H43 + ABS(MAXH3.40 >= H43 OR H43 <= MAXH3.44) * (ABS(MAXH3.41 < H44 AND H44 > MAXH3.45) * H44 + ABS(MAXH3.41 >= H44 OR H44 <= MAXH3.45) * (ABS(MAXH3.42 < H45 AND H45 > MAXH3.46) * H45 + ABS(MAXH3.42 >= H45 OR H45 <= MAXH3.46) * (ABS(MAXH3.43 < H46 AND H46 > MAXH3.47) * H46 + ABS(MAXH3.43 >= H46 OR H46 <= MAXH3.47) * (ABS(MAXH3.44 < H47 AND H47 > MAXH3.48) * H47 + ABS(MAXH3.44 >= H47 OR H47 <= MAXH3.48) * (ABS(MAXH3.45 < H48 AND H48 > MAXH3.49) * H48 + ABS(MAXH3.45 >= H48 OR H48 <= MAXH3.49) * (ABS(MAXH3.46 < H49 AND H49 > MAXH3.50) * H49 + ABS(MAXH3.46 >= H49 OR H49 <= MAXH3.50) * (ABS(MAXH3.47 < H50 AND H50 > MAXH3.51) * H50 + ABS(MAXH3.47 >= H50 OR H50 <= MAXH3.51) * (ABS(MAXH3.48 < H51 AND H51 > MAXH3.52) * H51 + ABS(MAXH3.48 >= H51 OR H51 <= MAXH3.52) * (ABS(MAXH3.49 < H52 AND H52 > MAXH3.53) * H52 + ABS(MAXH3.49 >= H52 OR H52 <= MAXH3.53) * (ABS(MAXH3.50 < H53 AND H53 > MAXH3.54) * H53 + ABS(MAXH3.50 >= H53 OR H53 <= MAXH3.54) * (ABS(MAXH3.51 < H54 AND H54 > MAXH3.55) * H54 + ABS(MAXH3.51 >= H54 OR H54 <= MAXH3.55) * (ABS(MAXH3.52 < H55 AND H55 > MAXH3.56) * H55 + ABS(MAXH3.52 >= H55 OR H55 <= MAXH3.56) * (ABS(MAXH3.53 < H56 AND H56 > MAXH3.57) * H56 + ABS(MAXH3.53 >= H56 OR H56 <= MAXH3.57) * (ABS(MAXH3.54 < H57 AND H57 > MAXH3.58) * H57 + ABS(MAXH3.54 >= H57 OR H57 <= MAXH3.58) * (ABS(MAXH3.55 < H58 AND H58 > MAXH3.59) * H58 + ABS(MAXH3.55 >= H58 OR H58 <= MAXH3.59) * (ABS(MAXH3.56 < H59 AND H59 > MAXH3.60) * H59 + ABS(MAXH3.56 >= H59 OR H59 <= MAXH3.60) * (ABS(MAXH3.57 < H60 AND H60 > MAXH3.61) * H60 + ABS(MAXH3.57 >= H60 OR H60 <= MAXH3.61) * (ABS(MAXH3.58 < H61 AND H61 > MAXH3.62) * H61 + ABS(MAXH3.58 >= H61 OR H61 <= MAXH3.62) * (ABS(MAXH3.59 < H62 AND H62 > MAXH3.63) * H62 + ABS(MAXH3.59 >= H62 OR H62 <= MAXH3.63) * MAXH63)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

And another Custom PCF Indicator in the same pane and scale as price to plot the Swing Low where it is detected:

- Plot Style: Dots
- Plot Color: Up to you.
- Period: 1
- Average Type: Doesn't matter (because the Period is 1).
- Formula: ABS(MINL3 > L3 AND L3 < MINL3.4) * L3 + ABS(MINL3 <= L3 OR L3 >= MINL3.4) * (ABS(MINL3.1 > L4 AND L4 < MINL3.5) * L4 + ABS(MINL3.1 <= L4 OR L4 >= MINL3.5) * (ABS(MINL3.2 > L5 AND L5 < MINL3.6) * L5 + ABS(MINL3.2 <= L5 OR L5 >= MINL3.6) * (ABS(MINL3.3 > L6 AND L6 < MINL3.7) * L6 + ABS(MINL3.3 <= L6 OR L6 >= MINL3.7) * (ABS(MINL3.4 > L7 AND L7 < MINL3.8) * L7 + ABS(MINL3.4 <= L7 OR L7 >= MINL3.8) * (ABS(MINL3.5 > L8 AND L8 < MINL3.9) * L8 + ABS(MINL3.5 <= L8 OR L8 >= MINL3.9) * (ABS(MINL3.6 > L9 AND L9 < MINL3.10) * L9 + ABS(MINL3.6 <= L9 OR L9 >= MINL3.10) * (ABS(MINL3.7 > L10 AND L10 < MINL3.11) * L10 + ABS(MINL3.7 <= L10 OR L10 >= MINL3.11) * (ABS(MINL3.8 > L11 AND L11 < MINL3.12) * L11 + ABS(MINL3.8 <= L11 OR L11 >= MINL3.12) * (ABS(MINL3.9 > L12 AND L12 < MINL3.13) * L12 + ABS(MINL3.9 <= L12 OR L12 >= MINL3.13) * (ABS(MINL3.10 > L13 AND L13 < MINL3.14) * L13 + ABS(MINL3.10 <= L13 OR L13 >= MINL3.14) * (ABS(MINL3.11 > L14 AND L14 < MINL3.15) * L14 + ABS(MINL3.11 <= L14 OR L14 >= MINL3.15) * (ABS(MINL3.12 > L15 AND L15 < MINL3.16) * L15 + ABS(MINL3.12 <= L15 OR L15 >= MINL3.16) * (ABS(MINL3.13 > L16 AND L16 < MINL3.17) * L16 + ABS(MINL3.13 <= L16 OR L16 >= MINL3.17) * (ABS(MINL3.14 > L17 AND L17 < MINL3.18) * L17 + ABS(MINL3.14 <= L17 OR L17 >= MINL3.18) * (ABS(MINL3.15 > L18 AND L18 < MINL3.19) * L18 + ABS(MINL3.15 <= L18 OR L18 >= MINL3.19) * (ABS(MINL3.16 > L19 AND L19 < MINL3.20) * L19 + ABS(MINL3.16 <= L19 OR L19 >= MINL3.20) * (ABS(MINL3.17 > L20 AND L20 < MINL3.21) * L20 + ABS(MINL3.17 <= L20 OR L20 >= MINL3.21) * (ABS(MINL3.18 > L21 AND L21 < MINL3.22) * L21 + ABS(MINL3.18 <= L21 OR L21 >= MINL3.22) * (ABS(MINL3.19 > L22 AND L22 < MINL3.23) * L22 + ABS(MINL3.19 <= L22 OR L22 >= MINL3.23) * (ABS(MINL3.20 > L23 AND L23 < MINL3.24) * L23 + ABS(MINL3.20 <= L23 OR L23 >= MINL3.24) * (ABS(MINL3.21 > L24 AND L24 < MINL3.25) * L24 + ABS(MINL3.21 <= L24 OR L24 >= MINL3.25) * (ABS(MINL3.22 > L25 AND L25 < MINL3.26) * L25 + ABS(MINL3.22 <= L25 OR L25 >= MINL3.26) * (ABS(MINL3.23 > L26 AND L26 < MINL3.27) * L26 + ABS(MINL3.23 <= L26 OR L26 >= MINL3.27) * (ABS(MINL3.24 > L27 AND L27 < MINL3.28) * L27 + ABS(MINL3.24 <= L27 OR L27 >= MINL3.28) * (ABS(MINL3.25 > L28 AND L28 < MINL3.29) * L28 + ABS(MINL3.25 <= L28 OR L28 >= MINL3.29) * (ABS(MINL3.26 > L29 AND L29 < MINL3.30) * L29 + ABS(MINL3.26 <= L29 OR L29 >= MINL3.30) * (ABS(MINL3.27 > L30 AND L30 < MINL3.31) * L30 + ABS(MINL3.27 <= L30 OR L30 >= MINL3.31) * (ABS(MINL3.28 > L31 AND L31 < MINL3.32) * L31 + ABS(MINL3.28 <= L31 OR L31 >= MINL3.32) * (ABS(MINL3.29 > L32 AND L32 < MINL3.33) * L32 + ABS(MINL3.29 <= L32 OR L32 >= MINL3.33) * (ABS(MINL3.30 > L33 AND L33 < MINL3.34) * L33 + ABS(MINL3.30 <= L33 OR L33 >= MINL3.34) * (ABS(MINL3.31 > L34 AND L34 < MINL3.35) * L34 + ABS(MINL3.31 <= L34 OR L34 >= MINL3.35) * (ABS(MINL3.32 > L35 AND L35 < MINL3.36) * L35 + ABS(MINL3.32 <= L35 OR L35 >= MINL3.36) * (ABS(MINL3.33 > L36 AND L36 < MINL3.37) * L36 + ABS(MINL3.33 <= L36 OR L36 >= MINL3.37) * (ABS(MINL3.34 > L37 AND L37 < MINL3.38) * L37 + ABS(MINL3.34 <= L37 OR L37 >= MINL3.38) * (ABS(MINL3.35 > L38 AND L38 < MINL3.39) * L38 + ABS(MINL3.35 <= L38 OR L38 >= MINL3.39) * (ABS(MINL3.36 > L39 AND L39 < MINL3.40) * L39 + ABS(MINL3.36 <= L39 OR L39 >= MINL3.40) * (ABS(MINL3.37 > L40 AND L40 < MINL3.41) * L40 + ABS(MINL3.37 <= L40 OR L40 >= MINL3.41) * (ABS(MINL3.38 > L41 AND L41 < MINL3.42) * L41 + ABS(MINL3.38 <= L41 OR L41 >= MINL3.42) * (ABS(MINL3.39 > L42 AND L42 < MINL3.43) * L42 + ABS(MINL3.39 <= L42 OR L42 >= MINL3.43) * (ABS(MINL3.40 > L43 AND L43 < MINL3.44) * L43 + ABS(MINL3.40 <= L43 OR L43 >= MINL3.44) * (ABS(MINL3.41 > L44 AND L44 < MINL3.45) * L44 + ABS(MINL3.41 <= L44 OR L44 >= MINL3.45) * (ABS(MINL3.42 > L45 AND L45 < MINL3.46) * L45 + ABS(MINL3.42 <= L45 OR L45 >= MINL3.46) * (ABS(MINL3.43 > L46 AND L46 < MINL3.47) * L46 + ABS(MINL3.43 <= L46 OR L46 >= MINL3.47) * (ABS(MINL3.44 > L47 AND L47 < MINL3.48) * L47 + ABS(MINL3.44 <= L47 OR L47 >= MINL3.48) * (ABS(MINL3.45 > L48 AND L48 < MINL3.49) * L48 + ABS(MINL3.45 <= L48 OR L48 >= MINL3.49) * (ABS(MINL3.46 > L49 AND L49 < MINL3.50) * L49 + ABS(MINL3.46 <= L49 OR L49 >= MINL3.50) * (ABS(MINL3.47 > L50 AND L50 < MINL3.51) * L50 + ABS(MINL3.47 <= L50 OR L50 >= MINL3.51) * (ABS(MINL3.48 > L51 AND L51 < MINL3.52) * L51 + ABS(MINL3.48 <= L51 OR L51 >= MINL3.52) * (ABS(MINL3.49 > L52 AND L52 < MINL3.53) * L52 + ABS(MINL3.49 <= L52 OR L52 >= MINL3.53) * (ABS(MINL3.50 > L53 AND L53 < MINL3.54) * L53 + ABS(MINL3.50 <= L53 OR L53 >= MINL3.54) * (ABS(MINL3.51 > L54 AND L54 < MINL3.55) * L54 + ABS(MINL3.51 <= L54 OR L54 >= MINL3.55) * (ABS(MINL3.52 > L55 AND L55 < MINL3.56) * L55 + ABS(MINL3.52 <= L55 OR L55 >= MINL3.56) * (ABS(MINL3.53 > L56 AND L56 < MINL3.57) * L56 + ABS(MINL3.53 <= L56 OR L56 >= MINL3.57) * (ABS(MINL3.54 > L57 AND L57 < MINL3.58) * L57 + ABS(MINL3.54 <= L57 OR L57 >= MINL3.58) * (ABS(MINL3.55 > L58 AND L58 < MINL3.59) * L58 + ABS(MINL3.55 <= L58 OR L58 >= MINL3.59) * (ABS(MINL3.56 > L59 AND L59 < MINL3.60) * L59 + ABS(MINL3.56 <= L59 OR L59 >= MINL3.60) * (ABS(MINL3.57 > L60 AND L60 < MINL3.61) * L60 + ABS(MINL3.57 <= L60 OR L60 >= MINL3.61) * (ABS(MINL3.58 > L61 AND L61 < MINL3.62) * L61 + ABS(MINL3.58 <= L61 OR L61 >= MINL3.62) * (ABS(MINL3.59 > L62 AND L62 < MINL3.63) * L62 + ABS(MINL3.59 <= L62 OR L62 >= MINL3.63) * MINL63)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

These indicators should be plotted in the same pane and scale and Price History.

Adding and Moving Indicators

Adding a 1-Period Simple Moving Average to these Custom PCF Indicators allows you to plot the indicators at the Swing High and Swing Low instead of at where they were identified. You just need to set the Offset of the moving average indicators to -3, the Plot Style of the Custom PCF Indicator to Dots and drag the Opacity setting of the Custom PCF Indicators upon which the moving averages are based all the way to the left (making the Custom PCF Indicators invisible).



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Friday, August 26, 2016 2:34:31 PM
Registered User
Joined: 9/30/2011
Posts: 630

I entered the formula with the function NEW - Indicator (PCF) Formula, Message Please enter a Formula.

R.C.

Bruce_L
Posted : Friday, August 26, 2016 2:53:24 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

The Formula to use in the first Custom PCF Indicator is just:

ABS(MAXH3 < H3 AND H3 > MAXH3.4) * H3 + ABS(MAXH3 >= H3 OR H3 <= MAXH3.4) * (ABS(MAXH3.1 < H4 AND H4 > MAXH3.5) * H4 + ABS(MAXH3.1 >= H4 OR H4 <= MAXH3.5) * (ABS(MAXH3.2 < H5 AND H5 > MAXH3.6) * H5 + ABS(MAXH3.2 >= H5 OR H5 <= MAXH3.6) * (ABS(MAXH3.3 < H6 AND H6 > MAXH3.7) * H6 + ABS(MAXH3.3 >= H6 OR H6 <= MAXH3.7) * (ABS(MAXH3.4 < H7 AND H7 > MAXH3.8) * H7 + ABS(MAXH3.4 >= H7 OR H7 <= MAXH3.8) * (ABS(MAXH3.5 < H8 AND H8 > MAXH3.9) * H8 + ABS(MAXH3.5 >= H8 OR H8 <= MAXH3.9) * (ABS(MAXH3.6 < H9 AND H9 > MAXH3.10) * H9 + ABS(MAXH3.6 >= H9 OR H9 <= MAXH3.10) * (ABS(MAXH3.7 < H10 AND H10 > MAXH3.11) * H10 + ABS(MAXH3.7 >= H10 OR H10 <= MAXH3.11) * (ABS(MAXH3.8 < H11 AND H11 > MAXH3.12) * H11 + ABS(MAXH3.8 >= H11 OR H11 <= MAXH3.12) * (ABS(MAXH3.9 < H12 AND H12 > MAXH3.13) * H12 + ABS(MAXH3.9 >= H12 OR H12 <= MAXH3.13) * (ABS(MAXH3.10 < H13 AND H13 > MAXH3.14) * H13 + ABS(MAXH3.10 >= H13 OR H13 <= MAXH3.14) * (ABS(MAXH3.11 < H14 AND H14 > MAXH3.15) * H14 + ABS(MAXH3.11 >= H14 OR H14 <= MAXH3.15) * (ABS(MAXH3.12 < H15 AND H15 > MAXH3.16) * H15 + ABS(MAXH3.12 >= H15 OR H15 <= MAXH3.16) * (ABS(MAXH3.13 < H16 AND H16 > MAXH3.17) * H16 + ABS(MAXH3.13 >= H16 OR H16 <= MAXH3.17) * (ABS(MAXH3.14 < H17 AND H17 > MAXH3.18) * H17 + ABS(MAXH3.14 >= H17 OR H17 <= MAXH3.18) * (ABS(MAXH3.15 < H18 AND H18 > MAXH3.19) * H18 + ABS(MAXH3.15 >= H18 OR H18 <= MAXH3.19) * (ABS(MAXH3.16 < H19 AND H19 > MAXH3.20) * H19 + ABS(MAXH3.16 >= H19 OR H19 <= MAXH3.20) * (ABS(MAXH3.17 < H20 AND H20 > MAXH3.21) * H20 + ABS(MAXH3.17 >= H20 OR H20 <= MAXH3.21) * (ABS(MAXH3.18 < H21 AND H21 > MAXH3.22) * H21 + ABS(MAXH3.18 >= H21 OR H21 <= MAXH3.22) * (ABS(MAXH3.19 < H22 AND H22 > MAXH3.23) * H22 + ABS(MAXH3.19 >= H22 OR H22 <= MAXH3.23) * (ABS(MAXH3.20 < H23 AND H23 > MAXH3.24) * H23 + ABS(MAXH3.20 >= H23 OR H23 <= MAXH3.24) * (ABS(MAXH3.21 < H24 AND H24 > MAXH3.25) * H24 + ABS(MAXH3.21 >= H24 OR H24 <= MAXH3.25) * (ABS(MAXH3.22 < H25 AND H25 > MAXH3.26) * H25 + ABS(MAXH3.22 >= H25 OR H25 <= MAXH3.26) * (ABS(MAXH3.23 < H26 AND H26 > MAXH3.27) * H26 + ABS(MAXH3.23 >= H26 OR H26 <= MAXH3.27) * (ABS(MAXH3.24 < H27 AND H27 > MAXH3.28) * H27 + ABS(MAXH3.24 >= H27 OR H27 <= MAXH3.28) * (ABS(MAXH3.25 < H28 AND H28 > MAXH3.29) * H28 + ABS(MAXH3.25 >= H28 OR H28 <= MAXH3.29) * (ABS(MAXH3.26 < H29 AND H29 > MAXH3.30) * H29 + ABS(MAXH3.26 >= H29 OR H29 <= MAXH3.30) * (ABS(MAXH3.27 < H30 AND H30 > MAXH3.31) * H30 + ABS(MAXH3.27 >= H30 OR H30 <= MAXH3.31) * (ABS(MAXH3.28 < H31 AND H31 > MAXH3.32) * H31 + ABS(MAXH3.28 >= H31 OR H31 <= MAXH3.32) * (ABS(MAXH3.29 < H32 AND H32 > MAXH3.33) * H32 + ABS(MAXH3.29 >= H32 OR H32 <= MAXH3.33) * (ABS(MAXH3.30 < H33 AND H33 > MAXH3.34) * H33 + ABS(MAXH3.30 >= H33 OR H33 <= MAXH3.34) * (ABS(MAXH3.31 < H34 AND H34 > MAXH3.35) * H34 + ABS(MAXH3.31 >= H34 OR H34 <= MAXH3.35) * (ABS(MAXH3.32 < H35 AND H35 > MAXH3.36) * H35 + ABS(MAXH3.32 >= H35 OR H35 <= MAXH3.36) * (ABS(MAXH3.33 < H36 AND H36 > MAXH3.37) * H36 + ABS(MAXH3.33 >= H36 OR H36 <= MAXH3.37) * (ABS(MAXH3.34 < H37 AND H37 > MAXH3.38) * H37 + ABS(MAXH3.34 >= H37 OR H37 <= MAXH3.38) * (ABS(MAXH3.35 < H38 AND H38 > MAXH3.39) * H38 + ABS(MAXH3.35 >= H38 OR H38 <= MAXH3.39) * (ABS(MAXH3.36 < H39 AND H39 > MAXH3.40) * H39 + ABS(MAXH3.36 >= H39 OR H39 <= MAXH3.40) * (ABS(MAXH3.37 < H40 AND H40 > MAXH3.41) * H40 + ABS(MAXH3.37 >= H40 OR H40 <= MAXH3.41) * (ABS(MAXH3.38 < H41 AND H41 > MAXH3.42) * H41 + ABS(MAXH3.38 >= H41 OR H41 <= MAXH3.42) * (ABS(MAXH3.39 < H42 AND H42 > MAXH3.43) * H42 + ABS(MAXH3.39 >= H42 OR H42 <= MAXH3.43) * (ABS(MAXH3.40 < H43 AND H43 > MAXH3.44) * H43 + ABS(MAXH3.40 >= H43 OR H43 <= MAXH3.44) * (ABS(MAXH3.41 < H44 AND H44 > MAXH3.45) * H44 + ABS(MAXH3.41 >= H44 OR H44 <= MAXH3.45) * (ABS(MAXH3.42 < H45 AND H45 > MAXH3.46) * H45 + ABS(MAXH3.42 >= H45 OR H45 <= MAXH3.46) * (ABS(MAXH3.43 < H46 AND H46 > MAXH3.47) * H46 + ABS(MAXH3.43 >= H46 OR H46 <= MAXH3.47) * (ABS(MAXH3.44 < H47 AND H47 > MAXH3.48) * H47 + ABS(MAXH3.44 >= H47 OR H47 <= MAXH3.48) * (ABS(MAXH3.45 < H48 AND H48 > MAXH3.49) * H48 + ABS(MAXH3.45 >= H48 OR H48 <= MAXH3.49) * (ABS(MAXH3.46 < H49 AND H49 > MAXH3.50) * H49 + ABS(MAXH3.46 >= H49 OR H49 <= MAXH3.50) * (ABS(MAXH3.47 < H50 AND H50 > MAXH3.51) * H50 + ABS(MAXH3.47 >= H50 OR H50 <= MAXH3.51) * (ABS(MAXH3.48 < H51 AND H51 > MAXH3.52) * H51 + ABS(MAXH3.48 >= H51 OR H51 <= MAXH3.52) * (ABS(MAXH3.49 < H52 AND H52 > MAXH3.53) * H52 + ABS(MAXH3.49 >= H52 OR H52 <= MAXH3.53) * (ABS(MAXH3.50 < H53 AND H53 > MAXH3.54) * H53 + ABS(MAXH3.50 >= H53 OR H53 <= MAXH3.54) * (ABS(MAXH3.51 < H54 AND H54 > MAXH3.55) * H54 + ABS(MAXH3.51 >= H54 OR H54 <= MAXH3.55) * (ABS(MAXH3.52 < H55 AND H55 > MAXH3.56) * H55 + ABS(MAXH3.52 >= H55 OR H55 <= MAXH3.56) * (ABS(MAXH3.53 < H56 AND H56 > MAXH3.57) * H56 + ABS(MAXH3.53 >= H56 OR H56 <= MAXH3.57) * (ABS(MAXH3.54 < H57 AND H57 > MAXH3.58) * H57 + ABS(MAXH3.54 >= H57 OR H57 <= MAXH3.58) * (ABS(MAXH3.55 < H58 AND H58 > MAXH3.59) * H58 + ABS(MAXH3.55 >= H58 OR H58 <= MAXH3.59) * (ABS(MAXH3.56 < H59 AND H59 > MAXH3.60) * H59 + ABS(MAXH3.56 >= H59 OR H59 <= MAXH3.60) * (ABS(MAXH3.57 < H60 AND H60 > MAXH3.61) * H60 + ABS(MAXH3.57 >= H60 OR H60 <= MAXH3.61) * (ABS(MAXH3.58 < H61 AND H61 > MAXH3.62) * H61 + ABS(MAXH3.58 >= H61 OR H61 <= MAXH3.62) * (ABS(MAXH3.59 < H62 AND H62 > MAXH3.63) * H62 + ABS(MAXH3.59 >= H62 OR H62 <= MAXH3.63) * MAXH63)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

The Formula to use in the second Custom PCF Indicator is just the following:

ABS(MINL3 > L3 AND L3 < MINL3.4) * L3 + ABS(MINL3 <= L3 OR L3 >= MINL3.4) * (ABS(MINL3.1 > L4 AND L4 < MINL3.5) * L4 + ABS(MINL3.1 <= L4 OR L4 >= MINL3.5) * (ABS(MINL3.2 > L5 AND L5 < MINL3.6) * L5 + ABS(MINL3.2 <= L5 OR L5 >= MINL3.6) * (ABS(MINL3.3 > L6 AND L6 < MINL3.7) * L6 + ABS(MINL3.3 <= L6 OR L6 >= MINL3.7) * (ABS(MINL3.4 > L7 AND L7 < MINL3.8) * L7 + ABS(MINL3.4 <= L7 OR L7 >= MINL3.8) * (ABS(MINL3.5 > L8 AND L8 < MINL3.9) * L8 + ABS(MINL3.5 <= L8 OR L8 >= MINL3.9) * (ABS(MINL3.6 > L9 AND L9 < MINL3.10) * L9 + ABS(MINL3.6 <= L9 OR L9 >= MINL3.10) * (ABS(MINL3.7 > L10 AND L10 < MINL3.11) * L10 + ABS(MINL3.7 <= L10 OR L10 >= MINL3.11) * (ABS(MINL3.8 > L11 AND L11 < MINL3.12) * L11 + ABS(MINL3.8 <= L11 OR L11 >= MINL3.12) * (ABS(MINL3.9 > L12 AND L12 < MINL3.13) * L12 + ABS(MINL3.9 <= L12 OR L12 >= MINL3.13) * (ABS(MINL3.10 > L13 AND L13 < MINL3.14) * L13 + ABS(MINL3.10 <= L13 OR L13 >= MINL3.14) * (ABS(MINL3.11 > L14 AND L14 < MINL3.15) * L14 + ABS(MINL3.11 <= L14 OR L14 >= MINL3.15) * (ABS(MINL3.12 > L15 AND L15 < MINL3.16) * L15 + ABS(MINL3.12 <= L15 OR L15 >= MINL3.16) * (ABS(MINL3.13 > L16 AND L16 < MINL3.17) * L16 + ABS(MINL3.13 <= L16 OR L16 >= MINL3.17) * (ABS(MINL3.14 > L17 AND L17 < MINL3.18) * L17 + ABS(MINL3.14 <= L17 OR L17 >= MINL3.18) * (ABS(MINL3.15 > L18 AND L18 < MINL3.19) * L18 + ABS(MINL3.15 <= L18 OR L18 >= MINL3.19) * (ABS(MINL3.16 > L19 AND L19 < MINL3.20) * L19 + ABS(MINL3.16 <= L19 OR L19 >= MINL3.20) * (ABS(MINL3.17 > L20 AND L20 < MINL3.21) * L20 + ABS(MINL3.17 <= L20 OR L20 >= MINL3.21) * (ABS(MINL3.18 > L21 AND L21 < MINL3.22) * L21 + ABS(MINL3.18 <= L21 OR L21 >= MINL3.22) * (ABS(MINL3.19 > L22 AND L22 < MINL3.23) * L22 + ABS(MINL3.19 <= L22 OR L22 >= MINL3.23) * (ABS(MINL3.20 > L23 AND L23 < MINL3.24) * L23 + ABS(MINL3.20 <= L23 OR L23 >= MINL3.24) * (ABS(MINL3.21 > L24 AND L24 < MINL3.25) * L24 + ABS(MINL3.21 <= L24 OR L24 >= MINL3.25) * (ABS(MINL3.22 > L25 AND L25 < MINL3.26) * L25 + ABS(MINL3.22 <= L25 OR L25 >= MINL3.26) * (ABS(MINL3.23 > L26 AND L26 < MINL3.27) * L26 + ABS(MINL3.23 <= L26 OR L26 >= MINL3.27) * (ABS(MINL3.24 > L27 AND L27 < MINL3.28) * L27 + ABS(MINL3.24 <= L27 OR L27 >= MINL3.28) * (ABS(MINL3.25 > L28 AND L28 < MINL3.29) * L28 + ABS(MINL3.25 <= L28 OR L28 >= MINL3.29) * (ABS(MINL3.26 > L29 AND L29 < MINL3.30) * L29 + ABS(MINL3.26 <= L29 OR L29 >= MINL3.30) * (ABS(MINL3.27 > L30 AND L30 < MINL3.31) * L30 + ABS(MINL3.27 <= L30 OR L30 >= MINL3.31) * (ABS(MINL3.28 > L31 AND L31 < MINL3.32) * L31 + ABS(MINL3.28 <= L31 OR L31 >= MINL3.32) * (ABS(MINL3.29 > L32 AND L32 < MINL3.33) * L32 + ABS(MINL3.29 <= L32 OR L32 >= MINL3.33) * (ABS(MINL3.30 > L33 AND L33 < MINL3.34) * L33 + ABS(MINL3.30 <= L33 OR L33 >= MINL3.34) * (ABS(MINL3.31 > L34 AND L34 < MINL3.35) * L34 + ABS(MINL3.31 <= L34 OR L34 >= MINL3.35) * (ABS(MINL3.32 > L35 AND L35 < MINL3.36) * L35 + ABS(MINL3.32 <= L35 OR L35 >= MINL3.36) * (ABS(MINL3.33 > L36 AND L36 < MINL3.37) * L36 + ABS(MINL3.33 <= L36 OR L36 >= MINL3.37) * (ABS(MINL3.34 > L37 AND L37 < MINL3.38) * L37 + ABS(MINL3.34 <= L37 OR L37 >= MINL3.38) * (ABS(MINL3.35 > L38 AND L38 < MINL3.39) * L38 + ABS(MINL3.35 <= L38 OR L38 >= MINL3.39) * (ABS(MINL3.36 > L39 AND L39 < MINL3.40) * L39 + ABS(MINL3.36 <= L39 OR L39 >= MINL3.40) * (ABS(MINL3.37 > L40 AND L40 < MINL3.41) * L40 + ABS(MINL3.37 <= L40 OR L40 >= MINL3.41) * (ABS(MINL3.38 > L41 AND L41 < MINL3.42) * L41 + ABS(MINL3.38 <= L41 OR L41 >= MINL3.42) * (ABS(MINL3.39 > L42 AND L42 < MINL3.43) * L42 + ABS(MINL3.39 <= L42 OR L42 >= MINL3.43) * (ABS(MINL3.40 > L43 AND L43 < MINL3.44) * L43 + ABS(MINL3.40 <= L43 OR L43 >= MINL3.44) * (ABS(MINL3.41 > L44 AND L44 < MINL3.45) * L44 + ABS(MINL3.41 <= L44 OR L44 >= MINL3.45) * (ABS(MINL3.42 > L45 AND L45 < MINL3.46) * L45 + ABS(MINL3.42 <= L45 OR L45 >= MINL3.46) * (ABS(MINL3.43 > L46 AND L46 < MINL3.47) * L46 + ABS(MINL3.43 <= L46 OR L46 >= MINL3.47) * (ABS(MINL3.44 > L47 AND L47 < MINL3.48) * L47 + ABS(MINL3.44 <= L47 OR L47 >= MINL3.48) * (ABS(MINL3.45 > L48 AND L48 < MINL3.49) * L48 + ABS(MINL3.45 <= L48 OR L48 >= MINL3.49) * (ABS(MINL3.46 > L49 AND L49 < MINL3.50) * L49 + ABS(MINL3.46 <= L49 OR L49 >= MINL3.50) * (ABS(MINL3.47 > L50 AND L50 < MINL3.51) * L50 + ABS(MINL3.47 <= L50 OR L50 >= MINL3.51) * (ABS(MINL3.48 > L51 AND L51 < MINL3.52) * L51 + ABS(MINL3.48 <= L51 OR L51 >= MINL3.52) * (ABS(MINL3.49 > L52 AND L52 < MINL3.53) * L52 + ABS(MINL3.49 <= L52 OR L52 >= MINL3.53) * (ABS(MINL3.50 > L53 AND L53 < MINL3.54) * L53 + ABS(MINL3.50 <= L53 OR L53 >= MINL3.54) * (ABS(MINL3.51 > L54 AND L54 < MINL3.55) * L54 + ABS(MINL3.51 <= L54 OR L54 >= MINL3.55) * (ABS(MINL3.52 > L55 AND L55 < MINL3.56) * L55 + ABS(MINL3.52 <= L55 OR L55 >= MINL3.56) * (ABS(MINL3.53 > L56 AND L56 < MINL3.57) * L56 + ABS(MINL3.53 <= L56 OR L56 >= MINL3.57) * (ABS(MINL3.54 > L57 AND L57 < MINL3.58) * L57 + ABS(MINL3.54 <= L57 OR L57 >= MINL3.58) * (ABS(MINL3.55 > L58 AND L58 < MINL3.59) * L58 + ABS(MINL3.55 <= L58 OR L58 >= MINL3.59) * (ABS(MINL3.56 > L59 AND L59 < MINL3.60) * L59 + ABS(MINL3.56 <= L59 OR L59 >= MINL3.60) * (ABS(MINL3.57 > L60 AND L60 < MINL3.61) * L60 + ABS(MINL3.57 <= L60 OR L60 >= MINL3.61) * (ABS(MINL3.58 > L61 AND L61 < MINL3.62) * L61 + ABS(MINL3.58 <= L61 OR L61 >= MINL3.62) * (ABS(MINL3.59 > L62 AND L62 < MINL3.63) * L62 + ABS(MINL3.59 <= L62 OR L62 >= MINL3.63) * MINL63)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Beyond that the things I can think of would just be the same as before. If you are using Edge or Internet Explorer try Chrome instead. You can also try copying and pasting into a text editor such as Notepad and then copying and pasting from the text editor into TC2000.

There aren't any decimal markers in the formula, so that shouldn't be it. Not sure if you need to change the instances of AND and OR in the formulas to something else or not.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Friday, August 26, 2016 3:01:40 PM
Registered User
Joined: 9/30/2011
Posts: 630

Formula Error message, the decimal problem? E = AND? - O = OR?

R.C.

Bruce_L
Posted : Friday, August 26, 2016 3:04:29 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

There shouldn't be any decimal markers in either formula so that shouldn't be it.

I am guessing you would need to change AND to E and OR to O but I cannot say for sure. I don't know if that would be the correct syntax in an Italian localized version of Visual Basic .NET or not.

The other thing you might want to check is that it is the plain Custom PCF Indicator and not some other type of Custom Indicator (like a Custom PCF % True Indicator).



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Rock1
Posted : Monday, February 12, 2018 12:06:04 PM
Registered User
Joined: 3/16/2016
Posts: 57

http://s349.photobucket.com/user/nuwava25/media/SPY%20SP_zpsgsn2xrph.jpg.html?o=0

 

Bruce_L
Posted : Monday, February 12, 2018 12:09:18 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

It looks like you don't have the indicator plotted in the same scale as price. Click on the Custom PCF Indicator and select Scaling... | Scale With: the symbol on the chart.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Rock1
Posted : Monday, February 12, 2018 12:10:16 PM
Registered User
Joined: 3/16/2016
Posts: 57

I was able to load this picture with the direct link. please delete my previous 2 posts with the links. Is this what the indicator should look like? Do any lines extend to the right of the chart where price has not been yet?

thanks

 

Rock1
Posted : Monday, February 12, 2018 12:27:36 PM
Registered User
Joined: 3/16/2016
Posts: 57

Looks like I got it, Red Line. Can you create a scan with the same indicator formula used here? And how do you go that to find stocks with price crossing thru the Red S&P line?

thanks

Rock1
Posted : Monday, February 12, 2018 1:32:38 PM
Registered User
Joined: 3/16/2016
Posts: 57

The white line is alot easyier to see. Can I create a scan with the same indicator formula used here? And how do you go that to find stocks with price crossing thru the Red S&P line? the scan does not seem to be working when I put in the formula.

thanks

Bruce_L
Posted : Monday, February 12, 2018 1:32:54 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

As long as it is plotted in the same pane and scale, you should be able to click on price and select Create Condition (or Create Scan Condition) to create a condition for price crossing through the line.

You should be able to edit the Custom PCF Indicator to change it back to white instead of red.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Rock1
Posted : Monday, February 12, 2018 1:58:18 PM
Registered User
Joined: 3/16/2016
Posts: 57

Thanks, I keep forgetting "create scan condition"  is the easyiest way, vs PCF script. I see that I can add the indicator twice, for both ways, on the chart, Swing Low and Swing high piviot point. and then make 2 diffrent scans for them .Its looking good-

thanks a lot.

Bruce_L
Posted : Monday, February 12, 2018 1:59:18 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Monday, February 12, 2018 2:16:33 PM
Registered User
Joined: 9/30/2011
Posts: 630

 

The following third Formula returns only numbers, I would like the change with the signal.

ABS(MAXH3 < H3 AND H3 > MAXH3.4) * H3 + ABS(MAXH3 >= H3 OR H3 <= MAXH3.4) * (ABS(MAXH3.1 < H4 AND H4 > MAXH3.5) * H4 + ABS(MAXH3.1 >= H4 OR H4 <= MAXH3.5) * (ABS(MAXH3.2 < H5 AND H5 > MAXH3.6) * H5 + ABS(MAXH3.2 >= H5 OR H5 <= MAXH3.6) * (ABS(MAXH3.3 < H6 AND H6 > MAXH3.7) * H6 + ABS(MAXH3.3 >= H6 OR H6 <= MAXH3.7) * (ABS(MAXH3.4 < H7 AND H7 > MAXH3.8) * H7 + ABS(MAXH3.4 >= H7 OR H7 <= MAXH3.8) * (ABS(MAXH3.5 < H8 AND H8 > MAXH3.9) * H8 + ABS(MAXH3.5 >= H8 OR H8 <= MAXH3.9) * (ABS(MAXH3.6 < H9 AND H9 > MAXH3.10) * H9 + ABS(MAXH3.6 >= H9 OR H9 <= MAXH3.10) * (ABS(MAXH3.7 < H10 AND H10 > MAXH3.11) * H10 + ABS(MAXH3.7 >= H10 OR H10 <= MAXH3.11) * (ABS(MAXH3.8 < H11 AND H11 > MAXH3.12) * H11 + ABS(MAXH3.8 >= H11 OR H11 <= MAXH3.12) * (ABS(MAXH3.9 < H12 AND H12 > MAXH3.13) * H12 + ABS(MAXH3.9 >= H12 OR H12 <= MAXH3.13) * (ABS(MAXH3.10 < H13 AND H13 > MAXH3.14) * H13 + ABS(MAXH3.10 >= H13 OR H13 <= MAXH3.14) * (ABS(MAXH3.11 < H14 AND H14 > MAXH3.15) * H14 + ABS(MAXH3.11 >= H14 OR H14 <= MAXH3.15) * (ABS(MAXH3.12 < H15 AND H15 > MAXH3.16) * H15 + ABS(MAXH3.12 >= H15 OR H15 <= MAXH3.16) * (ABS(MAXH3.13 < H16 AND H16 > MAXH3.17) * H16 + ABS(MAXH3.13 >= H16 OR H16 <= MAXH3.17) * (ABS(MAXH3.14 < H17 AND H17 > MAXH3.18) * H17 + ABS(MAXH3.14 >= H17 OR H17 <= MAXH3.18) * (ABS(MAXH3.15 < H18 AND H18 > MAXH3.19) * H18 + ABS(MAXH3.15 >= H18 OR H18 <= MAXH3.19) * (ABS(MAXH3.16 < H19 AND H19 > MAXH3.20) * H19 + ABS(MAXH3.16 >= H19 OR H19 <= MAXH3.20) * (ABS(MAXH3.17 < H20 AND H20 > MAXH3.21) * H20 + ABS(MAXH3.17 >= H20 OR H20 <= MAXH3.21) * (ABS(MAXH3.18 < H21 AND H21 > MAXH3.22) * H21 + ABS(MAXH3.18 >= H21 OR H21 <= MAXH3.22) * (ABS(MAXH3.19 < H22 AND H22 > MAXH3.23) * H22 + ABS(MAXH3.19 >= H22 OR H22 <= MAXH3.23) * (ABS(MAXH3.20 < H23 AND H23 > MAXH3.24) * H23 + ABS(MAXH3.20 >= H23 OR H23 <= MAXH3.24) * (ABS(MAXH3.21 < H24 AND H24 > MAXH3.25) * H24 + ABS(MAXH3.21 >= H24 OR H24 <= MAXH3.25) * (ABS(MAXH3.22 < H25 AND H25 > MAXH3.26) * H25 + ABS(MAXH3.22 >= H25 OR H25 <= MAXH3.26) * (ABS(MAXH3.23 < H26 AND H26 > MAXH3.27) * H26 + ABS(MAXH3.23 >= H26 OR H26 <= MAXH3.27) * (ABS(MAXH3.24 < H27 AND H27 > MAXH3.28) * H27 + ABS(MAXH3.24 >= H27 OR H27 <= MAXH3.28) * (ABS(MAXH3.25 < H28 AND H28 > MAXH3.29) * H28 + ABS(MAXH3.25 >= H28 OR H28 <= MAXH3.29) * (ABS(MAXH3.26 < H29 AND H29 > MAXH3.30) * H29 + ABS(MAXH3.26 >= H29 OR H29 <= MAXH3.30) * (ABS(MAXH3.27 < H30 AND H30 > MAXH3.31) * H30 + ABS(MAXH3.27 >= H30 OR H30 <= MAXH3.31) * (ABS(MAXH3.28 < H31 AND H31 > MAXH3.32) * H31 + ABS(MAXH3.28 >= H31 OR H31 <= MAXH3.32) * (ABS(MAXH3.29 < H32 AND H32 > MAXH3.33) * H32 + ABS(MAXH3.29 >= H32 OR H32 <= MAXH3.33) * (ABS(MAXH3.30 < H33 AND H33 > MAXH3.34) * H33 + ABS(MAXH3.30 >= H33 OR H33 <= MAXH3.34) * (ABS(MAXH3.31 < H34 AND H34 > MAXH3.35) * H34 + ABS(MAXH3.31 >= H34 OR H34 <= MAXH3.35) * (ABS(MAXH3.32 < H35 AND H35 > MAXH3.36) * H35 + ABS(MAXH3.32 >= H35 OR H35 <= MAXH3.36) * (ABS(MAXH3.33 < H36 AND H36 > MAXH3.37) * H36 + ABS(MAXH3.33 >= H36 OR H36 <= MAXH3.37) * (ABS(MAXH3.34 < H37 AND H37 > MAXH3.38) * H37 + ABS(MAXH3.34 >= H37 OR H37 <= MAXH3.38) * (ABS(MAXH3.35 < H38 AND H38 > MAXH3.39) * H38 + ABS(MAXH3.35 >= H38 OR H38 <= MAXH3.39) * (ABS(MAXH3.36 < H39 AND H39 > MAXH3.40) * H39 + ABS(MAXH3.36 >= H39 OR H39 <= MAXH3.40) * (ABS(MAXH3.37 < H40 AND H40 > MAXH3.41) * H40 + ABS(MAXH3.37 >= H40 OR H40 <= MAXH3.41) * (ABS(MAXH3.38 < H41 AND H41 > MAXH3.42) * H41 + ABS(MAXH3.38 >= H41 OR H41 <= MAXH3.42) * (ABS(MAXH3.39 < H42 AND H42 > MAXH3.43) * H42 + ABS(MAXH3.39 >= H42 OR H42 <= MAXH3.43) * (ABS(MAXH3.40 < H43 AND H43 > MAXH3.44) * H43 + ABS(MAXH3.40 >= H43 OR H43 <= MAXH3.44) * (ABS(MAXH3.41 < H44 AND H44 > MAXH3.45) * H44 + ABS(MAXH3.41 >= H44 OR H44 <= MAXH3.45) * (ABS(MAXH3.42 < H45 AND H45 > MAXH3.46) * H45 + ABS(MAXH3.42 >= H45 OR H45 <= MAXH3.46) * (ABS(MAXH3.43 < H46 AND H46 > MAXH3.47) * H46 + ABS(MAXH3.43 >= H46 OR H46 <= MAXH3.47) * (ABS(MAXH3.44 < H47 AND H47 > MAXH3.48) * H47 + ABS(MAXH3.44 >= H47 OR H47 <= MAXH3.48) * (ABS(MAXH3.45 < H48 AND H48 > MAXH3.49) * H48 + ABS(MAXH3.45 >= H48 OR H48 <= MAXH3.49) * (ABS(MAXH3.46 < H49 AND H49 > MAXH3.50) * H49 + ABS(MAXH3.46 >= H49 OR H49 <= MAXH3.50) * (ABS(MAXH3.47 < H50 AND H50 > MAXH3.51) * H50 + ABS(MAXH3.47 >= H50 OR H50 <= MAXH3.51) * (ABS(MAXH3.48 < H51 AND H51 > MAXH3.52) * H51 + ABS(MAXH3.48 >= H51 OR H51 <= MAXH3.52) * (ABS(MAXH3.49 < H52 AND H52 > MAXH3.53) * H52 + ABS(MAXH3.49 >= H52 OR H52 <= MAXH3.53) * (ABS(MAXH3.50 < H53 AND H53 > MAXH3.54) * H53 + ABS(MAXH3.50 >= H53 OR H53 <= MAXH3.54) * (ABS(MAXH3.51 < H54 AND H54 > MAXH3.55) * H54 + ABS(MAXH3.51 >= H54 OR H54 <= MAXH3.55) * (ABS(MAXH3.52 < H55 AND H55 > MAXH3.56) * H55 + ABS(MAXH3.52 >= H55 OR H55 <= MAXH3.56) * (ABS(MAXH3.53 < H56 AND H56 > MAXH3.57) * H56 + ABS(MAXH3.53 >= H56 OR H56 <= MAXH3.57) * (ABS(MAXH3.54 < H57 AND H57 > MAXH3.58) * H57 + ABS(MAXH3.54 >= H57 OR H57 <= MAXH3.58) * (ABS(MAXH3.55 < H58 AND H58 > MAXH3.59) * H58 + ABS(MAXH3.55 >= H58 OR H58 <= MAXH3.59) * (ABS(MAXH3.56 < H59 AND H59 > MAXH3.60) * H59 + ABS(MAXH3.56 >= H59 OR H59 <= MAXH3.60) * (ABS(MAXH3.57 < H60 AND H60 > MAXH3.61) * H60 + ABS(MAXH3.57 >= H60 OR H60 <= MAXH3.61) * (ABS(MAXH3.58 < H61 AND H61 > MAXH3.62) * H61 + ABS(MAXH3.58 >= H61 OR H61 <= MAXH3.62) * (ABS(MAXH3.59 < H62 AND H62 > MAXH3.63) * H62 + ABS(MAXH3.59 >= H62 OR H62 <= MAXH3.63) * MAXH63)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Thank you and goodbye.

Raider45

Bruce_L
Posted : Monday, February 12, 2018 2:27:19 PM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

The signal portion of that formula would just be the following.

MAXH3 < H3 AND H3 > MAXH3.4



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Tuesday, February 13, 2018 3:17:52 AM
Registered User
Joined: 9/30/2011
Posts: 630
The formula works very well, I would like the inverse one with the signal on the resistance.
 
Thank you and goodbye.
 
Raider45
Bruce_L
Posted : Tuesday, February 13, 2018 9:55:42 AM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

Please try the following.

MINL3 > L3 AND L3 < MINL3.4



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Tuesday, February 13, 2018 10:27:22 AM
Registered User
Joined: 9/30/2011
Posts: 630
Congratulations, thank you!
 
Best regards !
Bruce_L
Posted : Tuesday, February 13, 2018 10:28:14 AM


Worden Trainer

Joined: 10/7/2004
Posts: 63,458

You're welcome.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.