| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Gold Customer
Joined: 3/24/2005
Posts: 18
|
I am trying to caculate when price breaks through the upper Bollinger Band using these criteria.
Moving average is 350 days
Standard Deviation is 2.5
Any ideas?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try using the following Personal Criteria Formula as an EasyScan Condition:
C > AVGC350 + 2.5 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 + C30 ^ 2 + C31 ^ 2 + C32 ^ 2 + C33 ^ 2 + C34 ^ 2 + C35 ^ 2 + C36 ^ 2 + C37 ^ 2 + C38 ^ 2 + C39 ^ 2 + C40 ^ 2 + C41 ^ 2 + C42 ^ 2 + C43 ^ 2 + C44 ^ 2 + C45 ^ 2 + C46 ^ 2 + C47 ^ 2 + C48 ^ 2 + C49 ^ 2 + C50 ^ 2 + C51 ^ 2 + C52 ^ 2 + C53 ^ 2 + C54 ^ 2 + C55 ^ 2 + C56 ^ 2 + C57 ^ 2 + C58 ^ 2 + C59 ^ 2 + C60 ^ 2 + C61 ^ 2 + C62 ^ 2 + C63 ^ 2 + C64 ^ 2 + C65 ^ 2 + C66 ^ 2 + C67 ^ 2 + C68 ^ 2 + C69 ^ 2 + C70 ^ 2 + C71 ^ 2 + C72 ^ 2 + C73 ^ 2 + C74 ^ 2 + C75 ^ 2 + C76 ^ 2 + C77 ^ 2 + C78 ^ 2 + C79 ^ 2 + C80 ^ 2 + C81 ^ 2 + C82 ^ 2 + C83 ^ 2 + C84 ^ 2 + C85 ^ 2 + C86 ^ 2 + C87 ^ 2 + C88 ^ 2 + C89 ^ 2 + C90 ^ 2 + C91 ^ 2 + C92 ^ 2 + C93 ^ 2 + C94 ^ 2 + C95 ^ 2 + C96 ^ 2 + C97 ^ 2 + C98 ^ 2 + C99 ^ 2 + C100 ^ 2 + C101 ^ 2 + C102 ^ 2 + C103 ^ 2 + C104 ^ 2 + C105 ^ 2 + C106 ^ 2 + C107 ^ 2 + C108 ^ 2 + C109 ^ 2 + C110 ^ 2 + C111 ^ 2 + C112 ^ 2 + C113 ^ 2 + C114 ^ 2 + C115 ^ 2 + C116 ^ 2 + C117 ^ 2 + C118 ^ 2 + C119 ^ 2 + C120 ^ 2 + C121 ^ 2 + C122 ^ 2 + C123 ^ 2 + C124 ^ 2 + C125 ^ 2 + C126 ^ 2 + C127 ^ 2 + C128 ^ 2 + C129 ^ 2 + C130 ^ 2 + C131 ^ 2 + C132 ^ 2 + C133 ^ 2 + C134 ^ 2 + C135 ^ 2 + C136 ^ 2 + C137 ^ 2 + C138 ^ 2 + C139 ^ 2 + C140 ^ 2 + C141 ^ 2 + C142 ^ 2 + C143 ^ 2 + C144 ^ 2 + C145 ^ 2 + C146 ^ 2 + C147 ^ 2 + C148 ^ 2 + C149 ^ 2 + C150 ^ 2 + C151 ^ 2 + C152 ^ 2 + C153 ^ 2 + C154 ^ 2 + C155 ^ 2 + C156 ^ 2 + C157 ^ 2 + C158 ^ 2 + C159 ^ 2 + C160 ^ 2 + C161 ^ 2 + C162 ^ 2 + C163 ^ 2 + C164 ^ 2 + C165 ^ 2 + C166 ^ 2 + C167 ^ 2 + C168 ^ 2 + C169 ^ 2 + C170 ^ 2 + C171 ^ 2 + C172 ^ 2 + C173 ^ 2 + C174 ^ 2 + C175 ^ 2 + C176 ^ 2 + C177 ^ 2 + C178 ^ 2 + C179 ^ 2 + C180 ^ 2 + C181 ^ 2 + C182 ^ 2 + C183 ^ 2 + C184 ^ 2 + C185 ^ 2 + C186 ^ 2 + C187 ^ 2 + C188 ^ 2 + C189 ^ 2 + C190 ^ 2 + C191 ^ 2 + C192 ^ 2 + C193 ^ 2 + C194 ^ 2 + C195 ^ 2 + C196 ^ 2 + C197 ^ 2 + C198 ^ 2 + C199 ^ 2 + C200 ^ 2 + C201 ^ 2 + C202 ^ 2 + C203 ^ 2 + C204 ^ 2 + C205 ^ 2 + C206 ^ 2 + C207 ^ 2 + C208 ^ 2 + C209 ^ 2 + C210 ^ 2 + C211 ^ 2 + C212 ^ 2 + C213 ^ 2 + C214 ^ 2 + C215 ^ 2 + C216 ^ 2 + C217 ^ 2 + C218 ^ 2 + C219 ^ 2 + C220 ^ 2 + C221 ^ 2 + C222 ^ 2 + C223 ^ 2 + C224 ^ 2 + C225 ^ 2 + C226 ^ 2 + C227 ^ 2 + C228 ^ 2 + C229 ^ 2 + C230 ^ 2 + C231 ^ 2 + C232 ^ 2 + C233 ^ 2 + C234 ^ 2 + C235 ^ 2 + C236 ^ 2 + C237 ^ 2 + C238 ^ 2 + C239 ^ 2 + C240 ^ 2 + C241 ^ 2 + C242 ^ 2 + C243 ^ 2 + C244 ^ 2 + C245 ^ 2 + C246 ^ 2 + C247 ^ 2 + C248 ^ 2 + C249 ^ 2 + C250 ^ 2 + C251 ^ 2 + C252 ^ 2 + C253 ^ 2 + C254 ^ 2 + C255 ^ 2 + C256 ^ 2 + C257 ^ 2 + C258 ^ 2 + C259 ^ 2 + C260 ^ 2 + C261 ^ 2 + C262 ^ 2 + C263 ^ 2 + C264 ^ 2 + C265 ^ 2 + C266 ^ 2 + C267 ^ 2 + C268 ^ 2 + C269 ^ 2 + C270 ^ 2 + C271 ^ 2 + C272 ^ 2 + C273 ^ 2 + C274 ^ 2 + C275 ^ 2 + C276 ^ 2 + C277 ^ 2 + C278 ^ 2 + C279 ^ 2 + C280 ^ 2 + C281 ^ 2 + C282 ^ 2 + C283 ^ 2 + C284 ^ 2 + C285 ^ 2 + C286 ^ 2 + C287 ^ 2 + C288 ^ 2 + C289 ^ 2 + C290 ^ 2 + C291 ^ 2 + C292 ^ 2 + C293 ^ 2 + C294 ^ 2 + C295 ^ 2 + C296 ^ 2 + C297 ^ 2 + C298 ^ 2 + C299 ^ 2 + C300 ^ 2 + C301 ^ 2 + C302 ^ 2 + C303 ^ 2 + C304 ^ 2 + C305 ^ 2 + C306 ^ 2 + C307 ^ 2 + C308 ^ 2 + C309 ^ 2 + C310 ^ 2 + C311 ^ 2 + C312 ^ 2 + C313 ^ 2 + C314 ^ 2 + C315 ^ 2 + C316 ^ 2 + C317 ^ 2 + C318 ^ 2 + C319 ^ 2 + C320 ^ 2 + C321 ^ 2 + C322 ^ 2 + C323 ^ 2 + C324 ^ 2 + C325 ^ 2 + C326 ^ 2 + C327 ^ 2 + C328 ^ 2 + C329 ^ 2 + C330 ^ 2 + C331 ^ 2 + C332 ^ 2 + C333 ^ 2 + C334 ^ 2 + C335 ^ 2 + C336 ^ 2 + C337 ^ 2 + C338 ^ 2 + C339 ^ 2 + C340 ^ 2 + C341 ^ 2 + C342 ^ 2 + C343 ^ 2 + C344 ^ 2 + C345 ^ 2 + C346 ^ 2 + C347 ^ 2 + C348 ^ 2 + C349 ^ 2 - 350 * AVGC350 ^ 2) / 349) AND C1 <= AVGC350.1 + 2.5 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 + C30 ^ 2 + C31 ^ 2 + C32 ^ 2 + C33 ^ 2 + C34 ^ 2 + C35 ^ 2 + C36 ^ 2 + C37 ^ 2 + C38 ^ 2 + C39 ^ 2 + C40 ^ 2 + C41 ^ 2 + C42 ^ 2 + C43 ^ 2 + C44 ^ 2 + C45 ^ 2 + C46 ^ 2 + C47 ^ 2 + C48 ^ 2 + C49 ^ 2 + C50 ^ 2 + C51 ^ 2 + C52 ^ 2 + C53 ^ 2 + C54 ^ 2 + C55 ^ 2 + C56 ^ 2 + C57 ^ 2 + C58 ^ 2 + C59 ^ 2 + C60 ^ 2 + C61 ^ 2 + C62 ^ 2 + C63 ^ 2 + C64 ^ 2 + C65 ^ 2 + C66 ^ 2 + C67 ^ 2 + C68 ^ 2 + C69 ^ 2 + C70 ^ 2 + C71 ^ 2 + C72 ^ 2 + C73 ^ 2 + C74 ^ 2 + C75 ^ 2 + C76 ^ 2 + C77 ^ 2 + C78 ^ 2 + C79 ^ 2 + C80 ^ 2 + C81 ^ 2 + C82 ^ 2 + C83 ^ 2 + C84 ^ 2 + C85 ^ 2 + C86 ^ 2 + C87 ^ 2 + C88 ^ 2 + C89 ^ 2 + C90 ^ 2 + C91 ^ 2 + C92 ^ 2 + C93 ^ 2 + C94 ^ 2 + C95 ^ 2 + C96 ^ 2 + C97 ^ 2 + C98 ^ 2 + C99 ^ 2 + C100 ^ 2 + C101 ^ 2 + C102 ^ 2 + C103 ^ 2 + C104 ^ 2 + C105 ^ 2 + C106 ^ 2 + C107 ^ 2 + C108 ^ 2 + C109 ^ 2 + C110 ^ 2 + C111 ^ 2 + C112 ^ 2 + C113 ^ 2 + C114 ^ 2 + C115 ^ 2 + C116 ^ 2 + C117 ^ 2 + C118 ^ 2 + C119 ^ 2 + C120 ^ 2 + C121 ^ 2 + C122 ^ 2 + C123 ^ 2 + C124 ^ 2 + C125 ^ 2 + C126 ^ 2 + C127 ^ 2 + C128 ^ 2 + C129 ^ 2 + C130 ^ 2 + C131 ^ 2 + C132 ^ 2 + C133 ^ 2 + C134 ^ 2 + C135 ^ 2 + C136 ^ 2 + C137 ^ 2 + C138 ^ 2 + C139 ^ 2 + C140 ^ 2 + C141 ^ 2 + C142 ^ 2 + C143 ^ 2 + C144 ^ 2 + C145 ^ 2 + C146 ^ 2 + C147 ^ 2 + C148 ^ 2 + C149 ^ 2 + C150 ^ 2 + C151 ^ 2 + C152 ^ 2 + C153 ^ 2 + C154 ^ 2 + C155 ^ 2 + C156 ^ 2 + C157 ^ 2 + C158 ^ 2 + C159 ^ 2 + C160 ^ 2 + C161 ^ 2 + C162 ^ 2 + C163 ^ 2 + C164 ^ 2 + C165 ^ 2 + C166 ^ 2 + C167 ^ 2 + C168 ^ 2 + C169 ^ 2 + C170 ^ 2 + C171 ^ 2 + C172 ^ 2 + C173 ^ 2 + C174 ^ 2 + C175 ^ 2 + C176 ^ 2 + C177 ^ 2 + C178 ^ 2 + C179 ^ 2 + C180 ^ 2 + C181 ^ 2 + C182 ^ 2 + C183 ^ 2 + C184 ^ 2 + C185 ^ 2 + C186 ^ 2 + C187 ^ 2 + C188 ^ 2 + C189 ^ 2 + C190 ^ 2 + C191 ^ 2 + C192 ^ 2 + C193 ^ 2 + C194 ^ 2 + C195 ^ 2 + C196 ^ 2 + C197 ^ 2 + C198 ^ 2 + C199 ^ 2 + C200 ^ 2 + C201 ^ 2 + C202 ^ 2 + C203 ^ 2 + C204 ^ 2 + C205 ^ 2 + C206 ^ 2 + C207 ^ 2 + C208 ^ 2 + C209 ^ 2 + C210 ^ 2 + C211 ^ 2 + C212 ^ 2 + C213 ^ 2 + C214 ^ 2 + C215 ^ 2 + C216 ^ 2 + C217 ^ 2 + C218 ^ 2 + C219 ^ 2 + C220 ^ 2 + C221 ^ 2 + C222 ^ 2 + C223 ^ 2 + C224 ^ 2 + C225 ^ 2 + C226 ^ 2 + C227 ^ 2 + C228 ^ 2 + C229 ^ 2 + C230 ^ 2 + C231 ^ 2 + C232 ^ 2 + C233 ^ 2 + C234 ^ 2 + C235 ^ 2 + C236 ^ 2 + C237 ^ 2 + C238 ^ 2 + C239 ^ 2 + C240 ^ 2 + C241 ^ 2 + C242 ^ 2 + C243 ^ 2 + C244 ^ 2 + C245 ^ 2 + C246 ^ 2 + C247 ^ 2 + C248 ^ 2 + C249 ^ 2 + C250 ^ 2 + C251 ^ 2 + C252 ^ 2 + C253 ^ 2 + C254 ^ 2 + C255 ^ 2 + C256 ^ 2 + C257 ^ 2 + C258 ^ 2 + C259 ^ 2 + C260 ^ 2 + C261 ^ 2 + C262 ^ 2 + C263 ^ 2 + C264 ^ 2 + C265 ^ 2 + C266 ^ 2 + C267 ^ 2 + C268 ^ 2 + C269 ^ 2 + C270 ^ 2 + C271 ^ 2 + C272 ^ 2 + C273 ^ 2 + C274 ^ 2 + C275 ^ 2 + C276 ^ 2 + C277 ^ 2 + C278 ^ 2 + C279 ^ 2 + C280 ^ 2 + C281 ^ 2 + C282 ^ 2 + C283 ^ 2 + C284 ^ 2 + C285 ^ 2 + C286 ^ 2 + C287 ^ 2 + C288 ^ 2 + C289 ^ 2 + C290 ^ 2 + C291 ^ 2 + C292 ^ 2 + C293 ^ 2 + C294 ^ 2 + C295 ^ 2 + C296 ^ 2 + C297 ^ 2 + C298 ^ 2 + C299 ^ 2 + C300 ^ 2 + C301 ^ 2 + C302 ^ 2 + C303 ^ 2 + C304 ^ 2 + C305 ^ 2 + C306 ^ 2 + C307 ^ 2 + C308 ^ 2 + C309 ^ 2 + C310 ^ 2 + C311 ^ 2 + C312 ^ 2 + C313 ^ 2 + C314 ^ 2 + C315 ^ 2 + C316 ^ 2 + C317 ^ 2 + C318 ^ 2 + C319 ^ 2 + C320 ^ 2 + C321 ^ 2 + C322 ^ 2 + C323 ^ 2 + C324 ^ 2 + C325 ^ 2 + C326 ^ 2 + C327 ^ 2 + C328 ^ 2 + C329 ^ 2 + C330 ^ 2 + C331 ^ 2 + C332 ^ 2 + C333 ^ 2 + C334 ^ 2 + C335 ^ 2 + C336 ^ 2 + C337 ^ 2 + C338 ^ 2 + C339 ^ 2 + C340 ^ 2 + C341 ^ 2 + C342 ^ 2 + C343 ^ 2 + C344 ^ 2 + C345 ^ 2 + C346 ^ 2 + C347 ^ 2 + C348 ^ 2 + C349 ^ 2 + C350 ^ 2 - 350 * AVGC350.1 ^ 2) / 349)
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
Handy PCF example formulas to help you learn the syntax of PCFs!
PCF Formula Descriptions
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 3/24/2005
Posts: 18
|
Wow! They need to give you a raise! Thanks!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 3/24/2005
Posts: 18
|
This formula (above) was working great, providing a True result when price crossed the upper band in the Sort Value column for several months when I was sorting through a large list of stocks. Recently, however, it is no longer providing a True result. Has something changed in the Telechart 2007 software that no longer allows this computation to work as it did before. The other formulas I am using for other sorts still provide a True result in the Sort Value column when the condition is met.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Nothing has changed in TeleChart that should affect how this formula is updated.
Please check to see if Databank | Personal Criteria Formulas | Include criteria which require more than 250 days of history (slower) is checked or not. It would need to be checked for the formula to be updated.
You should also make sure that Do not update this criteria is not checked in its Editing formula window.
If neither of these situations apply, you may wish to try re-creating the PCF from scratch.
If that does not work, there may be a technical issue with your program. There are a variety of ways to contact technical support.
All e-mail communication sent to support@worden.com during business hours (Monday through Friday 9AM-11PM and Saturday and Sunday 9AM-3PM ET) should be answered within 20 minutes of arrival.
For an even quicker response to tech support questions, we recommend calling our voice line at (919) 408-0542 (there is no phone support on Sundays, some Market Holidays or after 9PM ET on weekdays).
You can also contact us using Live Chat Support during business hours.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |