| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 5/16/2006
Posts: 8
|
Does anyone know if it is possible to calcuate the number of days since a stock hit its 52-week high/low?
Thanks,
Joey.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
How far back should we search for the last 52-week high/low?
- Craig
Here to Help!
|
|
Registered User
Joined: 5/16/2006
Posts: 8
|
You would not need to go back more than 365 calendar days from today as the 52-week high is guaranteed to have occurred within that timeframe.
As an extreme example, consider a stock that has been in a 2-year linear downtrend (each day's close is less then previous). Today's 52-week high would have occurred 365 calendar days ago.
Joey.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The results will be in Trading Days instead of Calendar Days, but you may wish to try the following (they should not be used as Custom Indicators and can dramatically slow down updating Personal Criteria Formulas):
Periods since current 252-Period Low:
252 + 252 * (L = MINL252) - 251 * (L1 = MINL252) * (L1 < L) - 250 * (L2 = MINL252) * (L2 < MINL2) - 249 * (L3 = MINL252) * (L3 < MINL3) - 248 * (L4 = MINL252) * (L4 < MINL4) - 247 * (L5 = MINL252) * (L5 < MINL5) - 246 * (L6 = MINL252) * (L6 < MINL6) - 245 * (L7 = MINL252) * (L7 < MINL7) - 244 * (L8 = MINL252) * (L8 < MINL8) - 243 * (L9 = MINL252) * (L9 < MINL9) - 242 * (L10 = MINL252) * (L10 < MINL10) - 241 * (L11 = MINL252) * (L11 < MINL11) - 240 * (L12 = MINL252) * (L12 < MINL12) - 239 * (L13 = MINL252) * (L13 < MINL13) - 238 * (L14 = MINL252) * (L14 < MINL14) - 237 * (L15 = MINL252) * (L15 < MINL15) - 236 * (L16 = MINL252) * (L16 < MINL16) - 235 * (L17 = MINL252) * (L17 < MINL17) - 234 * (L18 = MINL252) * (L18 < MINL18) - 233 * (L19 = MINL252) * (L19 < MINL19) - 232 * (L20 = MINL252) * (L20 < MINL20) - 231 * (L21 = MINL252) * (L21 < MINL21) - 230 * (L22 = MINL252) * (L22 < MINL22) - 229 * (L23 = MINL252) * (L23 < MINL23) - 228 * (L24 = MINL252) * (L24 < MINL24) - 227 * (L25 = MINL252) * (L25 < MINL25) - 226 * (L26 = MINL252) * (L26 < MINL26) - 225 * (L27 = MINL252) * (L27 < MINL27) - 224 * (L28 = MINL252) * (L28 < MINL28) - 223 * (L29 = MINL252) * (L29 < MINL29) - 222 * (L30 = MINL252) * (L30 < MINL30) - 221 * (L31 = MINL252) * (L31 < MINL31) - 220 * (L32 = MINL252) * (L32 < MINL32) - 219 * (L33 = MINL252) * (L33 < MINL33) - 218 * (L34 = MINL252) * (L34 < MINL34) - 217 * (L35 = MINL252) * (L35 < MINL35) - 216 * (L36 = MINL252) * (L36 < MINL36) - 215 * (L37 = MINL252) * (L37 < MINL37) - 214 * (L38 = MINL252) * (L38 < MINL38) - 213 * (L39 = MINL252) * (L39 < MINL39) - 212 * (L40 = MINL252) * (L40 < MINL40) - 211 * (L41 = MINL252) * (L41 < MINL41) - 210 * (L42 = MINL252) * (L42 < MINL42) - 209 * (L43 = MINL252) * (L43 < MINL43) - 208 * (L44 = MINL252) * (L44 < MINL44) - 207 * (L45 = MINL252) * (L45 < MINL45) - 206 * (L46 = MINL252) * (L46 < MINL46) - 205 * (L47 = MINL252) * (L47 < MINL47) - 204 * (L48 = MINL252) * (L48 < MINL48) - 203 * (L49 = MINL252) * (L49 < MINL49) - 202 * (L50 = MINL252) * (L50 < MINL50) - 201 * (L51 = MINL252) * (L51 < MINL51) - 200 * (L52 = MINL252) * (L52 < MINL52) - 199 * (L53 = MINL252) * (L53 < MINL53) - 198 * (L54 = MINL252) * (L54 < MINL54) - 197 * (L55 = MINL252) * (L55 < MINL55) - 196 * (L56 = MINL252) * (L56 < MINL56) - 195 * (L57 = MINL252) * (L57 < MINL57) - 194 * (L58 = MINL252) * (L58 < MINL58) - 193 * (L59 = MINL252) * (L59 < MINL59) - 192 * (L60 = MINL252) * (L60 < MINL60) - 191 * (L61 = MINL252) * (L61 < MINL61) - 190 * (L62 = MINL252) * (L62 < MINL62) - 189 * (L63 = MINL252) * (L63 < MINL63) - 188 * (L64 = MINL252) * (L64 < MINL64) - 187 * (L65 = MINL252) * (L65 < MINL65) - 186 * (L66 = MINL252) * (L66 < MINL66) - 185 * (L67 = MINL252) * (L67 < MINL67) - 184 * (L68 = MINL252) * (L68 < MINL68) - 183 * (L69 = MINL252) * (L69 < MINL69) - 182 * (L70 = MINL252) * (L70 < MINL70) - 181 * (L71 = MINL252) * (L71 < MINL71) - 180 * (L72 = MINL252) * (L72 < MINL72) - 179 * (L73 = MINL252) * (L73 < MINL73) - 178 * (L74 = MINL252) * (L74 < MINL74) - 177 * (L75 = MINL252) * (L75 < MINL75) - 176 * (L76 = MINL252) * (L76 < MINL76) - 175 * (L77 = MINL252) * (L77 < MINL77) - 174 * (L78 = MINL252) * (L78 < MINL78) - 173 * (L79 = MINL252) * (L79 < MINL79) - 172 * (L80 = MINL252) * (L80 < MINL80) - 171 * (L81 = MINL252) * (L81 < MINL81) - 170 * (L82 = MINL252) * (L82 < MINL82) - 169 * (L83 = MINL252) * (L83 < MINL83) - 168 * (L84 = MINL252) * (L84 < MINL84) - 167 * (L85 = MINL252) * (L85 < MINL85) - 166 * (L86 = MINL252) * (L86 < MINL86) - 165 * (L87 = MINL252) * (L87 < MINL87) - 164 * (L88 = MINL252) * (L88 < MINL88) - 163 * (L89 = MINL252) * (L89 < MINL89) - 162 * (L90 = MINL252) * (L90 < MINL90) - 161 * (L91 = MINL252) * (L91 < MINL91) - 160 * (L92 = MINL252) * (L92 < MINL92) - 159 * (L93 = MINL252) * (L93 < MINL93) - 158 * (L94 = MINL252) * (L94 < MINL94) - 157 * (L95 = MINL252) * (L95 < MINL95) - 156 * (L96 = MINL252) * (L96 < MINL96) - 155 * (L97 = MINL252) * (L97 < MINL97) - 154 * (L98 = MINL252) * (L98 < MINL98) - 153 * (L99 = MINL252) * (L99 < MINL99) - 152 * (L100 = MINL252) * (L100 < MINL100) - 151 * (L101 = MINL252) * (L101 < MINL101) - 150 * (L102 = MINL252) * (L102 < MINL102) - 149 * (L103 = MINL252) * (L103 < MINL103) - 148 * (L104 = MINL252) * (L104 < MINL104) - 147 * (L105 = MINL252) * (L105 < MINL105) - 146 * (L106 = MINL252) * (L106 < MINL106) - 145 * (L107 = MINL252) * (L107 < MINL107) - 144 * (L108 = MINL252) * (L108 < MINL108) - 143 * (L109 = MINL252) * (L109 < MINL109) - 142 * (L110 = MINL252) * (L110 < MINL110) - 141 * (L111 = MINL252) * (L111 < MINL111) - 140 * (L112 = MINL252) * (L112 < MINL112) - 139 * (L113 = MINL252) * (L113 < MINL113) - 138 * (L114 = MINL252) * (L114 < MINL114) - 137 * (L115 = MINL252) * (L115 < MINL115) - 136 * (L116 = MINL252) * (L116 < MINL116) - 135 * (L117 = MINL252) * (L117 < MINL117) - 134 * (L118 = MINL252) * (L118 < MINL118) - 133 * (L119 = MINL252) * (L119 < MINL119) - 132 * (L120 = MINL252) * (L120 < MINL120) - 131 * (L121 = MINL252) * (L121 < MINL121) - 130 * (L122 = MINL252) * (L122 < MINL122) - 129 * (L123 = MINL252) * (L123 < MINL123) - 128 * (L124 = MINL252) * (L124 < MINL124) - 127 * (L125 = MINL252) * (L125 < MINL125) - 126 * (L126 = MINL252) * (L126 < MINL126) - 125 * (L127 = MINL252) * (L127 < MINL127) - 124 * (L128 = MINL252) * (L128 < MINL128) - 123 * (L129 = MINL252) * (L129 < MINL129) - 122 * (L130 = MINL252) * (L130 < MINL130) - 121 * (L131 = MINL252) * (L131 < MINL131) - 120 * (L132 = MINL252) * (L132 < MINL132) - 119 * (L133 = MINL252) * (L133 < MINL133) - 118 * (L134 = MINL252) * (L134 < MINL134) - 117 * (L135 = MINL252) * (L135 < MINL135) - 116 * (L136 = MINL252) * (L136 < MINL136) - 115 * (L137 = MINL252) * (L137 < MINL137) - 114 * (L138 = MINL252) * (L138 < MINL138) - 113 * (L139 = MINL252) * (L139 < MINL139) - 112 * (L140 = MINL252) * (L140 < MINL140) - 111 * (L141 = MINL252) * (L141 < MINL141) - 110 * (L142 = MINL252) * (L142 < MINL142) - 109 * (L143 = MINL252) * (L143 < MINL143) - 108 * (L144 = MINL252) * (L144 < MINL144) - 107 * (L145 = MINL252) * (L145 < MINL145) - 106 * (L146 = MINL252) * (L146 < MINL146) - 105 * (L147 = MINL252) * (L147 < MINL147) - 104 * (L148 = MINL252) * (L148 < MINL148) - 103 * (L149 = MINL252) * (L149 < MINL149) - 102 * (L150 = MINL252) * (L150 < MINL150) - 101 * (L151 = MINL252) * (L151 < MINL151) - 100 * (L152 = MINL252) * (L152 < MINL152) - 99 * (L153 = MINL252) * (L153 < MINL153) - 98 * (L154 = MINL252) * (L154 < MINL154) - 97 * (L155 = MINL252) * (L155 < MINL155) - 96 * (L156 = MINL252) * (L156 < MINL156) - 95 * (L157 = MINL252) * (L157 < MINL157) - 94 * (L158 = MINL252) * (L158 < MINL158) - 93 * (L159 = MINL252) * (L159 < MINL159) - 92 * (L160 = MINL252) * (L160 < MINL160) - 91 * (L161 = MINL252) * (L161 < MINL161) - 90 * (L162 = MINL252) * (L162 < MINL162) - 89 * (L163 = MINL252) * (L163 < MINL163) - 88 * (L164 = MINL252) * (L164 < MINL164) - 87 * (L165 = MINL252) * (L165 < MINL165) - 86 * (L166 = MINL252) * (L166 < MINL166) - 85 * (L167 = MINL252) * (L167 < MINL167) - 84 * (L168 = MINL252) * (L168 < MINL168) - 83 * (L169 = MINL252) * (L169 < MINL169) - 82 * (L170 = MINL252) * (L170 < MINL170) - 81 * (L171 = MINL252) * (L171 < MINL171) - 80 * (L172 = MINL252) * (L172 < MINL172) - 79 * (L173 = MINL252) * (L173 < MINL173) - 78 * (L174 = MINL252) * (L174 < MINL174) - 77 * (L175 = MINL252) * (L175 < MINL175) - 76 * (L176 = MINL252) * (L176 < MINL176) - 75 * (L177 = MINL252) * (L177 < MINL177) - 74 * (L178 = MINL252) * (L178 < MINL178) - 73 * (L179 = MINL252) * (L179 < MINL179) - 72 * (L180 = MINL252) * (L180 < MINL180) - 71 * (L181 = MINL252) * (L181 < MINL181) - 70 * (L182 = MINL252) * (L182 < MINL182) - 69 * (L183 = MINL252) * (L183 < MINL183) - 68 * (L184 = MINL252) * (L184 < MINL184) - 67 * (L185 = MINL252) * (L185 < MINL185) - 66 * (L186 = MINL252) * (L186 < MINL186) - 65 * (L187 = MINL252) * (L187 < MINL187) - 64 * (L188 = MINL252) * (L188 < MINL188) - 63 * (L189 = MINL252) * (L189 < MINL189) - 62 * (L190 = MINL252) * (L190 < MINL190) - 61 * (L191 = MINL252) * (L191 < MINL191) - 60 * (L192 = MINL252) * (L192 < MINL192) - 59 * (L193 = MINL252) * (L193 < MINL193) - 58 * (L194 = MINL252) * (L194 < MINL194) - 57 * (L195 = MINL252) * (L195 < MINL195) - 56 * (L196 = MINL252) * (L196 < MINL196) - 55 * (L197 = MINL252) * (L197 < MINL197) - 54 * (L198 = MINL252) * (L198 < MINL198) - 53 * (L199 = MINL252) * (L199 < MINL199) - 52 * (L200 = MINL252) * (L200 < MINL200) - 51 * (L201 = MINL252) * (L201 < MINL201) - 50 * (L202 = MINL252) * (L202 < MINL202) - 49 * (L203 = MINL252) * (L203 < MINL203) - 48 * (L204 = MINL252) * (L204 < MINL204) - 47 * (L205 = MINL252) * (L205 < MINL205) - 46 * (L206 = MINL252) * (L206 < MINL206) - 45 * (L207 = MINL252) * (L207 < MINL207) - 44 * (L208 = MINL252) * (L208 < MINL208) - 43 * (L209 = MINL252) * (L209 < MINL209) - 42 * (L210 = MINL252) * (L210 < MINL210) - 41 * (L211 = MINL252) * (L211 < MINL211) - 40 * (L212 = MINL252) * (L212 < MINL212) - 39 * (L213 = MINL252) * (L213 < MINL213) - 38 * (L214 = MINL252) * (L214 < MINL214) - 37 * (L215 = MINL252) * (L215 < MINL215) - 36 * (L216 = MINL252) * (L216 < MINL216) - 35 * (L217 = MINL252) * (L217 < MINL217) - 34 * (L218 = MINL252) * (L218 < MINL218) - 33 * (L219 = MINL252) * (L219 < MINL219) - 32 * (L220 = MINL252) * (L220 < MINL220) - 31 * (L221 = MINL252) * (L221 < MINL221) - 30 * (L222 = MINL252) * (L222 < MINL222) - 29 * (L223 = MINL252) * (L223 < MINL223) - 28 * (L224 = MINL252) * (L224 < MINL224) - 27 * (L225 = MINL252) * (L225 < MINL225) - 26 * (L226 = MINL252) * (L226 < MINL226) - 25 * (L227 = MINL252) * (L227 < MINL227) - 24 * (L228 = MINL252) * (L228 < MINL228) - 23 * (L229 = MINL252) * (L229 < MINL229) - 22 * (L230 = MINL252) * (L230 < MINL230) - 21 * (L231 = MINL252) * (L231 < MINL231) - 20 * (L232 = MINL252) * (L232 < MINL232) - 19 * (L233 = MINL252) * (L233 < MINL233) - 18 * (L234 = MINL252) * (L234 < MINL234) - 17 * (L235 = MINL252) * (L235 < MINL235) - 16 * (L236 = MINL252) * (L236 < MINL236) - 15 * (L237 = MINL252) * (L237 < MINL237) - 14 * (L238 = MINL252) * (L238 < MINL238) - 13 * (L239 = MINL252) * (L239 < MINL239) - 12 * (L240 = MINL252) * (L240 < MINL240) - 11 * (L241 = MINL252) * (L241 < MINL241) - 10 * (L242 = MINL252) * (L242 < MINL242) - 9 * (L243 = MINL252) * (L243 < MINL243) - 8 * (L244 = MINL252) * (L244 < MINL244) - 7 * (L245 = MINL252) * (L245 < MINL245) - 6 * (L246 = MINL252) * (L246 < MINL246) - 5 * (L247 = MINL252) * (L247 < MINL247) - 4 * (L248 = MINL252) * (L248 < MINL248) - 3 * (L249 = MINL252) * (L249 < MINL249) - 2 * (L250 = MINL252) * (L250 < MINL250) - 1 * (L251 = MINL252) * (L251 < MINL251)
Periods since current 252-Period High:
252 + 252 * (H = MAXH252) - 251 * (H1 = MAXH252) * (H1 > H) - 250 * (H2 = MAXH252) * (H2 > MAXH2) - 249 * (H3 = MAXH252) * (H3 > MAXH3) - 248 * (H4 = MAXH252) * (H4 > MAXH4) - 247 * (H5 = MAXH252) * (H5 > MAXH5) - 246 * (H6 = MAXH252) * (H6 > MAXH6) - 245 * (H7 = MAXH252) * (H7 > MAXH7) - 244 * (H8 = MAXH252) * (H8 > MAXH8) - 243 * (H9 = MAXH252) * (H9 > MAXH9) - 242 * (H10 = MAXH252) * (H10 > MAXH10) - 241 * (H11 = MAXH252) * (H11 > MAXH11) - 240 * (H12 = MAXH252) * (H12 > MAXH12) - 239 * (H13 = MAXH252) * (H13 > MAXH13) - 238 * (H14 = MAXH252) * (H14 > MAXH14) - 237 * (H15 = MAXH252) * (H15 > MAXH15) - 236 * (H16 = MAXH252) * (H16 > MAXH16) - 235 * (H17 = MAXH252) * (H17 > MAXH17) - 234 * (H18 = MAXH252) * (H18 > MAXH18) - 233 * (H19 = MAXH252) * (H19 > MAXH19) - 232 * (H20 = MAXH252) * (H20 > MAXH20) - 231 * (H21 = MAXH252) * (H21 > MAXH21) - 230 * (H22 = MAXH252) * (H22 > MAXH22) - 229 * (H23 = MAXH252) * (H23 > MAXH23) - 228 * (H24 = MAXH252) * (H24 > MAXH24) - 227 * (H25 = MAXH252) * (H25 > MAXH25) - 226 * (H26 = MAXH252) * (H26 > MAXH26) - 225 * (H27 = MAXH252) * (H27 > MAXH27) - 224 * (H28 = MAXH252) * (H28 > MAXH28) - 223 * (H29 = MAXH252) * (H29 > MAXH29) - 222 * (H30 = MAXH252) * (H30 > MAXH30) - 221 * (H31 = MAXH252) * (H31 > MAXH31) - 220 * (H32 = MAXH252) * (H32 > MAXH32) - 219 * (H33 = MAXH252) * (H33 > MAXH33) - 218 * (H34 = MAXH252) * (H34 > MAXH34) - 217 * (H35 = MAXH252) * (H35 > MAXH35) - 216 * (H36 = MAXH252) * (H36 > MAXH36) - 215 * (H37 = MAXH252) * (H37 > MAXH37) - 214 * (H38 = MAXH252) * (H38 > MAXH38) - 213 * (H39 = MAXH252) * (H39 > MAXH39) - 212 * (H40 = MAXH252) * (H40 > MAXH40) - 211 * (H41 = MAXH252) * (H41 > MAXH41) - 210 * (H42 = MAXH252) * (H42 > MAXH42) - 209 * (H43 = MAXH252) * (H43 > MAXH43) - 208 * (H44 = MAXH252) * (H44 > MAXH44) - 207 * (H45 = MAXH252) * (H45 > MAXH45) - 206 * (H46 = MAXH252) * (H46 > MAXH46) - 205 * (H47 = MAXH252) * (H47 > MAXH47) - 204 * (H48 = MAXH252) * (H48 > MAXH48) - 203 * (H49 = MAXH252) * (H49 > MAXH49) - 202 * (H50 = MAXH252) * (H50 > MAXH50) - 201 * (H51 = MAXH252) * (H51 > MAXH51) - 200 * (H52 = MAXH252) * (H52 > MAXH52) - 199 * (H53 = MAXH252) * (H53 > MAXH53) - 198 * (H54 = MAXH252) * (H54 > MAXH54) - 197 * (H55 = MAXH252) * (H55 > MAXH55) - 196 * (H56 = MAXH252) * (H56 > MAXH56) - 195 * (H57 = MAXH252) * (H57 > MAXH57) - 194 * (H58 = MAXH252) * (H58 > MAXH58) - 193 * (H59 = MAXH252) * (H59 > MAXH59) - 192 * (H60 = MAXH252) * (H60 > MAXH60) - 191 * (H61 = MAXH252) * (H61 > MAXH61) - 190 * (H62 = MAXH252) * (H62 > MAXH62) - 189 * (H63 = MAXH252) * (H63 > MAXH63) - 188 * (H64 = MAXH252) * (H64 > MAXH64) - 187 * (H65 = MAXH252) * (H65 > MAXH65) - 186 * (H66 = MAXH252) * (H66 > MAXH66) - 185 * (H67 = MAXH252) * (H67 > MAXH67) - 184 * (H68 = MAXH252) * (H68 > MAXH68) - 183 * (H69 = MAXH252) * (H69 > MAXH69) - 182 * (H70 = MAXH252) * (H70 > MAXH70) - 181 * (H71 = MAXH252) * (H71 > MAXH71) - 180 * (H72 = MAXH252) * (H72 > MAXH72) - 179 * (H73 = MAXH252) * (H73 > MAXH73) - 178 * (H74 = MAXH252) * (H74 > MAXH74) - 177 * (H75 = MAXH252) * (H75 > MAXH75) - 176 * (H76 = MAXH252) * (H76 > MAXH76) - 175 * (H77 = MAXH252) * (H77 > MAXH77) - 174 * (H78 = MAXH252) * (H78 > MAXH78) - 173 * (H79 = MAXH252) * (H79 > MAXH79) - 172 * (H80 = MAXH252) * (H80 > MAXH80) - 171 * (H81 = MAXH252) * (H81 > MAXH81) - 170 * (H82 = MAXH252) * (H82 > MAXH82) - 169 * (H83 = MAXH252) * (H83 > MAXH83) - 168 * (H84 = MAXH252) * (H84 > MAXH84) - 167 * (H85 = MAXH252) * (H85 > MAXH85) - 166 * (H86 = MAXH252) * (H86 > MAXH86) - 165 * (H87 = MAXH252) * (H87 > MAXH87) - 164 * (H88 = MAXH252) * (H88 > MAXH88) - 163 * (H89 = MAXH252) * (H89 > MAXH89) - 162 * (H90 = MAXH252) * (H90 > MAXH90) - 161 * (H91 = MAXH252) * (H91 > MAXH91) - 160 * (H92 = MAXH252) * (H92 > MAXH92) - 159 * (H93 = MAXH252) * (H93 > MAXH93) - 158 * (H94 = MAXH252) * (H94 > MAXH94) - 157 * (H95 = MAXH252) * (H95 > MAXH95) - 156 * (H96 = MAXH252) * (H96 > MAXH96) - 155 * (H97 = MAXH252) * (H97 > MAXH97) - 154 * (H98 = MAXH252) * (H98 > MAXH98) - 153 * (H99 = MAXH252) * (H99 > MAXH99) - 152 * (H100 = MAXH252) * (H100 > MAXH100) - 151 * (H101 = MAXH252) * (H101 > MAXH101) - 150 * (H102 = MAXH252) * (H102 > MAXH102) - 149 * (H103 = MAXH252) * (H103 > MAXH103) - 148 * (H104 = MAXH252) * (H104 > MAXH104) - 147 * (H105 = MAXH252) * (H105 > MAXH105) - 146 * (H106 = MAXH252) * (H106 > MAXH106) - 145 * (H107 = MAXH252) * (H107 > MAXH107) - 144 * (H108 = MAXH252) * (H108 > MAXH108) - 143 * (H109 = MAXH252) * (H109 > MAXH109) - 142 * (H110 = MAXH252) * (H110 > MAXH110) - 141 * (H111 = MAXH252) * (H111 > MAXH111) - 140 * (H112 = MAXH252) * (H112 > MAXH112) - 139 * (H113 = MAXH252) * (H113 > MAXH113) - 138 * (H114 = MAXH252) * (H114 > MAXH114) - 137 * (H115 = MAXH252) * (H115 > MAXH115) - 136 * (H116 = MAXH252) * (H116 > MAXH116) - 135 * (H117 = MAXH252) * (H117 > MAXH117) - 134 * (H118 = MAXH252) * (H118 > MAXH118) - 133 * (H119 = MAXH252) * (H119 > MAXH119) - 132 * (H120 = MAXH252) * (H120 > MAXH120) - 131 * (H121 = MAXH252) * (H121 > MAXH121) - 130 * (H122 = MAXH252) * (H122 > MAXH122) - 129 * (H123 = MAXH252) * (H123 > MAXH123) - 128 * (H124 = MAXH252) * (H124 > MAXH124) - 127 * (H125 = MAXH252) * (H125 > MAXH125) - 126 * (H126 = MAXH252) * (H126 > MAXH126) - 125 * (H127 = MAXH252) * (H127 > MAXH127) - 124 * (H128 = MAXH252) * (H128 > MAXH128) - 123 * (H129 = MAXH252) * (H129 > MAXH129) - 122 * (H130 = MAXH252) * (H130 > MAXH130) - 121 * (H131 = MAXH252) * (H131 > MAXH131) - 120 * (H132 = MAXH252) * (H132 > MAXH132) - 119 * (H133 = MAXH252) * (H133 > MAXH133) - 118 * (H134 = MAXH252) * (H134 > MAXH134) - 117 * (H135 = MAXH252) * (H135 > MAXH135) - 116 * (H136 = MAXH252) * (H136 > MAXH136) - 115 * (H137 = MAXH252) * (H137 > MAXH137) - 114 * (H138 = MAXH252) * (H138 > MAXH138) - 113 * (H139 = MAXH252) * (H139 > MAXH139) - 112 * (H140 = MAXH252) * (H140 > MAXH140) - 111 * (H141 = MAXH252) * (H141 > MAXH141) - 110 * (H142 = MAXH252) * (H142 > MAXH142) - 109 * (H143 = MAXH252) * (H143 > MAXH143) - 108 * (H144 = MAXH252) * (H144 > MAXH144) - 107 * (H145 = MAXH252) * (H145 > MAXH145) - 106 * (H146 = MAXH252) * (H146 > MAXH146) - 105 * (H147 = MAXH252) * (H147 > MAXH147) - 104 * (H148 = MAXH252) * (H148 > MAXH148) - 103 * (H149 = MAXH252) * (H149 > MAXH149) - 102 * (H150 = MAXH252) * (H150 > MAXH150) - 101 * (H151 = MAXH252) * (H151 > MAXH151) - 100 * (H152 = MAXH252) * (H152 > MAXH152) - 99 * (H153 = MAXH252) * (H153 > MAXH153) - 98 * (H154 = MAXH252) * (H154 > MAXH154) - 97 * (H155 = MAXH252) * (H155 > MAXH155) - 96 * (H156 = MAXH252) * (H156 > MAXH156) - 95 * (H157 = MAXH252) * (H157 > MAXH157) - 94 * (H158 = MAXH252) * (H158 > MAXH158) - 93 * (H159 = MAXH252) * (H159 > MAXH159) - 92 * (H160 = MAXH252) * (H160 > MAXH160) - 91 * (H161 = MAXH252) * (H161 > MAXH161) - 90 * (H162 = MAXH252) * (H162 > MAXH162) - 89 * (H163 = MAXH252) * (H163 > MAXH163) - 88 * (H164 = MAXH252) * (H164 > MAXH164) - 87 * (H165 = MAXH252) * (H165 > MAXH165) - 86 * (H166 = MAXH252) * (H166 > MAXH166) - 85 * (H167 = MAXH252) * (H167 > MAXH167) - 84 * (H168 = MAXH252) * (H168 > MAXH168) - 83 * (H169 = MAXH252) * (H169 > MAXH169) - 82 * (H170 = MAXH252) * (H170 > MAXH170) - 81 * (H171 = MAXH252) * (H171 > MAXH171) - 80 * (H172 = MAXH252) * (H172 > MAXH172) - 79 * (H173 = MAXH252) * (H173 > MAXH173) - 78 * (H174 = MAXH252) * (H174 > MAXH174) - 77 * (H175 = MAXH252) * (H175 > MAXH175) - 76 * (H176 = MAXH252) * (H176 > MAXH176) - 75 * (H177 = MAXH252) * (H177 > MAXH177) - 74 * (H178 = MAXH252) * (H178 > MAXH178) - 73 * (H179 = MAXH252) * (H179 > MAXH179) - 72 * (H180 = MAXH252) * (H180 > MAXH180) - 71 * (H181 = MAXH252) * (H181 > MAXH181) - 70 * (H182 = MAXH252) * (H182 > MAXH182) - 69 * (H183 = MAXH252) * (H183 > MAXH183) - 68 * (H184 = MAXH252) * (H184 > MAXH184) - 67 * (H185 = MAXH252) * (H185 > MAXH185) - 66 * (H186 = MAXH252) * (H186 > MAXH186) - 65 * (H187 = MAXH252) * (H187 > MAXH187) - 64 * (H188 = MAXH252) * (H188 > MAXH188) - 63 * (H189 = MAXH252) * (H189 > MAXH189) - 62 * (H190 = MAXH252) * (H190 > MAXH190) - 61 * (H191 = MAXH252) * (H191 > MAXH191) - 60 * (H192 = MAXH252) * (H192 > MAXH192) - 59 * (H193 = MAXH252) * (H193 > MAXH193) - 58 * (H194 = MAXH252) * (H194 > MAXH194) - 57 * (H195 = MAXH252) * (H195 > MAXH195) - 56 * (H196 = MAXH252) * (H196 > MAXH196) - 55 * (H197 = MAXH252) * (H197 > MAXH197) - 54 * (H198 = MAXH252) * (H198 > MAXH198) - 53 * (H199 = MAXH252) * (H199 > MAXH199) - 52 * (H200 = MAXH252) * (H200 > MAXH200) - 51 * (H201 = MAXH252) * (H201 > MAXH201) - 50 * (H202 = MAXH252) * (H202 > MAXH202) - 49 * (H203 = MAXH252) * (H203 > MAXH203) - 48 * (H204 = MAXH252) * (H204 > MAXH204) - 47 * (H205 = MAXH252) * (H205 > MAXH205) - 46 * (H206 = MAXH252) * (H206 > MAXH206) - 45 * (H207 = MAXH252) * (H207 > MAXH207) - 44 * (H208 = MAXH252) * (H208 > MAXH208) - 43 * (H209 = MAXH252) * (H209 > MAXH209) - 42 * (H210 = MAXH252) * (H210 > MAXH210) - 41 * (H211 = MAXH252) * (H211 > MAXH211) - 40 * (H212 = MAXH252) * (H212 > MAXH212) - 39 * (H213 = MAXH252) * (H213 > MAXH213) - 38 * (H214 = MAXH252) * (H214 > MAXH214) - 37 * (H215 = MAXH252) * (H215 > MAXH215) - 36 * (H216 = MAXH252) * (H216 > MAXH216) - 35 * (H217 = MAXH252) * (H217 > MAXH217) - 34 * (H218 = MAXH252) * (H218 > MAXH218) - 33 * (H219 = MAXH252) * (H219 > MAXH219) - 32 * (H220 = MAXH252) * (H220 > MAXH220) - 31 * (H221 = MAXH252) * (H221 > MAXH221) - 30 * (H222 = MAXH252) * (H222 > MAXH222) - 29 * (H223 = MAXH252) * (H223 > MAXH223) - 28 * (H224 = MAXH252) * (H224 > MAXH224) - 27 * (H225 = MAXH252) * (H225 > MAXH225) - 26 * (H226 = MAXH252) * (H226 > MAXH226) - 25 * (H227 = MAXH252) * (H227 > MAXH227) - 24 * (H228 = MAXH252) * (H228 > MAXH228) - 23 * (H229 = MAXH252) * (H229 > MAXH229) - 22 * (H230 = MAXH252) * (H230 > MAXH230) - 21 * (H231 = MAXH252) * (H231 > MAXH231) - 20 * (H232 = MAXH252) * (H232 > MAXH232) - 19 * (H233 = MAXH252) * (H233 > MAXH233) - 18 * (H234 = MAXH252) * (H234 > MAXH234) - 17 * (H235 = MAXH252) * (H235 > MAXH235) - 16 * (H236 = MAXH252) * (H236 > MAXH236) - 15 * (H237 = MAXH252) * (H237 > MAXH237) - 14 * (H238 = MAXH252) * (H238 > MAXH238) - 13 * (H239 = MAXH252) * (H239 > MAXH239) - 12 * (H240 = MAXH252) * (H240 > MAXH240) - 11 * (H241 = MAXH252) * (H241 > MAXH241) - 10 * (H242 = MAXH252) * (H242 > MAXH242) - 9 * (H243 = MAXH252) * (H243 > MAXH243) - 8 * (H244 = MAXH252) * (H244 > MAXH244) - 7 * (H245 = MAXH252) * (H245 > MAXH245) - 6 * (H246 = MAXH252) * (H246 > MAXH246) - 5 * (H247 = MAXH252) * (H247 > MAXH247) - 4 * (H248 = MAXH252) * (H248 > MAXH248) - 3 * (H249 = MAXH252) * (H249 > MAXH249) - 2 * (H250 = MAXH252) * (H250 > MAXH250) - (H251 = MAXH252) * (H251 > MAXH251)
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
Days Since Last Peak (or other day-counting needs)
First Time new 52-Week High
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |