Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 12/30/2004 Posts: 84
|
Good evening,
what would the pcf be that would produce any stocks greater than $ 10 that increased greater than 20% in any given day in the last 12 months (250 trading days)?
thank you
Jim
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following:
C > 10 AND (C > 1.2 * C1 OR C1 > 1.2 * C2 OR C2 > 1.2 * C3 OR C3 > 1.2 * C4 OR C4 > 1.2 * C5 OR C5 > 1.2 * C6 OR C6 > 1.2 * C7 OR C7 > 1.2 * C8 OR C8 > 1.2 * C9 OR C9 > 1.2 * C10 OR C10 > 1.2 * C11 OR C11 > 1.2 * C12 OR C12 > 1.2 * C13 OR C13 > 1.2 * C14 OR C14 > 1.2 * C15 OR C15 > 1.2 * C16 OR C16 > 1.2 * C17 OR C17 > 1.2 * C18 OR C18 > 1.2 * C19 OR C19 > 1.2 * C20 OR C20 > 1.2 * C21 OR C21 > 1.2 * C22 OR C22 > 1.2 * C23 OR C23 > 1.2 * C24 OR C24 > 1.2 * C25 OR C25 > 1.2 * C26 OR C26 > 1.2 * C27 OR C27 > 1.2 * C28 OR C28 > 1.2 * C29 OR C29 > 1.2 * C30 OR C30 > 1.2 * C31 OR C31 > 1.2 * C32 OR C32 > 1.2 * C33 OR C33 > 1.2 * C34 OR C34 > 1.2 * C35 OR C35 > 1.2 * C36 OR C36 > 1.2 * C37 OR C37 > 1.2 * C38 OR C38 > 1.2 * C39 OR C39 > 1.2 * C40 OR C40 > 1.2 * C41 OR C41 > 1.2 * C42 OR C42 > 1.2 * C43 OR C43 > 1.2 * C44 OR C44 > 1.2 * C45 OR C45 > 1.2 * C46 OR C46 > 1.2 * C47 OR C47 > 1.2 * C48 OR C48 > 1.2 * C49 OR C49 > 1.2 * C50 OR C50 > 1.2 * C51 OR C51 > 1.2 * C52 OR C52 > 1.2 * C53 OR C53 > 1.2 * C54 OR C54 > 1.2 * C55 OR C55 > 1.2 * C56 OR C56 > 1.2 * C57 OR C57 > 1.2 * C58 OR C58 > 1.2 * C59 OR C59 > 1.2 * C60 OR C60 > 1.2 * C61 OR C61 > 1.2 * C62 OR C62 > 1.2 * C63 OR C63 > 1.2 * C64 OR C64 > 1.2 * C65 OR C65 > 1.2 * C66 OR C66 > 1.2 * C67 OR C67 > 1.2 * C68 OR C68 > 1.2 * C69 OR C69 > 1.2 * C70 OR C70 > 1.2 * C71 OR C71 > 1.2 * C72 OR C72 > 1.2 * C73 OR C73 > 1.2 * C74 OR C74 > 1.2 * C75 OR C75 > 1.2 * C76 OR C76 > 1.2 * C77 OR C77 > 1.2 * C78 OR C78 > 1.2 * C79 OR C79 > 1.2 * C80 OR C80 > 1.2 * C81 OR C81 > 1.2 * C82 OR C82 > 1.2 * C83 OR C83 > 1.2 * C84 OR C84 > 1.2 * C85 OR C85 > 1.2 * C86 OR C86 > 1.2 * C87 OR C87 > 1.2 * C88 OR C88 > 1.2 * C89 OR C89 > 1.2 * C90 OR C90 > 1.2 * C91 OR C91 > 1.2 * C92 OR C92 > 1.2 * C93 OR C93 > 1.2 * C94 OR C94 > 1.2 * C95 OR C95 > 1.2 * C96 OR C96 > 1.2 * C97 OR C97 > 1.2 * C98 OR C98 > 1.2 * C99 OR C99 > 1.2 * C100 OR C100 > 1.2 * C101 OR C101 > 1.2 * C102 OR C102 > 1.2 * C103 OR C103 > 1.2 * C104 OR C104 > 1.2 * C105 OR C105 > 1.2 * C106 OR C106 > 1.2 * C107 OR C107 > 1.2 * C108 OR C108 > 1.2 * C109 OR C109 > 1.2 * C110 OR C110 > 1.2 * C111 OR C111 > 1.2 * C112 OR C112 > 1.2 * C113 OR C113 > 1.2 * C114 OR C114 > 1.2 * C115 OR C115 > 1.2 * C116 OR C116 > 1.2 * C117 OR C117 > 1.2 * C118 OR C118 > 1.2 * C119 OR C119 > 1.2 * C120 OR C120 > 1.2 * C121 OR C121 > 1.2 * C122 OR C122 > 1.2 * C123 OR C123 > 1.2 * C124 OR C124 > 1.2 * C125 OR C125 > 1.2 * C126 OR C126 > 1.2 * C127 OR C127 > 1.2 * C128 OR C128 > 1.2 * C129 OR C129 > 1.2 * C130 OR C130 > 1.2 * C131 OR C131 > 1.2 * C132 OR C132 > 1.2 * C133 OR C133 > 1.2 * C134 OR C134 > 1.2 * C135 OR C135 > 1.2 * C136 OR C136 > 1.2 * C137 OR C137 > 1.2 * C138 OR C138 > 1.2 * C139 OR C139 > 1.2 * C140 OR C140 > 1.2 * C141 OR C141 > 1.2 * C142 OR C142 > 1.2 * C143 OR C143 > 1.2 * C144 OR C144 > 1.2 * C145 OR C145 > 1.2 * C146 OR C146 > 1.2 * C147 OR C147 > 1.2 * C148 OR C148 > 1.2 * C149 OR C149 > 1.2 * C150 OR C150 > 1.2 * C151 OR C151 > 1.2 * C152 OR C152 > 1.2 * C153 OR C153 > 1.2 * C154 OR C154 > 1.2 * C155 OR C155 > 1.2 * C156 OR C156 > 1.2 * C157 OR C157 > 1.2 * C158 OR C158 > 1.2 * C159 OR C159 > 1.2 * C160 OR C160 > 1.2 * C161 OR C161 > 1.2 * C162 OR C162 > 1.2 * C163 OR C163 > 1.2 * C164 OR C164 > 1.2 * C165 OR C165 > 1.2 * C166 OR C166 > 1.2 * C167 OR C167 > 1.2 * C168 OR C168 > 1.2 * C169 OR C169 > 1.2 * C170 OR C170 > 1.2 * C171 OR C171 > 1.2 * C172 OR C172 > 1.2 * C173 OR C173 > 1.2 * C174 OR C174 > 1.2 * C175 OR C175 > 1.2 * C176 OR C176 > 1.2 * C177 OR C177 > 1.2 * C178 OR C178 > 1.2 * C179 OR C179 > 1.2 * C180 OR C180 > 1.2 * C181 OR C181 > 1.2 * C182 OR C182 > 1.2 * C183 OR C183 > 1.2 * C184 OR C184 > 1.2 * C185 OR C185 > 1.2 * C186 OR C186 > 1.2 * C187 OR C187 > 1.2 * C188 OR C188 > 1.2 * C189 OR C189 > 1.2 * C190 OR C190 > 1.2 * C191 OR C191 > 1.2 * C192 OR C192 > 1.2 * C193 OR C193 > 1.2 * C194 OR C194 > 1.2 * C195 OR C195 > 1.2 * C196 OR C196 > 1.2 * C197 OR C197 > 1.2 * C198 OR C198 > 1.2 * C199 OR C199 > 1.2 * C200 OR C200 > 1.2 * C201 OR C201 > 1.2 * C202 OR C202 > 1.2 * C203 OR C203 > 1.2 * C204 OR C204 > 1.2 * C205 OR C205 > 1.2 * C206 OR C206 > 1.2 * C207 OR C207 > 1.2 * C208 OR C208 > 1.2 * C209 OR C209 > 1.2 * C210 OR C210 > 1.2 * C211 OR C211 > 1.2 * C212 OR C212 > 1.2 * C213 OR C213 > 1.2 * C214 OR C214 > 1.2 * C215 OR C215 > 1.2 * C216 OR C216 > 1.2 * C217 OR C217 > 1.2 * C218 OR C218 > 1.2 * C219 OR C219 > 1.2 * C220 OR C220 > 1.2 * C221 OR C221 > 1.2 * C222 OR C222 > 1.2 * C223 OR C223 > 1.2 * C224 OR C224 > 1.2 * C225 OR C225 > 1.2 * C226 OR C226 > 1.2 * C227 OR C227 > 1.2 * C228 OR C228 > 1.2 * C229 OR C229 > 1.2 * C230 OR C230 > 1.2 * C231 OR C231 > 1.2 * C232 OR C232 > 1.2 * C233 OR C233 > 1.2 * C234 OR C234 > 1.2 * C235 OR C235 > 1.2 * C236 OR C236 > 1.2 * C237 OR C237 > 1.2 * C238 OR C238 > 1.2 * C239 OR C239 > 1.2 * C240 OR C240 > 1.2 * C241 OR C241 > 1.2 * C242 OR C242 > 1.2 * C243 OR C243 > 1.2 * C244 OR C244 > 1.2 * C245 OR C245 > 1.2 * C246 OR C246 > 1.2 * C247 OR C247 > 1.2 * C248 OR C248 > 1.2 * C249 OR C249 > 1.2 * C250)
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 12/30/2004 Posts: 84
|
Thanks Bruce...very much appreciated
Jim
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |