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

Histogram Help Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dhirenshah
Posted : Thursday, August 31, 2017 12:10:40 PM
Registered User
Joined: 3/10/2012
Posts: 465

Hi Bruce 

Here is an idea that i want to experiment ... I m looking to make Higher High's and Higher Lows in uptrend and Lower Highs and Lower lows in downtrend, 

1) So I did some back testing and what i want is a PCF which i can plot in Histogram, using this following formula for high

H2 * ABS(H < H2 AND H1 < H2 AND H2 > H3 AND H2 > H4)

Now Histogram should show GREEN if the above pcf is higher then the previous plotting of that pcf  and histogram should show RED if above pcf is lower then the previous plotting of that pcf, (so this becomes HIGHER HIGHS GREEN AND LOWER HIGHS In RED)

And can u pls include off set of -2 to the above pcf  into the new formula so it plots histogram bar exact to that candle of price ,

2) Next I need PCF which plots histogram using the following formula for low 

L2 * ABS(L > L1 AND L1 > L2 AND L2 < L3 AND L3 < L4)

Now here same idea if histogram should show GREEN if the pcf is higher then the previous plotting of that pcf and histogram show red if above pcf is lower then the previous plotting of that PCF (so this will become HIGHER LOWS GREEN AND LOWER LOWS AS RED)

And can u pls include off set of -2 to the pcf  into the new formula so it plots histogram bar exact to that candle of price ,

 

3) now the last part once we established new pcf then they should have flow as one synchronized histogram with FOUR COLOURS  if new pcf is true then it will plot  higher-highs  and higher -low above ZERO(with two colours) and lower highs and lower lows below zero (with another set of colours) so the flow visually looks like Awesome Oscillator,,, 

 

Thanks

Dhiren 

Bruce_L
Posted : Thursday, August 31, 2017 12:55:04 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You need to put in the offset yourself by adding a 1 period moving average to the Custom PCF Indicator with the desired offset and then sliding the opacity setting of the Custom PCF Indicator all the way to the left so it doesn't show.

Higher High:

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

Lower High:

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

Higher Low:

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

Lower Low:

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

Just put - (a minus or negative sign) in front of the "lower" formulas to get them to plot below zero instead of above zero.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Thursday, August 31, 2017 2:28:43 PM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce thank you for the formulas, 

they work perfect 

But when i m offsetting its not working correct... i mean when i add 1 period simple moving average and offset -2 histogram is not plotting the candle exact where my original PCF has plot on price ... 

Can u please check at your end , what am i missing 

 

thanks 

Bruce_L
Posted : Thursday, August 31, 2017 2:47:34 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

I frequently forget that the 1 period offset moving average trick doesn't work as desired for most applications when we don't output anything at all for some bars. Try changing the 1 / 0 near the end of each formula to just 0 (zero) instead.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Al_Gorithm
Posted : Thursday, August 31, 2017 3:02:00 PM

Registered User
Joined: 6/30/2017
Posts: 1,227

QUOTE (Bruce_L)

I frequently forget ...

I hear coffee is good for that. ;)

dhirenshah
Posted : Thursday, August 31, 2017 3:06:37 PM
Registered User
Joined: 3/10/2012
Posts: 465

Excellent Bruce that works...

thanks a Lot 

Cheers

dhirenshah
Posted : Monday, September 11, 2017 3:24:39 PM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce can u please write a pcf for it being true when the below conditions are met I am having trouble writing them

1) I need pcf output as -1 when from your post of Thursday, August 31, 2017 12:55:04 PM

"Higher High and Lower Low " triggered as true in a row example LMT on daily chart(so i m drawing fib retracement from higher high to bottom right lower low 

2) Need pcf output as +1 when from your post above "lower low and higher high" triggered in a row example BLK on daily chart  and i m drawing fib retacement from lower low to top right higher high 

So i m expecting #1 will be downward direction going forward and 

#2 will be upward direction going forward 

Thanks  a lot 

 

Bruce_L
Posted : Monday, September 11, 2017 4:06:58 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

I'm not quite sure what you are requesting (and some of my guesses are too long and slow to be practical or post in the forums), but maybe the following?

IIF(MAXH2 < H2 AND H2 > MAXH2.3 AND H2 > IIF(MAXH2.3 < H5 AND H5 > MAXH2.6, H5, IIF(MAXH2.4 < H6 AND H6 > MAXH2.7, H6, IIF(MAXH2.5 < H7 AND H7 > MAXH2.8, H7, IIF(MAXH2.6 < H8 AND H8 > MAXH2.9, H8, IIF(MAXH2.7 < H9 AND H9 > MAXH2.10, H9, IIF(MAXH2.8 < H10 AND H10 > MAXH2.11, H10, IIF(MAXH2.9 < H11 AND H11 > MAXH2.12, H11, IIF(MAXH2.10 < H12 AND H12 > MAXH2.13, H12, IIF(MAXH2.11 < H13 AND H13 > MAXH2.14, H13, IIF(MAXH2.12 < H14 AND H14 > MAXH2.15, H14, IIF(MAXH2.13 < H15 AND H15 > MAXH2.16, H15, IIF(MAXH2.14 < H16 AND H16 > MAXH2.17, H16, IIF(MAXH2.15 < H17 AND H17 > MAXH2.18, H17, IIF(MAXH2.16 < H18 AND H18 > MAXH2.19, H18, IIF(MAXH2.17 < H19 AND H19 > MAXH2.20, H19, IIF(MAXH2.18 < H20 AND H20 > MAXH2.21, H20, IIF(MAXH2.19 < H21 AND H21 > MAXH2.22, H21, IIF(MAXH2.20 < H22 AND H22 > MAXH2.23, H22, IIF(MAXH2.21 < H23 AND H23 > MAXH2.24, H23, IIF(MAXH2.22 < H24 AND H24 > MAXH2.25, H24, IIF(MAXH2.23 < H25 AND H25 > MAXH2.26, H25, IIF(MAXH2.24 < H26 AND H26 > MAXH2.27, H26, IIF(MAXH2.25 < H27 AND H27 > MAXH2.28, H27, IIF(MAXH2.26 < H28 AND H28 > MAXH2.29, H28, IIF(MAXH2.27 < H29 AND H29 > MAXH2.30, H29, IIF(MAXH2.28 < H30 AND H30 > MAXH2.31, H30, IIF(MAXH2.29 < H31 AND H31 > MAXH2.32, H31, IIF(MAXH2.30 < H32 AND H32 > MAXH2.33, H32, IIF(MAXH2.31 < H33 AND H33 > MAXH2.34, H33, IIF(MAXH2.32 < H34 AND H34 > MAXH2.35, H34, IIF(MAXH2.33 < H35 AND H35 > MAXH2.36, H35, IIF(MAXH2.34 < H36 AND H36 > MAXH2.37, H36, IIF(MAXH2.35 < H37 AND H37 > MAXH2.38, H37, IIF(MAXH2.36 < H38 AND H38 > MAXH2.39, H38, IIF(MAXH2.37 < H39 AND H39 > MAXH2.40, H39, IIF(MAXH2.38 < H40 AND H40 > MAXH2.41, H40, IIF(MAXH2.39 < H41 AND H41 > MAXH2.42, H41, IIF(MAXH2.40 < H42 AND H42 > MAXH2.43, H42, IIF(MAXH2.41 < H43 AND H43 > MAXH2.44, H43, IIF(MAXH2.42 < H44 AND H44 > MAXH2.45, H44, IIF(MAXH2.43 < H45 AND H45 > MAXH2.46, H45, IIF(MAXH2.44 < H46 AND H46 > MAXH2.47, H46, IIF(MAXH2.45 < H47 AND H47 > MAXH2.48, H47, IIF(MAXH2.46 < H48 AND H48 > MAXH2.49, H48, IIF(MAXH2.47 < H49 AND H49 > MAXH2.50, H49, IIF(MAXH2.48 < H50 AND H50 > MAXH2.51, H50, IIF(MAXH2.49 < H51 AND H51 > MAXH2.52, H51, IIF(MAXH2.50 < H52 AND H52 > MAXH2.53, H52, IIF(MAXH2.51 < H53 AND H53 > MAXH2.54, H53, IIF(MAXH2.52 < H54 AND H54 > MAXH2.55, H54, IIF(MAXH2.53 < H55 AND H55 > MAXH2.56, H55, IIF(MAXH2.54 < H56 AND H56 > MAXH2.57, H56, IIF(MAXH2.55 < H57 AND H57 > MAXH2.58, H57, IIF(MAXH2.56 < H58 AND H58 > MAXH2.59, H58, IIF(MAXH2.57 < H59 AND H59 > MAXH2.60, H59, IIF(MAXH2.58 < H60 AND H60 > MAXH2.61, H60, IIF(MAXH2.59 < H61 AND H61 > MAXH2.62, H61, IIF(MAXH2.60 < H62 AND H62 > MAXH2.63, H62, IIF(MAXH2.61 < H63 AND H63 > MAXH2.64, H63, IIF(MAXH2.62 < H64 AND H64 > MAXH2.65, H64, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), 1, 0) + IIF(MINL2 > L2 AND L2 < MINL2.3 AND L2 < IIF(MINL2.3 > L5 AND L5 < MINL2.6, L5, IIF(MINL2.4 > L6 AND L6 < MINL2.7, L6, IIF(MINL2.5 > L7 AND L7 < MINL2.8, L7, IIF(MINL2.6 > L8 AND L8 < MINL2.9, L8, IIF(MINL2.7 > L9 AND L9 < MINL2.10, L9, IIF(MINL2.8 > L10 AND L10 < MINL2.11, L10, IIF(MINL2.9 > L11 AND L11 < MINL2.12, L11, IIF(MINL2.10 > L12 AND L12 < MINL2.13, L12, IIF(MINL2.11 > L13 AND L13 < MINL2.14, L13, IIF(MINL2.12 > L14 AND L14 < MINL2.15, L14, IIF(MINL2.13 > L15 AND L15 < MINL2.16, L15, IIF(MINL2.14 > L16 AND L16 < MINL2.17, L16, IIF(MINL2.15 > L17 AND L17 < MINL2.18, L17, IIF(MINL2.16 > L18 AND L18 < MINL2.19, L18, IIF(MINL2.17 > L19 AND L19 < MINL2.20, L19, IIF(MINL2.18 > L20 AND L20 < MINL2.21, L20, IIF(MINL2.19 > L21 AND L21 < MINL2.22, L21, IIF(MINL2.20 > L22 AND L22 < MINL2.23, L22, IIF(MINL2.21 > L23 AND L23 < MINL2.24, L23, IIF(MINL2.22 > L24 AND L24 < MINL2.25, L24, IIF(MINL2.23 > L25 AND L25 < MINL2.26, L25, IIF(MINL2.24 > L26 AND L26 < MINL2.27, L26, IIF(MINL2.25 > L27 AND L27 < MINL2.28, L27, IIF(MINL2.26 > L28 AND L28 < MINL2.29, L28, IIF(MINL2.27 > L29 AND L29 < MINL2.30, L29, IIF(MINL2.28 > L30 AND L30 < MINL2.31, L30, IIF(MINL2.29 > L31 AND L31 < MINL2.32, L31, IIF(MINL2.30 > L32 AND L32 < MINL2.33, L32, IIF(MINL2.31 > L33 AND L33 < MINL2.34, L33, IIF(MINL2.32 > L34 AND L34 < MINL2.35, L34, IIF(MINL2.33 > L35 AND L35 < MINL2.36, L35, IIF(MINL2.34 > L36 AND L36 < MINL2.37, L36, IIF(MINL2.35 > L37 AND L37 < MINL2.38, L37, IIF(MINL2.36 > L38 AND L38 < MINL2.39, L38, IIF(MINL2.37 > L39 AND L39 < MINL2.40, L39, IIF(MINL2.38 > L40 AND L40 < MINL2.41, L40, IIF(MINL2.39 > L41 AND L41 < MINL2.42, L41, IIF(MINL2.40 > L42 AND L42 < MINL2.43, L42, IIF(MINL2.41 > L43 AND L43 < MINL2.44, L43, IIF(MINL2.42 > L44 AND L44 < MINL2.45, L44, IIF(MINL2.43 > L45 AND L45 < MINL2.46, L45, IIF(MINL2.44 > L46 AND L46 < MINL2.47, L46, IIF(MINL2.45 > L47 AND L47 < MINL2.48, L47, IIF(MINL2.46 > L48 AND L48 < MINL2.49, L48, IIF(MINL2.47 > L49 AND L49 < MINL2.50, L49, IIF(MINL2.48 > L50 AND L50 < MINL2.51, L50, IIF(MINL2.49 > L51 AND L51 < MINL2.52, L51, IIF(MINL2.50 > L52 AND L52 < MINL2.53, L52, IIF(MINL2.51 > L53 AND L53 < MINL2.54, L53, IIF(MINL2.52 > L54 AND L54 < MINL2.55, L54, IIF(MINL2.53 > L55 AND L55 < MINL2.56, L55, IIF(MINL2.54 > L56 AND L56 < MINL2.57, L56, IIF(MINL2.55 > L57 AND L57 < MINL2.58, L57, IIF(MINL2.56 > L58 AND L58 < MINL2.59, L58, IIF(MINL2.57 > L59 AND L59 < MINL2.60, L59, IIF(MINL2.58 > L60 AND L60 < MINL2.61, L60, IIF(MINL2.59 > L61 AND L61 < MINL2.62, L61, IIF(MINL2.60 > L62 AND L62 < MINL2.63, L62, IIF(MINL2.61 > L63 AND L63 < MINL2.64, L63, IIF(MINL2.62 > L64 AND L64 < MINL2.65, L64, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), -1, 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Tuesday, September 12, 2017 1:45:03 AM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce the pcf you did is perfect that is what i was  going for... 

Now is there a way to make that pcf as a dot plot so i can overlay on price bar ? as two colours  green for +1  and red for -1

thanks

 

 

Bruce_L
Posted : Tuesday, September 12, 2017 9:23:25 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You can do it as two indicators, but not as a single indicator if you want two different colors.

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

And:

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

But these are just the Higher High and Lower Low formulas given earlier using C, 0) at the end of the formulas instead of H2, 1 / 0) and L2, 1 / 0) at the end of the formulas.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Tuesday, September 12, 2017 12:31:34 PM
Registered User
Joined: 3/10/2012
Posts: 465

Okay thanks a lot bruce ... 

And last query non related , can u please change this formula 100 * (C / (XAVG(H + L + C, 13) / 3) - 1)

to heikanashi open close bars i m having trouble putting parenthesis correctly

Regards

Bruce_L
Posted : Tuesday, September 12, 2017 12:38:01 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

100 * ((O + H + L + C) / 4 / (XAVG(GREATEST(H, XAVG(O1 + H1 + L1 + C1, 3) / 4) + LEAST(L, XAVG(O1 + H1 + L1 + C1, 3) / 4) + (O + H + L + C) / 4, 13) / 3) - 1)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Monday, October 9, 2017 1:13:45 PM
Registered User
Joined: 3/10/2012
Posts: 465

hi Bruce 

from your post of Monday, September 11, 2017 4:06:58 PM can u please change to LOWER LOW AND LOWER HIGH in a row when fib retracement drawn from lower low up towatrds lower high to the right as i keep getting syntax error 

 

thanks

Bruce_L
Posted : Monday, October 9, 2017 1:24:52 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

I don't get a syntax error when I copy and paste it from the forums into TC2000.

Please try copying and pasting the formula into a text editor (such as Notepad and not a word processor such as Word) and then copying and pasting the formula from the text editor into TC2000 to see if that resolves the issue.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Monday, October 9, 2017 1:41:51 PM
Registered User
Joined: 3/10/2012
Posts: 465

No bruce that's not what i meant , sorry i should have written it better,... 

I need to make a new pcf that you wrote earlier Monday, September 11, 2017 4:06:58 PM using HIGHER HIGHER AND LOWER LOW in a row  and make a new one using "lower low and lower high" triggered in a row example FB" on daily 

Sept 25 2017 it was lower low and october 02,2017 it was LOWER HIGH" so i want +1 when it triggers like  when fib retacement drawn from lower low up towards lower high 

thanks 

Bruce_L
Posted : Monday, October 9, 2017 2:25:38 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

This follows the same pattern as the formula in my Monday, September 11, 2017 4:06:58 PM ET post, but I am still not sure it is what you want.

IIF(MAXH2 < H2 AND H2 > MAXH2.3 AND H2 < IIF(MAXH2.3 < H5 AND H5 > MAXH2.6, H5, IIF(MAXH2.4 < H6 AND H6 > MAXH2.7, H6, IIF(MAXH2.5 < H7 AND H7 > MAXH2.8, H7, IIF(MAXH2.6 < H8 AND H8 > MAXH2.9, H8, IIF(MAXH2.7 < H9 AND H9 > MAXH2.10, H9, IIF(MAXH2.8 < H10 AND H10 > MAXH2.11, H10, IIF(MAXH2.9 < H11 AND H11 > MAXH2.12, H11, IIF(MAXH2.10 < H12 AND H12 > MAXH2.13, H12, IIF(MAXH2.11 < H13 AND H13 > MAXH2.14, H13, IIF(MAXH2.12 < H14 AND H14 > MAXH2.15, H14, IIF(MAXH2.13 < H15 AND H15 > MAXH2.16, H15, IIF(MAXH2.14 < H16 AND H16 > MAXH2.17, H16, IIF(MAXH2.15 < H17 AND H17 > MAXH2.18, H17, IIF(MAXH2.16 < H18 AND H18 > MAXH2.19, H18, IIF(MAXH2.17 < H19 AND H19 > MAXH2.20, H19, IIF(MAXH2.18 < H20 AND H20 > MAXH2.21, H20, IIF(MAXH2.19 < H21 AND H21 > MAXH2.22, H21, IIF(MAXH2.20 < H22 AND H22 > MAXH2.23, H22, IIF(MAXH2.21 < H23 AND H23 > MAXH2.24, H23, IIF(MAXH2.22 < H24 AND H24 > MAXH2.25, H24, IIF(MAXH2.23 < H25 AND H25 > MAXH2.26, H25, IIF(MAXH2.24 < H26 AND H26 > MAXH2.27, H26, IIF(MAXH2.25 < H27 AND H27 > MAXH2.28, H27, IIF(MAXH2.26 < H28 AND H28 > MAXH2.29, H28, IIF(MAXH2.27 < H29 AND H29 > MAXH2.30, H29, IIF(MAXH2.28 < H30 AND H30 > MAXH2.31, H30, IIF(MAXH2.29 < H31 AND H31 > MAXH2.32, H31, IIF(MAXH2.30 < H32 AND H32 > MAXH2.33, H32, IIF(MAXH2.31 < H33 AND H33 > MAXH2.34, H33, IIF(MAXH2.32 < H34 AND H34 > MAXH2.35, H34, IIF(MAXH2.33 < H35 AND H35 > MAXH2.36, H35, IIF(MAXH2.34 < H36 AND H36 > MAXH2.37, H36, IIF(MAXH2.35 < H37 AND H37 > MAXH2.38, H37, IIF(MAXH2.36 < H38 AND H38 > MAXH2.39, H38, IIF(MAXH2.37 < H39 AND H39 > MAXH2.40, H39, IIF(MAXH2.38 < H40 AND H40 > MAXH2.41, H40, IIF(MAXH2.39 < H41 AND H41 > MAXH2.42, H41, IIF(MAXH2.40 < H42 AND H42 > MAXH2.43, H42, IIF(MAXH2.41 < H43 AND H43 > MAXH2.44, H43, IIF(MAXH2.42 < H44 AND H44 > MAXH2.45, H44, IIF(MAXH2.43 < H45 AND H45 > MAXH2.46, H45, IIF(MAXH2.44 < H46 AND H46 > MAXH2.47, H46, IIF(MAXH2.45 < H47 AND H47 > MAXH2.48, H47, IIF(MAXH2.46 < H48 AND H48 > MAXH2.49, H48, IIF(MAXH2.47 < H49 AND H49 > MAXH2.50, H49, IIF(MAXH2.48 < H50 AND H50 > MAXH2.51, H50, IIF(MAXH2.49 < H51 AND H51 > MAXH2.52, H51, IIF(MAXH2.50 < H52 AND H52 > MAXH2.53, H52, IIF(MAXH2.51 < H53 AND H53 > MAXH2.54, H53, IIF(MAXH2.52 < H54 AND H54 > MAXH2.55, H54, IIF(MAXH2.53 < H55 AND H55 > MAXH2.56, H55, IIF(MAXH2.54 < H56 AND H56 > MAXH2.57, H56, IIF(MAXH2.55 < H57 AND H57 > MAXH2.58, H57, IIF(MAXH2.56 < H58 AND H58 > MAXH2.59, H58, IIF(MAXH2.57 < H59 AND H59 > MAXH2.60, H59, IIF(MAXH2.58 < H60 AND H60 > MAXH2.61, H60, IIF(MAXH2.59 < H61 AND H61 > MAXH2.62, H61, IIF(MAXH2.60 < H62 AND H62 > MAXH2.63, H62, IIF(MAXH2.61 < H63 AND H63 > MAXH2.64, H63, IIF(MAXH2.62 < H64 AND H64 > MAXH2.65, H64, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), 1, 0) + IIF(MINL2 > L2 AND L2 < MINL2.3 AND L2 < IIF(MINL2.3 > L5 AND L5 < MINL2.6, L5, IIF(MINL2.4 > L6 AND L6 < MINL2.7, L6, IIF(MINL2.5 > L7 AND L7 < MINL2.8, L7, IIF(MINL2.6 > L8 AND L8 < MINL2.9, L8, IIF(MINL2.7 > L9 AND L9 < MINL2.10, L9, IIF(MINL2.8 > L10 AND L10 < MINL2.11, L10, IIF(MINL2.9 > L11 AND L11 < MINL2.12, L11, IIF(MINL2.10 > L12 AND L12 < MINL2.13, L12, IIF(MINL2.11 > L13 AND L13 < MINL2.14, L13, IIF(MINL2.12 > L14 AND L14 < MINL2.15, L14, IIF(MINL2.13 > L15 AND L15 < MINL2.16, L15, IIF(MINL2.14 > L16 AND L16 < MINL2.17, L16, IIF(MINL2.15 > L17 AND L17 < MINL2.18, L17, IIF(MINL2.16 > L18 AND L18 < MINL2.19, L18, IIF(MINL2.17 > L19 AND L19 < MINL2.20, L19, IIF(MINL2.18 > L20 AND L20 < MINL2.21, L20, IIF(MINL2.19 > L21 AND L21 < MINL2.22, L21, IIF(MINL2.20 > L22 AND L22 < MINL2.23, L22, IIF(MINL2.21 > L23 AND L23 < MINL2.24, L23, IIF(MINL2.22 > L24 AND L24 < MINL2.25, L24, IIF(MINL2.23 > L25 AND L25 < MINL2.26, L25, IIF(MINL2.24 > L26 AND L26 < MINL2.27, L26, IIF(MINL2.25 > L27 AND L27 < MINL2.28, L27, IIF(MINL2.26 > L28 AND L28 < MINL2.29, L28, IIF(MINL2.27 > L29 AND L29 < MINL2.30, L29, IIF(MINL2.28 > L30 AND L30 < MINL2.31, L30, IIF(MINL2.29 > L31 AND L31 < MINL2.32, L31, IIF(MINL2.30 > L32 AND L32 < MINL2.33, L32, IIF(MINL2.31 > L33 AND L33 < MINL2.34, L33, IIF(MINL2.32 > L34 AND L34 < MINL2.35, L34, IIF(MINL2.33 > L35 AND L35 < MINL2.36, L35, IIF(MINL2.34 > L36 AND L36 < MINL2.37, L36, IIF(MINL2.35 > L37 AND L37 < MINL2.38, L37, IIF(MINL2.36 > L38 AND L38 < MINL2.39, L38, IIF(MINL2.37 > L39 AND L39 < MINL2.40, L39, IIF(MINL2.38 > L40 AND L40 < MINL2.41, L40, IIF(MINL2.39 > L41 AND L41 < MINL2.42, L41, IIF(MINL2.40 > L42 AND L42 < MINL2.43, L42, IIF(MINL2.41 > L43 AND L43 < MINL2.44, L43, IIF(MINL2.42 > L44 AND L44 < MINL2.45, L44, IIF(MINL2.43 > L45 AND L45 < MINL2.46, L45, IIF(MINL2.44 > L46 AND L46 < MINL2.47, L46, IIF(MINL2.45 > L47 AND L47 < MINL2.48, L47, IIF(MINL2.46 > L48 AND L48 < MINL2.49, L48, IIF(MINL2.47 > L49 AND L49 < MINL2.50, L49, IIF(MINL2.48 > L50 AND L50 < MINL2.51, L50, IIF(MINL2.49 > L51 AND L51 < MINL2.52, L51, IIF(MINL2.50 > L52 AND L52 < MINL2.53, L52, IIF(MINL2.51 > L53 AND L53 < MINL2.54, L53, IIF(MINL2.52 > L54 AND L54 < MINL2.55, L54, IIF(MINL2.53 > L55 AND L55 < MINL2.56, L55, IIF(MINL2.54 > L56 AND L56 < MINL2.57, L56, IIF(MINL2.55 > L57 AND L57 < MINL2.58, L57, IIF(MINL2.56 > L58 AND L58 < MINL2.59, L58, IIF(MINL2.57 > L59 AND L59 < MINL2.60, L59, IIF(MINL2.58 > L60 AND L60 < MINL2.61, L60, IIF(MINL2.59 > L61 AND L61 < MINL2.62, L61, IIF(MINL2.60 > L62 AND L62 < MINL2.63, L62, IIF(MINL2.61 > L63 AND L63 < MINL2.64, L63, IIF(MINL2.62 > L64 AND L64 < MINL2.65, L64, 1 / 0)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), -1, 0)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dhirenshah
Posted : Monday, October 9, 2017 2:56:50 PM
Registered User
Joined: 3/10/2012
Posts: 465

Thanks Bruce what you created is correct thats what i wanted its pattern trading 

Cheers

Bruce_L
Posted : Monday, October 9, 2017 2:57:40 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

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.