| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 12/9/2009
Posts: 9
|
Dear Worden SupportWondered whether you could help. I would like to create a pcf that allows me to search for stocks which have gapped up or down (in the direction of the trend) over the past 3 months and then price has pulled back or rallied up to the gap. Essentially I am looking for price to re-engage the trend once it has returned to the area of the gap.So the scan would basically 1) identify that a gap had occurred in the last 3 months and 2) that price (on the day you run the update) had returned to the area of the gap. Many thanks
|
|
Registered User
Joined: 12/9/2009
Posts: 9
|
Actually would it be possible to search for gaps in the last year. A good example of what I am looking for is stock CMCSA which gapped up on the 12/3/09. It then returned to the gap on 02/5/10 to 02/12/10 before re-engaging the upward trend.Thanks
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Warning: Long Personal Criteria Formulas can dramatically increase the time it takes to update your PCFs.
Price Above Most Recent Gap Down During Last Year:
C > ABS(H < L1) * L1 + ABS(H >= L1) * (ABS(H1 < L2) * L2 + ABS(H1 >= L2) * (ABS(H2 < L3) * L3 + ABS(H2 >= L3) * (ABS(H3 < L4) * L4 + ABS(H3 >= L4) * (ABS(H4 < L5) * L5 + ABS(H4 >= L5) * (ABS(H5 < L6) * L6 + ABS(H5 >= L6) * (ABS(H6 < L7) * L7 + ABS(H6 >= L7) * (ABS(H7 < L8) * L8 + ABS(H7 >= L8) * (ABS(H8 < L9) * L9 + ABS(H8 >= L9) * (ABS(H9 < L10) * L10 + ABS(H9 >= L10) * (ABS(H10 < L11) * L11 + ABS(H10 >= L11) * (ABS(H11 < L12) * L12 + ABS(H11 >= L12) * (ABS(H12 < L13) * L13 + ABS(H12 >= L13) * (ABS(H13 < L14) * L14 + ABS(H13 >= L14) * (ABS(H14 < L15) * L15 + ABS(H14 >= L15) * (ABS(H15 < L16) * L16 + ABS(H15 >= L16) * (ABS(H16 < L17) * L17 + ABS(H16 >= L17) * (ABS(H17 < L18) * L18 + ABS(H17 >= L18) * (ABS(H18 < L19) * L19 + ABS(H18 >= L19) * (ABS(H19 < L20) * L20 + ABS(H19 >= L20) * (ABS(H20 < L21) * L21 + ABS(H20 >= L21) * (ABS(H21 < L22) * L22 + ABS(H21 >= L22) * (ABS(H22 < L23) * L23 + ABS(H22 >= L23) * (ABS(H23 < L24) * L24 + ABS(H23 >= L24) * (ABS(H24 < L25) * L25 + ABS(H24 >= L25) * (ABS(H25 < L26) * L26 + ABS(H25 >= L26) * (ABS(H26 < L27) * L27 + ABS(H26 >= L27) * (ABS(H27 < L28) * L28 + ABS(H27 >= L28) * (ABS(H28 < L29) * L29 + ABS(H28 >= L29) * (ABS(H29 < L30) * L30 + ABS(H29 >= L30) * (ABS(H30 < L31) * L31 + ABS(H30 >= L31) * (ABS(H31 < L32) * L32 + ABS(H31 >= L32) * (ABS(H32 < L33) * L33 + ABS(H32 >= L33) * (ABS(H33 < L34) * L34 + ABS(H33 >= L34) * (ABS(H34 < L35) * L35 + ABS(H34 >= L35) * (ABS(H35 < L36) * L36 + ABS(H35 >= L36) * (ABS(H36 < L37) * L37 + ABS(H36 >= L37) * (ABS(H37 < L38) * L38 + ABS(H37 >= L38) * (ABS(H38 < L39) * L39 + ABS(H38 >= L39) * (ABS(H39 < L40) * L40 + ABS(H39 >= L40) * (ABS(H40 < L41) * L41 + ABS(H40 >= L41) * (ABS(H41 < L42) * L42 + ABS(H41 >= L42) * (ABS(H42 < L43) * L43 + ABS(H42 >= L43) * (ABS(H43 < L44) * L44 + ABS(H43 >= L44) * (ABS(H44 < L45) * L45 + ABS(H44 >= L45) * (ABS(H45 < L46) * L46 + ABS(H45 >= L46) * (ABS(H46 < L47) * L47 + ABS(H46 >= L47) * (ABS(H47 < L48) * L48 + ABS(H47 >= L48) * (ABS(H48 < L49) * L49 + ABS(H48 >= L49) * (ABS(H49 < L50) * L50 + ABS(H49 >= L50) * (ABS(H50 < L51) * L51 + ABS(H50 >= L51) * (ABS(H51 < L52) * L52 + ABS(H51 >= L52) * (ABS(H52 < L53) * L53 + ABS(H52 >= L53) * (ABS(H53 < L54) * L54 + ABS(H53 >= L54) * (ABS(H54 < L55) * L55 + ABS(H54 >= L55) * (ABS(H55 < L56) * L56 + ABS(H55 >= L56) * (ABS(H56 < L57) * L57 + ABS(H56 >= L57) * (ABS(H57 < L58) * L58 + ABS(H57 >= L58) * (ABS(H58 < L59) * L59 + ABS(H58 >= L59) * (ABS(H59 < L60) * L60 + ABS(H59 >= L60) * (ABS(H60 < L61) * L61 + ABS(H60 >= L61) * (ABS(H61 < L62) * L62 + ABS(H61 >= L62) * (ABS(H62 < L63) * L63 + ABS(H62 >= L63) * (ABS(H63 < L64) * L64 + ABS(H63 >= L64) * (ABS(H64 < L65) * L65 + ABS(H64 >= L65) * (ABS(H65 < L66) * L66 + ABS(H65 >= L66) * (ABS(H66 < L67) * L67 + ABS(H66 >= L67) * (ABS(H67 < L68) * L68 + ABS(H67 >= L68) * (ABS(H68 < L69) * L69 + ABS(H68 >= L69) * (ABS(H69 < L70) * L70 + ABS(H69 >= L70) * (ABS(H70 < L71) * L71 + ABS(H70 >= L71) * (ABS(H71 < L72) * L72 + ABS(H71 >= L72) * (ABS(H72 < L73) * L73 + ABS(H72 >= L73) * (ABS(H73 < L74) * L74 + ABS(H73 >= L74) * (ABS(H74 < L75) * L75 + ABS(H74 >= L75) * (ABS(H75 < L76) * L76 + ABS(H75 >= L76) * (ABS(H76 < L77) * L77 + ABS(H76 >= L77) * (ABS(H77 < L78) * L78 + ABS(H77 >= L78) * (ABS(H78 < L79) * L79 + ABS(H78 >= L79) * (ABS(H79 < L80) * L80 + ABS(H79 >= L80) * (ABS(H80 < L81) * L81 + ABS(H80 >= L81) * (ABS(H81 < L82) * L82 + ABS(H81 >= L82) * (ABS(H82 < L83) * L83 + ABS(H82 >= L83) * (ABS(H83 < L84) * L84 + ABS(H83 >= L84) * (ABS(H84 < L85) * L85 + ABS(H84 >= L85) * (ABS(H85 < L86) * L86 + ABS(H85 >= L86) * (ABS(H86 < L87) * L87 + ABS(H86 >= L87) * (ABS(H87 < L88) * L88 + ABS(H87 >= L88) * (ABS(H88 < L89) * L89 + ABS(H88 >= L89) * (ABS(H89 < L90) * L90 + ABS(H89 >= L90) * (ABS(H90 < L91) * L91 + ABS(H90 >= L91) * (ABS(H91 < L92) * L92 + ABS(H91 >= L92) * (ABS(H92 < L93) * L93 + ABS(H92 >= L93) * (ABS(H93 < L94) * L94 + ABS(H93 >= L94) * (ABS(H94 < L95) * L95 + ABS(H94 >= L95) * (ABS(H95 < L96) * L96 + ABS(H95 >= L96) * (ABS(H96 < L97) * L97 + ABS(H96 >= L97) * (ABS(H97 < L98) * L98 + ABS(H97 >= L98) * (ABS(H98 < L99) * L99 + ABS(H98 >= L99) * (ABS(H99 < L100) * L100 + ABS(H99 >= L100) * (ABS(H100 < L101) * L101 + ABS(H100 >= L101) * (ABS(H101 < L102) * L102 + ABS(H101 >= L102) * (ABS(H102 < L103) * L103 + ABS(H102 >= L103) * (ABS(H103 < L104) * L104 + ABS(H103 >= L104) * (ABS(H104 < L105) * L105 + ABS(H104 >= L105) * (ABS(H105 < L106) * L106 + ABS(H105 >= L106) * (ABS(H106 < L107) * L107 + ABS(H106 >= L107) * (ABS(H107 < L108) * L108 + ABS(H107 >= L108) * (ABS(H108 < L109) * L109 + ABS(H108 >= L109) * (ABS(H109 < L110) * L110 + ABS(H109 >= L110) * (ABS(H110 < L111) * L111 + ABS(H110 >= L111) * (ABS(H111 < L112) * L112 + ABS(H111 >= L112) * (ABS(H112 < L113) * L113 + ABS(H112 >= L113) * (ABS(H113 < L114) * L114 + ABS(H113 >= L114) * (ABS(H114 < L115) * L115 + ABS(H114 >= L115) * (ABS(H115 < L116) * L116 + ABS(H115 >= L116) * (ABS(H116 < L117) * L117 + ABS(H116 >= L117) * (ABS(H117 < L118) * L118 + ABS(H117 >= L118) * (ABS(H118 < L119) * L119 + ABS(H118 >= L119) * (ABS(H119 < L120) * L120 + ABS(H119 >= L120) * (ABS(H120 < L121) * L121 + ABS(H120 >= L121) * (ABS(H121 < L122) * L122 + ABS(H121 >= L122) * (ABS(H122 < L123) * L123 + ABS(H122 >= L123) * (ABS(H123 < L124) * L124 + ABS(H123 >= L124) * (ABS(H124 < L125) * L125 + ABS(H124 >= L125) * (ABS(H125 < L126) * L126 + ABS(H125 >= L126) * (ABS(H126 < L127) * L127 + ABS(H126 >= L127) * (ABS(H127 < L128) * L128 + ABS(H127 >= L128) * (ABS(H128 < L129) * L129 + ABS(H128 >= L129) * (ABS(H129 < L130) * L130 + ABS(H129 >= L130) * (ABS(H130 < L131) * L131 + ABS(H130 >= L131) * (ABS(H131 < L132) * L132 + ABS(H131 >= L132) * (ABS(H132 < L133) * L133 + ABS(H132 >= L133) * (ABS(H133 < L134) * L134 + ABS(H133 >= L134) * (ABS(H134 < L135) * L135 + ABS(H134 >= L135) * (ABS(H135 < L136) * L136 + ABS(H135 >= L136) * (ABS(H136 < L137) * L137 + ABS(H136 >= L137) * (ABS(H137 < L138) * L138 + ABS(H137 >= L138) * (ABS(H138 < L139) * L139 + ABS(H138 >= L139) * (ABS(H139 < L140) * L140 + ABS(H139 >= L140) * (ABS(H140 < L141) * L141 + ABS(H140 >= L141) * (ABS(H141 < L142) * L142 + ABS(H141 >= L142) * (ABS(H142 < L143) * L143 + ABS(H142 >= L143) * (ABS(H143 < L144) * L144 + ABS(H143 >= L144) * (ABS(H144 < L145) * L145 + ABS(H144 >= L145) * (ABS(H145 < L146) * L146 + ABS(H145 >= L146) * (ABS(H146 < L147) * L147 + ABS(H146 >= L147) * (ABS(H147 < L148) * L148 + ABS(H147 >= L148) * (ABS(H148 < L149) * L149 + ABS(H148 >= L149) * (ABS(H149 < L150) * L150 + ABS(H149 >= L150) * (ABS(H150 < L151) * L151 + ABS(H150 >= L151) * (ABS(H151 < L152) * L152 + ABS(H151 >= L152) * (ABS(H152 < L153) * L153 + ABS(H152 >= L153) * (ABS(H153 < L154) * L154 + ABS(H153 >= L154) * (ABS(H154 < L155) * L155 + ABS(H154 >= L155) * (ABS(H155 < L156) * L156 + ABS(H155 >= L156) * (ABS(H156 < L157) * L157 + ABS(H156 >= L157) * (ABS(H157 < L158) * L158 + ABS(H157 >= L158) * (ABS(H158 < L159) * L159 + ABS(H158 >= L159) * (ABS(H159 < L160) * L160 + ABS(H159 >= L160) * (ABS(H160 < L161) * L161 + ABS(H160 >= L161) * (ABS(H161 < L162) * L162 + ABS(H161 >= L162) * (ABS(H162 < L163) * L163 + ABS(H162 >= L163) * (ABS(H163 < L164) * L164 + ABS(H163 >= L164) * (ABS(H164 < L165) * L165 + ABS(H164 >= L165) * (ABS(H165 < L166) * L166 + ABS(H165 >= L166) * (ABS(H166 < L167) * L167 + ABS(H166 >= L167) * (ABS(H167 < L168) * L168 + ABS(H167 >= L168) * (ABS(H168 < L169) * L169 + ABS(H168 >= L169) * (ABS(H169 < L170) * L170 + ABS(H169 >= L170) * (ABS(H170 < L171) * L171 + ABS(H170 >= L171) * (ABS(H171 < L172) * L172 + ABS(H171 >= L172) * (ABS(H172 < L173) * L173 + ABS(H172 >= L173) * (ABS(H173 < L174) * L174 + ABS(H173 >= L174) * (ABS(H174 < L175) * L175 + ABS(H174 >= L175) * (ABS(H175 < L176) * L176 + ABS(H175 >= L176) * (ABS(H176 < L177) * L177 + ABS(H176 >= L177) * (ABS(H177 < L178) * L178 + ABS(H177 >= L178) * (ABS(H178 < L179) * L179 + ABS(H178 >= L179) * (ABS(H179 < L180) * L180 + ABS(H179 >= L180) * (ABS(H180 < L181) * L181 + ABS(H180 >= L181) * (ABS(H181 < L182) * L182 + ABS(H181 >= L182) * (ABS(H182 < L183) * L183 + ABS(H182 >= L183) * (ABS(H183 < L184) * L184 + ABS(H183 >= L184) * (ABS(H184 < L185) * L185 + ABS(H184 >= L185) * (ABS(H185 < L186) * L186 + ABS(H185 >= L186) * (ABS(H186 < L187) * L187 + ABS(H186 >= L187) * (ABS(H187 < L188) * L188 + ABS(H187 >= L188) * (ABS(H188 < L189) * L189 + ABS(H188 >= L189) * (ABS(H189 < L190) * L190 + ABS(H189 >= L190) * (ABS(H190 < L191) * L191 + ABS(H190 >= L191) * (ABS(H191 < L192) * L192 + ABS(H191 >= L192) * (ABS(H192 < L193) * L193 + ABS(H192 >= L193) * (ABS(H193 < L194) * L194 + ABS(H193 >= L194) * (ABS(H194 < L195) * L195 + ABS(H194 >= L195) * (ABS(H195 < L196) * L196 + ABS(H195 >= L196) * (ABS(H196 < L197) * L197 + ABS(H196 >= L197) * (ABS(H197 < L198) * L198 + ABS(H197 >= L198) * (ABS(H198 < L199) * L199 + ABS(H198 >= L199) * (ABS(H199 < L200) * L200 + ABS(H199 >= L200) * (ABS(H200 < L201) * L201 + ABS(H200 >= L201) * (ABS(H201 < L202) * L202 + ABS(H201 >= L202) * (ABS(H202 < L203) * L203 + ABS(H202 >= L203) * (ABS(H203 < L204) * L204 + ABS(H203 >= L204) * (ABS(H204 < L205) * L205 + ABS(H204 >= L205) * (ABS(H205 < L206) * L206 + ABS(H205 >= L206) * (ABS(H206 < L207) * L207 + ABS(H206 >= L207) * (ABS(H207 < L208) * L208 + ABS(H207 >= L208) * (ABS(H208 < L209) * L209 + ABS(H208 >= L209) * (ABS(H209 < L210) * L210 + ABS(H209 >= L210) * (ABS(H210 < L211) * L211 + ABS(H210 >= L211) * (ABS(H211 < L212) * L212 + ABS(H211 >= L212) * (ABS(H212 < L213) * L213 + ABS(H212 >= L213) * (ABS(H213 < L214) * L214 + ABS(H213 >= L214) * (ABS(H214 < L215) * L215 + ABS(H214 >= L215) * (ABS(H215 < L216) * L216 + ABS(H215 >= L216) * (ABS(H216 < L217) * L217 + ABS(H216 >= L217) * (ABS(H217 < L218) * L218 + ABS(H217 >= L218) * (ABS(H218 < L219) * L219 + ABS(H218 >= L219) * (ABS(H219 < L220) * L220 + ABS(H219 >= L220) * (ABS(H220 < L221) * L221 + ABS(H220 >= L221) * (ABS(H221 < L222) * L222 + ABS(H221 >= L222) * (ABS(H222 < L223) * L223 + ABS(H222 >= L223) * (ABS(H223 < L224) * L224 + ABS(H223 >= L224) * (ABS(H224 < L225) * L225 + ABS(H224 >= L225) * (ABS(H225 < L226) * L226 + ABS(H225 >= L226) * (ABS(H226 < L227) * L227 + ABS(H226 >= L227) * (ABS(H227 < L228) * L228 + ABS(H227 >= L228) * (ABS(H228 < L229) * L229 + ABS(H228 >= L229) * (ABS(H229 < L230) * L230 + ABS(H229 >= L230) * (ABS(H230 < L231) * L231 + ABS(H230 >= L231) * (ABS(H231 < L232) * L232 + ABS(H231 >= L232) * (ABS(H232 < L233) * L233 + ABS(H232 >= L233) * (ABS(H233 < L234) * L234 + ABS(H233 >= L234) * (ABS(H234 < L235) * L235 + ABS(H234 >= L235) * (ABS(H235 < L236) * L236 + ABS(H235 >= L236) * (ABS(H236 < L237) * L237 + ABS(H236 >= L237) * (ABS(H237 < L238) * L238 + ABS(H237 >= L238) * (ABS(H238 < L239) * L239 + ABS(H238 >= L239) * (ABS(H239 < L240) * L240 + ABS(H239 >= L240) * (ABS(H240 < L241) * L241 + ABS(H240 >= L241) * (ABS(H241 < L242) * L242 + ABS(H241 >= L242) * (ABS(H242 < L243) * L243 + ABS(H242 >= L243) * (ABS(H243 < L244) * L244 + ABS(H243 >= L244) * (ABS(H244 < L245) * L245 + ABS(H244 >= L245) * (ABS(H245 < L246) * L246 + ABS(H245 >= L246) * (ABS(H246 < L247) * L247 + ABS(H246 >= L247) * (ABS(H247 < L248) * L248 + ABS(H247 >= L248) * (ABS(H248 < L249) * L249 + ABS(H248 >= L249) * (ABS(H249 < L250) * L250 + ABS(H249 >= L250) * (ABS(H250 < L251) * L251 + ABS(H250 >= L251) * (ABS(H251 < L252) * L252 + ABS(H251 >= L252) * (H + 1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
Price Below Must Recent Gap Up During Last Year:
C < ABS(L > H1) * H1 + ABS(L <= H1) * (ABS(L1 > H2) * H2 + ABS(L1 <= H2) * (ABS(L2 > H3) * H3 + ABS(L2 <= H3) * (ABS(L3 > H4) * H4 + ABS(L3 <= H4) * (ABS(L4 > H5) * H5 + ABS(L4 <= H5) * (ABS(L5 > H6) * H6 + ABS(L5 <= H6) * (ABS(L6 > H7) * H7 + ABS(L6 <= H7) * (ABS(L7 > H8) * H8 + ABS(L7 <= H8) * (ABS(L8 > H9) * H9 + ABS(L8 <= H9) * (ABS(L9 > H10) * H10 + ABS(L9 <= H10) * (ABS(L10 > H11) * H11 + ABS(L10 <= H11) * (ABS(L11 > H12) * H12 + ABS(L11 <= H12) * (ABS(L12 > H13) * H13 + ABS(L12 <= H13) * (ABS(L13 > H14) * H14 + ABS(L13 <= H14) * (ABS(L14 > H15) * H15 + ABS(L14 <= H15) * (ABS(L15 > H16) * H16 + ABS(L15 <= H16) * (ABS(L16 > H17) * H17 + ABS(L16 <= H17) * (ABS(L17 > H18) * H18 + ABS(L17 <= H18) * (ABS(L18 > H19) * H19 + ABS(L18 <= H19) * (ABS(L19 > H20) * H20 + ABS(L19 <= H20) * (ABS(L20 > H21) * H21 + ABS(L20 <= H21) * (ABS(L21 > H22) * H22 + ABS(L21 <= H22) * (ABS(L22 > H23) * H23 + ABS(L22 <= H23) * (ABS(L23 > H24) * H24 + ABS(L23 <= H24) * (ABS(L24 > H25) * H25 + ABS(L24 <= H25) * (ABS(L25 > H26) * H26 + ABS(L25 <= H26) * (ABS(L26 > H27) * H27 + ABS(L26 <= H27) * (ABS(L27 > H28) * H28 + ABS(L27 <= H28) * (ABS(L28 > H29) * H29 + ABS(L28 <= H29) * (ABS(L29 > H30) * H30 + ABS(L29 <= H30) * (ABS(L30 > H31) * H31 + ABS(L30 <= H31) * (ABS(L31 > H32) * H32 + ABS(L31 <= H32) * (ABS(L32 > H33) * H33 + ABS(L32 <= H33) * (ABS(L33 > H34) * H34 + ABS(L33 <= H34) * (ABS(L34 > H35) * H35 + ABS(L34 <= H35) * (ABS(L35 > H36) * H36 + ABS(L35 <= H36) * (ABS(L36 > H37) * H37 + ABS(L36 <= H37) * (ABS(L37 > H38) * H38 + ABS(L37 <= H38) * (ABS(L38 > H39) * H39 + ABS(L38 <= H39) * (ABS(L39 > H40) * H40 + ABS(L39 <= H40) * (ABS(L40 > H41) * H41 + ABS(L40 <= H41) * (ABS(L41 > H42) * H42 + ABS(L41 <= H42) * (ABS(L42 > H43) * H43 + ABS(L42 <= H43) * (ABS(L43 > H44) * H44 + ABS(L43 <= H44) * (ABS(L44 > H45) * H45 + ABS(L44 <= H45) * (ABS(L45 > H46) * H46 + ABS(L45 <= H46) * (ABS(L46 > H47) * H47 + ABS(L46 <= H47) * (ABS(L47 > H48) * H48 + ABS(L47 <= H48) * (ABS(L48 > H49) * H49 + ABS(L48 <= H49) * (ABS(L49 > H50) * H50 + ABS(L49 <= H50) * (ABS(L50 > H51) * H51 + ABS(L50 <= H51) * (ABS(L51 > H52) * H52 + ABS(L51 <= H52) * (ABS(L52 > H53) * H53 + ABS(L52 <= H53) * (ABS(L53 > H54) * H54 + ABS(L53 <= H54) * (ABS(L54 > H55) * H55 + ABS(L54 <= H55) * (ABS(L55 > H56) * H56 + ABS(L55 <= H56) * (ABS(L56 > H57) * H57 + ABS(L56 <= H57) * (ABS(L57 > H58) * H58 + ABS(L57 <= H58) * (ABS(L58 > H59) * H59 + ABS(L58 <= H59) * (ABS(L59 > H60) * H60 + ABS(L59 <= H60) * (ABS(L60 > H61) * H61 + ABS(L60 <= H61) * (ABS(L61 > H62) * H62 + ABS(L61 <= H62) * (ABS(L62 > H63) * H63 + ABS(L62 <= H63) * (ABS(L63 > H64) * H64 + ABS(L63 <= H64) * (ABS(L64 > H65) * H65 + ABS(L64 <= H65) * (ABS(L65 > H66) * H66 + ABS(L65 <= H66) * (ABS(L66 > H67) * H67 + ABS(L66 <= H67) * (ABS(L67 > H68) * H68 + ABS(L67 <= H68) * (ABS(L68 > H69) * H69 + ABS(L68 <= H69) * (ABS(L69 > H70) * H70 + ABS(L69 <= H70) * (ABS(L70 > H71) * H71 + ABS(L70 <= H71) * (ABS(L71 > H72) * H72 + ABS(L71 <= H72) * (ABS(L72 > H73) * H73 + ABS(L72 <= H73) * (ABS(L73 > H74) * H74 + ABS(L73 <= H74) * (ABS(L74 > H75) * H75 + ABS(L74 <= H75) * (ABS(L75 > H76) * H76 + ABS(L75 <= H76) * (ABS(L76 > H77) * H77 + ABS(L76 <= H77) * (ABS(L77 > H78) * H78 + ABS(L77 <= H78) * (ABS(L78 > H79) * H79 + ABS(L78 <= H79) * (ABS(L79 > H80) * H80 + ABS(L79 <= H80) * (ABS(L80 > H81) * H81 + ABS(L80 <= H81) * (ABS(L81 > H82) * H82 + ABS(L81 <= H82) * (ABS(L82 > H83) * H83 + ABS(L82 <= H83) * (ABS(L83 > H84) * H84 + ABS(L83 <= H84) * (ABS(L84 > H85) * H85 + ABS(L84 <= H85) * (ABS(L85 > H86) * H86 + ABS(L85 <= H86) * (ABS(L86 > H87) * H87 + ABS(L86 <= H87) * (ABS(L87 > H88) * H88 + ABS(L87 <= H88) * (ABS(L88 > H89) * H89 + ABS(L88 <= H89) * (ABS(L89 > H90) * H90 + ABS(L89 <= H90) * (ABS(L90 > H91) * H91 + ABS(L90 <= H91) * (ABS(L91 > H92) * H92 + ABS(L91 <= H92) * (ABS(L92 > H93) * H93 + ABS(L92 <= H93) * (ABS(L93 > H94) * H94 + ABS(L93 <= H94) * (ABS(L94 > H95) * H95 + ABS(L94 <= H95) * (ABS(L95 > H96) * H96 + ABS(L95 <= H96) * (ABS(L96 > H97) * H97 + ABS(L96 <= H97) * (ABS(L97 > H98) * H98 + ABS(L97 <= H98) * (ABS(L98 > H99) * H99 + ABS(L98 <= H99) * (ABS(L99 > H100) * H100 + ABS(L99 <= H100) * (ABS(L100 > H101) * H101 + ABS(L100 <= H101) * (ABS(L101 > H102) * H102 + ABS(L101 <= H102) * (ABS(L102 > H103) * H103 + ABS(L102 <= H103) * (ABS(L103 > H104) * H104 + ABS(L103 <= H104) * (ABS(L104 > H105) * H105 + ABS(L104 <= H105) * (ABS(L105 > H106) * H106 + ABS(L105 <= H106) * (ABS(L106 > H107) * H107 + ABS(L106 <= H107) * (ABS(L107 > H108) * H108 + ABS(L107 <= H108) * (ABS(L108 > H109) * H109 + ABS(L108 <= H109) * (ABS(L109 > H110) * H110 + ABS(L109 <= H110) * (ABS(L110 > H111) * H111 + ABS(L110 <= H111) * (ABS(L111 > H112) * H112 + ABS(L111 <= H112) * (ABS(L112 > H113) * H113 + ABS(L112 <= H113) * (ABS(L113 > H114) * H114 + ABS(L113 <= H114) * (ABS(L114 > H115) * H115 + ABS(L114 <= H115) * (ABS(L115 > H116) * H116 + ABS(L115 <= H116) * (ABS(L116 > H117) * H117 + ABS(L116 <= H117) * (ABS(L117 > H118) * H118 + ABS(L117 <= H118) * (ABS(L118 > H119) * H119 + ABS(L118 <= H119) * (ABS(L119 > H120) * H120 + ABS(L119 <= H120) * (ABS(L120 > H121) * H121 + ABS(L120 <= H121) * (ABS(L121 > H122) * H122 + ABS(L121 <= H122) * (ABS(L122 > H123) * H123 + ABS(L122 <= H123) * (ABS(L123 > H124) * H124 + ABS(L123 <= H124) * (ABS(L124 > H125) * H125 + ABS(L124 <= H125) * (ABS(L125 > H126) * H126 + ABS(L125 <= H126) * (ABS(L126 > H127) * H127 + ABS(L126 <= H127) * (ABS(L127 > H128) * H128 + ABS(L127 <= H128) * (ABS(L128 > H129) * H129 + ABS(L128 <= H129) * (ABS(L129 > H130) * H130 + ABS(L129 <= H130) * (ABS(L130 > H131) * H131 + ABS(L130 <= H131) * (ABS(L131 > H132) * H132 + ABS(L131 <= H132) * (ABS(L132 > H133) * H133 + ABS(L132 <= H133) * (ABS(L133 > H134) * H134 + ABS(L133 <= H134) * (ABS(L134 > H135) * H135 + ABS(L134 <= H135) * (ABS(L135 > H136) * H136 + ABS(L135 <= H136) * (ABS(L136 > H137) * H137 + ABS(L136 <= H137) * (ABS(L137 > H138) * H138 + ABS(L137 <= H138) * (ABS(L138 > H139) * H139 + ABS(L138 <= H139) * (ABS(L139 > H140) * H140 + ABS(L139 <= H140) * (ABS(L140 > H141) * H141 + ABS(L140 <= H141) * (ABS(L141 > H142) * H142 + ABS(L141 <= H142) * (ABS(L142 > H143) * H143 + ABS(L142 <= H143) * (ABS(L143 > H144) * H144 + ABS(L143 <= H144) * (ABS(L144 > H145) * H145 + ABS(L144 <= H145) * (ABS(L145 > H146) * H146 + ABS(L145 <= H146) * (ABS(L146 > H147) * H147 + ABS(L146 <= H147) * (ABS(L147 > H148) * H148 + ABS(L147 <= H148) * (ABS(L148 > H149) * H149 + ABS(L148 <= H149) * (ABS(L149 > H150) * H150 + ABS(L149 <= H150) * (ABS(L150 > H151) * H151 + ABS(L150 <= H151) * (ABS(L151 > H152) * H152 + ABS(L151 <= H152) * (ABS(L152 > H153) * H153 + ABS(L152 <= H153) * (ABS(L153 > H154) * H154 + ABS(L153 <= H154) * (ABS(L154 > H155) * H155 + ABS(L154 <= H155) * (ABS(L155 > H156) * H156 + ABS(L155 <= H156) * (ABS(L156 > H157) * H157 + ABS(L156 <= H157) * (ABS(L157 > H158) * H158 + ABS(L157 <= H158) * (ABS(L158 > H159) * H159 + ABS(L158 <= H159) * (ABS(L159 > H160) * H160 + ABS(L159 <= H160) * (ABS(L160 > H161) * H161 + ABS(L160 <= H161) * (ABS(L161 > H162) * H162 + ABS(L161 <= H162) * (ABS(L162 > H163) * H163 + ABS(L162 <= H163) * (ABS(L163 > H164) * H164 + ABS(L163 <= H164) * (ABS(L164 > H165) * H165 + ABS(L164 <= H165) * (ABS(L165 > H166) * H166 + ABS(L165 <= H166) * (ABS(L166 > H167) * H167 + ABS(L166 <= H167) * (ABS(L167 > H168) * H168 + ABS(L167 <= H168) * (ABS(L168 > H169) * H169 + ABS(L168 <= H169) * (ABS(L169 > H170) * H170 + ABS(L169 <= H170) * (ABS(L170 > H171) * H171 + ABS(L170 <= H171) * (ABS(L171 > H172) * H172 + ABS(L171 <= H172) * (ABS(L172 > H173) * H173 + ABS(L172 <= H173) * (ABS(L173 > H174) * H174 + ABS(L173 <= H174) * (ABS(L174 > H175) * H175 + ABS(L174 <= H175) * (ABS(L175 > H176) * H176 + ABS(L175 <= H176) * (ABS(L176 > H177) * H177 + ABS(L176 <= H177) * (ABS(L177 > H178) * H178 + ABS(L177 <= H178) * (ABS(L178 > H179) * H179 + ABS(L178 <= H179) * (ABS(L179 > H180) * H180 + ABS(L179 <= H180) * (ABS(L180 > H181) * H181 + ABS(L180 <= H181) * (ABS(L181 > H182) * H182 + ABS(L181 <= H182) * (ABS(L182 > H183) * H183 + ABS(L182 <= H183) * (ABS(L183 > H184) * H184 + ABS(L183 <= H184) * (ABS(L184 > H185) * H185 + ABS(L184 <= H185) * (ABS(L185 > H186) * H186 + ABS(L185 <= H186) * (ABS(L186 > H187) * H187 + ABS(L186 <= H187) * (ABS(L187 > H188) * H188 + ABS(L187 <= H188) * (ABS(L188 > H189) * H189 + ABS(L188 <= H189) * (ABS(L189 > H190) * H190 + ABS(L189 <= H190) * (ABS(L190 > H191) * H191 + ABS(L190 <= H191) * (ABS(L191 > H192) * H192 + ABS(L191 <= H192) * (ABS(L192 > H193) * H193 + ABS(L192 <= H193) * (ABS(L193 > H194) * H194 + ABS(L193 <= H194) * (ABS(L194 > H195) * H195 + ABS(L194 <= H195) * (ABS(L195 > H196) * H196 + ABS(L195 <= H196) * (ABS(L196 > H197) * H197 + ABS(L196 <= H197) * (ABS(L197 > H198) * H198 + ABS(L197 <= H198) * (ABS(L198 > H199) * H199 + ABS(L198 <= H199) * (ABS(L199 > H200) * H200 + ABS(L199 <= H200) * (ABS(L200 > H201) * H201 + ABS(L200 <= H201) * (ABS(L201 > H202) * H202 + ABS(L201 <= H202) * (ABS(L202 > H203) * H203 + ABS(L202 <= H203) * (ABS(L203 > H204) * H204 + ABS(L203 <= H204) * (ABS(L204 > H205) * H205 + ABS(L204 <= H205) * (ABS(L205 > H206) * H206 + ABS(L205 <= H206) * (ABS(L206 > H207) * H207 + ABS(L206 <= H207) * (ABS(L207 > H208) * H208 + ABS(L207 <= H208) * (ABS(L208 > H209) * H209 + ABS(L208 <= H209) * (ABS(L209 > H210) * H210 + ABS(L209 <= H210) * (ABS(L210 > H211) * H211 + ABS(L210 <= H211) * (ABS(L211 > H212) * H212 + ABS(L211 <= H212) * (ABS(L212 > H213) * H213 + ABS(L212 <= H213) * (ABS(L213 > H214) * H214 + ABS(L213 <= H214) * (ABS(L214 > H215) * H215 + ABS(L214 <= H215) * (ABS(L215 > H216) * H216 + ABS(L215 <= H216) * (ABS(L216 > H217) * H217 + ABS(L216 <= H217) * (ABS(L217 > H218) * H218 + ABS(L217 <= H218) * (ABS(L218 > H219) * H219 + ABS(L218 <= H219) * (ABS(L219 > H220) * H220 + ABS(L219 <= H220) * (ABS(L220 > H221) * H221 + ABS(L220 <= H221) * (ABS(L221 > H222) * H222 + ABS(L221 <= H222) * (ABS(L222 > H223) * H223 + ABS(L222 <= H223) * (ABS(L223 > H224) * H224 + ABS(L223 <= H224) * (ABS(L224 > H225) * H225 + ABS(L224 <= H225) * (ABS(L225 > H226) * H226 + ABS(L225 <= H226) * (ABS(L226 > H227) * H227 + ABS(L226 <= H227) * (ABS(L227 > H228) * H228 + ABS(L227 <= H228) * (ABS(L228 > H229) * H229 + ABS(L228 <= H229) * (ABS(L229 > H230) * H230 + ABS(L229 <= H230) * (ABS(L230 > H231) * H231 + ABS(L230 <= H231) * (ABS(L231 > H232) * H232 + ABS(L231 <= H232) * (ABS(L232 > H233) * H233 + ABS(L232 <= H233) * (ABS(L233 > H234) * H234 + ABS(L233 <= H234) * (ABS(L234 > H235) * H235 + ABS(L234 <= H235) * (ABS(L235 > H236) * H236 + ABS(L235 <= H236) * (ABS(L236 > H237) * H237 + ABS(L236 <= H237) * (ABS(L237 > H238) * H238 + ABS(L237 <= H238) * (ABS(L238 > H239) * H239 + ABS(L238 <= H239) * (ABS(L239 > H240) * H240 + ABS(L239 <= H240) * (ABS(L240 > H241) * H241 + ABS(L240 <= H241) * (ABS(L241 > H242) * H242 + ABS(L241 <= H242) * (ABS(L242 > H243) * H243 + ABS(L242 <= H243) * (ABS(L243 > H244) * H244 + ABS(L243 <= H244) * (ABS(L244 > H245) * H245 + ABS(L244 <= H245) * (ABS(L245 > H246) * H246 + ABS(L245 <= H246) * (ABS(L246 > H247) * H247 + ABS(L246 <= H247) * (ABS(L247 > H248) * H248 + ABS(L247 <= H248) * (ABS(L248 > H249) * H249 + ABS(L248 <= H249) * (ABS(L249 > H250) * H250 + ABS(L249 <= H250) * (ABS(L250 > H251) * H251 + ABS(L250 <= H251) * (ABS(L251 > H252) * H252 + ABS(L251 <= H252) * (L - 1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
You may wish to review the following:
Days Since Last Peak (or other day-counting needs)
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/2009
Posts: 9
|
Hi BruceWOW!!  Would it be possible to limit to 6 months?But here's the key, I'm looking for stocks where price has returned to the gap, rather than simply being above/below it? So on the day of the update, price is within 10% of the region of the gap, or if easier, price is within $1 of the top/bottom of the gap?Not sure this would be possible.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (rogertaylor22) I'm looking for stocks where price has returned to the gap...
This would seem to require a test for them to have exited the gap. This would add significant complexity and the result may not end up being short enough to be practical.
QUOTE (rogertaylor22) So on the day of the update, price is within 10% of the region of the gap, or if easier, price is within $1 of the top/bottom of the gap?
Is the 10% based on the range of the gap or the actual values of the High, Low or midpoint of the Gap? I suspect basing it on 10% of the size of the range would approximately double the size of the formula.
QUOTE (rogertaylor22) Would it be possible to limit to 6 months?
Here are the old versions shortened to six months:
Warning: Long Personal Criteria Formulas can dramatically increase the time it takes to update your PCFs.
Price Above Most Recent Gap Down During Last 6-Months:
C > ABS(H < L1) * L1 + ABS(H >= L1) * (ABS(H1 < L2) * L2 + ABS(H1 >= L2) * (ABS(H2 < L3) * L3 + ABS(H2 >= L3) * (ABS(H3 < L4) * L4 + ABS(H3 >= L4) * (ABS(H4 < L5) * L5 + ABS(H4 >= L5) * (ABS(H5 < L6) * L6 + ABS(H5 >= L6) * (ABS(H6 < L7) * L7 + ABS(H6 >= L7) * (ABS(H7 < L8) * L8 + ABS(H7 >= L8) * (ABS(H8 < L9) * L9 + ABS(H8 >= L9) * (ABS(H9 < L10) * L10 + ABS(H9 >= L10) * (ABS(H10 < L11) * L11 + ABS(H10 >= L11) * (ABS(H11 < L12) * L12 + ABS(H11 >= L12) * (ABS(H12 < L13) * L13 + ABS(H12 >= L13) * (ABS(H13 < L14) * L14 + ABS(H13 >= L14) * (ABS(H14 < L15) * L15 + ABS(H14 >= L15) * (ABS(H15 < L16) * L16 + ABS(H15 >= L16) * (ABS(H16 < L17) * L17 + ABS(H16 >= L17) * (ABS(H17 < L18) * L18 + ABS(H17 >= L18) * (ABS(H18 < L19) * L19 + ABS(H18 >= L19) * (ABS(H19 < L20) * L20 + ABS(H19 >= L20) * (ABS(H20 < L21) * L21 + ABS(H20 >= L21) * (ABS(H21 < L22) * L22 + ABS(H21 >= L22) * (ABS(H22 < L23) * L23 + ABS(H22 >= L23) * (ABS(H23 < L24) * L24 + ABS(H23 >= L24) * (ABS(H24 < L25) * L25 + ABS(H24 >= L25) * (ABS(H25 < L26) * L26 + ABS(H25 >= L26) * (ABS(H26 < L27) * L27 + ABS(H26 >= L27) * (ABS(H27 < L28) * L28 + ABS(H27 >= L28) * (ABS(H28 < L29) * L29 + ABS(H28 >= L29) * (ABS(H29 < L30) * L30 + ABS(H29 >= L30) * (ABS(H30 < L31) * L31 + ABS(H30 >= L31) * (ABS(H31 < L32) * L32 + ABS(H31 >= L32) * (ABS(H32 < L33) * L33 + ABS(H32 >= L33) * (ABS(H33 < L34) * L34 + ABS(H33 >= L34) * (ABS(H34 < L35) * L35 + ABS(H34 >= L35) * (ABS(H35 < L36) * L36 + ABS(H35 >= L36) * (ABS(H36 < L37) * L37 + ABS(H36 >= L37) * (ABS(H37 < L38) * L38 + ABS(H37 >= L38) * (ABS(H38 < L39) * L39 + ABS(H38 >= L39) * (ABS(H39 < L40) * L40 + ABS(H39 >= L40) * (ABS(H40 < L41) * L41 + ABS(H40 >= L41) * (ABS(H41 < L42) * L42 + ABS(H41 >= L42) * (ABS(H42 < L43) * L43 + ABS(H42 >= L43) * (ABS(H43 < L44) * L44 + ABS(H43 >= L44) * (ABS(H44 < L45) * L45 + ABS(H44 >= L45) * (ABS(H45 < L46) * L46 + ABS(H45 >= L46) * (ABS(H46 < L47) * L47 + ABS(H46 >= L47) * (ABS(H47 < L48) * L48 + ABS(H47 >= L48) * (ABS(H48 < L49) * L49 + ABS(H48 >= L49) * (ABS(H49 < L50) * L50 + ABS(H49 >= L50) * (ABS(H50 < L51) * L51 + ABS(H50 >= L51) * (ABS(H51 < L52) * L52 + ABS(H51 >= L52) * (ABS(H52 < L53) * L53 + ABS(H52 >= L53) * (ABS(H53 < L54) * L54 + ABS(H53 >= L54) * (ABS(H54 < L55) * L55 + ABS(H54 >= L55) * (ABS(H55 < L56) * L56 + ABS(H55 >= L56) * (ABS(H56 < L57) * L57 + ABS(H56 >= L57) * (ABS(H57 < L58) * L58 + ABS(H57 >= L58) * (ABS(H58 < L59) * L59 + ABS(H58 >= L59) * (ABS(H59 < L60) * L60 + ABS(H59 >= L60) * (ABS(H60 < L61) * L61 + ABS(H60 >= L61) * (ABS(H61 < L62) * L62 + ABS(H61 >= L62) * (ABS(H62 < L63) * L63 + ABS(H62 >= L63) * (ABS(H63 < L64) * L64 + ABS(H63 >= L64) * (ABS(H64 < L65) * L65 + ABS(H64 >= L65) * (ABS(H65 < L66) * L66 + ABS(H65 >= L66) * (ABS(H66 < L67) * L67 + ABS(H66 >= L67) * (ABS(H67 < L68) * L68 + ABS(H67 >= L68) * (ABS(H68 < L69) * L69 + ABS(H68 >= L69) * (ABS(H69 < L70) * L70 + ABS(H69 >= L70) * (ABS(H70 < L71) * L71 + ABS(H70 >= L71) * (ABS(H71 < L72) * L72 + ABS(H71 >= L72) * (ABS(H72 < L73) * L73 + ABS(H72 >= L73) * (ABS(H73 < L74) * L74 + ABS(H73 >= L74) * (ABS(H74 < L75) * L75 + ABS(H74 >= L75) * (ABS(H75 < L76) * L76 + ABS(H75 >= L76) * (ABS(H76 < L77) * L77 + ABS(H76 >= L77) * (ABS(H77 < L78) * L78 + ABS(H77 >= L78) * (ABS(H78 < L79) * L79 + ABS(H78 >= L79) * (ABS(H79 < L80) * L80 + ABS(H79 >= L80) * (ABS(H80 < L81) * L81 + ABS(H80 >= L81) * (ABS(H81 < L82) * L82 + ABS(H81 >= L82) * (ABS(H82 < L83) * L83 + ABS(H82 >= L83) * (ABS(H83 < L84) * L84 + ABS(H83 >= L84) * (ABS(H84 < L85) * L85 + ABS(H84 >= L85) * (ABS(H85 < L86) * L86 + ABS(H85 >= L86) * (ABS(H86 < L87) * L87 + ABS(H86 >= L87) * (ABS(H87 < L88) * L88 + ABS(H87 >= L88) * (ABS(H88 < L89) * L89 + ABS(H88 >= L89) * (ABS(H89 < L90) * L90 + ABS(H89 >= L90) * (ABS(H90 < L91) * L91 + ABS(H90 >= L91) * (ABS(H91 < L92) * L92 + ABS(H91 >= L92) * (ABS(H92 < L93) * L93 + ABS(H92 >= L93) * (ABS(H93 < L94) * L94 + ABS(H93 >= L94) * (ABS(H94 < L95) * L95 + ABS(H94 >= L95) * (ABS(H95 < L96) * L96 + ABS(H95 >= L96) * (ABS(H96 < L97) * L97 + ABS(H96 >= L97) * (ABS(H97 < L98) * L98 + ABS(H97 >= L98) * (ABS(H98 < L99) * L99 + ABS(H98 >= L99) * (ABS(H99 < L100) * L100 + ABS(H99 >= L100) * (ABS(H100 < L101) * L101 + ABS(H100 >= L101) * (ABS(H101 < L102) * L102 + ABS(H101 >= L102) * (ABS(H102 < L103) * L103 + ABS(H102 >= L103) * (ABS(H103 < L104) * L104 + ABS(H103 >= L104) * (ABS(H104 < L105) * L105 + ABS(H104 >= L105) * (ABS(H105 < L106) * L106 + ABS(H105 >= L106) * (ABS(H106 < L107) * L107 + ABS(H106 >= L107) * (ABS(H107 < L108) * L108 + ABS(H107 >= L108) * (ABS(H108 < L109) * L109 + ABS(H108 >= L109) * (ABS(H109 < L110) * L110 + ABS(H109 >= L110) * (ABS(H110 < L111) * L111 + ABS(H110 >= L111) * (ABS(H111 < L112) * L112 + ABS(H111 >= L112) * (ABS(H112 < L113) * L113 + ABS(H112 >= L113) * (ABS(H113 < L114) * L114 + ABS(H113 >= L114) * (ABS(H114 < L115) * L115 + ABS(H114 >= L115) * (ABS(H115 < L116) * L116 + ABS(H115 >= L116) * (ABS(H116 < L117) * L117 + ABS(H116 >= L117) * (ABS(H117 < L118) * L118 + ABS(H117 >= L118) * (ABS(H118 < L119) * L119 + ABS(H118 >= L119) * (ABS(H119 < L120) * L120 + ABS(H119 >= L120) * (ABS(H120 < L121) * L121 + ABS(H120 >= L121) * (ABS(H121 < L122) * L122 + ABS(H121 >= L122) * (ABS(H122 < L123) * L123 + ABS(H122 >= L123) * (ABS(H123 < L124) * L124 + ABS(H123 >= L124) * (ABS(H124 < L125) * L125 + ABS(H124 >= L125) * (ABS(H125 < L126) * L126 + ABS(H125 >= L126) * (ABS(H126 < L127) * L127 + ABS(H126 >= L127) * (H + 1)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
Price Below Must Recent Gap Up During Last 6-Months:
C < ABS(L > H1) * H1 + ABS(L <= H1) * (ABS(L1 > H2) * H2 + ABS(L1 <= H2) * (ABS(L2 > H3) * H3 + ABS(L2 <= H3) * (ABS(L3 > H4) * H4 + ABS(L3 <= H4) * (ABS(L4 > H5) * H5 + ABS(L4 <= H5) * (ABS(L5 > H6) * H6 + ABS(L5 <= H6) * (ABS(L6 > H7) * H7 + ABS(L6 <= H7) * (ABS(L7 > H8) * H8 + ABS(L7 <= H8) * (ABS(L8 > H9) * H9 + ABS(L8 <= H9) * (ABS(L9 > H10) * H10 + ABS(L9 <= H10) * (ABS(L10 > H11) * H11 + ABS(L10 <= H11) * (ABS(L11 > H12) * H12 + ABS(L11 <= H12) * (ABS(L12 > H13) * H13 + ABS(L12 <= H13) * (ABS(L13 > H14) * H14 + ABS(L13 <= H14) * (ABS(L14 > H15) * H15 + ABS(L14 <= H15) * (ABS(L15 > H16) * H16 + ABS(L15 <= H16) * (ABS(L16 > H17) * H17 + ABS(L16 <= H17) * (ABS(L17 > H18) * H18 + ABS(L17 <= H18) * (ABS(L18 > H19) * H19 + ABS(L18 <= H19) * (ABS(L19 > H20) * H20 + ABS(L19 <= H20) * (ABS(L20 > H21) * H21 + ABS(L20 <= H21) * (ABS(L21 > H22) * H22 + ABS(L21 <= H22) * (ABS(L22 > H23) * H23 + ABS(L22 <= H23) * (ABS(L23 > H24) * H24 + ABS(L23 <= H24) * (ABS(L24 > H25) * H25 + ABS(L24 <= H25) * (ABS(L25 > H26) * H26 + ABS(L25 <= H26) * (ABS(L26 > H27) * H27 + ABS(L26 <= H27) * (ABS(L27 > H28) * H28 + ABS(L27 <= H28) * (ABS(L28 > H29) * H29 + ABS(L28 <= H29) * (ABS(L29 > H30) * H30 + ABS(L29 <= H30) * (ABS(L30 > H31) * H31 + ABS(L30 <= H31) * (ABS(L31 > H32) * H32 + ABS(L31 <= H32) * (ABS(L32 > H33) * H33 + ABS(L32 <= H33) * (ABS(L33 > H34) * H34 + ABS(L33 <= H34) * (ABS(L34 > H35) * H35 + ABS(L34 <= H35) * (ABS(L35 > H36) * H36 + ABS(L35 <= H36) * (ABS(L36 > H37) * H37 + ABS(L36 <= H37) * (ABS(L37 > H38) * H38 + ABS(L37 <= H38) * (ABS(L38 > H39) * H39 + ABS(L38 <= H39) * (ABS(L39 > H40) * H40 + ABS(L39 <= H40) * (ABS(L40 > H41) * H41 + ABS(L40 <= H41) * (ABS(L41 > H42) * H42 + ABS(L41 <= H42) * (ABS(L42 > H43) * H43 + ABS(L42 <= H43) * (ABS(L43 > H44) * H44 + ABS(L43 <= H44) * (ABS(L44 > H45) * H45 + ABS(L44 <= H45) * (ABS(L45 > H46) * H46 + ABS(L45 <= H46) * (ABS(L46 > H47) * H47 + ABS(L46 <= H47) * (ABS(L47 > H48) * H48 + ABS(L47 <= H48) * (ABS(L48 > H49) * H49 + ABS(L48 <= H49) * (ABS(L49 > H50) * H50 + ABS(L49 <= H50) * (ABS(L50 > H51) * H51 + ABS(L50 <= H51) * (ABS(L51 > H52) * H52 + ABS(L51 <= H52) * (ABS(L52 > H53) * H53 + ABS(L52 <= H53) * (ABS(L53 > H54) * H54 + ABS(L53 <= H54) * (ABS(L54 > H55) * H55 + ABS(L54 <= H55) * (ABS(L55 > H56) * H56 + ABS(L55 <= H56) * (ABS(L56 > H57) * H57 + ABS(L56 <= H57) * (ABS(L57 > H58) * H58 + ABS(L57 <= H58) * (ABS(L58 > H59) * H59 + ABS(L58 <= H59) * (ABS(L59 > H60) * H60 + ABS(L59 <= H60) * (ABS(L60 > H61) * H61 + ABS(L60 <= H61) * (ABS(L61 > H62) * H62 + ABS(L61 <= H62) * (ABS(L62 > H63) * H63 + ABS(L62 <= H63) * (ABS(L63 > H64) * H64 + ABS(L63 <= H64) * (ABS(L64 > H65) * H65 + ABS(L64 <= H65) * (ABS(L65 > H66) * H66 + ABS(L65 <= H66) * (ABS(L66 > H67) * H67 + ABS(L66 <= H67) * (ABS(L67 > H68) * H68 + ABS(L67 <= H68) * (ABS(L68 > H69) * H69 + ABS(L68 <= H69) * (ABS(L69 > H70) * H70 + ABS(L69 <= H70) * (ABS(L70 > H71) * H71 + ABS(L70 <= H71) * (ABS(L71 > H72) * H72 + ABS(L71 <= H72) * (ABS(L72 > H73) * H73 + ABS(L72 <= H73) * (ABS(L73 > H74) * H74 + ABS(L73 <= H74) * (ABS(L74 > H75) * H75 + ABS(L74 <= H75) * (ABS(L75 > H76) * H76 + ABS(L75 <= H76) * (ABS(L76 > H77) * H77 + ABS(L76 <= H77) * (ABS(L77 > H78) * H78 + ABS(L77 <= H78) * (ABS(L78 > H79) * H79 + ABS(L78 <= H79) * (ABS(L79 > H80) * H80 + ABS(L79 <= H80) * (ABS(L80 > H81) * H81 + ABS(L80 <= H81) * (ABS(L81 > H82) * H82 + ABS(L81 <= H82) * (ABS(L82 > H83) * H83 + ABS(L82 <= H83) * (ABS(L83 > H84) * H84 + ABS(L83 <= H84) * (ABS(L84 > H85) * H85 + ABS(L84 <= H85) * (ABS(L85 > H86) * H86 + ABS(L85 <= H86) * (ABS(L86 > H87) * H87 + ABS(L86 <= H87) * (ABS(L87 > H88) * H88 + ABS(L87 <= H88) * (ABS(L88 > H89) * H89 + ABS(L88 <= H89) * (ABS(L89 > H90) * H90 + ABS(L89 <= H90) * (ABS(L90 > H91) * H91 + ABS(L90 <= H91) * (ABS(L91 > H92) * H92 + ABS(L91 <= H92) * (ABS(L92 > H93) * H93 + ABS(L92 <= H93) * (ABS(L93 > H94) * H94 + ABS(L93 <= H94) * (ABS(L94 > H95) * H95 + ABS(L94 <= H95) * (ABS(L95 > H96) * H96 + ABS(L95 <= H96) * (ABS(L96 > H97) * H97 + ABS(L96 <= H97) * (ABS(L97 > H98) * H98 + ABS(L97 <= H98) * (ABS(L98 > H99) * H99 + ABS(L98 <= H99) * (ABS(L99 > H100) * H100 + ABS(L99 <= H100) * (ABS(L100 > H101) * H101 + ABS(L100 <= H101) * (ABS(L101 > H102) * H102 + ABS(L101 <= H102) * (ABS(L102 > H103) * H103 + ABS(L102 <= H103) * (ABS(L103 > H104) * H104 + ABS(L103 <= H104) * (ABS(L104 > H105) * H105 + ABS(L104 <= H105) * (ABS(L105 > H106) * H106 + ABS(L105 <= H106) * (ABS(L106 > H107) * H107 + ABS(L106 <= H107) * (ABS(L107 > H108) * H108 + ABS(L107 <= H108) * (ABS(L108 > H109) * H109 + ABS(L108 <= H109) * (ABS(L109 > H110) * H110 + ABS(L109 <= H110) * (ABS(L110 > H111) * H111 + ABS(L110 <= H111) * (ABS(L111 > H112) * H112 + ABS(L111 <= H112) * (ABS(L112 > H113) * H113 + ABS(L112 <= H113) * (ABS(L113 > H114) * H114 + ABS(L113 <= H114) * (ABS(L114 > H115) * H115 + ABS(L114 <= H115) * (ABS(L115 > H116) * H116 + ABS(L115 <= H116) * (ABS(L116 > H117) * H117 + ABS(L116 <= H117) * (ABS(L117 > H118) * H118 + ABS(L117 <= H118) * (ABS(L118 > H119) * H119 + ABS(L118 <= H119) * (ABS(L119 > H120) * H120 + ABS(L119 <= H120) * (ABS(L120 > H121) * H121 + ABS(L120 <= H121) * (ABS(L121 > H122) * H122 + ABS(L121 <= H122) * (ABS(L122 > H123) * H123 + ABS(L122 <= H123) * (ABS(L123 > H124) * H124 + ABS(L123 <= H124) * (ABS(L124 > H125) * H125 + ABS(L124 <= H125) * (ABS(L125 > H126) * H126 + ABS(L125 <= H126) * (L - 1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/9/2009
Posts: 9
|
OK Thanks Bruce, your help is much appreciated, as you say its starting to get a little large. Thanks for looking into it anyway.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |