Platinum Customer
Joined: 3/31/2006 Posts: 3,207

Is thee a way in Telechart I can screen out stocks out of the Us stocks watch list that for majority of the last 5 years let say 75% their price was under $5 and their market cap was less than a 100 million?


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

I can't really think of a practical method. Market Capitalization is one of the built in Fundamental System Criteria, but TeleChart only has the most recent value (Blocks has historical values with Strategy Trader).
While it is theoretically possible to create a Personal Criteria Formula to find if Price was less than $5.00 for 75% of the time during the last 5Years, this would involve a formula that would need to test over 1200 Price points individually. It would be very long. It might even be too long to be practical (although I haven't actually tried writing it yet).
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 3/31/2006 Posts: 3,207

Bruce,
Forget it. My goal was to reduce the # of the stocks in the watch list because I have to use the Ranked weighted quarters you created rather than weighted quarters.
Maybe the value that matches a ranking of 75 or greater today is 5% but a year ago that value was 10% or 2 years ago it was 15% so since that changes I can't use weighted quarters and the value that matches 75 rank today I have to use the Ranking.
I have taken out all ETF's so it's down to little less than 6000 stocks and I was looking to see if I can remove most of the tiny little stocks that won't make much of a difference so I can make the list even smaller.
Do you have any suggestions?


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

The following Personal Criteria Formulas should return True for Symbols where Price was less than $5.00 for 75% of the time during the last 5Years:
Warning: Long Personal Criteria Formulas can dramatically increase the time it takes to update your PCFs.
ABS((C < 5) + (C1 < 5) + (C2 < 5) + (C3 < 5) + (C4 < 5) + (C5 < 5) + (C6 < 5) + (C7 < 5) + (C8 < 5) + (C9 < 5) + (C10 < 5) + (C11 < 5) + (C12 < 5) + (C13 < 5) + (C14 < 5) + (C15 < 5) + (C16 < 5) + (C17 < 5) + (C18 < 5) + (C19 < 5) + (C20 < 5) + (C21 < 5) + (C22 < 5) + (C23 < 5) + (C24 < 5) + (C25 < 5) + (C26 < 5) + (C27 < 5) + (C28 < 5) + (C29 < 5) + (C30 < 5) + (C31 < 5) + (C32 < 5) + (C33 < 5) + (C34 < 5) + (C35 < 5) + (C36 < 5) + (C37 < 5) + (C38 < 5) + (C39 < 5) + (C40 < 5) + (C41 < 5) + (C42 < 5) + (C43 < 5) + (C44 < 5) + (C45 < 5) + (C46 < 5) + (C47 < 5) + (C48 < 5) + (C49 < 5) + (C50 < 5) + (C51 < 5) + (C52 < 5) + (C53 < 5) + (C54 < 5) + (C55 < 5) + (C56 < 5) + (C57 < 5) + (C58 < 5) + (C59 < 5) + (C60 < 5) + (C61 < 5) + (C62 < 5) + (C63 < 5) + (C64 < 5) + (C65 < 5) + (C66 < 5) + (C67 < 5) + (C68 < 5) + (C69 < 5) + (C70 < 5) + (C71 < 5) + (C72 < 5) + (C73 < 5) + (C74 < 5) + (C75 < 5) + (C76 < 5) + (C77 < 5) + (C78 < 5) + (C79 < 5) + (C80 < 5) + (C81 < 5) + (C82 < 5) + (C83 < 5) + (C84 < 5) + (C85 < 5) + (C86 < 5) + (C87 < 5) + (C88 < 5) + (C89 < 5) + (C90 < 5) + (C91 < 5) + (C92 < 5) + (C93 < 5) + (C94 < 5) + (C95 < 5) + (C96 < 5) + (C97 < 5) + (C98 < 5) + (C99 < 5) + (C100 < 5) + (C101 < 5) + (C102 < 5) + (C103 < 5) + (C104 < 5) + (C105 < 5) + (C106 < 5) + (C107 < 5) + (C108 < 5) + (C109 < 5) + (C110 < 5) + (C111 < 5) + (C112 < 5) + (C113 < 5) + (C114 < 5) + (C115 < 5) + (C116 < 5) + (C117 < 5) + (C118 < 5) + (C119 < 5) + (C120 < 5) + (C121 < 5) + (C122 < 5) + (C123 < 5) + (C124 < 5) + (C125 < 5) + (C126 < 5) + (C127 < 5) + (C128 < 5) + (C129 < 5) + (C130 < 5) + (C131 < 5) + (C132 < 5) + (C133 < 5) + (C134 < 5) + (C135 < 5) + (C136 < 5) + (C137 < 5) + (C138 < 5) + (C139 < 5) + (C140 < 5) + (C141 < 5) + (C142 < 5) + (C143 < 5) + (C144 < 5) + (C145 < 5) + (C146 < 5) + (C147 < 5) + (C148 < 5) + (C149 < 5) + (C150 < 5) + (C151 < 5) + (C152 < 5) + (C153 < 5) + (C154 < 5) + (C155 < 5) + (C156 < 5) + (C157 < 5) + (C158 < 5) + (C159 < 5) + (C160 < 5) + (C161 < 5) + (C162 < 5) + (C163 < 5) + (C164 < 5) + (C165 < 5) + (C166 < 5) + (C167 < 5) + (C168 < 5) + (C169 < 5) + (C170 < 5) + (C171 < 5) + (C172 < 5) + (C173 < 5) + (C174 < 5) + (C175 < 5) + (C176 < 5) + (C177 < 5) + (C178 < 5) + (C179 < 5) + (C180 < 5) + (C181 < 5) + (C182 < 5) + (C183 < 5) + (C184 < 5) + (C185 < 5) + (C186 < 5) + (C187 < 5) + (C188 < 5) + (C189 < 5) + (C190 < 5) + (C191 < 5) + (C192 < 5) + (C193 < 5) + (C194 < 5) + (C195 < 5) + (C196 < 5) + (C197 < 5) + (C198 < 5) + (C199 < 5) + (C200 < 5) + (C201 < 5) + (C202 < 5) + (C203 < 5) + (C204 < 5) + (C205 < 5) + (C206 < 5) + (C207 < 5) + (C208 < 5) + (C209 < 5) + (C210 < 5) + (C211 < 5) + (C212 < 5) + (C213 < 5) + (C214 < 5) + (C215 < 5) + (C216 < 5) + (C217 < 5) + (C218 < 5) + (C219 < 5) + (C220 < 5) + (C221 < 5) + (C222 < 5) + (C223 < 5) + (C224 < 5) + (C225 < 5) + (C226 < 5) + (C227 < 5) + (C228 < 5) + (C229 < 5) + (C230 < 5) + (C231 < 5) + (C232 < 5) + (C233 < 5) + (C234 < 5) + (C235 < 5) + (C236 < 5) + (C237 < 5) + (C238 < 5) + (C239 < 5) + (C240 < 5) + (C241 < 5) + (C242 < 5) + (C243 < 5) + (C244 < 5) + (C245 < 5) + (C246 < 5) + (C247 < 5) + (C248 < 5) + (C249 < 5) + (C250 < 5) + (C251 < 5) + (C252 < 5) + (C253 < 5) + (C254 < 5) + (C255 < 5) + (C256 < 5) + (C257 < 5) + (C258 < 5) + (C259 < 5) + (C260 < 5) + (C261 < 5) + (C262 < 5) + (C263 < 5) + (C264 < 5) + (C265 < 5) + (C266 < 5) + (C267 < 5) + (C268 < 5) + (C269 < 5) + (C270 < 5) + (C271 < 5) + (C272 < 5) + (C273 < 5) + (C274 < 5) + (C275 < 5) + (C276 < 5) + (C277 < 5) + (C278 < 5) + (C279 < 5) + (C280 < 5) + (C281 < 5) + (C282 < 5) + (C283 < 5) + (C284 < 5) + (C285 < 5) + (C286 < 5) + (C287 < 5) + (C288 < 5) + (C289 < 5) + (C290 < 5) + (C291 < 5) + (C292 < 5) + (C293 < 5) + (C294 < 5) + (C295 < 5) + (C296 < 5) + (C297 < 5) + (C298 < 5) + (C299 < 5) + (C300 < 5) + (C301 < 5) + (C302 < 5) + (C303 < 5) + (C304 < 5) + (C305 < 5) + (C306 < 5) + (C307 < 5) + (C308 < 5) + (C309 < 5) + (C310 < 5) + (C311 < 5) + (C312 < 5) + (C313 < 5) + (C314 < 5) + (C315 < 5) + (C316 < 5) + (C317 < 5) + (C318 < 5) + (C319 < 5) + (C320 < 5) + (C321 < 5) + (C322 < 5) + (C323 < 5) + (C324 < 5) + (C325 < 5) + (C326 < 5) + (C327 < 5) + (C328 < 5) + (C329 < 5) + (C330 < 5) + (C331 < 5) + (C332 < 5) + (C333 < 5) + (C334 < 5) + (C335 < 5) + (C336 < 5) + (C337 < 5) + (C338 < 5) + (C339 < 5) + (C340 < 5) + (C341 < 5) + (C342 < 5) + (C343 < 5) + (C344 < 5) + (C345 < 5) + (C346 < 5) + (C347 < 5) + (C348 < 5) + (C349 < 5) + (C350 < 5) + (C351 < 5) + (C352 < 5) + (C353 < 5) + (C354 < 5) + (C355 < 5) + (C356 < 5) + (C357 < 5) + (C358 < 5) + (C359 < 5) + (C360 < 5) + (C361 < 5) + (C362 < 5) + (C363 < 5) + (C364 < 5) + (C365 < 5) + (C366 < 5) + (C367 < 5) + (C368 < 5) + (C369 < 5) + (C370 < 5) + (C371 < 5) + (C372 < 5) + (C373 < 5) + (C374 < 5) + (C375 < 5) + (C376 < 5) + (C377 < 5) + (C378 < 5) + (C379 < 5) + (C380 < 5) + (C381 < 5) + (C382 < 5) + (C383 < 5) + (C384 < 5) + (C385 < 5) + (C386 < 5) + (C387 < 5) + (C388 < 5) + (C389 < 5) + (C390 < 5) + (C391 < 5) + (C392 < 5) + (C393 < 5) + (C394 < 5) + (C395 < 5) + (C396 < 5) + (C397 < 5) + (C398 < 5) + (C399 < 5) + (C400 < 5) + (C401 < 5) + (C402 < 5) + (C403 < 5) + (C404 < 5) + (C405 < 5) + (C406 < 5) + (C407 < 5) + (C408 < 5) + (C409 < 5) + (C410 < 5) + (C411 < 5) + (C412 < 5) + (C413 < 5) + (C414 < 5) + (C415 < 5) + (C416 < 5) + (C417 < 5) + (C418 < 5) + (C419 < 5) + (C420 < 5) + (C421 < 5) + (C422 < 5) + (C423 < 5) + (C424 < 5) + (C425 < 5) + (C426 < 5) + (C427 < 5) + (C428 < 5) + (C429 < 5) + (C430 < 5) + (C431 < 5) + (C432 < 5) + (C433 < 5) + (C434 < 5) + (C435 < 5) + (C436 < 5) + (C437 < 5) + (C438 < 5) + (C439 < 5) + (C440 < 5) + (C441 < 5) + (C442 < 5) + (C443 < 5) + (C444 < 5) + (C445 < 5) + (C446 < 5) + (C447 < 5) + (C448 < 5) + (C449 < 5) + (C450 < 5) + (C451 < 5) + (C452 < 5) + (C453 < 5) + (C454 < 5) + (C455 < 5) + (C456 < 5) + (C457 < 5) + (C458 < 5) + (C459 < 5) + (C460 < 5) + (C461 < 5) + (C462 < 5) + (C463 < 5) + (C464 < 5) + (C465 < 5) + (C466 < 5) + (C467 < 5) + (C468 < 5) + (C469 < 5) + (C470 < 5) + (C471 < 5) + (C472 < 5) + (C473 < 5) + (C474 < 5) + (C475 < 5) + (C476 < 5) + (C477 < 5) + (C478 < 5) + (C479 < 5) + (C480 < 5) + (C481 < 5) + (C482 < 5) + (C483 < 5) + (C484 < 5) + (C485 < 5) + (C486 < 5) + (C487 < 5) + (C488 < 5) + (C489 < 5) + (C490 < 5) + (C491 < 5) + (C492 < 5) + (C493 < 5) + (C494 < 5) + (C495 < 5) + (C496 < 5) + (C497 < 5) + (C498 < 5) + (C499 < 5) + (C500 < 5) + (C501 < 5) + (C502 < 5) + (C503 < 5) + (C504 < 5) + (C505 < 5) + (C506 < 5) + (C507 < 5) + (C508 < 5) + (C509 < 5) + (C510 < 5) + (C511 < 5) + (C512 < 5) + (C513 < 5) + (C514 < 5) + (C515 < 5) + (C516 < 5) + (C517 < 5) + (C518 < 5) + (C519 < 5) + (C520 < 5) + (C521 < 5) + (C522 < 5) + (C523 < 5) + (C524 < 5) + (C525 < 5) + (C526 < 5) + (C527 < 5) + (C528 < 5) + (C529 < 5) + (C530 < 5) + (C531 < 5) + (C532 < 5) + (C533 < 5) + (C534 < 5) + (C535 < 5) + (C536 < 5) + (C537 < 5) + (C538 < 5) + (C539 < 5) + (C540 < 5) + (C541 < 5) + (C542 < 5) + (C543 < 5) + (C544 < 5) + (C545 < 5) + (C546 < 5) + (C547 < 5) + (C548 < 5) + (C549 < 5) + (C550 < 5) + (C551 < 5) + (C552 < 5) + (C553 < 5) + (C554 < 5) + (C555 < 5) + (C556 < 5) + (C557 < 5) + (C558 < 5) + (C559 < 5) + (C560 < 5) + (C561 < 5) + (C562 < 5) + (C563 < 5) + (C564 < 5) + (C565 < 5) + (C566 < 5) + (C567 < 5) + (C568 < 5) + (C569 < 5) + (C570 < 5) + (C571 < 5) + (C572 < 5) + (C573 < 5) + (C574 < 5) + (C575 < 5) + (C576 < 5) + (C577 < 5) + (C578 < 5) + (C579 < 5) + (C580 < 5) + (C581 < 5) + (C582 < 5) + (C583 < 5) + (C584 < 5) + (C585 < 5) + (C586 < 5) + (C587 < 5) + (C588 < 5) + (C589 < 5) + (C590 < 5) + (C591 < 5) + (C592 < 5) + (C593 < 5) + (C594 < 5) + (C595 < 5) + (C596 < 5) + (C597 < 5) + (C598 < 5) + (C599 < 5) + (C600 < 5) + (C601 < 5) + (C602 < 5) + (C603 < 5) + (C604 < 5) + (C605 < 5) + (C606 < 5) + (C607 < 5) + (C608 < 5) + (C609 < 5) + (C610 < 5) + (C611 < 5) + (C612 < 5) + (C613 < 5) + (C614 < 5) + (C615 < 5) + (C616 < 5) + (C617 < 5) + (C618 < 5) + (C619 < 5) + (C620 < 5) + (C621 < 5) + (C622 < 5) + (C623 < 5) + (C624 < 5) + (C625 < 5) + (C626 < 5) + (C627 < 5) + (C628 < 5) + (C629 < 5) + (C630 < 5) + (C631 < 5) + (C632 < 5) + (C633 < 5) + (C634 < 5) + (C635 < 5) + (C636 < 5) + (C637 < 5) + (C638 < 5) + (C639 < 5) + (C640 < 5) + (C641 < 5) + (C642 < 5) + (C643 < 5) + (C644 < 5) + (C645 < 5) + (C646 < 5) + (C647 < 5) + (C648 < 5) + (C649 < 5) + (C650 < 5) + (C651 < 5) + (C652 < 5) + (C653 < 5) + (C654 < 5) + (C655 < 5) + (C656 < 5) + (C657 < 5) + (C658 < 5) + (C659 < 5) + (C660 < 5) + (C661 < 5) + (C662 < 5) + (C663 < 5) + (C664 < 5) + (C665 < 5) + (C666 < 5) + (C667 < 5) + (C668 < 5) + (C669 < 5) + (C670 < 5) + (C671 < 5) + (C672 < 5) + (C673 < 5) + (C674 < 5) + (C675 < 5) + (C676 < 5) + (C677 < 5) + (C678 < 5) + (C679 < 5) + (C680 < 5) + (C681 < 5) + (C682 < 5) + (C683 < 5) + (C684 < 5) + (C685 < 5) + (C686 < 5) + (C687 < 5) + (C688 < 5) + (C689 < 5) + (C690 < 5) + (C691 < 5) + (C692 < 5) + (C693 < 5) + (C694 < 5) + (C695 < 5) + (C696 < 5) + (C697 < 5) + (C698 < 5) + (C699 < 5) + (C700 < 5) + (C701 < 5) + (C702 < 5) + (C703 < 5) + (C704 < 5) + (C705 < 5) + (C706 < 5) + (C707 < 5) + (C708 < 5) + (C709 < 5) + (C710 < 5) + (C711 < 5) + (C712 < 5) + (C713 < 5) + (C714 < 5) + (C715 < 5) + (C716 < 5) + (C717 < 5) + (C718 < 5) + (C719 < 5) + (C720 < 5) + (C721 < 5) + (C722 < 5) + (C723 < 5) + (C724 < 5) + (C725 < 5) + (C726 < 5) + (C727 < 5) + (C728 < 5) + (C729 < 5) + (C730 < 5) + (C731 < 5) + (C732 < 5) + (C733 < 5) + (C734 < 5) + (C735 < 5) + (C736 < 5) + (C737 < 5) + (C738 < 5) + (C739 < 5) + (C740 < 5) + (C741 < 5) + (C742 < 5) + (C743 < 5) + (C744 < 5) + (C745 < 5) + (C746 < 5) + (C747 < 5) + (C748 < 5) + (C749 < 5) + (C750 < 5) + (C751 < 5) + (C752 < 5) + (C753 < 5) + (C754 < 5) + (C755 < 5) + (C756 < 5) + (C757 < 5) + (C758 < 5) + (C759 < 5) + (C760 < 5) + (C761 < 5) + (C762 < 5) + (C763 < 5) + (C764 < 5) + (C765 < 5) + (C766 < 5) + (C767 < 5) + (C768 < 5) + (C769 < 5) + (C770 < 5) + (C771 < 5) + (C772 < 5) + (C773 < 5) + (C774 < 5) + (C775 < 5) + (C776 < 5) + (C777 < 5) + (C778 < 5) + (C779 < 5) + (C780 < 5) + (C781 < 5) + (C782 < 5) + (C783 < 5) + (C784 < 5) + (C785 < 5) + (C786 < 5) + (C787 < 5) + (C788 < 5) + (C789 < 5) + (C790 < 5) + (C791 < 5) + (C792 < 5) + (C793 < 5) + (C794 < 5) + (C795 < 5) + (C796 < 5) + (C797 < 5) + (C798 < 5) + (C799 < 5) + (C800 < 5) + (C801 < 5) + (C802 < 5) + (C803 < 5) + (C804 < 5) + (C805 < 5) + (C806 < 5) + (C807 < 5) + (C808 < 5) + (C809 < 5) + (C810 < 5) + (C811 < 5) + (C812 < 5) + (C813 < 5) + (C814 < 5) + (C815 < 5) + (C816 < 5) + (C817 < 5) + (C818 < 5) + (C819 < 5) + (C820 < 5) + (C821 < 5) + (C822 < 5) + (C823 < 5) + (C824 < 5) + (C825 < 5) + (C826 < 5) + (C827 < 5) + (C828 < 5) + (C829 < 5) + (C830 < 5) + (C831 < 5) + (C832 < 5) + (C833 < 5) + (C834 < 5) + (C835 < 5) + (C836 < 5) + (C837 < 5) + (C838 < 5) + (C839 < 5) + (C840 < 5) + (C841 < 5) + (C842 < 5) + (C843 < 5) + (C844 < 5) + (C845 < 5) + (C846 < 5) + (C847 < 5) + (C848 < 5) + (C849 < 5) + (C850 < 5) + (C851 < 5) + (C852 < 5) + (C853 < 5) + (C854 < 5) + (C855 < 5) + (C856 < 5) + (C857 < 5) + (C858 < 5) + (C859 < 5) + (C860 < 5) + (C861 < 5) + (C862 < 5) + (C863 < 5) + (C864 < 5) + (C865 < 5) + (C866 < 5) + (C867 < 5) + (C868 < 5) + (C869 < 5) + (C870 < 5) + (C871 < 5) + (C872 < 5) + (C873 < 5) + (C874 < 5) + (C875 < 5) + (C876 < 5) + (C877 < 5) + (C878 < 5) + (C879 < 5) + (C880 < 5) + (C881 < 5) + (C882 < 5) + (C883 < 5) + (C884 < 5) + (C885 < 5) + (C886 < 5) + (C887 < 5) + (C888 < 5) + (C889 < 5) + (C890 < 5) + (C891 < 5) + (C892 < 5) + (C893 < 5) + (C894 < 5) + (C895 < 5) + (C896 < 5) + (C897 < 5) + (C898 < 5) + (C899 < 5) + (C900 < 5) + (C901 < 5) + (C902 < 5) + (C903 < 5) + (C904 < 5) + (C905 < 5) + (C906 < 5) + (C907 < 5) + (C908 < 5) + (C909 < 5) + (C910 < 5) + (C911 < 5) + (C912 < 5) + (C913 < 5) + (C914 < 5) + (C915 < 5) + (C916 < 5) + (C917 < 5) + (C918 < 5) + (C919 < 5) + (C920 < 5) + (C921 < 5) + (C922 < 5) + (C923 < 5) + (C924 < 5) + (C925 < 5) + (C926 < 5) + (C927 < 5) + (C928 < 5) + (C929 < 5) + (C930 < 5) + (C931 < 5) + (C932 < 5) + (C933 < 5) + (C934 < 5) + (C935 < 5) + (C936 < 5) + (C937 < 5) + (C938 < 5) + (C939 < 5) + (C940 < 5) + (C941 < 5) + (C942 < 5) + (C943 < 5) + (C944 < 5) + (C945 < 5) + (C946 < 5) + (C947 < 5) + (C948 < 5) + (C949 < 5) + (C950 < 5) + (C951 < 5) + (C952 < 5) + (C953 < 5) + (C954 < 5) + (C955 < 5) + (C956 < 5) + (C957 < 5) + (C958 < 5) + (C959 < 5) + (C960 < 5) + (C961 < 5) + (C962 < 5) + (C963 < 5) + (C964 < 5) + (C965 < 5) + (C966 < 5) + (C967 < 5) + (C968 < 5) + (C969 < 5) + (C970 < 5) + (C971 < 5) + (C972 < 5) + (C973 < 5) + (C974 < 5) + (C975 < 5) + (C976 < 5) + (C977 < 5) + (C978 < 5) + (C979 < 5) + (C980 < 5) + (C981 < 5) + (C982 < 5) + (C983 < 5) + (C984 < 5) + (C985 < 5) + (C986 < 5) + (C987 < 5) + (C988 < 5) + (C989 < 5) + (C990 < 5) + (C991 < 5) + (C992 < 5) + (C993 < 5) + (C994 < 5) + (C995 < 5) + (C996 < 5) + (C997 < 5) + (C998 < 5) + (C999 < 5) + (C1000 < 5) + (C1001 < 5) + (C1002 < 5) + (C1003 < 5) + (C1004 < 5) + (C1005 < 5) + (C1006 < 5) + (C1007 < 5) + (C1008 < 5) + (C1009 < 5) + (C1010 < 5) + (C1011 < 5) + (C1012 < 5) + (C1013 < 5) + (C1014 < 5) + (C1015 < 5) + (C1016 < 5) + (C1017 < 5) + (C1018 < 5) + (C1019 < 5) + (C1020 < 5) + (C1021 < 5) + (C1022 < 5) + (C1023 < 5) + (C1024 < 5) + (C1025 < 5) + (C1026 < 5) + (C1027 < 5) + (C1028 < 5) + (C1029 < 5) + (C1030 < 5) + (C1031 < 5) + (C1032 < 5) + (C1033 < 5) + (C1034 < 5) + (C1035 < 5) + (C1036 < 5) + (C1037 < 5) + (C1038 < 5) + (C1039 < 5) + (C1040 < 5) + (C1041 < 5) + (C1042 < 5) + (C1043 < 5) + (C1044 < 5) + (C1045 < 5) + (C1046 < 5) + (C1047 < 5) + (C1048 < 5) + (C1049 < 5) + (C1050 < 5) + (C1051 < 5) + (C1052 < 5) + (C1053 < 5) + (C1054 < 5) + (C1055 < 5) + (C1056 < 5) + (C1057 < 5) + (C1058 < 5) + (C1059 < 5) + (C1060 < 5) + (C1061 < 5) + (C1062 < 5) + (C1063 < 5) + (C1064 < 5) + (C1065 < 5) + (C1066 < 5) + (C1067 < 5) + (C1068 < 5) + (C1069 < 5) + (C1070 < 5) + (C1071 < 5) + (C1072 < 5) + (C1073 < 5) + (C1074 < 5) + (C1075 < 5) + (C1076 < 5) + (C1077 < 5) + (C1078 < 5) + (C1079 < 5) + (C1080 < 5) + (C1081 < 5) + (C1082 < 5) + (C1083 < 5) + (C1084 < 5) + (C1085 < 5) + (C1086 < 5) + (C1087 < 5) + (C1088 < 5) + (C1089 < 5) + (C1090 < 5) + (C1091 < 5) + (C1092 < 5) + (C1093 < 5) + (C1094 < 5) + (C1095 < 5) + (C1096 < 5) + (C1097 < 5) + (C1098 < 5) + (C1099 < 5) + (C1100 < 5) + (C1101 < 5) + (C1102 < 5) + (C1103 < 5) + (C1104 < 5) + (C1105 < 5) + (C1106 < 5) + (C1107 < 5) + (C1108 < 5) + (C1109 < 5) + (C1110 < 5) + (C1111 < 5) + (C1112 < 5) + (C1113 < 5) + (C1114 < 5) + (C1115 < 5) + (C1116 < 5) + (C1117 < 5) + (C1118 < 5) + (C1119 < 5) + (C1120 < 5) + (C1121 < 5) + (C1122 < 5) + (C1123 < 5) + (C1124 < 5) + (C1125 < 5) + (C1126 < 5) + (C1127 < 5) + (C1128 < 5) + (C1129 < 5) + (C1130 < 5) + (C1131 < 5) + (C1132 < 5) + (C1133 < 5) + (C1134 < 5) + (C1135 < 5) + (C1136 < 5) + (C1137 < 5) + (C1138 < 5) + (C1139 < 5) + (C1140 < 5) + (C1141 < 5) + (C1142 < 5) + (C1143 < 5) + (C1144 < 5) + (C1145 < 5) + (C1146 < 5) + (C1147 < 5) + (C1148 < 5) + (C1149 < 5) + (C1150 < 5) + (C1151 < 5) + (C1152 < 5) + (C1153 < 5) + (C1154 < 5) + (C1155 < 5) + (C1156 < 5) + (C1157 < 5) + (C1158 < 5) + (C1159 < 5) + (C1160 < 5) + (C1161 < 5) + (C1162 < 5) + (C1163 < 5) + (C1164 < 5) + (C1165 < 5) + (C1166 < 5) + (C1167 < 5) + (C1168 < 5) + (C1169 < 5) + (C1170 < 5) + (C1171 < 5) + (C1172 < 5) + (C1173 < 5) + (C1174 < 5) + (C1175 < 5) + (C1176 < 5) + (C1177 < 5) + (C1178 < 5) + (C1179 < 5) + (C1180 < 5) + (C1181 < 5) + (C1182 < 5) + (C1183 < 5) + (C1184 < 5) + (C1185 < 5) + (C1186 < 5) + (C1187 < 5) + (C1188 < 5) + (C1189 < 5) + (C1190 < 5) + (C1191 < 5) + (C1192 < 5) + (C1193 < 5) + (C1194 < 5) + (C1195 < 5) + (C1196 < 5) + (C1197 < 5) + (C1198 < 5) + (C1199 < 5) + (C1200 < 5) + (C1201 < 5) + (C1202 < 5) + (C1203 < 5) + (C1204 < 5) + (C1205 < 5) + (C1206 < 5) + (C1207 < 5) + (C1208 < 5) + (C1209 < 5) + (C1210 < 5) + (C1211 < 5) + (C1212 < 5) + (C1213 < 5) + (C1214 < 5) + (C1215 < 5) + (C1216 < 5) + (C1217 < 5) + (C1218 < 5) + (C1219 < 5) + (C1220 < 5) + (C1221 < 5) + (C1222 < 5) + (C1223 < 5) + (C1224 < 5) + (C1225 < 5) + (C1226 < 5) + (C1227 < 5) + (C1228 < 5) + (C1229 < 5) + (C1230 < 5) + (C1231 < 5) + (C1232 < 5) + (C1233 < 5) + (C1234 < 5) + (C1235 < 5) + (C1236 < 5) + (C1237 < 5) + (C1238 < 5) + (C1239 < 5) + (C1240 < 5) + (C1241 < 5) + (C1242 < 5) + (C1243 < 5) + (C1244 < 5) + (C1245 < 5) + (C1246 < 5) + (C1247 < 5) + (C1248 < 5) + (C1249 < 5) + (C1250 < 5) + (C1251 < 5) + (C1252 < 5) + (C1253 < 5) + (C1254 < 5) + (C1255 < 5) + (C1256 < 5) + (C1257 < 5) + (C1258 < 5) + (C1259 < 5)) > 944
If you would like to try the same thing using Blocks instead, please download the attached .scond files to:
\My Documents\Blocks Files\Tool Parts\Strategy Conditions
Once downloaded, you should be able to select Add Condition  My Computer when adding a Strategy Condition to access them.
You can use QuickEdit to adjust the settings or view the Block Diagrams.
You will probably want to use it as a Scan Only Condition.Attachments: Price.scond  5 KB, downloaded 777 time(s).
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 3/31/2006 Posts: 3,207

Wow I can't believe you spend the time to write this. Thanks
let me ask you this does the Weighted quarters ranking take a long time because it has to rank the stocks or is it because of the way its weighted, last quarter 40% and the three quarters before that each with 20%?
Will it make it a lot better if we just rank them based on their 1 year performance without any weighting to any one quarter? Just list all stocks by 1 year performance and take the top 25% will this make it run easier?
I ran a test yesterday using the ranked weighted quarters, the start date was 1/1/2003 with almost 6000 stocks in my watch list it did finish the test in 6 hours, that I don't have a problem with but when I wanted to space bar through stocks it kept freezing.


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

It mostly takes a long time because it has to rank the stocks (it gets a lot worse as more symbols and history are used... in a way that far exceeds linear). It might make things a little quicker to rank them based just on their 1 year performance, but not much.
That said, I've created alternative versions that I'm hoping will work more quickly for you despite having Block Diagrams that are significantly more complex. Please download the attached .scond files to:
\My Documents\Blocks Files\Tool Parts\Strategy Conditions
Once downloaded, you should be able to select Add Condition  My Computer when adding a Strategy Condition to access them.
You can use QuickEdit to adjust the settings or view the Block Diagrams.
The descriptions are contained in my Thursday, October 11, 2007 7:13:43 PM ET post in fundamentals.Attachments: Industry Rank vs Industries.scond  6 KB, downloaded 767 time(s). Ranked Weighted PPC.scond  11 KB, downloaded 824 time(s). Ranked Weighted Quarters.scond  11 KB, downloaded 785 time(s). Sub Industry Rank (Avg Net).scond  7 KB, downloaded 788 time(s). Sub Industry Rank (unweighted).scond  7 KB, downloaded 781 time(s).
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 3/31/2006 Posts: 3,207

Bruce,
What do I need to do to these to be able to plot them as an indicator? It seems whatever you did to make it faster works can you do the same with the ones we can plot please?
Thanks


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

I can't think of any changes that could be made to decrease the time it takes to calculate the Plotted versions.
The new versions of the Strategy Conditions calculate a Value for the appropriate Rank at each point in time and then compares the Value calculated for the symbol to the Value calculated for the Rank. The old version calculated a Rank for each symbol. This optimization is not applicable to the Plots.
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 3/31/2006 Posts: 3,207

Howcome the EPS on GOOG or FSLR or I am assuming its on all IPO's doesn' show up for a year from when they went public.
on FSLR Percent revenue last qtr is there but not EPS % change. on GOOG it took a year from when it went public.
Ay reason for this?


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

EPS Percent Change (Latest Q)  The percentage change in earnings per share from the comparable quarter a year before. Timely stocks will usually have strong recent quarterly earnings to validate the annual earnings strength. This reads in percentage.
EPS Percent Change (2nd Q back)  The percentage change in earnings per share from the comparable quarter a year before.
EPS Percent Change (3rd Q back)  The percentage change in earnings per share from the comparable quarter a year before.
EPS Percent Change (4th Q back)  The percentage change in earnings per share from the comparable quarter a year before.
EPS Percent Change (Latest Yr)  The percentage change in earnings for the latest 4 quarters compared to the preceding 4 quarters. An appropriate criterion to include in many types of screens. Also a common criterion to sort by, with the best earners on top.
You may wish to review the following:
Definitions of all built in scanning and sorting criteria
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 3/31/2006 Posts: 3,207

Bruce I think you misunderstood my question.
Plot EPS % change latest qtr and percent change revenue latest qtr for GOOG, FSLR and TELOZ. these are just few examples.
TELOZ went public in 1995 but its EPS and sales % change started to plot in 2001.
FSLR came public little more than a year ago its percent change revenue has been plotted for the last 3 quarters but its EPS % change hasn't yet.
I am trying to see if there is a reason for this.
At first I thought it will take a year because it needs to compare it with the #'s from a year ago same quarter so it needs 1 year of data before it plots it but I don't think that's true because it plots the sales on FSLR how come it doesn't plot EPS, or on GOOG it went public in Sep of 04 the EPS and Sales started to plot in May of 05.
The problem this creates for me, I know FSLR sales and EPS % change is above 25% but since its not available in the system it won't meet all the buy conditions and the stock will never be traded but it's price appreciation is part of the buy and hold equity line that we compare every test to.
Can you find why it does this is it because the data is not available?


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

One thing to consider are that we do not have EPS history for as long a period as we have Price history.
Another thing to consider is that we cannot calculate an EPS % change if one or more of the EPS values used in the calculation is less than or equal to zero.
Also, an EPS % change for the most recent quarter would require at least 5 quarters of data. 1 Quarter back would require at least 6 quarters of data. 2 quarters back would require at least 7 quarters of data. 3 quarters back would require at least 8 quarters of data (as would EPS % change for an entire year).
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 3/31/2006 Posts: 3,207

Thanks I get it now.
Help me understand the equity lines please
The Buy and Hold, Buys equal amount of every single stock in your watch list and hold it until the end.
The Strategy equity line buys an equal amount of all stocks that meet your conditions. It assumes that an unlimited equity is available.
let say the system is using 10,000 per trade if ABC stock screens through today it will buy 10,000 worth and sells it two weeks later for whatever reason. If it screens through again two months later it will buy again 10,000 worth?
and it assumes that a 100% of your money line is always being invested?
By that I mean let say in the month of October my system held a 100 stocks and it gained 15% for the month but it the month of November my system held only 10 stocks and they lost an average of 15% so the Equity line will show a 15% gain in October and a 15% drop in November it doesn't take into account that 90% of your money line is in cash.
Am I correct on this?


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

QUOTE (thnkbigr) The Strategy equity line buys an equal amount of all stocks that meet your conditions. It assumes that an unlimited equity is available.
I apologize, but I don't have the slightest idea of what this sentence is supposed to mean.
QUOTE (thnkbigr) let say the system is using 10,000 per trade if ABC stock screens through today it will buy 10,000 worth and sells it two weeks later for whatever reason. If it screens through again two months later it will buy again 10,000 worth?
You start with a $100. If you have a position in at least one symbol, all of your equity is invested and equally divided between your positions.
QUOTE (thnkbigr) and it assumes that a 100% of your money line is always being invested?
That it does.
QUOTE (thnkbigr) By that I mean let say in the month of October my system held a 100 stocks and it gained 15% for the month but it the month of November my system held only 10 stocks and they lost an average of 15% so the Equity line will show a 15% gain in October and a 15% drop in November it doesn't take into account that 90% of your money line is in cash.
None of your money is in cash. If you had your money invested in 100 stocks one month and 10 stocks the next month, a higher percentage of your equity (ten times as much) will be invested in each stock during the second month than during the first month.
The equity line is not a money management system (which is on the todo list). You cannot gradually enter and exit symbols. You cannot assign different percentages to different symbols. You cannot specify a specific percentage to remain as cash.
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 3/31/2006 Posts: 3,207

thanks Bruce I get it


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

You're welcome.
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 3/31/2006 Posts: 3,207

Bruce take a look at the Price strategy you made for Blocks above to eliminate stocks that traded less than 5 for 75% of the tome in the last 5 years.
Now how do I screen out these stocks out of MY ALL STOCKS watch list?
My goal is to delete all of these stocks out the watch list before I run my tests so when you run a test the Buy and Hold equity line is not effected by any of these stocks.
I need to create an another watch list from MY ALL STOCKS list without these small thinly traded stocks?


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

Frankly I would use its reverse for this purpose:
 Price: Bar Close (Last)
 is: Greater Than Value
 Value: 5
 Override TimeFrame: 1 Day
 # Bars True: 945
 Bars to Test: 1260
Test Strategy for Entire WatchList (with your MY ALL STOCKS Watchlist active) using a Scan Only Strategy and rightclick on the Strategy  Results tab to bring up the context sensitive menu. Select Add to Another List  All Symbols  (New List).
It should probably be noted that a low price does not necessarily mean a thinly traded stock.
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 3/31/2006 Posts: 3,207

How do I do a Scan only test?


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

Select Strategy  Conditions  Scan Only.
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 3/31/2006 Posts: 3,207

I saw it I have to check scan only before testing the strategy.
You said I need to right click on the strategy results tab to bring up the context sensetive menu nothing comes up when I right click.


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

My mistake, you need to actually rightclick on the WatchList itself (where the stocks are listed) not the Tab (but the Tab needs to be selected first so it is displaying the current Strategy Results).
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 3/31/2006 Posts: 3,207

How do I see how many stocks are in the new list?
I like to do the same thing for Volume in dollars and market cap. I tried to do it my self using the Blocks diagarm that you created for price but it seems litlle too complicated.
For market cap don't I have to replace the Price 1 day block with capitalization and change greater than value of 5 to 100 so it scans out all stocks that their market cap was less than a 100 million for 75% of the last 5 years?


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

For Market Capitalization, just add the Hemscott Financials  Criteria Raw History Value Strategy Condition. One thing to keep in mind is that it is a Weekly indicator, so you'll want to set # Bars True to 195 and Bars to Test to 260.
Please download the attached .scond file to:
\My Documents\Blocks Files\Tool Parts\Strategy Conditions
Once downloaded, you should be able to select Add Condition  My Computer when adding a Strategy Condition to access it.
You can use QuickEdit to adjust the settings or view the Block Diagram.Attachments: Volume Dollars.scond  6 KB, downloaded 732 time(s).
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 3/31/2006 Posts: 3,207

How do I see how many stocks are in the new list?


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

You may wish to review the following:
Count items in watchlist
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 3/31/2006 Posts: 3,207

Bruce, I saved the WARD1 workspace and i see the items # up there but how can I save this so I can add it to any workspace I am working on rather than opening another workspace to see the items #.
When you right click on it there is no save option and nothing happens when you left click.


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

One of the options available when you rightclick should be Properties. If you select this, it should bring up the Block Diagram. You can hold down ctrl and leftclick and drag to highlight the Blocks in the Block Diagram. Once they are highlighted (the box will disappear, but the Blocks should have little squares along the edges), you can rightclick and copy the Blocks in the Block Diagram.
You can rightclick on a Pane in your other Workspace and select Patch Panels  Add Patch Panel  Whole Number. Rightclicking on this new Patch Panel and selecting Properties will bring up its Block Diagram. You should then be able to paste the desired Blocks into the Block Diagram. Make sure all of the Blocks are connected the same way there were in the other Workspace (the Whole Number Block will almost certainly need to be connected for example) and you should get your display.
Bruce Personal Criteria Formulas TC2000 Support Articles


Platinum Customer
Joined: 3/31/2006 Posts: 3,207

I want to create a column with Volume dollars so I can sort my lists.
I created a new numeric column if I copy and paste the plot version on the Volume dollars block to create a column version will it work or is it different?


Worden Trainer
Joined: 10/7/2004 Posts: 65,138

It is pretty much the same, but you would need to run the output through a Last Value in Series or Value for Date Block since you want only one number instead of series of numbers. Please save the following .SGCol file in:
\My Documents\Blocks Files\Tool Parts\Columns
Once there, you can add a column by rightclicking the tab header of the WatchList, choosing load column then My Computer.
You can use QuickEdit to change the settings or view the Block Diagram.Attachments: Volume Dollars.SGCol  5 KB, downloaded 709 time(s).
Bruce Personal Criteria Formulas TC2000 Support Articles


Guest1 