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

BB Break out Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
spendabuck
Posted : Friday, September 21, 2007 9:24:41 AM
Gold Customer 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?
Bruce_L
Posted : Friday, September 21, 2007 9:54:10 AM


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
spendabuck
Posted : Friday, September 21, 2007 10:23:51 AM
Gold Customer Gold Customer

Joined: 3/24/2005
Posts: 18
Wow! They need to give you a raise! Thanks!
Bruce_L
Posted : Friday, September 21, 2007 10:24:20 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
spendabuck
Posted : Wednesday, December 19, 2007 8:18:19 AM
Gold Customer 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.
Bruce_L
Posted : Wednesday, December 19, 2007 10:16:10 AM


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