Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you really mean just the 33 day low, then you wouldn't need to keep plotting it for 100 bars since you only need to look at 33 bars to know the 33 day low.
MINL33
If you mean the low of the current bar was lower than any of the previous 33 bars, then there isn't an easy way to do it. The formula is going to be pretty long.
IIF(L < MINL33.1, L, IIF(L1 < MINL33.2, L1, IIF(L2 < MINL33.3, L2, IIF(L3 < MINL33.4, L3, IIF(L4 < MINL33.5, L4, IIF(L5 < MINL33.6, L5, IIF(L6 < MINL33.7, L6, IIF(L7 < MINL33.8, L7, IIF(L8 < MINL33.9, L8, IIF(L9 < MINL33.10, L9, IIF(L10 < MINL33.11, L10, IIF(L11 < MINL33.12, L11, IIF(L12 < MINL33.13, L12, IIF(L13 < MINL33.14, L13, IIF(L14 < MINL33.15, L14, IIF(L15 < MINL33.16, L15, IIF(L16 < MINL33.17, L16, IIF(L17 < MINL33.18, L17, IIF(L18 < MINL33.19, L18, IIF(L19 < MINL33.20, L19, IIF(L20 < MINL33.21, L20, IIF(L21 < MINL33.22, L21, IIF(L22 < MINL33.23, L22, IIF(L23 < MINL33.24, L23, IIF(L24 < MINL33.25, L24, IIF(L25 < MINL33.26, L25, IIF(L26 < MINL33.27, L26, IIF(L27 < MINL33.28, L27, IIF(L28 < MINL33.29, L28, IIF(L29 < MINL33.30, L29, IIF(L30 < MINL33.31, L30, IIF(L31 < MINL33.32, L31, IIF(L32 < MINL33.33, L32, IIF(L33 < MINL33.34, L33, IIF(L34 < MINL33.35, L34, IIF(L35 < MINL33.36, L35, IIF(L36 < MINL33.37, L36, IIF(L37 < MINL33.38, L37, IIF(L38 < MINL33.39, L38, IIF(L39 < MINL33.40, L39, IIF(L40 < MINL33.41, L40, IIF(L41 < MINL33.42, L41, IIF(L42 < MINL33.43, L42, IIF(L43 < MINL33.44, L43, IIF(L44 < MINL33.45, L44, IIF(L45 < MINL33.46, L45, IIF(L46 < MINL33.47, L46, IIF(L47 < MINL33.48, L47, IIF(L48 < MINL33.49, L48, IIF(L49 < MINL33.50, L49, IIF(L50 < MINL33.51, L50, IIF(L51 < MINL33.52, L51, IIF(L52 < MINL33.53, L52, IIF(L53 < MINL33.54, L53, IIF(L54 < MINL33.55, L54, IIF(L55 < MINL33.56, L55, IIF(L56 < MINL33.57, L56, IIF(L57 < MINL33.58, L57, IIF(L58 < MINL33.59, L58, IIF(L59 < MINL33.60, L59, IIF(L60 < MINL33.61, L60, IIF(L61 < MINL33.62, L61, IIF(L62 < MINL33.63, L62, IIF(L63 < MINL33.64, L63, IIF(L64 < MINL33.65, L64, IIF(L65 < MINL33.66, L65, IIF(L66 < MINL33.67, L66, IIF(L67 < MINL33.68, L67, IIF(L68 < MINL33.69, L68, IIF(L69 < MINL33.70, L69, IIF(L70 < MINL33.71, L70, IIF(L71 < MINL33.72, L71, IIF(L72 < MINL33.73, L72, IIF(L73 < MINL33.74, L73, IIF(L74 < MINL33.75, L74, IIF(L75 < MINL33.76, L75, IIF(L76 < MINL33.77, L76, IIF(L77 < MINL33.78, L77, IIF(L78 < MINL33.79, L78, IIF(L79 < MINL33.80, L79, IIF(L80 < MINL33.81, L80, IIF(L81 < MINL33.82, L81, IIF(L82 < MINL33.83, L82, IIF(L83 < MINL33.84, L83, IIF(L84 < MINL33.85, L84, IIF(L85 < MINL33.86, L85, IIF(L86 < MINL33.87, L86, IIF(L87 < MINL33.88, L87, IIF(L88 < MINL33.89, L88, IIF(L89 < MINL33.90, L89, IIF(L90 < MINL33.91, L90, IIF(L91 < MINL33.92, L91, IIF(L92 < MINL33.93, L92, IIF(L93 < MINL33.94, L93, IIF(L94 < MINL33.95, L94, IIF(L95 < MINL33.96, L95, IIF(L96 < MINL33.97, L96, IIF(L97 < MINL33.98, L97, IIF(L98 < MINL33.99, L98, IIF(L99 < MINL33.100, L99, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Put it in a text editor and use the replace function?
IIF(L < MINL22.1, L, IIF(L1 < MINL22.2, L1, IIF(L2 < MINL22.3, L2, IIF(L3 < MINL22.4, L3, IIF(L4 < MINL22.5, L4, IIF(L5 < MINL22.6, L5, IIF(L6 < MINL22.7, L6, IIF(L7 < MINL22.8, L7, IIF(L8 < MINL22.9, L8, IIF(L9 < MINL22.10, L9, IIF(L10 < MINL22.11, L10, IIF(L11 < MINL22.12, L11, IIF(L12 < MINL22.13, L12, IIF(L13 < MINL22.14, L13, IIF(L14 < MINL22.15, L14, IIF(L15 < MINL22.16, L15, IIF(L16 < MINL22.17, L16, IIF(L17 < MINL22.18, L17, IIF(L18 < MINL22.19, L18, IIF(L19 < MINL22.20, L19, IIF(L20 < MINL22.21, L20, IIF(L21 < MINL22.22, L21, IIF(L22 < MINL22.23, L22, IIF(L23 < MINL22.24, L23, IIF(L24 < MINL22.25, L24, IIF(L25 < MINL22.26, L25, IIF(L26 < MINL22.27, L26, IIF(L27 < MINL22.28, L27, IIF(L28 < MINL22.29, L28, IIF(L29 < MINL22.30, L29, IIF(L30 < MINL22.31, L30, IIF(L31 < MINL22.32, L31, IIF(L32 < MINL22.33, L32, IIF(L33 < MINL22.34, L33, IIF(L34 < MINL22.35, L34, IIF(L35 < MINL22.36, L35, IIF(L36 < MINL22.37, L36, IIF(L37 < MINL22.38, L37, IIF(L38 < MINL22.39, L38, IIF(L39 < MINL22.40, L39, IIF(L40 < MINL22.41, L40, IIF(L41 < MINL22.42, L41, IIF(L42 < MINL22.43, L42, IIF(L43 < MINL22.44, L43, IIF(L44 < MINL22.45, L44, IIF(L45 < MINL22.46, L45, IIF(L46 < MINL22.47, L46, IIF(L47 < MINL22.48, L47, IIF(L48 < MINL22.49, L48, IIF(L49 < MINL22.50, L49, IIF(L50 < MINL22.51, L50, IIF(L51 < MINL22.52, L51, IIF(L52 < MINL22.53, L52, IIF(L53 < MINL22.54, L53, IIF(L54 < MINL22.55, L54, IIF(L55 < MINL22.56, L55, IIF(L56 < MINL22.57, L56, IIF(L57 < MINL22.58, L57, IIF(L58 < MINL22.59, L58, IIF(L59 < MINL22.60, L59, IIF(L60 < MINL22.61, L60, IIF(L61 < MINL22.62, L61, IIF(L62 < MINL22.63, L62, IIF(L63 < MINL22.64, L63, IIF(L64 < MINL22.65, L64, IIF(L65 < MINL22.66, L65, IIF(L66 < MINL22.67, L66, IIF(L67 < MINL22.68, L67, IIF(L68 < MINL22.69, L68, IIF(L69 < MINL22.70, L69, IIF(L70 < MINL22.71, L70, IIF(L71 < MINL22.72, L71, IIF(L72 < MINL22.73, L72, IIF(L73 < MINL22.74, L73, IIF(L74 < MINL22.75, L74, IIF(L75 < MINL22.76, L75, IIF(L76 < MINL22.77, L76, IIF(L77 < MINL22.78, L77, IIF(L78 < MINL22.79, L78, IIF(L79 < MINL22.80, L79, IIF(L80 < MINL22.81, L80, IIF(L81 < MINL22.82, L81, IIF(L82 < MINL22.83, L82, IIF(L83 < MINL22.84, L83, IIF(L84 < MINL22.85, L84, IIF(L85 < MINL22.86, L85, IIF(L86 < MINL22.87, L86, IIF(L87 < MINL22.88, L87, IIF(L88 < MINL22.89, L88, IIF(L89 < MINL22.90, L89, IIF(L90 < MINL22.91, L90, IIF(L91 < MINL22.92, L91, IIF(L92 < MINL22.93, L92, IIF(L93 < MINL22.94, L93, IIF(L94 < MINL22.95, L94, IIF(L95 < MINL22.96, L95, IIF(L96 < MINL22.97, L96, IIF(L97 < MINL22.98, L97, IIF(L98 < MINL22.99, L98, IIF(L99 < MINL22.100, L99, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|