Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 8/22/2006 Posts: 15
|
I need the following pcfs if possible to scan for
1.) Stocks up 100% plus from 52 week low if traded less than 52 weeks the low of the number of days the stock traded for.
2.) Current price is within 25% of high price during 100% plus move.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I do not know of a practical automated method for implementing the "if traded less than 52 weeks the low of the number of days the stock traded for" portion of your request in TeleChart. Please try the following:
Warning: Long Personal Criteria Formulas can dramatically increase the time it takes to update your PCFs.
C > 2 * MINL252 AND ABS(L = MINL252) * STOC1 + ABS(L > MINL252) * (ABS(L1 = MINL252) * STOC2 + ABS(L1 > MINL252) * (ABS(L2 = MINL252) * STOC3 + ABS(L2 > MINL252) * (ABS(L3 = MINL252) * STOC4 + ABS(L3 > MINL252) * (ABS(L4 = MINL252) * STOC5 + ABS(L4 > MINL252) * (ABS(L5 = MINL252) * STOC6 + ABS(L5 > MINL252) * (ABS(L6 = MINL252) * STOC7 + ABS(L6 > MINL252) * (ABS(L7 = MINL252) * STOC8 + ABS(L7 > MINL252) * (ABS(L8 = MINL252) * STOC9 + ABS(L8 > MINL252) * (ABS(L9 = MINL252) * STOC10 + ABS(L9 > MINL252) * (ABS(L10 = MINL252) * STOC11 + ABS(L10 > MINL252) * (ABS(L11 = MINL252) * STOC12 + ABS(L11 > MINL252) * (ABS(L12 = MINL252) * STOC13 + ABS(L12 > MINL252) * (ABS(L13 = MINL252) * STOC14 + ABS(L13 > MINL252) * (ABS(L14 = MINL252) * STOC15 + ABS(L14 > MINL252) * (ABS(L15 = MINL252) * STOC16 + ABS(L15 > MINL252) * (ABS(L16 = MINL252) * STOC17 + ABS(L16 > MINL252) * (ABS(L17 = MINL252) * STOC18 + ABS(L17 > MINL252) * (ABS(L18 = MINL252) * STOC19 + ABS(L18 > MINL252) * (ABS(L19 = MINL252) * STOC20 + ABS(L19 > MINL252) * (ABS(L20 = MINL252) * STOC21 + ABS(L20 > MINL252) * (ABS(L21 = MINL252) * STOC22 + ABS(L21 > MINL252) * (ABS(L22 = MINL252) * STOC23 + ABS(L22 > MINL252) * (ABS(L23 = MINL252) * STOC24 + ABS(L23 > MINL252) * (ABS(L24 = MINL252) * STOC25 + ABS(L24 > MINL252) * (ABS(L25 = MINL252) * STOC26 + ABS(L25 > MINL252) * (ABS(L26 = MINL252) * STOC27 + ABS(L26 > MINL252) * (ABS(L27 = MINL252) * STOC28 + ABS(L27 > MINL252) * (ABS(L28 = MINL252) * STOC29 + ABS(L28 > MINL252) * (ABS(L29 = MINL252) * STOC30 + ABS(L29 > MINL252) * (ABS(L30 = MINL252) * STOC31 + ABS(L30 > MINL252) * (ABS(L31 = MINL252) * STOC32 + ABS(L31 > MINL252) * (ABS(L32 = MINL252) * STOC33 + ABS(L32 > MINL252) * (ABS(L33 = MINL252) * STOC34 + ABS(L33 > MINL252) * (ABS(L34 = MINL252) * STOC35 + ABS(L34 > MINL252) * (ABS(L35 = MINL252) * STOC36 + ABS(L35 > MINL252) * (ABS(L36 = MINL252) * STOC37 + ABS(L36 > MINL252) * (ABS(L37 = MINL252) * STOC38 + ABS(L37 > MINL252) * (ABS(L38 = MINL252) * STOC39 + ABS(L38 > MINL252) * (ABS(L39 = MINL252) * STOC40 + ABS(L39 > MINL252) * (ABS(L40 = MINL252) * STOC41 + ABS(L40 > MINL252) * (ABS(L41 = MINL252) * STOC42 + ABS(L41 > MINL252) * (ABS(L42 = MINL252) * STOC43 + ABS(L42 > MINL252) * (ABS(L43 = MINL252) * STOC44 + ABS(L43 > MINL252) * (ABS(L44 = MINL252) * STOC45 + ABS(L44 > MINL252) * (ABS(L45 = MINL252) * STOC46 + ABS(L45 > MINL252) * (ABS(L46 = MINL252) * STOC47 + ABS(L46 > MINL252) * (ABS(L47 = MINL252) * STOC48 + ABS(L47 > MINL252) * (ABS(L48 = MINL252) * STOC49 + ABS(L48 > MINL252) * (ABS(L49 = MINL252) * STOC50 + ABS(L49 > MINL252) * (ABS(L50 = MINL252) * STOC51 + ABS(L50 > MINL252) * (ABS(L51 = MINL252) * STOC52 + ABS(L51 > MINL252) * (ABS(L52 = MINL252) * STOC53 + ABS(L52 > MINL252) * (ABS(L53 = MINL252) * STOC54 + ABS(L53 > MINL252) * (ABS(L54 = MINL252) * STOC55 + ABS(L54 > MINL252) * (ABS(L55 = MINL252) * STOC56 + ABS(L55 > MINL252) * (ABS(L56 = MINL252) * STOC57 + ABS(L56 > MINL252) * (ABS(L57 = MINL252) * STOC58 + ABS(L57 > MINL252) * (ABS(L58 = MINL252) * STOC59 + ABS(L58 > MINL252) * (ABS(L59 = MINL252) * STOC60 + ABS(L59 > MINL252) * (ABS(L60 = MINL252) * STOC61 + ABS(L60 > MINL252) * (ABS(L61 = MINL252) * STOC62 + ABS(L61 > MINL252) * (ABS(L62 = MINL252) * STOC63 + ABS(L62 > MINL252) * (ABS(L63 = MINL252) * STOC64 + ABS(L63 > MINL252) * (ABS(L64 = MINL252) * STOC65 + ABS(L64 > MINL252) * (ABS(L65 = MINL252) * STOC66 + ABS(L65 > MINL252) * (ABS(L66 = MINL252) * STOC67 + ABS(L66 > MINL252) * (ABS(L67 = MINL252) * STOC68 + ABS(L67 > MINL252) * (ABS(L68 = MINL252) * STOC69 + ABS(L68 > MINL252) * (ABS(L69 = MINL252) * STOC70 + ABS(L69 > MINL252) * (ABS(L70 = MINL252) * STOC71 + ABS(L70 > MINL252) * (ABS(L71 = MINL252) * STOC72 + ABS(L71 > MINL252) * (ABS(L72 = MINL252) * STOC73 + ABS(L72 > MINL252) * (ABS(L73 = MINL252) * STOC74 + ABS(L73 > MINL252) * (ABS(L74 = MINL252) * STOC75 + ABS(L74 > MINL252) * (ABS(L75 = MINL252) * STOC76 + ABS(L75 > MINL252) * (ABS(L76 = MINL252) * STOC77 + ABS(L76 > MINL252) * (ABS(L77 = MINL252) * STOC78 + ABS(L77 > MINL252) * (ABS(L78 = MINL252) * STOC79 + ABS(L78 > MINL252) * (ABS(L79 = MINL252) * STOC80 + ABS(L79 > MINL252) * (ABS(L80 = MINL252) * STOC81 + ABS(L80 > MINL252) * (ABS(L81 = MINL252) * STOC82 + ABS(L81 > MINL252) * (ABS(L82 = MINL252) * STOC83 + ABS(L82 > MINL252) * (ABS(L83 = MINL252) * STOC84 + ABS(L83 > MINL252) * (ABS(L84 = MINL252) * STOC85 + ABS(L84 > MINL252) * (ABS(L85 = MINL252) * STOC86 + ABS(L85 > MINL252) * (ABS(L86 = MINL252) * STOC87 + ABS(L86 > MINL252) * (ABS(L87 = MINL252) * STOC88 + ABS(L87 > MINL252) * (ABS(L88 = MINL252) * STOC89 + ABS(L88 > MINL252) * (ABS(L89 = MINL252) * STOC90 + ABS(L89 > MINL252) * (ABS(L90 = MINL252) * STOC91 + ABS(L90 > MINL252) * (ABS(L91 = MINL252) * STOC92 + ABS(L91 > MINL252) * (ABS(L92 = MINL252) * STOC93 + ABS(L92 > MINL252) * (ABS(L93 = MINL252) * STOC94 + ABS(L93 > MINL252) * (ABS(L94 = MINL252) * STOC95 + ABS(L94 > MINL252) * (ABS(L95 = MINL252) * STOC96 + ABS(L95 > MINL252) * (ABS(L96 = MINL252) * STOC97 + ABS(L96 > MINL252) * (ABS(L97 = MINL252) * STOC98 + ABS(L97 > MINL252) * (ABS(L98 = MINL252) * STOC99 + ABS(L98 > MINL252) * (ABS(L99 = MINL252) * STOC100 + ABS(L99 > MINL252) * (ABS(L100 = MINL252) * STOC101 + ABS(L100 > MINL252) * (ABS(L101 = MINL252) * STOC102 + ABS(L101 > MINL252) * (ABS(L102 = MINL252) * STOC103 + ABS(L102 > MINL252) * (ABS(L103 = MINL252) * STOC104 + ABS(L103 > MINL252) * (ABS(L104 = MINL252) * STOC105 + ABS(L104 > MINL252) * (ABS(L105 = MINL252) * STOC106 + ABS(L105 > MINL252) * (ABS(L106 = MINL252) * STOC107 + ABS(L106 > MINL252) * (ABS(L107 = MINL252) * STOC108 + ABS(L107 > MINL252) * (ABS(L108 = MINL252) * STOC109 + ABS(L108 > MINL252) * (ABS(L109 = MINL252) * STOC110 + ABS(L109 > MINL252) * (ABS(L110 = MINL252) * STOC111 + ABS(L110 > MINL252) * (ABS(L111 = MINL252) * STOC112 + ABS(L111 > MINL252) * (ABS(L112 = MINL252) * STOC113 + ABS(L112 > MINL252) * (ABS(L113 = MINL252) * STOC114 + ABS(L113 > MINL252) * (ABS(L114 = MINL252) * STOC115 + ABS(L114 > MINL252) * (ABS(L115 = MINL252) * STOC116 + ABS(L115 > MINL252) * (ABS(L116 = MINL252) * STOC117 + ABS(L116 > MINL252) * (ABS(L117 = MINL252) * STOC118 + ABS(L117 > MINL252) * (ABS(L118 = MINL252) * STOC119 + ABS(L118 > MINL252) * (ABS(L119 = MINL252) * STOC120 + ABS(L119 > MINL252) * (ABS(L120 = MINL252) * STOC121 + ABS(L120 > MINL252) * (ABS(L121 = MINL252) * STOC122 + ABS(L121 > MINL252) * (ABS(L122 = MINL252) * STOC123 + ABS(L122 > MINL252) * (ABS(L123 = MINL252) * STOC124 + ABS(L123 > MINL252) * (ABS(L124 = MINL252) * STOC125 + ABS(L124 > MINL252) * (ABS(L125 = MINL252) * STOC126 + ABS(L125 > MINL252) * (ABS(L126 = MINL252) * STOC127 + ABS(L126 > MINL252) * (ABS(L127 = MINL252) * STOC128 + ABS(L127 > MINL252) * (ABS(L128 = MINL252) * STOC129 + ABS(L128 > MINL252) * (ABS(L129 = MINL252) * STOC130 + ABS(L129 > MINL252) * (ABS(L130 = MINL252) * STOC131 + ABS(L130 > MINL252) * (ABS(L131 = MINL252) * STOC132 + ABS(L131 > MINL252) * (ABS(L132 = MINL252) * STOC133 + ABS(L132 > MINL252) * (ABS(L133 = MINL252) * STOC134 + ABS(L133 > MINL252) * (ABS(L134 = MINL252) * STOC135 + ABS(L134 > MINL252) * (ABS(L135 = MINL252) * STOC136 + ABS(L135 > MINL252) * (ABS(L136 = MINL252) * STOC137 + ABS(L136 > MINL252) * (ABS(L137 = MINL252) * STOC138 + ABS(L137 > MINL252) * (ABS(L138 = MINL252) * STOC139 + ABS(L138 > MINL252) * (ABS(L139 = MINL252) * STOC140 + ABS(L139 > MINL252) * (ABS(L140 = MINL252) * STOC141 + ABS(L140 > MINL252) * (ABS(L141 = MINL252) * STOC142 + ABS(L141 > MINL252) * (ABS(L142 = MINL252) * STOC143 + ABS(L142 > MINL252) * (ABS(L143 = MINL252) * STOC144 + ABS(L143 > MINL252) * (ABS(L144 = MINL252) * STOC145 + ABS(L144 > MINL252) * (ABS(L145 = MINL252) * STOC146 + ABS(L145 > MINL252) * (ABS(L146 = MINL252) * STOC147 + ABS(L146 > MINL252) * (ABS(L147 = MINL252) * STOC148 + ABS(L147 > MINL252) * (ABS(L148 = MINL252) * STOC149 + ABS(L148 > MINL252) * (ABS(L149 = MINL252) * STOC150 + ABS(L149 > MINL252) * (ABS(L150 = MINL252) * STOC151 + ABS(L150 > MINL252) * (ABS(L151 = MINL252) * STOC152 + ABS(L151 > MINL252) * (ABS(L152 = MINL252) * STOC153 + ABS(L152 > MINL252) * (ABS(L153 = MINL252) * STOC154 + ABS(L153 > MINL252) * (ABS(L154 = MINL252) * STOC155 + ABS(L154 > MINL252) * (ABS(L155 = MINL252) * STOC156 + ABS(L155 > MINL252) * (ABS(L156 = MINL252) * STOC157 + ABS(L156 > MINL252) * (ABS(L157 = MINL252) * STOC158 + ABS(L157 > MINL252) * (ABS(L158 = MINL252) * STOC159 + ABS(L158 > MINL252) * (ABS(L159 = MINL252) * STOC160 + ABS(L159 > MINL252) * (ABS(L160 = MINL252) * STOC161 + ABS(L160 > MINL252) * (ABS(L161 = MINL252) * STOC162 + ABS(L161 > MINL252) * (ABS(L162 = MINL252) * STOC163 + ABS(L162 > MINL252) * (ABS(L163 = MINL252) * STOC164 + ABS(L163 > MINL252) * (ABS(L164 = MINL252) * STOC165 + ABS(L164 > MINL252) * (ABS(L165 = MINL252) * STOC166 + ABS(L165 > MINL252) * (ABS(L166 = MINL252) * STOC167 + ABS(L166 > MINL252) * (ABS(L167 = MINL252) * STOC168 + ABS(L167 > MINL252) * (ABS(L168 = MINL252) * STOC169 + ABS(L168 > MINL252) * (ABS(L169 = MINL252) * STOC170 + ABS(L169 > MINL252) * (ABS(L170 = MINL252) * STOC171 + ABS(L170 > MINL252) * (ABS(L171 = MINL252) * STOC172 + ABS(L171 > MINL252) * (ABS(L172 = MINL252) * STOC173 + ABS(L172 > MINL252) * (ABS(L173 = MINL252) * STOC174 + ABS(L173 > MINL252) * (ABS(L174 = MINL252) * STOC175 + ABS(L174 > MINL252) * (ABS(L175 = MINL252) * STOC176 + ABS(L175 > MINL252) * (ABS(L176 = MINL252) * STOC177 + ABS(L176 > MINL252) * (ABS(L177 = MINL252) * STOC178 + ABS(L177 > MINL252) * (ABS(L178 = MINL252) * STOC179 + ABS(L178 > MINL252) * (ABS(L179 = MINL252) * STOC180 + ABS(L179 > MINL252) * (ABS(L180 = MINL252) * STOC181 + ABS(L180 > MINL252) * (ABS(L181 = MINL252) * STOC182 + ABS(L181 > MINL252) * (ABS(L182 = MINL252) * STOC183 + ABS(L182 > MINL252) * (ABS(L183 = MINL252) * STOC184 + ABS(L183 > MINL252) * (ABS(L184 = MINL252) * STOC185 + ABS(L184 > MINL252) * (ABS(L185 = MINL252) * STOC186 + ABS(L185 > MINL252) * (ABS(L186 = MINL252) * STOC187 + ABS(L186 > MINL252) * (ABS(L187 = MINL252) * STOC188 + ABS(L187 > MINL252) * (ABS(L188 = MINL252) * STOC189 + ABS(L188 > MINL252) * (ABS(L189 = MINL252) * STOC190 + ABS(L189 > MINL252) * (ABS(L190 = MINL252) * STOC191 + ABS(L190 > MINL252) * (ABS(L191 = MINL252) * STOC192 + ABS(L191 > MINL252) * (ABS(L192 = MINL252) * STOC193 + ABS(L192 > MINL252) * (ABS(L193 = MINL252) * STOC194 + ABS(L193 > MINL252) * (ABS(L194 = MINL252) * STOC195 + ABS(L194 > MINL252) * (ABS(L195 = MINL252) * STOC196 + ABS(L195 > MINL252) * (ABS(L196 = MINL252) * STOC197 + ABS(L196 > MINL252) * (ABS(L197 = MINL252) * STOC198 + ABS(L197 > MINL252) * (ABS(L198 = MINL252) * STOC199 + ABS(L198 > MINL252) * (ABS(L199 = MINL252) * STOC200 + ABS(L199 > MINL252) * (ABS(L200 = MINL252) * STOC201 + ABS(L200 > MINL252) * (ABS(L201 = MINL252) * STOC202 + ABS(L201 > MINL252) * (ABS(L202 = MINL252) * STOC203 + ABS(L202 > MINL252) * (ABS(L203 = MINL252) * STOC204 + ABS(L203 > MINL252) * (ABS(L204 = MINL252) * STOC205 + ABS(L204 > MINL252) * (ABS(L205 = MINL252) * STOC206 + ABS(L205 > MINL252) * (ABS(L206 = MINL252) * STOC207 + ABS(L206 > MINL252) * (ABS(L207 = MINL252) * STOC208 + ABS(L207 > MINL252) * (ABS(L208 = MINL252) * STOC209 + ABS(L208 > MINL252) * (ABS(L209 = MINL252) * STOC210 + ABS(L209 > MINL252) * (ABS(L210 = MINL252) * STOC211 + ABS(L210 > MINL252) * (ABS(L211 = MINL252) * STOC212 + ABS(L211 > MINL252) * (ABS(L212 = MINL252) * STOC213 + ABS(L212 > MINL252) * (ABS(L213 = MINL252) * STOC214 + ABS(L213 > MINL252) * (ABS(L214 = MINL252) * STOC215 + ABS(L214 > MINL252) * (ABS(L215 = MINL252) * STOC216 + ABS(L215 > MINL252) * (ABS(L216 = MINL252) * STOC217 + ABS(L216 > MINL252) * (ABS(L217 = MINL252) * STOC218 + ABS(L217 > MINL252) * (ABS(L218 = MINL252) * STOC219 + ABS(L218 > MINL252) * (ABS(L219 = MINL252) * STOC220 + ABS(L219 > MINL252) * (ABS(L220 = MINL252) * STOC221 + ABS(L220 > MINL252) * (ABS(L221 = MINL252) * STOC222 + ABS(L221 > MINL252) * (ABS(L222 = MINL252) * STOC223 + ABS(L222 > MINL252) * (ABS(L223 = MINL252) * STOC224 + ABS(L223 > MINL252) * (ABS(L224 = MINL252) * STOC225 + ABS(L224 > MINL252) * (ABS(L225 = MINL252) * STOC226 + ABS(L225 > MINL252) * (ABS(L226 = MINL252) * STOC227 + ABS(L226 > MINL252) * (ABS(L227 = MINL252) * STOC228 + ABS(L227 > MINL252) * (ABS(L228 = MINL252) * STOC229 + ABS(L228 > MINL252) * (ABS(L229 = MINL252) * STOC230 + ABS(L229 > MINL252) * (ABS(L230 = MINL252) * STOC231 + ABS(L230 > MINL252) * (ABS(L231 = MINL252) * STOC232 + ABS(L231 > MINL252) * (ABS(L232 = MINL252) * STOC233 + ABS(L232 > MINL252) * (ABS(L233 = MINL252) * STOC234 + ABS(L233 > MINL252) * (ABS(L234 = MINL252) * STOC235 + ABS(L234 > MINL252) * (ABS(L235 = MINL252) * STOC236 + ABS(L235 > MINL252) * (ABS(L236 = MINL252) * STOC237 + ABS(L236 > MINL252) * (ABS(L237 = MINL252) * STOC238 + ABS(L237 > MINL252) * (ABS(L238 = MINL252) * STOC239 + ABS(L238 > MINL252) * (ABS(L239 = MINL252) * STOC240 + ABS(L239 > MINL252) * (ABS(L240 = MINL252) * STOC241 + ABS(L240 > MINL252) * (ABS(L241 = MINL252) * STOC242 + ABS(L241 > MINL252) * (ABS(L242 = MINL252) * STOC243 + ABS(L242 > MINL252) * (ABS(L243 = MINL252) * STOC244 + ABS(L243 > MINL252) * (ABS(L244 = MINL252) * STOC245 + ABS(L244 > MINL252) * (ABS(L245 = MINL252) * STOC246 + ABS(L245 > MINL252) * (ABS(L246 = MINL252) * STOC247 + ABS(L246 > MINL252) * (ABS(L247 = MINL252) * STOC248 + ABS(L247 > MINL252) * (ABS(L248 = MINL252) * STOC249 + ABS(L248 > MINL252) * (ABS(L249 = MINL252) * STOC250 + ABS(L249 > MINL252) * (ABS(L250 = MINL252) * STOC251 + ABS(L250 > MINL252) * STOC252)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) >= 75
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
Understanding MACD
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/1/2005 Posts: 2,645
|
Bruce,
1) The present request is:
1. Stocks up 100% plus from 52 week low if traded less than 52 weeks the low of the number of days the stock traded for.
2. Current price is within 25% of high price during 100% plus move.
2) At:
http://www.worden.com/training/default.aspx?g=posts&t=27699
the request was for:
- Up 100% plus from 52 week low. (where the stock has traded for less than 52 week, the low of the number of days the stock traded for)
- Current price is within 25% of high price during the 100% plus move.
3) At:
http://www.worden.com/training/default.aspx?g=posts&t=27460
the request was for:
1. The stock currently is up 100% or more from its 52 week low.
2. When the stock has traded for less than 52 week, it has doubled.
3. It is within 25% of highest move during the rise from the 52 week low or low of whatever period it traded for.
In the first two requests above, the "current price" is referred to explicitly in Item 2) , but not in Item 1). This leads me to believe that the stock must move up 100% plus from the 52 week low at some time since that low. Current price is within 25% of high price during the 100% plus move.
That the stock currently is up 100% or more from the 52 week low is explicit in the third request, but not the first two.
There is nothing in the three requests that requires requires STOCn >= 75. At the reference under 2), I erroneously agreed that there should be.
Thus, in my opinion the PCF should be of the form:
(high at or since the most recent occurrence of Lk = MINL252) >= 2*MINL252
AND
0.75*(high at or since the most recent occurrence of Lk = MINL252) < C
You already have a PCF for (high at or since the most recent occurrence of Lk = MINL252) at the reference under 2). Unfortunately, I do not see a way to prevent writing it twice.
Please notice that if the PCF returns True, then:
C > (3/2)*MINL252
returns True.
Your comments will be appreciated.
Thanks,
Jim Murphy
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
bustermu,
The assumption that three requests with such striking similarities are actually for the same thing is probably a good one. That said, the requests do differ and none of the requests seem to be unambiguous (although your interpretation appears to be as good as any).
Assuming your interpretation is correct, my first thought would be that the following would be true (not sure though):
2 * MINL252 <= (H @ Lk = MINL252) < 4 * C / 3
So something based on the distance from the midpoint of 2 * MINL252 and 4 * C / 3 might work (the fact that the above has both <= and < might be problematic however even if the basic idea ends up being sound):
ABS((H @ Lk = MINL252) - MINL252 - 2 * C / 3) <= 2 * C / 3 - MINL252
Or (as an actual PCF):
ABS(ABS(L = MINL252) * H + ABS(L > MINL252) * (ABS(L1 = MINL252) * MAXH2 + ABS(L1 > MINL252) * (ABS(L2 = MINL252) * MAXH3 + ABS(L2 > MINL252) * (ABS(L3 = MINL252) * MAXH4 + ABS(L3 > MINL252) * (ABS(L4 = MINL252) * MAXH5 + ABS(L4 > MINL252) * (ABS(L5 = MINL252) * MAXH6 + ABS(L5 > MINL252) * (ABS(L6 = MINL252) * MAXH7 + ABS(L6 > MINL252) * (ABS(L7 = MINL252) * MAXH8 + ABS(L7 > MINL252) * (ABS(L8 = MINL252) * MAXH9 + ABS(L8 > MINL252) * (ABS(L9 = MINL252) * MAXH10 + ABS(L9 > MINL252) * (ABS(L10 = MINL252) * MAXH11 + ABS(L10 > MINL252) * (ABS(L11 = MINL252) * MAXH12 + ABS(L11 > MINL252) * (ABS(L12 = MINL252) * MAXH13 + ABS(L12 > MINL252) * (ABS(L13 = MINL252) * MAXH14 + ABS(L13 > MINL252) * (ABS(L14 = MINL252) * MAXH15 + ABS(L14 > MINL252) * (ABS(L15 = MINL252) * MAXH16 + ABS(L15 > MINL252) * (ABS(L16 = MINL252) * MAXH17 + ABS(L16 > MINL252) * (ABS(L17 = MINL252) * MAXH18 + ABS(L17 > MINL252) * (ABS(L18 = MINL252) * MAXH19 + ABS(L18 > MINL252) * (ABS(L19 = MINL252) * MAXH20 + ABS(L19 > MINL252) * (ABS(L20 = MINL252) * MAXH21 + ABS(L20 > MINL252) * (ABS(L21 = MINL252) * MAXH22 + ABS(L21 > MINL252) * (ABS(L22 = MINL252) * MAXH23 + ABS(L22 > MINL252) * (ABS(L23 = MINL252) * MAXH24 + ABS(L23 > MINL252) * (ABS(L24 = MINL252) * MAXH25 + ABS(L24 > MINL252) * (ABS(L25 = MINL252) * MAXH26 + ABS(L25 > MINL252) * (ABS(L26 = MINL252) * MAXH27 + ABS(L26 > MINL252) * (ABS(L27 = MINL252) * MAXH28 + ABS(L27 > MINL252) * (ABS(L28 = MINL252) * MAXH29 + ABS(L28 > MINL252) * (ABS(L29 = MINL252) * MAXH30 + ABS(L29 > MINL252) * (ABS(L30 = MINL252) * MAXH31 + ABS(L30 > MINL252) * (ABS(L31 = MINL252) * MAXH32 + ABS(L31 > MINL252) * (ABS(L32 = MINL252) * MAXH33 + ABS(L32 > MINL252) * (ABS(L33 = MINL252) * MAXH34 + ABS(L33 > MINL252) * (ABS(L34 = MINL252) * MAXH35 + ABS(L34 > MINL252) * (ABS(L35 = MINL252) * MAXH36 + ABS(L35 > MINL252) * (ABS(L36 = MINL252) * MAXH37 + ABS(L36 > MINL252) * (ABS(L37 = MINL252) * MAXH38 + ABS(L37 > MINL252) * (ABS(L38 = MINL252) * MAXH39 + ABS(L38 > MINL252) * (ABS(L39 = MINL252) * MAXH40 + ABS(L39 > MINL252) * (ABS(L40 = MINL252) * MAXH41 + ABS(L40 > MINL252) * (ABS(L41 = MINL252) * MAXH42 + ABS(L41 > MINL252) * (ABS(L42 = MINL252) * MAXH43 + ABS(L42 > MINL252) * (ABS(L43 = MINL252) * MAXH44 + ABS(L43 > MINL252) * (ABS(L44 = MINL252) * MAXH45 + ABS(L44 > MINL252) * (ABS(L45 = MINL252) * MAXH46 + ABS(L45 > MINL252) * (ABS(L46 = MINL252) * MAXH47 + ABS(L46 > MINL252) * (ABS(L47 = MINL252) * MAXH48 + ABS(L47 > MINL252) * (ABS(L48 = MINL252) * MAXH49 + ABS(L48 > MINL252) * (ABS(L49 = MINL252) * MAXH50 + ABS(L49 > MINL252) * (ABS(L50 = MINL252) * MAXH51 + ABS(L50 > MINL252) * (ABS(L51 = MINL252) * MAXH52 + ABS(L51 > MINL252) * (ABS(L52 = MINL252) * MAXH53 + ABS(L52 > MINL252) * (ABS(L53 = MINL252) * MAXH54 + ABS(L53 > MINL252) * (ABS(L54 = MINL252) * MAXH55 + ABS(L54 > MINL252) * (ABS(L55 = MINL252) * MAXH56 + ABS(L55 > MINL252) * (ABS(L56 = MINL252) * MAXH57 + ABS(L56 > MINL252) * (ABS(L57 = MINL252) * MAXH58 + ABS(L57 > MINL252) * (ABS(L58 = MINL252) * MAXH59 + ABS(L58 > MINL252) * (ABS(L59 = MINL252) * MAXH60 + ABS(L59 > MINL252) * (ABS(L60 = MINL252) * MAXH61 + ABS(L60 > MINL252) * (ABS(L61 = MINL252) * MAXH62 + ABS(L61 > MINL252) * (ABS(L62 = MINL252) * MAXH63 + ABS(L62 > MINL252) * (ABS(L63 = MINL252) * MAXH64 + ABS(L63 > MINL252) * (ABS(L64 = MINL252) * MAXH65 + ABS(L64 > MINL252) * (ABS(L65 = MINL252) * MAXH66 + ABS(L65 > MINL252) * (ABS(L66 = MINL252) * MAXH67 + ABS(L66 > MINL252) * (ABS(L67 = MINL252) * MAXH68 + ABS(L67 > MINL252) * (ABS(L68 = MINL252) * MAXH69 + ABS(L68 > MINL252) * (ABS(L69 = MINL252) * MAXH70 + ABS(L69 > MINL252) * (ABS(L70 = MINL252) * MAXH71 + ABS(L70 > MINL252) * (ABS(L71 = MINL252) * MAXH72 + ABS(L71 > MINL252) * (ABS(L72 = MINL252) * MAXH73 + ABS(L72 > MINL252) * (ABS(L73 = MINL252) * MAXH74 + ABS(L73 > MINL252) * (ABS(L74 = MINL252) * MAXH75 + ABS(L74 > MINL252) * (ABS(L75 = MINL252) * MAXH76 + ABS(L75 > MINL252) * (ABS(L76 = MINL252) * MAXH77 + ABS(L76 > MINL252) * (ABS(L77 = MINL252) * MAXH78 + ABS(L77 > MINL252) * (ABS(L78 = MINL252) * MAXH79 + ABS(L78 > MINL252) * (ABS(L79 = MINL252) * MAXH80 + ABS(L79 > MINL252) * (ABS(L80 = MINL252) * MAXH81 + ABS(L80 > MINL252) * (ABS(L81 = MINL252) * MAXH82 + ABS(L81 > MINL252) * (ABS(L82 = MINL252) * MAXH83 + ABS(L82 > MINL252) * (ABS(L83 = MINL252) * MAXH84 + ABS(L83 > MINL252) * (ABS(L84 = MINL252) * MAXH85 + ABS(L84 > MINL252) * (ABS(L85 = MINL252) * MAXH86 + ABS(L85 > MINL252) * (ABS(L86 = MINL252) * MAXH87 + ABS(L86 > MINL252) * (ABS(L87 = MINL252) * MAXH88 + ABS(L87 > MINL252) * (ABS(L88 = MINL252) * MAXH89 + ABS(L88 > MINL252) * (ABS(L89 = MINL252) * MAXH90 + ABS(L89 > MINL252) * (ABS(L90 = MINL252) * MAXH91 + ABS(L90 > MINL252) * (ABS(L91 = MINL252) * MAXH92 + ABS(L91 > MINL252) * (ABS(L92 = MINL252) * MAXH93 + ABS(L92 > MINL252) * (ABS(L93 = MINL252) * MAXH94 + ABS(L93 > MINL252) * (ABS(L94 = MINL252) * MAXH95 + ABS(L94 > MINL252) * (ABS(L95 = MINL252) * MAXH96 + ABS(L95 > MINL252) * (ABS(L96 = MINL252) * MAXH97 + ABS(L96 > MINL252) * (ABS(L97 = MINL252) * MAXH98 + ABS(L97 > MINL252) * (ABS(L98 = MINL252) * MAXH99 + ABS(L98 > MINL252) * (ABS(L99 = MINL252) * MAXH100 + ABS(L99 > MINL252) * (ABS(L100 = MINL252) * MAXH101 + ABS(L100 > MINL252) * (ABS(L101 = MINL252) * MAXH102 + ABS(L101 > MINL252) * (ABS(L102 = MINL252) * MAXH103 + ABS(L102 > MINL252) * (ABS(L103 = MINL252) * MAXH104 + ABS(L103 > MINL252) * (ABS(L104 = MINL252) * MAXH105 + ABS(L104 > MINL252) * (ABS(L105 = MINL252) * MAXH106 + ABS(L105 > MINL252) * (ABS(L106 = MINL252) * MAXH107 + ABS(L106 > MINL252) * (ABS(L107 = MINL252) * MAXH108 + ABS(L107 > MINL252) * (ABS(L108 = MINL252) * MAXH109 + ABS(L108 > MINL252) * (ABS(L109 = MINL252) * MAXH110 + ABS(L109 > MINL252) * (ABS(L110 = MINL252) * MAXH111 + ABS(L110 > MINL252) * (ABS(L111 = MINL252) * MAXH112 + ABS(L111 > MINL252) * (ABS(L112 = MINL252) * MAXH113 + ABS(L112 > MINL252) * (ABS(L113 = MINL252) * MAXH114 + ABS(L113 > MINL252) * (ABS(L114 = MINL252) * MAXH115 + ABS(L114 > MINL252) * (ABS(L115 = MINL252) * MAXH116 + ABS(L115 > MINL252) * (ABS(L116 = MINL252) * MAXH117 + ABS(L116 > MINL252) * (ABS(L117 = MINL252) * MAXH118 + ABS(L117 > MINL252) * (ABS(L118 = MINL252) * MAXH119 + ABS(L118 > MINL252) * (ABS(L119 = MINL252) * MAXH120 + ABS(L119 > MINL252) * (ABS(L120 = MINL252) * MAXH121 + ABS(L120 > MINL252) * (ABS(L121 = MINL252) * MAXH122 + ABS(L121 > MINL252) * (ABS(L122 = MINL252) * MAXH123 + ABS(L122 > MINL252) * (ABS(L123 = MINL252) * MAXH124 + ABS(L123 > MINL252) * (ABS(L124 = MINL252) * MAXH125 + ABS(L124 > MINL252) * (ABS(L125 = MINL252) * MAXH126 + ABS(L125 > MINL252) * (ABS(L126 = MINL252) * MAXH127 + ABS(L126 > MINL252) * (ABS(L127 = MINL252) * MAXH128 + ABS(L127 > MINL252) * (ABS(L128 = MINL252) * MAXH129 + ABS(L128 > MINL252) * (ABS(L129 = MINL252) * MAXH130 + ABS(L129 > MINL252) * (ABS(L130 = MINL252) * MAXH131 + ABS(L130 > MINL252) * (ABS(L131 = MINL252) * MAXH132 + ABS(L131 > MINL252) * (ABS(L132 = MINL252) * MAXH133 + ABS(L132 > MINL252) * (ABS(L133 = MINL252) * MAXH134 + ABS(L133 > MINL252) * (ABS(L134 = MINL252) * MAXH135 + ABS(L134 > MINL252) * (ABS(L135 = MINL252) * MAXH136 + ABS(L135 > MINL252) * (ABS(L136 = MINL252) * MAXH137 + ABS(L136 > MINL252) * (ABS(L137 = MINL252) * MAXH138 + ABS(L137 > MINL252) * (ABS(L138 = MINL252) * MAXH139 + ABS(L138 > MINL252) * (ABS(L139 = MINL252) * MAXH140 + ABS(L139 > MINL252) * (ABS(L140 = MINL252) * MAXH141 + ABS(L140 > MINL252) * (ABS(L141 = MINL252) * MAXH142 + ABS(L141 > MINL252) * (ABS(L142 = MINL252) * MAXH143 + ABS(L142 > MINL252) * (ABS(L143 = MINL252) * MAXH144 + ABS(L143 > MINL252) * (ABS(L144 = MINL252) * MAXH145 + ABS(L144 > MINL252) * (ABS(L145 = MINL252) * MAXH146 + ABS(L145 > MINL252) * (ABS(L146 = MINL252) * MAXH147 + ABS(L146 > MINL252) * (ABS(L147 = MINL252) * MAXH148 + ABS(L147 > MINL252) * (ABS(L148 = MINL252) * MAXH149 + ABS(L148 > MINL252) * (ABS(L149 = MINL252) * MAXH150 + ABS(L149 > MINL252) * (ABS(L150 = MINL252) * MAXH151 + ABS(L150 > MINL252) * (ABS(L151 = MINL252) * MAXH152 + ABS(L151 > MINL252) * (ABS(L152 = MINL252) * MAXH153 + ABS(L152 > MINL252) * (ABS(L153 = MINL252) * MAXH154 + ABS(L153 > MINL252) * (ABS(L154 = MINL252) * MAXH155 + ABS(L154 > MINL252) * (ABS(L155 = MINL252) * MAXH156 + ABS(L155 > MINL252) * (ABS(L156 = MINL252) * MAXH157 + ABS(L156 > MINL252) * (ABS(L157 = MINL252) * MAXH158 + ABS(L157 > MINL252) * (ABS(L158 = MINL252) * MAXH159 + ABS(L158 > MINL252) * (ABS(L159 = MINL252) * MAXH160 + ABS(L159 > MINL252) * (ABS(L160 = MINL252) * MAXH161 + ABS(L160 > MINL252) * (ABS(L161 = MINL252) * MAXH162 + ABS(L161 > MINL252) * (ABS(L162 = MINL252) * MAXH163 + ABS(L162 > MINL252) * (ABS(L163 = MINL252) * MAXH164 + ABS(L163 > MINL252) * (ABS(L164 = MINL252) * MAXH165 + ABS(L164 > MINL252) * (ABS(L165 = MINL252) * MAXH166 + ABS(L165 > MINL252) * (ABS(L166 = MINL252) * MAXH167 + ABS(L166 > MINL252) * (ABS(L167 = MINL252) * MAXH168 + ABS(L167 > MINL252) * (ABS(L168 = MINL252) * MAXH169 + ABS(L168 > MINL252) * (ABS(L169 = MINL252) * MAXH170 + ABS(L169 > MINL252) * (ABS(L170 = MINL252) * MAXH171 + ABS(L170 > MINL252) * (ABS(L171 = MINL252) * MAXH172 + ABS(L171 > MINL252) * (ABS(L172 = MINL252) * MAXH173 + ABS(L172 > MINL252) * (ABS(L173 = MINL252) * MAXH174 + ABS(L173 > MINL252) * (ABS(L174 = MINL252) * MAXH175 + ABS(L174 > MINL252) * (ABS(L175 = MINL252) * MAXH176 + ABS(L175 > MINL252) * (ABS(L176 = MINL252) * MAXH177 + ABS(L176 > MINL252) * (ABS(L177 = MINL252) * MAXH178 + ABS(L177 > MINL252) * (ABS(L178 = MINL252) * MAXH179 + ABS(L178 > MINL252) * (ABS(L179 = MINL252) * MAXH180 + ABS(L179 > MINL252) * (ABS(L180 = MINL252) * MAXH181 + ABS(L180 > MINL252) * (ABS(L181 = MINL252) * MAXH182 + ABS(L181 > MINL252) * (ABS(L182 = MINL252) * MAXH183 + ABS(L182 > MINL252) * (ABS(L183 = MINL252) * MAXH184 + ABS(L183 > MINL252) * (ABS(L184 = MINL252) * MAXH185 + ABS(L184 > MINL252) * (ABS(L185 = MINL252) * MAXH186 + ABS(L185 > MINL252) * (ABS(L186 = MINL252) * MAXH187 + ABS(L186 > MINL252) * (ABS(L187 = MINL252) * MAXH188 + ABS(L187 > MINL252) * (ABS(L188 = MINL252) * MAXH189 + ABS(L188 > MINL252) * (ABS(L189 = MINL252) * MAXH190 + ABS(L189 > MINL252) * (ABS(L190 = MINL252) * MAXH191 + ABS(L190 > MINL252) * (ABS(L191 = MINL252) * MAXH192 + ABS(L191 > MINL252) * (ABS(L192 = MINL252) * MAXH193 + ABS(L192 > MINL252) * (ABS(L193 = MINL252) * MAXH194 + ABS(L193 > MINL252) * (ABS(L194 = MINL252) * MAXH195 + ABS(L194 > MINL252) * (ABS(L195 = MINL252) * MAXH196 + ABS(L195 > MINL252) * (ABS(L196 = MINL252) * MAXH197 + ABS(L196 > MINL252) * (ABS(L197 = MINL252) * MAXH198 + ABS(L197 > MINL252) * (ABS(L198 = MINL252) * MAXH199 + ABS(L198 > MINL252) * (ABS(L199 = MINL252) * MAXH200 + ABS(L199 > MINL252) * (ABS(L200 = MINL252) * MAXH201 + ABS(L200 > MINL252) * (ABS(L201 = MINL252) * MAXH202 + ABS(L201 > MINL252) * (ABS(L202 = MINL252) * MAXH203 + ABS(L202 > MINL252) * (ABS(L203 = MINL252) * MAXH204 + ABS(L203 > MINL252) * (ABS(L204 = MINL252) * MAXH205 + ABS(L204 > MINL252) * (ABS(L205 = MINL252) * MAXH206 + ABS(L205 > MINL252) * (ABS(L206 = MINL252) * MAXH207 + ABS(L206 > MINL252) * (ABS(L207 = MINL252) * MAXH208 + ABS(L207 > MINL252) * (ABS(L208 = MINL252) * MAXH209 + ABS(L208 > MINL252) * (ABS(L209 = MINL252) * MAXH210 + ABS(L209 > MINL252) * (ABS(L210 = MINL252) * MAXH211 + ABS(L210 > MINL252) * (ABS(L211 = MINL252) * MAXH212 + ABS(L211 > MINL252) * (ABS(L212 = MINL252) * MAXH213 + ABS(L212 > MINL252) * (ABS(L213 = MINL252) * MAXH214 + ABS(L213 > MINL252) * (ABS(L214 = MINL252) * MAXH215 + ABS(L214 > MINL252) * (ABS(L215 = MINL252) * MAXH216 + ABS(L215 > MINL252) * (ABS(L216 = MINL252) * MAXH217 + ABS(L216 > MINL252) * (ABS(L217 = MINL252) * MAXH218 + ABS(L217 > MINL252) * (ABS(L218 = MINL252) * MAXH219 + ABS(L218 > MINL252) * (ABS(L219 = MINL252) * MAXH220 + ABS(L219 > MINL252) * (ABS(L220 = MINL252) * MAXH221 + ABS(L220 > MINL252) * (ABS(L221 = MINL252) * MAXH222 + ABS(L221 > MINL252) * (ABS(L222 = MINL252) * MAXH223 + ABS(L222 > MINL252) * (ABS(L223 = MINL252) * MAXH224 + ABS(L223 > MINL252) * (ABS(L224 = MINL252) * MAXH225 + ABS(L224 > MINL252) * (ABS(L225 = MINL252) * MAXH226 + ABS(L225 > MINL252) * (ABS(L226 = MINL252) * MAXH227 + ABS(L226 > MINL252) * (ABS(L227 = MINL252) * MAXH228 + ABS(L227 > MINL252) * (ABS(L228 = MINL252) * MAXH229 + ABS(L228 > MINL252) * (ABS(L229 = MINL252) * MAXH230 + ABS(L229 > MINL252) * (ABS(L230 = MINL252) * MAXH231 + ABS(L230 > MINL252) * (ABS(L231 = MINL252) * MAXH232 + ABS(L231 > MINL252) * (ABS(L232 = MINL252) * MAXH233 + ABS(L232 > MINL252) * (ABS(L233 = MINL252) * MAXH234 + ABS(L233 > MINL252) * (ABS(L234 = MINL252) * MAXH235 + ABS(L234 > MINL252) * (ABS(L235 = MINL252) * MAXH236 + ABS(L235 > MINL252) * (ABS(L236 = MINL252) * MAXH237 + ABS(L236 > MINL252) * (ABS(L237 = MINL252) * MAXH238 + ABS(L237 > MINL252) * (ABS(L238 = MINL252) * MAXH239 + ABS(L238 > MINL252) * (ABS(L239 = MINL252) * MAXH240 + ABS(L239 > MINL252) * (ABS(L240 = MINL252) * MAXH241 + ABS(L240 > MINL252) * (ABS(L241 = MINL252) * MAXH242 + ABS(L241 > MINL252) * (ABS(L242 = MINL252) * MAXH243 + ABS(L242 > MINL252) * (ABS(L243 = MINL252) * MAXH244 + ABS(L243 > MINL252) * (ABS(L244 = MINL252) * MAXH245 + ABS(L244 > MINL252) * (ABS(L245 = MINL252) * MAXH246 + ABS(L245 > MINL252) * (ABS(L246 = MINL252) * MAXH247 + ABS(L246 > MINL252) * (ABS(L247 = MINL252) * MAXH248 + ABS(L247 > MINL252) * (ABS(L248 = MINL252) * MAXH249 + ABS(L248 > MINL252) * (ABS(L249 = MINL252) * MAXH250 + ABS(L249 > MINL252) * (ABS(L250 = MINL252) * MAXH251 + ABS(L250 > MINL252) * MAXH252)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - MINL252 - 2 * C / 3) <= 2 * C / 3 - MINL252
I still think we won't know for sure until somebody refers us to an original source.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/1/2005 Posts: 2,645
|
QUOTE (bustermu) Unfortunately, I do not see a way to prevent writing it twice.
Bruce,
I've said some stupid things before, but, hopefully, none more absurd than that.
I greatly appreciate you straightening me out.
Thanks,
Jim Murphy
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
bustermu,
I do not associate the word absurd or stupid with you or any of your posts.
I've re-read my Wednesday, April 09, 2008 4:33:31 PM ET and come to the conclusion that some of the parentheticals could be perceived as flip. That was certainly not the intent and I hope you did not take it that way.
I was coming to the end of a rather long day and wanted to post something instead of leaving the post unanswered. I thought about it for a few seconds, wrote the Personal Criteria Formula (essentially as copy and paste) along with a short explanation with the full expectation that you would find it was seriously flawed (as I had not examined the problem rigorously and had run only a single test on the PCF to see if it produced "similar" results to the "long" version proposed in your Wednesday, April 09, 2008 9:42:35 AM post).
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/1/2005 Posts: 2,645
|
Bruce,
I also do not associate the word absurd or stupid with myself, just with the statement I made. For me to say that I don't know how to write a PCF for a < b < c without writing b twice?
Your post is perfectly fine. Some may be a little confused by the notation (H @ Lk = MINL252) but they get the correct results and an explanation of how you got there.
Thanks,
Jim Murphy
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
bustermu,
You're welcome. I'm happy to read you did not take my post the wrong way.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |