Registered User Joined: 3/10/2012 Posts: 465
|
Hi Bruce
You did this below formula for me and i added Since true on it they work perfect as count but a small change i m trying to do is make that as a oscillator to overlay the formula on top of each other when either is true becaue i like to plot them as histogram
So When SinceTrue(C > IIF(MAXH2 is above the SinceTrue(C < IIF(MINL2 and Vice Versa SO i can get dominant trend ....
below is the formula
SinceTrue(C < IIF(MINL2 > L2 AND L2 < MINL2.3, C, IIF(MINL2.1 > L3 AND L3 < MINL2.4, L3, IIF(MINL2.2 > L4 AND L4 < MINL2.5, IIF(C1 > L4, L4, C), IIF(MINL2.3 > L5 AND L5 < MINL2.6, IIF(MINC2.1 > L5, L5, C), IIF(MINL2.4 > L6 AND L6 < MINL2.7, IIF(MINC3.1 > L6, L6, C), IIF(MINL2.5 > L7 AND L7 < MINL2.8, IIF(MINC4.1 > L7, L7, C), IIF(MINL2.6 > L8 AND L8 < MINL2.9, IIF(MINC5.1 > L8, L8, C), IIF(MINL2.7 > L9 AND L9 < MINL2.10, IIF(MINC6.1 > L9, L9, C), IIF(MINL2.8 > L10 AND L10 < MINL2.11, IIF(MINC7.1 > L10, L10, C), IIF(MINL2.9 > L11 AND L11 < MINL2.12, IIF(MINC8.1 > L11, L11, C), IIF(MINL2.10 > L12 AND L12 < MINL2.13, IIF(MINC9.1 > L12, L12, C), IIF(MINL2.11 > L13 AND L13 < MINL2.14, IIF(MINC10.1 > L13, L13, C), IIF(MINL2.12 > L14 AND L14 < MINL2.15, IIF(MINC11.1 > L14, L14, C), IIF(MINL2.13 > L15 AND L15 < MINL2.16, IIF(MINC12.1 > L15, L15, C), IIF(MINL2.14 > L16 AND L16 < MINL2.17, IIF(MINC13.1 > L16, L16, C), IIF(MINL2.15 > L17 AND L17 < MINL2.18, IIF(MINC14.1 > L17, L17, C), IIF(MINL2.16 > L18 AND L18 < MINL2.19, IIF(MINC15.1 > L18, L18, C), IIF(MINL2.17 > L19 AND L19 < MINL2.20, IIF(MINC16.1 > L19, L19, C), IIF(MINL2.18 > L20 AND L20 < MINL2.21, IIF(MINC17.1 > L20, L20, C), IIF(MINL2.19 > L21 AND L21 < MINL2.22, IIF(MINC18.1 > L21, L21, C), IIF(MINL2.20 > L22 AND L22 < MINL2.23, IIF(MINC19.1 > L22, L22, C), IIF(MINL2.21 > L23 AND L23 < MINL2.24, IIF(MINC20.1 > L23, L23, C), IIF(MINL2.22 > L24 AND L24 < MINL2.25, IIF(MINC21.1 > L24, L24, C), IIF(MINL2.23 > L25 AND L25 < MINL2.26, IIF(MINC22.1 > L25, L25, C), IIF(MINL2.24 > L26 AND L26 < MINL2.27, IIF(MINC23.1 > L26, L26, C), IIF(MINL2.25 > L27 AND L27 < MINL2.28, IIF(MINC24.1 > L27, L27, C), IIF(MINL2.26 > L28 AND L28 < MINL2.29, IIF(MINC25.1 > L28, L28, C), IIF(MINL2.27 > L29 AND L29 < MINL2.30, IIF(MINC26.1 > L29, L29, C), IIF(MINL2.28 > L30 AND L30 < MINL2.31, IIF(MINC27.1 > L30, L30, C), IIF(MINL2.29 > L31 AND L31 < MINL2.32, IIF(MINC28.1 > L31, L31, C), IIF(MINL2.30 > L32 AND L32 < MINL2.33, IIF(MINC29.1 > L32, L32, C), IIF(MINL2.31 > L33 AND L33 < MINL2.34, IIF(MINC30.1 > L33, L33, C), IIF(MINL2.32 > L34 AND L34 < MINL2.35, IIF(MINC31.1 > L34, L34, C), IIF(MINL2.33 > L35 AND L35 < MINL2.36, IIF(MINC32.1 > L35, L35, C), IIF(MINL2.34 > L36 AND L36 < MINL2.37, IIF(MINC33.1 > L36, L36, C), IIF(MINL2.35 > L37 AND L37 < MINL2.38, IIF(MINC34.1 > L37, L37, C), IIF(MINL2.36 > L38 AND L38 < MINL2.39, IIF(MINC35.1 > L38, L38, C), IIF(MINL2.37 > L39 AND L39 < MINL2.40, IIF(MINC36.1 > L39, L39, C), IIF(MINL2.38 > L40 AND L40 < MINL2.41, IIF(MINC37.1 > L40, L40, C), IIF(MINL2.39 > L41 AND L41 < MINL2.42, IIF(MINC38.1 > L41, L41, C), IIF(MINL2.40 > L42 AND L42 < MINL2.43, IIF(MINC39.1 > L42, L42, C), IIF(MINL2.41 > L43 AND L43 < MINL2.44, IIF(MINC40.1 > L43, L43, C), IIF(MINL2.42 > L44 AND L44 < MINL2.45, IIF(MINC41.1 > L44, L44, C), IIF(MINL2.43 > L45 AND L45 < MINL2.46, IIF(MINC42.1 > L45, L45, C), IIF(MINL2.44 > L46 AND L46 < MINL2.47, IIF(MINC43.1 > L46, L46, C), IIF(MINL2.45 > L47 AND L47 < MINL2.48, IIF(MINC44.1 > L47, L47, C), IIF(MINL2.46 > L48 AND L48 < MINL2.49, IIF(MINC45.1 > L48, L48, C), IIF(MINL2.47 > L49 AND L49 < MINL2.50, IIF(MINC46.1 > L49, L49, C), IIF(MINL2.48 > L50 AND L50 < MINL2.51, IIF(MINC47.1 > L50, L50, C), IIF(MINL2.49 > L51 AND L51 < MINL2.52, IIF(MINC48.1 > L51, L51, C), IIF(MINL2.50 > L52 AND L52 < MINL2.53, IIF(MINC49.1 > L52, L52, C), IIF(MINL2.51 > L53 AND L53 < MINL2.54, IIF(MINC50.1 > L53, L53, C), IIF(MINL2.52 > L54 AND L54 < MINL2.55, IIF(MINC51.1 > L54, L54, C), IIF(MINL2.53 > L55 AND L55 < MINL2.56, IIF(MINC52.1 > L55, L55, C), IIF(MINL2.54 > L56 AND L56 < MINL2.57, IIF(MINC53.1 > L56, L56, C), IIF(MINL2.55 > L57 AND L57 < MINL2.58, IIF(MINC54.1 > L57, L57, C), IIF(MINL2.56 > L58 AND L58 < MINL2.59, IIF(MINC55.1 > L58, L58, C), IIF(MINL2.57 > L59 AND L59 < MINL2.60, IIF(MINC56.1 > L59, L59, C), IIF(MINL2.58 > L60 AND L60 < MINL2.61, IIF(MINC57.1 > L60, L60, C), IIF(MINL2.59 > L61 AND L61 < MINL2.62, IIF(MINC58.1 > L61, L61, C), IIF(MINL2.60 > L62 AND L62 < MINL2.63, IIF(MINC59.1 > L62, L62, C), IIF(MINL2.61 > L63 AND L63 < MINL2.64, IIF(MINC60.1 > L63, L63, C), IIF(MINL2.62 > L64 AND L64 < MINL2.65, IIF(MINC61.1 > L64, L64, C), IIF(MINL2.63 > L65 AND L65 < MINL2.66, IIF(MINC62.1 > L65, L65, C), IIF(MINL2.64 > L66 AND L66 < MINL2.67, IIF(MINC63.1 > L66, L66, C), IIF(MINL2.65 > L67 AND L67 < MINL2.68, IIF(MINC64.1 > L67, L67, C), IIF(MINL2.66 > L68 AND L68 < MINL2.69, IIF(MINC65.1 > L68, L68, C), IIF(MINL2.67 > L69 AND L69 < MINL2.70, IIF(MINC66.1 > L69, L69, C), IIF(MINL2.68 > L70 AND L70 < MINL2.71, IIF(MINC67.1 > L70, L70, C), IIF(MINL2.69 > L71 AND L71 < MINL2.72, IIF(MINC68.1 > L71, L71, C), IIF(MINL2.70 > L72 AND L72 < MINL2.73, IIF(MINC69.1 > L72, L72, C), IIF(MINL2.71 > L73 AND L73 < MINL2.74, IIF(MINC70.1 > L73, L73, C), IIF(MINL2.72 > L74 AND L74 < MINL2.75, IIF(MINC71.1 > L74, L74, C), IIF(MINL2.73 > L75 AND L75 < MINL2.76, IIF(MINC72.1 > L75, L75, C), IIF(MINL2.74 > L76 AND L76 < MINL2.77, IIF(MINC73.1 > L76, L76, C), IIF(MINL2.75 > L77 AND L77 < MINL2.78, IIF(MINC74.1 > L77, L77, C), IIF(MINL2.76 > L78 AND L78 < MINL2.79, IIF(MINC75.1 > L78, L78, C), IIF(MINL2.77 > L79 AND L79 < MINL2.80, IIF(MINC76.1 > L79, L79, C), IIF(MINL2.78 > L80 AND L80 < MINL2.81, IIF(MINC77.1 > L80, L80, C), IIF(MINL2.79 > L81 AND L81 < MINL2.82, IIF(MINC78.1 > L81, L81, C), IIF(MINL2.80 > L82 AND L82 < MINL2.83, IIF(MINC79.1 > L82, L82, C), IIF(MINL2.81 > L83 AND L83 < MINL2.84, IIF(MINC80.1 > L83, L83, C), IIF(MINL2.82 > L84 AND L84 < MINL2.85, IIF(MINC81.1 > L84, L84, C), IIF(MINL2.83 > L85 AND L85 < MINL2.86, IIF(MINC82.1 > L85, L85, C), IIF(MINL2.84 > L86 AND L86 < MINL2.87, IIF(MINC83.1 > L86, L86, C), IIF(MINL2.85 > L87 AND L87 < MINL2.88, IIF(MINC84.1 > L87, L87, C), IIF(MINL2.86 > L88 AND L88 < MINL2.89, IIF(MINC85.1 > L88, L88, C), IIF(MINL2.87 > L89 AND L89 < MINL2.90, IIF(MINC86.1 > L89, L89, C), IIF(MINL2.88 > L90 AND L90 < MINL2.91, IIF(MINC87.1 > L90, L90, C), IIF(MINL2.89 > L91 AND L91 < MINL2.92, IIF(MINC88.1 > L91, L91, C), IIF(MINL2.90 > L92 AND L92 < MINL2.93, IIF(MINC89.1 > L92, L92, C), IIF(MINL2.91 > L93 AND L93 < MINL2.94, IIF(MINC90.1 > L93, L93, C), IIF(MINL2.92 > L94 AND L94 < MINL2.95, IIF(MINC91.1 > L94, L94, C), IIF(MINL2.93 > L95 AND L95 < MINL2.96, IIF(MINC92.1 > L95, L95, C), IIF(MINL2.94 > L96 AND L96 < MINL2.97, IIF(MINC93.1 > L96, L96, C), IIF(MINL2.95 > L97 AND L97 < MINL2.98, IIF(MINC94.1 > L97, L97, C), IIF(MINL2.96 > L98 AND L98 < MINL2.99, IIF(MINC95.1 > L98, L98, C), IIF(MINL2.97 > L99 AND L99 < MINL2.100, IIF(MINC96.1 > L99, L99, C), IIF(MINL2.98 > L100 AND L100 < MINL2.101, IIF(MINC97.1 > L100, L100, C), IIF(MINL2.99 > L101 AND L101 < MINL2.102, IIF(MINC98.1 > L101, L101, C), C))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
, 200)
SinceTrue(C > IIF(MAXH2 < H2 AND H2 > MAXH2.3, C, IIF(MAXH2.1 < H3 AND H3 > MAXH2.4, H3, IIF(MAXH2.2 < H4 AND H4 > MAXH2.5, IIF(C1 < H4, H4, C), IIF(MAXH2.3 < H5 AND H5 > MAXH2.6, IIF(MAXC2.1 < H5, H5, C), IIF(MAXH2.4 < H6 AND H6 > MAXH2.7, IIF(MAXC3.1 < H6, H6, C), IIF(MAXH2.5 < H7 AND H7 > MAXH2.8, IIF(MAXC4.1 < H7, H7, C), IIF(MAXH2.6 < H8 AND H8 > MAXH2.9, IIF(MAXC5.1 < H8, H8, C), IIF(MAXH2.7 < H9 AND H9 > MAXH2.10, IIF(MAXC6.1 < H9, H9, C), IIF(MAXH2.8 < H10 AND H10 > MAXH2.11, IIF(MAXC7.1 < H10, H10, C), IIF(MAXH2.9 < H11 AND H11 > MAXH2.12, IIF(MAXC8.1 < H11, H11, C), IIF(MAXH2.10 < H12 AND H12 > MAXH2.13, IIF(MAXC9.1 < H12, H12, C), IIF(MAXH2.11 < H13 AND H13 > MAXH2.14, IIF(MAXC10.1 < H13, H13, C), IIF(MAXH2.12 < H14 AND H14 > MAXH2.15, IIF(MAXC11.1 < H14, H14, C), IIF(MAXH2.13 < H15 AND H15 > MAXH2.16, IIF(MAXC12.1 < H15, H15, C), IIF(MAXH2.14 < H16 AND H16 > MAXH2.17, IIF(MAXC13.1 < H16, H16, C), IIF(MAXH2.15 < H17 AND H17 > MAXH2.18, IIF(MAXC14.1 < H17, H17, C), IIF(MAXH2.16 < H18 AND H18 > MAXH2.19, IIF(MAXC15.1 < H18, H18, C), IIF(MAXH2.17 < H19 AND H19 > MAXH2.20, IIF(MAXC16.1 < H19, H19, C), IIF(MAXH2.18 < H20 AND H20 > MAXH2.21, IIF(MAXC17.1 < H20, H20, C), IIF(MAXH2.19 < H21 AND H21 > MAXH2.22, IIF(MAXC18.1 < H21, H21, C), IIF(MAXH2.20 < H22 AND H22 > MAXH2.23, IIF(MAXC19.1 < H22, H22, C), IIF(MAXH2.21 < H23 AND H23 > MAXH2.24, IIF(MAXC20.1 < H23, H23, C), IIF(MAXH2.22 < H24 AND H24 > MAXH2.25, IIF(MAXC21.1 < H24, H24, C), IIF(MAXH2.23 < H25 AND H25 > MAXH2.26, IIF(MAXC22.1 < H25, H25, C), IIF(MAXH2.24 < H26 AND H26 > MAXH2.27, IIF(MAXC23.1 < H26, H26, C), IIF(MAXH2.25 < H27 AND H27 > MAXH2.28, IIF(MAXC24.1 < H27, H27, C), IIF(MAXH2.26 < H28 AND H28 > MAXH2.29, IIF(MAXC25.1 < H28, H28, C), IIF(MAXH2.27 < H29 AND H29 > MAXH2.30, IIF(MAXC26.1 < H29, H29, C), IIF(MAXH2.28 < H30 AND H30 > MAXH2.31, IIF(MAXC27.1 < H30, H30, C), IIF(MAXH2.29 < H31 AND H31 > MAXH2.32, IIF(MAXC28.1 < H31, H31, C), IIF(MAXH2.30 < H32 AND H32 > MAXH2.33, IIF(MAXC29.1 < H32, H32, C), IIF(MAXH2.31 < H33 AND H33 > MAXH2.34, IIF(MAXC30.1 < H33, H33, C), IIF(MAXH2.32 < H34 AND H34 > MAXH2.35, IIF(MAXC31.1 < H34, H34, C), IIF(MAXH2.33 < H35 AND H35 > MAXH2.36, IIF(MAXC32.1 < H35, H35, C), IIF(MAXH2.34 < H36 AND H36 > MAXH2.37, IIF(MAXC33.1 < H36, H36, C), IIF(MAXH2.35 < H37 AND H37 > MAXH2.38, IIF(MAXC34.1 < H37, H37, C), IIF(MAXH2.36 < H38 AND H38 > MAXH2.39, IIF(MAXC35.1 < H38, H38, C), IIF(MAXH2.37 < H39 AND H39 > MAXH2.40, IIF(MAXC36.1 < H39, H39, C), IIF(MAXH2.38 < H40 AND H40 > MAXH2.41, IIF(MAXC37.1 < H40, H40, C), IIF(MAXH2.39 < H41 AND H41 > MAXH2.42, IIF(MAXC38.1 < H41, H41, C), IIF(MAXH2.40 < H42 AND H42 > MAXH2.43, IIF(MAXC39.1 < H42, H42, C), IIF(MAXH2.41 < H43 AND H43 > MAXH2.44, IIF(MAXC40.1 < H43, H43, C), IIF(MAXH2.42 < H44 AND H44 > MAXH2.45, IIF(MAXC41.1 < H44, H44, C), IIF(MAXH2.43 < H45 AND H45 > MAXH2.46, IIF(MAXC42.1 < H45, H45, C), IIF(MAXH2.44 < H46 AND H46 > MAXH2.47, IIF(MAXC43.1 < H46, H46, C), IIF(MAXH2.45 < H47 AND H47 > MAXH2.48, IIF(MAXC44.1 < H47, H47, C), IIF(MAXH2.46 < H48 AND H48 > MAXH2.49, IIF(MAXC45.1 < H48, H48, C), IIF(MAXH2.47 < H49 AND H49 > MAXH2.50, IIF(MAXC46.1 < H49, H49, C), IIF(MAXH2.48 < H50 AND H50 > MAXH2.51, IIF(MAXC47.1 < H50, H50, C), IIF(MAXH2.49 < H51 AND H51 > MAXH2.52, IIF(MAXC48.1 < H51, H51, C), IIF(MAXH2.50 < H52 AND H52 > MAXH2.53, IIF(MAXC49.1 < H52, H52, C), IIF(MAXH2.51 < H53 AND H53 > MAXH2.54, IIF(MAXC50.1 < H53, H53, C), IIF(MAXH2.52 < H54 AND H54 > MAXH2.55, IIF(MAXC51.1 < H54, H54, C), IIF(MAXH2.53 < H55 AND H55 > MAXH2.56, IIF(MAXC52.1 < H55, H55, C), IIF(MAXH2.54 < H56 AND H56 > MAXH2.57, IIF(MAXC53.1 < H56, H56, C), IIF(MAXH2.55 < H57 AND H57 > MAXH2.58, IIF(MAXC54.1 < H57, H57, C), IIF(MAXH2.56 < H58 AND H58 > MAXH2.59, IIF(MAXC55.1 < H58, H58, C), IIF(MAXH2.57 < H59 AND H59 > MAXH2.60, IIF(MAXC56.1 < H59, H59, C), IIF(MAXH2.58 < H60 AND H60 > MAXH2.61, IIF(MAXC57.1 < H60, H60, C), IIF(MAXH2.59 < H61 AND H61 > MAXH2.62, IIF(MAXC58.1 < H61, H61, C), IIF(MAXH2.60 < H62 AND H62 > MAXH2.63, IIF(MAXC59.1 < H62, H62, C), IIF(MAXH2.61 < H63 AND H63 > MAXH2.64, IIF(MAXC60.1 < H63, H63, C), IIF(MAXH2.62 < H64 AND H64 > MAXH2.65, IIF(MAXC61.1 < H64, H64, C), IIF(MAXH2.63 < H65 AND H65 > MAXH2.66, IIF(MAXC62.1 < H65, H65, C), IIF(MAXH2.64 < H66 AND H66 > MAXH2.67, IIF(MAXC63.1 < H66, H66, C), IIF(MAXH2.65 < H67 AND H67 > MAXH2.68, IIF(MAXC64.1 < H67, H67, C), IIF(MAXH2.66 < H68 AND H68 > MAXH2.69, IIF(MAXC65.1 < H68, H68, C), IIF(MAXH2.67 < H69 AND H69 > MAXH2.70, IIF(MAXC66.1 < H69, H69, C), IIF(MAXH2.68 < H70 AND H70 > MAXH2.71, IIF(MAXC67.1 < H70, H70, C), IIF(MAXH2.69 < H71 AND H71 > MAXH2.72, IIF(MAXC68.1 < H71, H71, C), IIF(MAXH2.70 < H72 AND H72 > MAXH2.73, IIF(MAXC69.1 < H72, H72, C), IIF(MAXH2.71 < H73 AND H73 > MAXH2.74, IIF(MAXC70.1 < H73, H73, C), IIF(MAXH2.72 < H74 AND H74 > MAXH2.75, IIF(MAXC71.1 < H74, H74, C), IIF(MAXH2.73 < H75 AND H75 > MAXH2.76, IIF(MAXC72.1 < H75, H75, C), IIF(MAXH2.74 < H76 AND H76 > MAXH2.77, IIF(MAXC73.1 < H76, H76, C), IIF(MAXH2.75 < H77 AND H77 > MAXH2.78, IIF(MAXC74.1 < H77, H77, C), IIF(MAXH2.76 < H78 AND H78 > MAXH2.79, IIF(MAXC75.1 < H78, H78, C), IIF(MAXH2.77 < H79 AND H79 > MAXH2.80, IIF(MAXC76.1 < H79, H79, C), IIF(MAXH2.78 < H80 AND H80 > MAXH2.81, IIF(MAXC77.1 < H80, H80, C), IIF(MAXH2.79 < H81 AND H81 > MAXH2.82, IIF(MAXC78.1 < H81, H81, C), IIF(MAXH2.80 < H82 AND H82 > MAXH2.83, IIF(MAXC79.1 < H82, H82, C), IIF(MAXH2.81 < H83 AND H83 > MAXH2.84, IIF(MAXC80.1 < H83, H83, C), IIF(MAXH2.82 < H84 AND H84 > MAXH2.85, IIF(MAXC81.1 < H84, H84, C), IIF(MAXH2.83 < H85 AND H85 > MAXH2.86, IIF(MAXC82.1 < H85, H85, C), IIF(MAXH2.84 < H86 AND H86 > MAXH2.87, IIF(MAXC83.1 < H86, H86, C), IIF(MAXH2.85 < H87 AND H87 > MAXH2.88, IIF(MAXC84.1 < H87, H87, C), IIF(MAXH2.86 < H88 AND H88 > MAXH2.89, IIF(MAXC85.1 < H88, H88, C), IIF(MAXH2.87 < H89 AND H89 > MAXH2.90, IIF(MAXC86.1 < H89, H89, C), IIF(MAXH2.88 < H90 AND H90 > MAXH2.91, IIF(MAXC87.1 < H90, H90, C), IIF(MAXH2.89 < H91 AND H91 > MAXH2.92, IIF(MAXC88.1 < H91, H91, C), IIF(MAXH2.90 < H92 AND H92 > MAXH2.93, IIF(MAXC89.1 < H92, H92, C), IIF(MAXH2.91 < H93 AND H93 > MAXH2.94, IIF(MAXC90.1 < H93, H93, C), IIF(MAXH2.92 < H94 AND H94 > MAXH2.95, IIF(MAXC91.1 < H94, H94, C), IIF(MAXH2.93 < H95 AND H95 > MAXH2.96, IIF(MAXC92.1 < H95, H95, C), IIF(MAXH2.94 < H96 AND H96 > MAXH2.97, IIF(MAXC93.1 < H96, H96, C), IIF(MAXH2.95 < H97 AND H97 > MAXH2.98, IIF(MAXC94.1 < H97, H97, C), IIF(MAXH2.96 < H98 AND H98 > MAXH2.99, IIF(MAXC95.1 < H98, H98, C), IIF(MAXH2.97 < H99 AND H99 > MAXH2.100, IIF(MAXC96.1 < H99, H99, C), IIF(MAXH2.98 < H100 AND H100 > MAXH2.101, IIF(MAXC97.1 < H100, H100, C), IIF(MAXH2.99 < H101 AND H101 > MAXH2.102, IIF(MAXC98.1 < H101, H101, C), C)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) , 200)
I don't need any other change in the formula , I tried but it gives me syntax error
thanks
Dhiren
|