Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

OBV Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dfst24a
Posted : Thursday, April 15, 2010 9:30:34 PM
Registered User
Joined: 12/30/2004
Posts: 84
How would I create a PCF for identifying OBV crossing the zero line (turning positive) TODAY on any stock based on a 2 year timeframe?  

Thank you
Bruce_L
Posted : Friday, April 16, 2010 9:31:44 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Let me start by saying the Value of OBV is meaningless. It doesn't matter if it is positive or negative or crosses through zero.

Dealing with OBV & MS in PCF's - how to interp their "values"

Hopefully reading through the above will make you not want to do this. That said, the following Personal Criteria Formula should return True if an OBV that was calculated using 504-Trading today and 503-Trading Days yesterday is above zero today and was at or below zero yesterday:

Warning: Long Personal Criteria Formulas can dramatically increase the time it takes to update your PCFs.

SGN(C - C1) * V + SGN(C1 - C2) * V1 + SGN(C2 - C3) * V2 + SGN(C3 - C4) * V3 + SGN(C4 - C5) * V4 + SGN(C5 - C6) * V5 + SGN(C6 - C7) * V6 + SGN(C7 - C8) * V7 + SGN(C8 - C9) * V8 + SGN(C9 - C10) * V9 + SGN(C10 - C11) * V10 + SGN(C11 - C12) * V11 + SGN(C12 - C13) * V12 + SGN(C13 - C14) * V13 + SGN(C14 - C15) * V14 + SGN(C15 - C16) * V15 + SGN(C16 - C17) * V16 + SGN(C17 - C18) * V17 + SGN(C18 - C19) * V18 + SGN(C19 - C20) * V19 + SGN(C20 - C21) * V20 + SGN(C21 - C22) * V21 + SGN(C22 - C23) * V22 + SGN(C23 - C24) * V23 + SGN(C24 - C25) * V24 + SGN(C25 - C26) * V25 + SGN(C26 - C27) * V26 + SGN(C27 - C28) * V27 + SGN(C28 - C29) * V28 + SGN(C29 - C30) * V29 + SGN(C30 - C31) * V30 + SGN(C31 - C32) * V31 + SGN(C32 - C33) * V32 + SGN(C33 - C34) * V33 + SGN(C34 - C35) * V34 + SGN(C35 - C36) * V35 + SGN(C36 - C37) * V36 + SGN(C37 - C38) * V37 + SGN(C38 - C39) * V38 + SGN(C39 - C40) * V39 + SGN(C40 - C41) * V40 + SGN(C41 - C42) * V41 + SGN(C42 - C43) * V42 + SGN(C43 - C44) * V43 + SGN(C44 - C45) * V44 + SGN(C45 - C46) * V45 + SGN(C46 - C47) * V46 + SGN(C47 - C48) * V47 + SGN(C48 - C49) * V48 + SGN(C49 - C50) * V49 + SGN(C50 - C51) * V50 + SGN(C51 - C52) * V51 + SGN(C52 - C53) * V52 + SGN(C53 - C54) * V53 + SGN(C54 - C55) * V54 + SGN(C55 - C56) * V55 + SGN(C56 - C57) * V56 + SGN(C57 - C58) * V57 + SGN(C58 - C59) * V58 + SGN(C59 - C60) * V59 + SGN(C60 - C61) * V60 + SGN(C61 - C62) * V61 + SGN(C62 - C63) * V62 + SGN(C63 - C64) * V63 + SGN(C64 - C65) * V64 + SGN(C65 - C66) * V65 + SGN(C66 - C67) * V66 + SGN(C67 - C68) * V67 + SGN(C68 - C69) * V68 + SGN(C69 - C70) * V69 + SGN(C70 - C71) * V70 + SGN(C71 - C72) * V71 + SGN(C72 - C73) * V72 + SGN(C73 - C74) * V73 + SGN(C74 - C75) * V74 + SGN(C75 - C76) * V75 + SGN(C76 - C77) * V76 + SGN(C77 - C78) * V77 + SGN(C78 - C79) * V78 + SGN(C79 - C80) * V79 + SGN(C80 - C81) * V80 + SGN(C81 - C82) * V81 + SGN(C82 - C83) * V82 + SGN(C83 - C84) * V83 + SGN(C84 - C85) * V84 + SGN(C85 - C86) * V85 + SGN(C86 - C87) * V86 + SGN(C87 - C88) * V87 + SGN(C88 - C89) * V88 + SGN(C89 - C90) * V89 + SGN(C90 - C91) * V90 + SGN(C91 - C92) * V91 + SGN(C92 - C93) * V92 + SGN(C93 - C94) * V93 + SGN(C94 - C95) * V94 + SGN(C95 - C96) * V95 + SGN(C96 - C97) * V96 + SGN(C97 - C98) * V97 + SGN(C98 - C99) * V98 + SGN(C99 - C100) * V99 + SGN(C100 - C101) * V100 + SGN(C101 - C102) * V101 + SGN(C102 - C103) * V102 + SGN(C103 - C104) * V103 + SGN(C104 - C105) * V104 + SGN(C105 - C106) * V105 + SGN(C106 - C107) * V106 + SGN(C107 - C108) * V107 + SGN(C108 - C109) * V108 + SGN(C109 - C110) * V109 + SGN(C110 - C111) * V110 + SGN(C111 - C112) * V111 + SGN(C112 - C113) * V112 + SGN(C113 - C114) * V113 + SGN(C114 - C115) * V114 + SGN(C115 - C116) * V115 + SGN(C116 - C117) * V116 + SGN(C117 - C118) * V117 + SGN(C118 - C119) * V118 + SGN(C119 - C120) * V119 + SGN(C120 - C121) * V120 + SGN(C121 - C122) * V121 + SGN(C122 - C123) * V122 + SGN(C123 - C124) * V123 + SGN(C124 - C125) * V124 + SGN(C125 - C126) * V125 + SGN(C126 - C127) * V126 + SGN(C127 - C128) * V127 + SGN(C128 - C129) * V128 + SGN(C129 - C130) * V129 + SGN(C130 - C131) * V130 + SGN(C131 - C132) * V131 + SGN(C132 - C133) * V132 + SGN(C133 - C134) * V133 + SGN(C134 - C135) * V134 + SGN(C135 - C136) * V135 + SGN(C136 - C137) * V136 + SGN(C137 - C138) * V137 + SGN(C138 - C139) * V138 + SGN(C139 - C140) * V139 + SGN(C140 - C141) * V140 + SGN(C141 - C142) * V141 + SGN(C142 - C143) * V142 + SGN(C143 - C144) * V143 + SGN(C144 - C145) * V144 + SGN(C145 - C146) * V145 + SGN(C146 - C147) * V146 + SGN(C147 - C148) * V147 + SGN(C148 - C149) * V148 + SGN(C149 - C150) * V149 + SGN(C150 - C151) * V150 + SGN(C151 - C152) * V151 + SGN(C152 - C153) * V152 + SGN(C153 - C154) * V153 + SGN(C154 - C155) * V154 + SGN(C155 - C156) * V155 + SGN(C156 - C157) * V156 + SGN(C157 - C158) * V157 + SGN(C158 - C159) * V158 + SGN(C159 - C160) * V159 + SGN(C160 - C161) * V160 + SGN(C161 - C162) * V161 + SGN(C162 - C163) * V162 + SGN(C163 - C164) * V163 + SGN(C164 - C165) * V164 + SGN(C165 - C166) * V165 + SGN(C166 - C167) * V166 + SGN(C167 - C168) * V167 + SGN(C168 - C169) * V168 + SGN(C169 - C170) * V169 + SGN(C170 - C171) * V170 + SGN(C171 - C172) * V171 + SGN(C172 - C173) * V172 + SGN(C173 - C174) * V173 + SGN(C174 - C175) * V174 + SGN(C175 - C176) * V175 + SGN(C176 - C177) * V176 + SGN(C177 - C178) * V177 + SGN(C178 - C179) * V178 + SGN(C179 - C180) * V179 + SGN(C180 - C181) * V180 + SGN(C181 - C182) * V181 + SGN(C182 - C183) * V182 + SGN(C183 - C184) * V183 + SGN(C184 - C185) * V184 + SGN(C185 - C186) * V185 + SGN(C186 - C187) * V186 + SGN(C187 - C188) * V187 + SGN(C188 - C189) * V188 + SGN(C189 - C190) * V189 + SGN(C190 - C191) * V190 + SGN(C191 - C192) * V191 + SGN(C192 - C193) * V192 + SGN(C193 - C194) * V193 + SGN(C194 - C195) * V194 + SGN(C195 - C196) * V195 + SGN(C196 - C197) * V196 + SGN(C197 - C198) * V197 + SGN(C198 - C199) * V198 + SGN(C199 - C200) * V199 + SGN(C200 - C201) * V200 + SGN(C201 - C202) * V201 + SGN(C202 - C203) * V202 + SGN(C203 - C204) * V203 + SGN(C204 - C205) * V204 + SGN(C205 - C206) * V205 + SGN(C206 - C207) * V206 + SGN(C207 - C208) * V207 + SGN(C208 - C209) * V208 + SGN(C209 - C210) * V209 + SGN(C210 - C211) * V210 + SGN(C211 - C212) * V211 + SGN(C212 - C213) * V212 + SGN(C213 - C214) * V213 + SGN(C214 - C215) * V214 + SGN(C215 - C216) * V215 + SGN(C216 - C217) * V216 + SGN(C217 - C218) * V217 + SGN(C218 - C219) * V218 + SGN(C219 - C220) * V219 + SGN(C220 - C221) * V220 + SGN(C221 - C222) * V221 + SGN(C222 - C223) * V222 + SGN(C223 - C224) * V223 + SGN(C224 - C225) * V224 + SGN(C225 - C226) * V225 + SGN(C226 - C227) * V226 + SGN(C227 - C228) * V227 + SGN(C228 - C229) * V228 + SGN(C229 - C230) * V229 + SGN(C230 - C231) * V230 + SGN(C231 - C232) * V231 + SGN(C232 - C233) * V232 + SGN(C233 - C234) * V233 + SGN(C234 - C235) * V234 + SGN(C235 - C236) * V235 + SGN(C236 - C237) * V236 + SGN(C237 - C238) * V237 + SGN(C238 - C239) * V238 + SGN(C239 - C240) * V239 + SGN(C240 - C241) * V240 + SGN(C241 - C242) * V241 + SGN(C242 - C243) * V242 + SGN(C243 - C244) * V243 + SGN(C244 - C245) * V244 + SGN(C245 - C246) * V245 + SGN(C246 - C247) * V246 + SGN(C247 - C248) * V247 + SGN(C248 - C249) * V248 + SGN(C249 - C250) * V249 + SGN(C250 - C251) * V250 + SGN(C251 - C252) * V251 + SGN(C252 - C253) * V252 + SGN(C253 - C254) * V253 + SGN(C254 - C255) * V254 + SGN(C255 - C256) * V255 + SGN(C256 - C257) * V256 + SGN(C257 - C258) * V257 + SGN(C258 - C259) * V258 + SGN(C259 - C260) * V259 + SGN(C260 - C261) * V260 + SGN(C261 - C262) * V261 + SGN(C262 - C263) * V262 + SGN(C263 - C264) * V263 + SGN(C264 - C265) * V264 + SGN(C265 - C266) * V265 + SGN(C266 - C267) * V266 + SGN(C267 - C268) * V267 + SGN(C268 - C269) * V268 + SGN(C269 - C270) * V269 + SGN(C270 - C271) * V270 + SGN(C271 - C272) * V271 + SGN(C272 - C273) * V272 + SGN(C273 - C274) * V273 + SGN(C274 - C275) * V274 + SGN(C275 - C276) * V275 + SGN(C276 - C277) * V276 + SGN(C277 - C278) * V277 + SGN(C278 - C279) * V278 + SGN(C279 - C280) * V279 + SGN(C280 - C281) * V280 + SGN(C281 - C282) * V281 + SGN(C282 - C283) * V282 + SGN(C283 - C284) * V283 + SGN(C284 - C285) * V284 + SGN(C285 - C286) * V285 + SGN(C286 - C287) * V286 + SGN(C287 - C288) * V287 + SGN(C288 - C289) * V288 + SGN(C289 - C290) * V289 + SGN(C290 - C291) * V290 + SGN(C291 - C292) * V291 + SGN(C292 - C293) * V292 + SGN(C293 - C294) * V293 + SGN(C294 - C295) * V294 + SGN(C295 - C296) * V295 + SGN(C296 - C297) * V296 + SGN(C297 - C298) * V297 + SGN(C298 - C299) * V298 + SGN(C299 - C300) * V299 + SGN(C300 - C301) * V300 + SGN(C301 - C302) * V301 + SGN(C302 - C303) * V302 + SGN(C303 - C304) * V303 + SGN(C304 - C305) * V304 + SGN(C305 - C306) * V305 + SGN(C306 - C307) * V306 + SGN(C307 - C308) * V307 + SGN(C308 - C309) * V308 + SGN(C309 - C310) * V309 + SGN(C310 - C311) * V310 + SGN(C311 - C312) * V311 + SGN(C312 - C313) * V312 + SGN(C313 - C314) * V313 + SGN(C314 - C315) * V314 + SGN(C315 - C316) * V315 + SGN(C316 - C317) * V316 + SGN(C317 - C318) * V317 + SGN(C318 - C319) * V318 + SGN(C319 - C320) * V319 + SGN(C320 - C321) * V320 + SGN(C321 - C322) * V321 + SGN(C322 - C323) * V322 + SGN(C323 - C324) * V323 + SGN(C324 - C325) * V324 + SGN(C325 - C326) * V325 + SGN(C326 - C327) * V326 + SGN(C327 - C328) * V327 + SGN(C328 - C329) * V328 + SGN(C329 - C330) * V329 + SGN(C330 - C331) * V330 + SGN(C331 - C332) * V331 + SGN(C332 - C333) * V332 + SGN(C333 - C334) * V333 + SGN(C334 - C335) * V334 + SGN(C335 - C336) * V335 + SGN(C336 - C337) * V336 + SGN(C337 - C338) * V337 + SGN(C338 - C339) * V338 + SGN(C339 - C340) * V339 + SGN(C340 - C341) * V340 + SGN(C341 - C342) * V341 + SGN(C342 - C343) * V342 + SGN(C343 - C344) * V343 + SGN(C344 - C345) * V344 + SGN(C345 - C346) * V345 + SGN(C346 - C347) * V346 + SGN(C347 - C348) * V347 + SGN(C348 - C349) * V348 + SGN(C349 - C350) * V349 + SGN(C350 - C351) * V350 + SGN(C351 - C352) * V351 + SGN(C352 - C353) * V352 + SGN(C353 - C354) * V353 + SGN(C354 - C355) * V354 + SGN(C355 - C356) * V355 + SGN(C356 - C357) * V356 + SGN(C357 - C358) * V357 + SGN(C358 - C359) * V358 + SGN(C359 - C360) * V359 + SGN(C360 - C361) * V360 + SGN(C361 - C362) * V361 + SGN(C362 - C363) * V362 + SGN(C363 - C364) * V363 + SGN(C364 - C365) * V364 + SGN(C365 - C366) * V365 + SGN(C366 - C367) * V366 + SGN(C367 - C368) * V367 + SGN(C368 - C369) * V368 + SGN(C369 - C370) * V369 + SGN(C370 - C371) * V370 + SGN(C371 - C372) * V371 + SGN(C372 - C373) * V372 + SGN(C373 - C374) * V373 + SGN(C374 - C375) * V374 + SGN(C375 - C376) * V375 + SGN(C376 - C377) * V376 + SGN(C377 - C378) * V377 + SGN(C378 - C379) * V378 + SGN(C379 - C380) * V379 + SGN(C380 - C381) * V380 + SGN(C381 - C382) * V381 + SGN(C382 - C383) * V382 + SGN(C383 - C384) * V383 + SGN(C384 - C385) * V384 + SGN(C385 - C386) * V385 + SGN(C386 - C387) * V386 + SGN(C387 - C388) * V387 + SGN(C388 - C389) * V388 + SGN(C389 - C390) * V389 + SGN(C390 - C391) * V390 + SGN(C391 - C392) * V391 + SGN(C392 - C393) * V392 + SGN(C393 - C394) * V393 + SGN(C394 - C395) * V394 + SGN(C395 - C396) * V395 + SGN(C396 - C397) * V396 + SGN(C397 - C398) * V397 + SGN(C398 - C399) * V398 + SGN(C399 - C400) * V399 + SGN(C400 - C401) * V400 + SGN(C401 - C402) * V401 + SGN(C402 - C403) * V402 + SGN(C403 - C404) * V403 + SGN(C404 - C405) * V404 + SGN(C405 - C406) * V405 + SGN(C406 - C407) * V406 + SGN(C407 - C408) * V407 + SGN(C408 - C409) * V408 + SGN(C409 - C410) * V409 + SGN(C410 - C411) * V410 + SGN(C411 - C412) * V411 + SGN(C412 - C413) * V412 + SGN(C413 - C414) * V413 + SGN(C414 - C415) * V414 + SGN(C415 - C416) * V415 + SGN(C416 - C417) * V416 + SGN(C417 - C418) * V417 + SGN(C418 - C419) * V418 + SGN(C419 - C420) * V419 + SGN(C420 - C421) * V420 + SGN(C421 - C422) * V421 + SGN(C422 - C423) * V422 + SGN(C423 - C424) * V423 + SGN(C424 - C425) * V424 + SGN(C425 - C426) * V425 + SGN(C426 - C427) * V426 + SGN(C427 - C428) * V427 + SGN(C428 - C429) * V428 + SGN(C429 - C430) * V429 + SGN(C430 - C431) * V430 + SGN(C431 - C432) * V431 + SGN(C432 - C433) * V432 + SGN(C433 - C434) * V433 + SGN(C434 - C435) * V434 + SGN(C435 - C436) * V435 + SGN(C436 - C437) * V436 + SGN(C437 - C438) * V437 + SGN(C438 - C439) * V438 + SGN(C439 - C440) * V439 + SGN(C440 - C441) * V440 + SGN(C441 - C442) * V441 + SGN(C442 - C443) * V442 + SGN(C443 - C444) * V443 + SGN(C444 - C445) * V444 + SGN(C445 - C446) * V445 + SGN(C446 - C447) * V446 + SGN(C447 - C448) * V447 + SGN(C448 - C449) * V448 + SGN(C449 - C450) * V449 + SGN(C450 - C451) * V450 + SGN(C451 - C452) * V451 + SGN(C452 - C453) * V452 + SGN(C453 - C454) * V453 + SGN(C454 - C455) * V454 + SGN(C455 - C456) * V455 + SGN(C456 - C457) * V456 + SGN(C457 - C458) * V457 + SGN(C458 - C459) * V458 + SGN(C459 - C460) * V459 + SGN(C460 - C461) * V460 + SGN(C461 - C462) * V461 + SGN(C462 - C463) * V462 + SGN(C463 - C464) * V463 + SGN(C464 - C465) * V464 + SGN(C465 - C466) * V465 + SGN(C466 - C467) * V466 + SGN(C467 - C468) * V467 + SGN(C468 - C469) * V468 + SGN(C469 - C470) * V469 + SGN(C470 - C471) * V470 + SGN(C471 - C472) * V471 + SGN(C472 - C473) * V472 + SGN(C473 - C474) * V473 + SGN(C474 - C475) * V474 + SGN(C475 - C476) * V475 + SGN(C476 - C477) * V476 + SGN(C477 - C478) * V477 + SGN(C478 - C479) * V478 + SGN(C479 - C480) * V479 + SGN(C480 - C481) * V480 + SGN(C481 - C482) * V481 + SGN(C482 - C483) * V482 + SGN(C483 - C484) * V483 + SGN(C484 - C485) * V484 + SGN(C485 - C486) * V485 + SGN(C486 - C487) * V486 + SGN(C487 - C488) * V487 + SGN(C488 - C489) * V488 + SGN(C489 - C490) * V489 + SGN(C490 - C491) * V490 + SGN(C491 - C492) * V491 + SGN(C492 - C493) * V492 + SGN(C493 - C494) * V493 + SGN(C494 - C495) * V494 + SGN(C495 - C496) * V495 + SGN(C496 - C497) * V496 + SGN(C497 - C498) * V497 + SGN(C498 - C499) * V498 + SGN(C499 - C500) * V499 + SGN(C500 - C501) * V500 + SGN(C501 - C502) * V501 + SGN(C502 - C503) * V502 + SGN(C503 - C504) * V503 > 0 AND SGN(C1 - C2) * V1 + SGN(C2 - C3) * V2 + SGN(C3 - C4) * V3 + SGN(C4 - C5) * V4 + SGN(C5 - C6) * V5 + SGN(C6 - C7) * V6 + SGN(C7 - C8) * V7 + SGN(C8 - C9) * V8 + SGN(C9 - C10) * V9 + SGN(C10 - C11) * V10 + SGN(C11 - C12) * V11 + SGN(C12 - C13) * V12 + SGN(C13 - C14) * V13 + SGN(C14 - C15) * V14 + SGN(C15 - C16) * V15 + SGN(C16 - C17) * V16 + SGN(C17 - C18) * V17 + SGN(C18 - C19) * V18 + SGN(C19 - C20) * V19 + SGN(C20 - C21) * V20 + SGN(C21 - C22) * V21 + SGN(C22 - C23) * V22 + SGN(C23 - C24) * V23 + SGN(C24 - C25) * V24 + SGN(C25 - C26) * V25 + SGN(C26 - C27) * V26 + SGN(C27 - C28) * V27 + SGN(C28 - C29) * V28 + SGN(C29 - C30) * V29 + SGN(C30 - C31) * V30 + SGN(C31 - C32) * V31 + SGN(C32 - C33) * V32 + SGN(C33 - C34) * V33 + SGN(C34 - C35) * V34 + SGN(C35 - C36) * V35 + SGN(C36 - C37) * V36 + SGN(C37 - C38) * V37 + SGN(C38 - C39) * V38 + SGN(C39 - C40) * V39 + SGN(C40 - C41) * V40 + SGN(C41 - C42) * V41 + SGN(C42 - C43) * V42 + SGN(C43 - C44) * V43 + SGN(C44 - C45) * V44 + SGN(C45 - C46) * V45 + SGN(C46 - C47) * V46 + SGN(C47 - C48) * V47 + SGN(C48 - C49) * V48 + SGN(C49 - C50) * V49 + SGN(C50 - C51) * V50 + SGN(C51 - C52) * V51 + SGN(C52 - C53) * V52 + SGN(C53 - C54) * V53 + SGN(C54 - C55) * V54 + SGN(C55 - C56) * V55 + SGN(C56 - C57) * V56 + SGN(C57 - C58) * V57 + SGN(C58 - C59) * V58 + SGN(C59 - C60) * V59 + SGN(C60 - C61) * V60 + SGN(C61 - C62) * V61 + SGN(C62 - C63) * V62 + SGN(C63 - C64) * V63 + SGN(C64 - C65) * V64 + SGN(C65 - C66) * V65 + SGN(C66 - C67) * V66 + SGN(C67 - C68) * V67 + SGN(C68 - C69) * V68 + SGN(C69 - C70) * V69 + SGN(C70 - C71) * V70 + SGN(C71 - C72) * V71 + SGN(C72 - C73) * V72 + SGN(C73 - C74) * V73 + SGN(C74 - C75) * V74 + SGN(C75 - C76) * V75 + SGN(C76 - C77) * V76 + SGN(C77 - C78) * V77 + SGN(C78 - C79) * V78 + SGN(C79 - C80) * V79 + SGN(C80 - C81) * V80 + SGN(C81 - C82) * V81 + SGN(C82 - C83) * V82 + SGN(C83 - C84) * V83 + SGN(C84 - C85) * V84 + SGN(C85 - C86) * V85 + SGN(C86 - C87) * V86 + SGN(C87 - C88) * V87 + SGN(C88 - C89) * V88 + SGN(C89 - C90) * V89 + SGN(C90 - C91) * V90 + SGN(C91 - C92) * V91 + SGN(C92 - C93) * V92 + SGN(C93 - C94) * V93 + SGN(C94 - C95) * V94 + SGN(C95 - C96) * V95 + SGN(C96 - C97) * V96 + SGN(C97 - C98) * V97 + SGN(C98 - C99) * V98 + SGN(C99 - C100) * V99 + SGN(C100 - C101) * V100 + SGN(C101 - C102) * V101 + SGN(C102 - C103) * V102 + SGN(C103 - C104) * V103 + SGN(C104 - C105) * V104 + SGN(C105 - C106) * V105 + SGN(C106 - C107) * V106 + SGN(C107 - C108) * V107 + SGN(C108 - C109) * V108 + SGN(C109 - C110) * V109 + SGN(C110 - C111) * V110 + SGN(C111 - C112) * V111 + SGN(C112 - C113) * V112 + SGN(C113 - C114) * V113 + SGN(C114 - C115) * V114 + SGN(C115 - C116) * V115 + SGN(C116 - C117) * V116 + SGN(C117 - C118) * V117 + SGN(C118 - C119) * V118 + SGN(C119 - C120) * V119 + SGN(C120 - C121) * V120 + SGN(C121 - C122) * V121 + SGN(C122 - C123) * V122 + SGN(C123 - C124) * V123 + SGN(C124 - C125) * V124 + SGN(C125 - C126) * V125 + SGN(C126 - C127) * V126 + SGN(C127 - C128) * V127 + SGN(C128 - C129) * V128 + SGN(C129 - C130) * V129 + SGN(C130 - C131) * V130 + SGN(C131 - C132) * V131 + SGN(C132 - C133) * V132 + SGN(C133 - C134) * V133 + SGN(C134 - C135) * V134 + SGN(C135 - C136) * V135 + SGN(C136 - C137) * V136 + SGN(C137 - C138) * V137 + SGN(C138 - C139) * V138 + SGN(C139 - C140) * V139 + SGN(C140 - C141) * V140 + SGN(C141 - C142) * V141 + SGN(C142 - C143) * V142 + SGN(C143 - C144) * V143 + SGN(C144 - C145) * V144 + SGN(C145 - C146) * V145 + SGN(C146 - C147) * V146 + SGN(C147 - C148) * V147 + SGN(C148 - C149) * V148 + SGN(C149 - C150) * V149 + SGN(C150 - C151) * V150 + SGN(C151 - C152) * V151 + SGN(C152 - C153) * V152 + SGN(C153 - C154) * V153 + SGN(C154 - C155) * V154 + SGN(C155 - C156) * V155 + SGN(C156 - C157) * V156 + SGN(C157 - C158) * V157 + SGN(C158 - C159) * V158 + SGN(C159 - C160) * V159 + SGN(C160 - C161) * V160 + SGN(C161 - C162) * V161 + SGN(C162 - C163) * V162 + SGN(C163 - C164) * V163 + SGN(C164 - C165) * V164 + SGN(C165 - C166) * V165 + SGN(C166 - C167) * V166 + SGN(C167 - C168) * V167 + SGN(C168 - C169) * V168 + SGN(C169 - C170) * V169 + SGN(C170 - C171) * V170 + SGN(C171 - C172) * V171 + SGN(C172 - C173) * V172 + SGN(C173 - C174) * V173 + SGN(C174 - C175) * V174 + SGN(C175 - C176) * V175 + SGN(C176 - C177) * V176 + SGN(C177 - C178) * V177 + SGN(C178 - C179) * V178 + SGN(C179 - C180) * V179 + SGN(C180 - C181) * V180 + SGN(C181 - C182) * V181 + SGN(C182 - C183) * V182 + SGN(C183 - C184) * V183 + SGN(C184 - C185) * V184 + SGN(C185 - C186) * V185 + SGN(C186 - C187) * V186 + SGN(C187 - C188) * V187 + SGN(C188 - C189) * V188 + SGN(C189 - C190) * V189 + SGN(C190 - C191) * V190 + SGN(C191 - C192) * V191 + SGN(C192 - C193) * V192 + SGN(C193 - C194) * V193 + SGN(C194 - C195) * V194 + SGN(C195 - C196) * V195 + SGN(C196 - C197) * V196 + SGN(C197 - C198) * V197 + SGN(C198 - C199) * V198 + SGN(C199 - C200) * V199 + SGN(C200 - C201) * V200 + SGN(C201 - C202) * V201 + SGN(C202 - C203) * V202 + SGN(C203 - C204) * V203 + SGN(C204 - C205) * V204 + SGN(C205 - C206) * V205 + SGN(C206 - C207) * V206 + SGN(C207 - C208) * V207 + SGN(C208 - C209) * V208 + SGN(C209 - C210) * V209 + SGN(C210 - C211) * V210 + SGN(C211 - C212) * V211 + SGN(C212 - C213) * V212 + SGN(C213 - C214) * V213 + SGN(C214 - C215) * V214 + SGN(C215 - C216) * V215 + SGN(C216 - C217) * V216 + SGN(C217 - C218) * V217 + SGN(C218 - C219) * V218 + SGN(C219 - C220) * V219 + SGN(C220 - C221) * V220 + SGN(C221 - C222) * V221 + SGN(C222 - C223) * V222 + SGN(C223 - C224) * V223 + SGN(C224 - C225) * V224 + SGN(C225 - C226) * V225 + SGN(C226 - C227) * V226 + SGN(C227 - C228) * V227 + SGN(C228 - C229) * V228 + SGN(C229 - C230) * V229 + SGN(C230 - C231) * V230 + SGN(C231 - C232) * V231 + SGN(C232 - C233) * V232 + SGN(C233 - C234) * V233 + SGN(C234 - C235) * V234 + SGN(C235 - C236) * V235 + SGN(C236 - C237) * V236 + SGN(C237 - C238) * V237 + SGN(C238 - C239) * V238 + SGN(C239 - C240) * V239 + SGN(C240 - C241) * V240 + SGN(C241 - C242) * V241 + SGN(C242 - C243) * V242 + SGN(C243 - C244) * V243 + SGN(C244 - C245) * V244 + SGN(C245 - C246) * V245 + SGN(C246 - C247) * V246 + SGN(C247 - C248) * V247 + SGN(C248 - C249) * V248 + SGN(C249 - C250) * V249 + SGN(C250 - C251) * V250 + SGN(C251 - C252) * V251 + SGN(C252 - C253) * V252 + SGN(C253 - C254) * V253 + SGN(C254 - C255) * V254 + SGN(C255 - C256) * V255 + SGN(C256 - C257) * V256 + SGN(C257 - C258) * V257 + SGN(C258 - C259) * V258 + SGN(C259 - C260) * V259 + SGN(C260 - C261) * V260 + SGN(C261 - C262) * V261 + SGN(C262 - C263) * V262 + SGN(C263 - C264) * V263 + SGN(C264 - C265) * V264 + SGN(C265 - C266) * V265 + SGN(C266 - C267) * V266 + SGN(C267 - C268) * V267 + SGN(C268 - C269) * V268 + SGN(C269 - C270) * V269 + SGN(C270 - C271) * V270 + SGN(C271 - C272) * V271 + SGN(C272 - C273) * V272 + SGN(C273 - C274) * V273 + SGN(C274 - C275) * V274 + SGN(C275 - C276) * V275 + SGN(C276 - C277) * V276 + SGN(C277 - C278) * V277 + SGN(C278 - C279) * V278 + SGN(C279 - C280) * V279 + SGN(C280 - C281) * V280 + SGN(C281 - C282) * V281 + SGN(C282 - C283) * V282 + SGN(C283 - C284) * V283 + SGN(C284 - C285) * V284 + SGN(C285 - C286) * V285 + SGN(C286 - C287) * V286 + SGN(C287 - C288) * V287 + SGN(C288 - C289) * V288 + SGN(C289 - C290) * V289 + SGN(C290 - C291) * V290 + SGN(C291 - C292) * V291 + SGN(C292 - C293) * V292 + SGN(C293 - C294) * V293 + SGN(C294 - C295) * V294 + SGN(C295 - C296) * V295 + SGN(C296 - C297) * V296 + SGN(C297 - C298) * V297 + SGN(C298 - C299) * V298 + SGN(C299 - C300) * V299 + SGN(C300 - C301) * V300 + SGN(C301 - C302) * V301 + SGN(C302 - C303) * V302 + SGN(C303 - C304) * V303 + SGN(C304 - C305) * V304 + SGN(C305 - C306) * V305 + SGN(C306 - C307) * V306 + SGN(C307 - C308) * V307 + SGN(C308 - C309) * V308 + SGN(C309 - C310) * V309 + SGN(C310 - C311) * V310 + SGN(C311 - C312) * V311 + SGN(C312 - C313) * V312 + SGN(C313 - C314) * V313 + SGN(C314 - C315) * V314 + SGN(C315 - C316) * V315 + SGN(C316 - C317) * V316 + SGN(C317 - C318) * V317 + SGN(C318 - C319) * V318 + SGN(C319 - C320) * V319 + SGN(C320 - C321) * V320 + SGN(C321 - C322) * V321 + SGN(C322 - C323) * V322 + SGN(C323 - C324) * V323 + SGN(C324 - C325) * V324 + SGN(C325 - C326) * V325 + SGN(C326 - C327) * V326 + SGN(C327 - C328) * V327 + SGN(C328 - C329) * V328 + SGN(C329 - C330) * V329 + SGN(C330 - C331) * V330 + SGN(C331 - C332) * V331 + SGN(C332 - C333) * V332 + SGN(C333 - C334) * V333 + SGN(C334 - C335) * V334 + SGN(C335 - C336) * V335 + SGN(C336 - C337) * V336 + SGN(C337 - C338) * V337 + SGN(C338 - C339) * V338 + SGN(C339 - C340) * V339 + SGN(C340 - C341) * V340 + SGN(C341 - C342) * V341 + SGN(C342 - C343) * V342 + SGN(C343 - C344) * V343 + SGN(C344 - C345) * V344 + SGN(C345 - C346) * V345 + SGN(C346 - C347) * V346 + SGN(C347 - C348) * V347 + SGN(C348 - C349) * V348 + SGN(C349 - C350) * V349 + SGN(C350 - C351) * V350 + SGN(C351 - C352) * V351 + SGN(C352 - C353) * V352 + SGN(C353 - C354) * V353 + SGN(C354 - C355) * V354 + SGN(C355 - C356) * V355 + SGN(C356 - C357) * V356 + SGN(C357 - C358) * V357 + SGN(C358 - C359) * V358 + SGN(C359 - C360) * V359 + SGN(C360 - C361) * V360 + SGN(C361 - C362) * V361 + SGN(C362 - C363) * V362 + SGN(C363 - C364) * V363 + SGN(C364 - C365) * V364 + SGN(C365 - C366) * V365 + SGN(C366 - C367) * V366 + SGN(C367 - C368) * V367 + SGN(C368 - C369) * V368 + SGN(C369 - C370) * V369 + SGN(C370 - C371) * V370 + SGN(C371 - C372) * V371 + SGN(C372 - C373) * V372 + SGN(C373 - C374) * V373 + SGN(C374 - C375) * V374 + SGN(C375 - C376) * V375 + SGN(C376 - C377) * V376 + SGN(C377 - C378) * V377 + SGN(C378 - C379) * V378 + SGN(C379 - C380) * V379 + SGN(C380 - C381) * V380 + SGN(C381 - C382) * V381 + SGN(C382 - C383) * V382 + SGN(C383 - C384) * V383 + SGN(C384 - C385) * V384 + SGN(C385 - C386) * V385 + SGN(C386 - C387) * V386 + SGN(C387 - C388) * V387 + SGN(C388 - C389) * V388 + SGN(C389 - C390) * V389 + SGN(C390 - C391) * V390 + SGN(C391 - C392) * V391 + SGN(C392 - C393) * V392 + SGN(C393 - C394) * V393 + SGN(C394 - C395) * V394 + SGN(C395 - C396) * V395 + SGN(C396 - C397) * V396 + SGN(C397 - C398) * V397 + SGN(C398 - C399) * V398 + SGN(C399 - C400) * V399 + SGN(C400 - C401) * V400 + SGN(C401 - C402) * V401 + SGN(C402 - C403) * V402 + SGN(C403 - C404) * V403 + SGN(C404 - C405) * V404 + SGN(C405 - C406) * V405 + SGN(C406 - C407) * V406 + SGN(C407 - C408) * V407 + SGN(C408 - C409) * V408 + SGN(C409 - C410) * V409 + SGN(C410 - C411) * V410 + SGN(C411 - C412) * V411 + SGN(C412 - C413) * V412 + SGN(C413 - C414) * V413 + SGN(C414 - C415) * V414 + SGN(C415 - C416) * V415 + SGN(C416 - C417) * V416 + SGN(C417 - C418) * V417 + SGN(C418 - C419) * V418 + SGN(C419 - C420) * V419 + SGN(C420 - C421) * V420 + SGN(C421 - C422) * V421 + SGN(C422 - C423) * V422 + SGN(C423 - C424) * V423 + SGN(C424 - C425) * V424 + SGN(C425 - C426) * V425 + SGN(C426 - C427) * V426 + SGN(C427 - C428) * V427 + SGN(C428 - C429) * V428 + SGN(C429 - C430) * V429 + SGN(C430 - C431) * V430 + SGN(C431 - C432) * V431 + SGN(C432 - C433) * V432 + SGN(C433 - C434) * V433 + SGN(C434 - C435) * V434 + SGN(C435 - C436) * V435 + SGN(C436 - C437) * V436 + SGN(C437 - C438) * V437 + SGN(C438 - C439) * V438 + SGN(C439 - C440) * V439 + SGN(C440 - C441) * V440 + SGN(C441 - C442) * V441 + SGN(C442 - C443) * V442 + SGN(C443 - C444) * V443 + SGN(C444 - C445) * V444 + SGN(C445 - C446) * V445 + SGN(C446 - C447) * V446 + SGN(C447 - C448) * V447 + SGN(C448 - C449) * V448 + SGN(C449 - C450) * V449 + SGN(C450 - C451) * V450 + SGN(C451 - C452) * V451 + SGN(C452 - C453) * V452 + SGN(C453 - C454) * V453 + SGN(C454 - C455) * V454 + SGN(C455 - C456) * V455 + SGN(C456 - C457) * V456 + SGN(C457 - C458) * V457 + SGN(C458 - C459) * V458 + SGN(C459 - C460) * V459 + SGN(C460 - C461) * V460 + SGN(C461 - C462) * V461 + SGN(C462 - C463) * V462 + SGN(C463 - C464) * V463 + SGN(C464 - C465) * V464 + SGN(C465 - C466) * V465 + SGN(C466 - C467) * V466 + SGN(C467 - C468) * V467 + SGN(C468 - C469) * V468 + SGN(C469 - C470) * V469 + SGN(C470 - C471) * V470 + SGN(C471 - C472) * V471 + SGN(C472 - C473) * V472 + SGN(C473 - C474) * V473 + SGN(C474 - C475) * V474 + SGN(C475 - C476) * V475 + SGN(C476 - C477) * V476 + SGN(C477 - C478) * V477 + SGN(C478 - C479) * V478 + SGN(C479 - C480) * V479 + SGN(C480 - C481) * V480 + SGN(C481 - C482) * V481 + SGN(C482 - C483) * V482 + SGN(C483 - C484) * V483 + SGN(C484 - C485) * V484 + SGN(C485 - C486) * V485 + SGN(C486 - C487) * V486 + SGN(C487 - C488) * V487 + SGN(C488 - C489) * V488 + SGN(C489 - C490) * V489 + SGN(C490 - C491) * V490 + SGN(C491 - C492) * V491 + SGN(C492 - C493) * V492 + SGN(C493 - C494) * V493 + SGN(C494 - C495) * V494 + SGN(C495 - C496) * V495 + SGN(C496 - C497) * V496 + SGN(C497 - C498) * V497 + SGN(C498 - C499) * V498 + SGN(C499 - C500) * V499 + SGN(C500 - C501) * V500 + SGN(C501 - C502) * V501 + SGN(C502 - C503) * V502 + SGN(C503 - C504) * V503 <= 0

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
dfst24a
Posted : Friday, April 16, 2010 9:53:44 PM
Registered User
Joined: 12/30/2004
Posts: 84
Thanks Bruce...I'll give it a go.  Much appreciated...

Jim
Bruce_L
Posted : Saturday, April 17, 2010 8:43:55 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome. I'd still recommend against this.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.