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

ROC Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
gbstax
Posted : Monday, October 19, 2009 9:30:27 PM
Registered User
Joined: 5/22/2006
Posts: 20

Is there a way to scan for stock that have a 6 day ROC that is at the bottom or at the top

Bruce_L
Posted : Tuesday, October 20, 2009 7:25:14 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
If you are looking for the ROC of the symbol to be at the top or bottom of the list of symbols, you could create the following Personal Criteria Formula and using at as an EasyScan Condition set to Rank: ? to Max to get the highest values or Rank: Min to ? to get the lowest values:

How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria

C - C6

If you are looking for the ROC being at the top of the Chart, the formula would depend on the Zoom of the Chart. Some of the shorter examples follow:

Zoom 9 (20 Bars):

C - C6 >= C1 - C7 AND C - C6 >= C2 - C8 AND C - C6 >= C3 - C9 AND C - C6 >= C4 - C10 AND C - C6 >= C5 - C11 AND C - C6 >= C6 - C12 AND C - C6 >= C7 - C13 AND C - C6 >= C8 - C14 AND C - C6 >= C9 - C15 AND C - C6 >= C10 - C16 AND C - C6 >= C11 - C17 AND C - C6 >= C12 - C18 AND C - C6 >= C13 - C19 AND C - C6 >= C14 - C20 AND C - C6 >= C15 - C21 AND C - C6 >= C16 - C22 AND C - C6 >= C17 - C23 AND C - C6 >= C18 - C24 AND C - C6 >= C19 - C25

Zoom 8 (29 Bars):

C - C6 >= C1 - C7 AND C - C6 >= C2 - C8 AND C - C6 >= C3 - C9 AND C - C6 >= C4 - C10 AND C - C6 >= C5 - C11 AND C - C6 >= C6 - C12 AND C - C6 >= C7 - C13 AND C - C6 >= C8 - C14 AND C - C6 >= C9 - C15 AND C - C6 >= C10 - C16 AND C - C6 >= C11 - C17 AND C - C6 >= C12 - C18 AND C - C6 >= C13 - C19 AND C - C6 >= C14 - C20 AND C - C6 >= C15 - C21 AND C - C6 >= C16 - C22 AND C - C6 >= C17 - C23 AND C - C6 >= C18 - C24 AND C - C6 >= C19 - C25 AND C - C6 >= C20 - C26 AND C - C6 >= C21 - C27 AND C - C6 >= C22 - C28 AND C - C6 >= C23 - C29 AND C - C6 >= C24 - C30 AND C - C6 >= C25 - C31 AND C - C6 >= C26 - C32 AND C - C6 >= C27 - C33 AND C - C6 >= C28 - C34

Zoom 7 (44 Bars):

C - C6 >= C1 - C7 AND C - C6 >= C2 - C8 AND C - C6 >= C3 - C9 AND C - C6 >= C4 - C10 AND C - C6 >= C5 - C11 AND C - C6 >= C6 - C12 AND C - C6 >= C7 - C13 AND C - C6 >= C8 - C14 AND C - C6 >= C9 - C15 AND C - C6 >= C10 - C16 AND C - C6 >= C11 - C17 AND C - C6 >= C12 - C18 AND C - C6 >= C13 - C19 AND C - C6 >= C14 - C20 AND C - C6 >= C15 - C21 AND C - C6 >= C16 - C22 AND C - C6 >= C17 - C23 AND C - C6 >= C18 - C24 AND C - C6 >= C19 - C25 AND C - C6 >= C20 - C26 AND C - C6 >= C21 - C27 AND C - C6 >= C22 - C28 AND C - C6 >= C23 - C29 AND C - C6 >= C24 - C30 AND C - C6 >= C25 - C31 AND C - C6 >= C26 - C32 AND C - C6 >= C27 - C33 AND C - C6 >= C28 - C34 AND C - C6 >= C29 - C35 AND C - C6 >= C30 - C36 AND C - C6 >= C31 - C37 AND C - C6 >= C32 - C38 AND C - C6 >= C33 - C39 AND C - C6 >= C34 - C40 AND C - C6 >= C35 - C41 AND C - C6 >= C36 - C42 AND C - C6 >= C37 - C43 AND C - C6 >= C38 - C44 AND C - C6 >= C39 - C45 AND C - C6 >= C40 - C46 AND C - C6 >= C41 - C47 AND C - C6 >= C42 - C48 AND C - C6 >= C43 - C49

Zoom 6 (66 Bars):

C - C6 >= C1 - C7 AND C - C6 >= C2 - C8 AND C - C6 >= C3 - C9 AND C - C6 >= C4 - C10 AND C - C6 >= C5 - C11 AND C - C6 >= C6 - C12 AND C - C6 >= C7 - C13 AND C - C6 >= C8 - C14 AND C - C6 >= C9 - C15 AND C - C6 >= C10 - C16 AND C - C6 >= C11 - C17 AND C - C6 >= C12 - C18 AND C - C6 >= C13 - C19 AND C - C6 >= C14 - C20 AND C - C6 >= C15 - C21 AND C - C6 >= C16 - C22 AND C - C6 >= C17 - C23 AND C - C6 >= C18 - C24 AND C - C6 >= C19 - C25 AND C - C6 >= C20 - C26 AND C - C6 >= C21 - C27 AND C - C6 >= C22 - C28 AND C - C6 >= C23 - C29 AND C - C6 >= C24 - C30 AND C - C6 >= C25 - C31 AND C - C6 >= C26 - C32 AND C - C6 >= C27 - C33 AND C - C6 >= C28 - C34 AND C - C6 >= C29 - C35 AND C - C6 >= C30 - C36 AND C - C6 >= C31 - C37 AND C - C6 >= C32 - C38 AND C - C6 >= C33 - C39 AND C - C6 >= C34 - C40 AND C - C6 >= C35 - C41 AND C - C6 >= C36 - C42 AND C - C6 >= C37 - C43 AND C - C6 >= C38 - C44 AND C - C6 >= C39 - C45 AND C - C6 >= C40 - C46 AND C - C6 >= C41 - C47 AND C - C6 >= C42 - C48 AND C - C6 >= C43 - C49 AND C - C6 >= C44 - C50 AND C - C6 >= C45 - C51 AND C - C6 >= C46 - C52 AND C - C6 >= C47 - C53 AND C - C6 >= C48 - C54 AND C - C6 >= C49 - C55 AND C - C6 >= C50 - C56 AND C - C6 >= C51 - C57 AND C - C6 >= C52 - C58 AND C - C6 >= C53 - C59 AND C - C6 >= C54 - C60 AND C - C6 >= C55 - C61 AND C - C6 >= C56 - C62 AND C - C6 >= C57 - C63 AND C - C6 >= C58 - C64 AND C - C6 >= C59 - C65 AND C - C6 >= C60 - C66 AND C - C6 >= C61 - C67 AND C - C6 >= C62 - C68 AND C - C6 >= C63 - C69 AND C - C6 >= C64 - C70 AND C - C6 >= C65 - C71

Zoom 5 (99 Bars):

C - C6 >= C1 - C7 AND C - C6 >= C2 - C8 AND C - C6 >= C3 - C9 AND C - C6 >= C4 - C10 AND C - C6 >= C5 - C11 AND C - C6 >= C6 - C12 AND C - C6 >= C7 - C13 AND C - C6 >= C8 - C14 AND C - C6 >= C9 - C15 AND C - C6 >= C10 - C16 AND C - C6 >= C11 - C17 AND C - C6 >= C12 - C18 AND C - C6 >= C13 - C19 AND C - C6 >= C14 - C20 AND C - C6 >= C15 - C21 AND C - C6 >= C16 - C22 AND C - C6 >= C17 - C23 AND C - C6 >= C18 - C24 AND C - C6 >= C19 - C25 AND C - C6 >= C20 - C26 AND C - C6 >= C21 - C27 AND C - C6 >= C22 - C28 AND C - C6 >= C23 - C29 AND C - C6 >= C24 - C30 AND C - C6 >= C25 - C31 AND C - C6 >= C26 - C32 AND C - C6 >= C27 - C33 AND C - C6 >= C28 - C34 AND C - C6 >= C29 - C35 AND C - C6 >= C30 - C36 AND C - C6 >= C31 - C37 AND C - C6 >= C32 - C38 AND C - C6 >= C33 - C39 AND C - C6 >= C34 - C40 AND C - C6 >= C35 - C41 AND C - C6 >= C36 - C42 AND C - C6 >= C37 - C43 AND C - C6 >= C38 - C44 AND C - C6 >= C39 - C45 AND C - C6 >= C40 - C46 AND C - C6 >= C41 - C47 AND C - C6 >= C42 - C48 AND C - C6 >= C43 - C49 AND C - C6 >= C44 - C50 AND C - C6 >= C45 - C51 AND C - C6 >= C46 - C52 AND C - C6 >= C47 - C53 AND C - C6 >= C48 - C54 AND C - C6 >= C49 - C55 AND C - C6 >= C50 - C56 AND C - C6 >= C51 - C57 AND C - C6 >= C52 - C58 AND C - C6 >= C53 - C59 AND C - C6 >= C54 - C60 AND C - C6 >= C55 - C61 AND C - C6 >= C56 - C62 AND C - C6 >= C57 - C63 AND C - C6 >= C58 - C64 AND C - C6 >= C59 - C65 AND C - C6 >= C60 - C66 AND C - C6 >= C61 - C67 AND C - C6 >= C62 - C68 AND C - C6 >= C63 - C69 AND C - C6 >= C64 - C70 AND C - C6 >= C65 - C71 AND C - C6 >= C66 - C72 AND C - C6 >= C67 - C73 AND C - C6 >= C68 - C74 AND C - C6 >= C69 - C75 AND C - C6 >= C70 - C76 AND C - C6 >= C71 - C77 AND C - C6 >= C72 - C78 AND C - C6 >= C73 - C79 AND C - C6 >= C74 - C80 AND C - C6 >= C75 - C81 AND C - C6 >= C76 - C82 AND C - C6 >= C77 - C83 AND C - C6 >= C78 - C84 AND C - C6 >= C79 - C85 AND C - C6 >= C80 - C86 AND C - C6 >= C81 - C87 AND C - C6 >= C82 - C88 AND C - C6 >= C83 - C89 AND C - C6 >= C84 - C90 AND C - C6 >= C85 - C91 AND C - C6 >= C86 - C92 AND C - C6 >= C87 - C93 AND C - C6 >= C88 - C94 AND C - C6 >= C89 - C95 AND C - C6 >= C90 - C96 AND C - C6 >= C91 - C97 AND C - C6 >= C92 - C98 AND C - C6 >= C93 - C99 AND C - C6 >= C94 - C100 AND C - C6 >= C95 - C101 AND C - C6 >= C96 - C102 AND C - C6 >= C97 - C103 AND C - C6 >= C98 - C104

If you are looking for the ROC being at the bottom of the Chart, the formula would depend on the Zoom of the Chart. Some of the shorter examples follow:

Zoom 9 (20 Bars):

C - C6 <= C1 - C7 AND C - C6 <= C2 - C8 AND C - C6 <= C3 - C9 AND C - C6 <= C4 - C10 AND C - C6 <= C5 - C11 AND C - C6 <= C6 - C12 AND C - C6 <= C7 - C13 AND C - C6 <= C8 - C14 AND C - C6 <= C9 - C15 AND C - C6 <= C10 - C16 AND C - C6 <= C11 - C17 AND C - C6 <= C12 - C18 AND C - C6 <= C13 - C19 AND C - C6 <= C14 - C20 AND C - C6 <= C15 - C21 AND C - C6 <= C16 - C22 AND C - C6 <= C17 - C23 AND C - C6 <= C18 - C24 AND C - C6 <= C19 - C25

Zoom 8 (29 Bars):

C - C6 <= C1 - C7 AND C - C6 <= C2 - C8 AND C - C6 <= C3 - C9 AND C - C6 <= C4 - C10 AND C - C6 <= C5 - C11 AND C - C6 <= C6 - C12 AND C - C6 <= C7 - C13 AND C - C6 <= C8 - C14 AND C - C6 <= C9 - C15 AND C - C6 <= C10 - C16 AND C - C6 <= C11 - C17 AND C - C6 <= C12 - C18 AND C - C6 <= C13 - C19 AND C - C6 <= C14 - C20 AND C - C6 <= C15 - C21 AND C - C6 <= C16 - C22 AND C - C6 <= C17 - C23 AND C - C6 <= C18 - C24 AND C - C6 <= C19 - C25 AND C - C6 <= C20 - C26 AND C - C6 <= C21 - C27 AND C - C6 <= C22 - C28 AND C - C6 <= C23 - C29 AND C - C6 <= C24 - C30 AND C - C6 <= C25 - C31 AND C - C6 <= C26 - C32 AND C - C6 <= C27 - C33 AND C - C6 <= C28 - C34

Zoom 7 (44 Bars):

C - C6 <= C1 - C7 AND C - C6 <= C2 - C8 AND C - C6 <= C3 - C9 AND C - C6 <= C4 - C10 AND C - C6 <= C5 - C11 AND C - C6 <= C6 - C12 AND C - C6 <= C7 - C13 AND C - C6 <= C8 - C14 AND C - C6 <= C9 - C15 AND C - C6 <= C10 - C16 AND C - C6 <= C11 - C17 AND C - C6 <= C12 - C18 AND C - C6 <= C13 - C19 AND C - C6 <= C14 - C20 AND C - C6 <= C15 - C21 AND C - C6 <= C16 - C22 AND C - C6 <= C17 - C23 AND C - C6 <= C18 - C24 AND C - C6 <= C19 - C25 AND C - C6 <= C20 - C26 AND C - C6 <= C21 - C27 AND C - C6 <= C22 - C28 AND C - C6 <= C23 - C29 AND C - C6 <= C24 - C30 AND C - C6 <= C25 - C31 AND C - C6 <= C26 - C32 AND C - C6 <= C27 - C33 AND C - C6 <= C28 - C34 AND C - C6 <= C29 - C35 AND C - C6 <= C30 - C36 AND C - C6 <= C31 - C37 AND C - C6 <= C32 - C38 AND C - C6 <= C33 - C39 AND C - C6 <= C34 - C40 AND C - C6 <= C35 - C41 AND C - C6 <= C36 - C42 AND C - C6 <= C37 - C43 AND C - C6 <= C38 - C44 AND C - C6 <= C39 - C45 AND C - C6 <= C40 - C46 AND C - C6 <= C41 - C47 AND C - C6 <= C42 - C48 AND C - C6 <= C43 - C49

Zoom 6 (66 Bars):

C - C6 <= C1 - C7 AND C - C6 <= C2 - C8 AND C - C6 <= C3 - C9 AND C - C6 <= C4 - C10 AND C - C6 <= C5 - C11 AND C - C6 <= C6 - C12 AND C - C6 <= C7 - C13 AND C - C6 <= C8 - C14 AND C - C6 <= C9 - C15 AND C - C6 <= C10 - C16 AND C - C6 <= C11 - C17 AND C - C6 <= C12 - C18 AND C - C6 <= C13 - C19 AND C - C6 <= C14 - C20 AND C - C6 <= C15 - C21 AND C - C6 <= C16 - C22 AND C - C6 <= C17 - C23 AND C - C6 <= C18 - C24 AND C - C6 <= C19 - C25 AND C - C6 <= C20 - C26 AND C - C6 <= C21 - C27 AND C - C6 <= C22 - C28 AND C - C6 <= C23 - C29 AND C - C6 <= C24 - C30 AND C - C6 <= C25 - C31 AND C - C6 <= C26 - C32 AND C - C6 <= C27 - C33 AND C - C6 <= C28 - C34 AND C - C6 <= C29 - C35 AND C - C6 <= C30 - C36 AND C - C6 <= C31 - C37 AND C - C6 <= C32 - C38 AND C - C6 <= C33 - C39 AND C - C6 <= C34 - C40 AND C - C6 <= C35 - C41 AND C - C6 <= C36 - C42 AND C - C6 <= C37 - C43 AND C - C6 <= C38 - C44 AND C - C6 <= C39 - C45 AND C - C6 <= C40 - C46 AND C - C6 <= C41 - C47 AND C - C6 <= C42 - C48 AND C - C6 <= C43 - C49 AND C - C6 <= C44 - C50 AND C - C6 <= C45 - C51 AND C - C6 <= C46 - C52 AND C - C6 <= C47 - C53 AND C - C6 <= C48 - C54 AND C - C6 <= C49 - C55 AND C - C6 <= C50 - C56 AND C - C6 <= C51 - C57 AND C - C6 <= C52 - C58 AND C - C6 <= C53 - C59 AND C - C6 <= C54 - C60 AND C - C6 <= C55 - C61 AND C - C6 <= C56 - C62 AND C - C6 <= C57 - C63 AND C - C6 <= C58 - C64 AND C - C6 <= C59 - C65 AND C - C6 <= C60 - C66 AND C - C6 <= C61 - C67 AND C - C6 <= C62 - C68 AND C - C6 <= C63 - C69 AND C - C6 <= C64 - C70 AND C - C6 <= C65 - C71

Zoom 5 (99 Bars):

C - C6 <= C1 - C7 AND C - C6 <= C2 - C8 AND C - C6 <= C3 - C9 AND C - C6 <= C4 - C10 AND C - C6 <= C5 - C11 AND C - C6 <= C6 - C12 AND C - C6 <= C7 - C13 AND C - C6 <= C8 - C14 AND C - C6 <= C9 - C15 AND C - C6 <= C10 - C16 AND C - C6 <= C11 - C17 AND C - C6 <= C12 - C18 AND C - C6 <= C13 - C19 AND C - C6 <= C14 - C20 AND C - C6 <= C15 - C21 AND C - C6 <= C16 - C22 AND C - C6 <= C17 - C23 AND C - C6 <= C18 - C24 AND C - C6 <= C19 - C25 AND C - C6 <= C20 - C26 AND C - C6 <= C21 - C27 AND C - C6 <= C22 - C28 AND C - C6 <= C23 - C29 AND C - C6 <= C24 - C30 AND C - C6 <= C25 - C31 AND C - C6 <= C26 - C32 AND C - C6 <= C27 - C33 AND C - C6 <= C28 - C34 AND C - C6 <= C29 - C35 AND C - C6 <= C30 - C36 AND C - C6 <= C31 - C37 AND C - C6 <= C32 - C38 AND C - C6 <= C33 - C39 AND C - C6 <= C34 - C40 AND C - C6 <= C35 - C41 AND C - C6 <= C36 - C42 AND C - C6 <= C37 - C43 AND C - C6 <= C38 - C44 AND C - C6 <= C39 - C45 AND C - C6 <= C40 - C46 AND C - C6 <= C41 - C47 AND C - C6 <= C42 - C48 AND C - C6 <= C43 - C49 AND C - C6 <= C44 - C50 AND C - C6 <= C45 - C51 AND C - C6 <= C46 - C52 AND C - C6 <= C47 - C53 AND C - C6 <= C48 - C54 AND C - C6 <= C49 - C55 AND C - C6 <= C50 - C56 AND C - C6 <= C51 - C57 AND C - C6 <= C52 - C58 AND C - C6 <= C53 - C59 AND C - C6 <= C54 - C60 AND C - C6 <= C55 - C61 AND C - C6 <= C56 - C62 AND C - C6 <= C57 - C63 AND C - C6 <= C58 - C64 AND C - C6 <= C59 - C65 AND C - C6 <= C60 - C66 AND C - C6 <= C61 - C67 AND C - C6 <= C62 - C68 AND C - C6 <= C63 - C69 AND C - C6 <= C64 - C70 AND C - C6 <= C65 - C71 AND C - C6 <= C66 - C72 AND C - C6 <= C67 - C73 AND C - C6 <= C68 - C74 AND C - C6 <= C69 - C75 AND C - C6 <= C70 - C76 AND C - C6 <= C71 - C77 AND C - C6 <= C72 - C78 AND C - C6 <= C73 - C79 AND C - C6 <= C74 - C80 AND C - C6 <= C75 - C81 AND C - C6 <= C76 - C82 AND C - C6 <= C77 - C83 AND C - C6 <= C78 - C84 AND C - C6 <= C79 - C85 AND C - C6 <= C80 - C86 AND C - C6 <= C81 - C87 AND C - C6 <= C82 - C88 AND C - C6 <= C83 - C89 AND C - C6 <= C84 - C90 AND C - C6 <= C85 - C91 AND C - C6 <= C86 - C92 AND C - C6 <= C87 - C93 AND C - C6 <= C88 - C94 AND C - C6 <= C89 - C95 AND C - C6 <= C90 - C96 AND C - C6 <= C91 - C97 AND C - C6 <= C92 - C98 AND C - C6 <= C93 - C99 AND C - C6 <= C94 - C100 AND C - C6 <= C95 - C101 AND C - C6 <= C96 - C102 AND C - C6 <= C97 - C103 AND C - C6 <= C98 - C104

Another option would be to use Visual Indicator Sorting:

Sort by Visual Value to find new highs and lows in price and indicators

-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.