Hello .... I've reviewed the dialogue contained in the Discussion area.  I don't agree that a Bollinger Band squeeze within 6% is the same as having a closing price within 6% of the 20 day moving average.   I'd like to use the V12 condition formulas to subtract the value of the LowerBB(20,2) from the UpperBB(20,2)  .. and having that % be no more than 6% .. so I need something like (UpperBB(20,2) - LowerBB(20,2))/LowerBB(20,2) <= .06 .... I'm not sure how to best construct this formula/condition using V12.   I'll add other conditions as well to create the ultimate EasyScan.  Please advise.  Thank you.

That's why in the only topic where the customer asking the question defined a Bollinger Band Squeeze as the closing price being within 6% of its moving average:

BBand squeeze formula

I gave both a solution to the customer's definition and a solution to the most common definition where the difference between the Upper Bollinger Band and Lower Bollinger Bands was less than or equal to 6% of the Center Bollinger Band.

Your definition where the difference between the Upper Bollinger Band and Lower Bollinger Band is less than or equal to 6% of the Lower Bollinger Band is also not the common definition as it uses a different denominator (the Lower Bollinger Band instead of the Center Bollinger Band). One way to write a Condition Formula to check for this for a Simple Bollinger Band 20, 2.00 would be:

(AVGC20 + 2 * 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 - 20 * AVGC20 ^ 2) / 20) / (AVGC20 - 2 * 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 - 20 * AVGC20 ^ 2) / 20) <= 1.06

Modelling Bollinger Bands (& Standard Deviation) in a TC PCF

This process is going pretty slow .. could you please provide me with the date of your post to answer my question?

Thank you Bruce.   Could you please tell me where to find the "classic" BB Squeeze < 6% from the center line?    Can these formulas be cut and paste into a V12 condition?   Please advise.  THANKS again!

I'm not quite sure what date or which post is being referenced, so I'll provide a link about searching the forums so you can try to find out such information on your own and run through all of the posts which seem to be directly related to your question.

The Learn how to use the forums: post a new topic, reply, Search existing topics topic has information about keeping track of the posts in which have participated. You can click on your username in the forums to bring up a list of your ten most recent posts for example.

My Tuesday, September 11, 2012 5:10:40 PM ET post in the BBand squeeze formula topic was made about 5 minutes after somebody else asked the question. It is the only place on I know of which has any reference whatsoever to a Bollinger Band Squeeze as price being within 6% of the middle Bollinger Band. It also contains instructed for identifying the classic Bollinger Band Squeeze using TC2000 version 12.2.

I will re-quote a small portion and provide a link to a video on creating Conditions in TC2000 version 12.2.

Creating Scan and Sort Conditions

The instructions were also quoted in my Thursday, September 13, 2012 7:47:04 AM ET post in this very topic which was made before 8 AM on the day you posted the question. This response includes a link to original topic to which your original Thursday, September 13, 2012 2:30:05 AM ET question appears to be referencing.

You asked a similar question Thursday, September 13, 2012 5:18:14 PM ET in the Modelling Bollinger Bands (& Standard Deviation) in a TC PCF topic which was answered by StockGuy Thursday, September 13, 2012 5:21:14 PM ET (exactly 3 minutes after you asked it).

I don't know the date and time of this particular post as I am still writing it, but it will be listed at the top of the post. Note that I am normally only online during weekdays that aren't market holidays, don't make a practice of getting up until about 6:30 AM ET (but might not log into the forums until as late as 9 AM ET) and generally log out of the forums a little after 5 PM ET. So your most recent questions would not usually get answered until Monday morning since they were asked after normal business hours on a Friday.

Both your question and StockGuy's answer are on page 3 of the topic, so you will need to click through to that page to see them.

The best way to do this is to add Bollinger Bandwidth to the Charts and click on the BB to select Create Scan Condition | Less Than: .06

A Condition created this way is both easier to create and far more efficient than creating a Condiiton Formula. It will use fewer resources and calculate more quickly.

If you really need a Condition Formula instead, a Condition Formula for the 20-Period Simple Bollinger Band being less than 6% of the centerline could be written as:

4 * 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 - 20 * AVGC20 ^ 2) / 20) / AVGC20 < .06

Note that this is significantly more compact and efficient than the Condition Formula using the Lower Bollinger Band for the denominator as given in my Thursday, September 13, 2012 7:47:04 AM ET post. This may be why it is preferred. The results will frequently be quite similar although using the Lower Bollinger band should produce somewhat fewer results than using the Center Bollinger Band (because 6% of the Center Bollinger Band will be a slightly larger value than 6% of the Lower Bollinger Band).

Yes, you can copy and paste formula from the forums into TC2000 version 12.2. You can just highlight the formula, right-click on the highlighted formula and selet Copy to copy (or you could highlight the formula and select ctrl-c). You will need to use ctrl-v to paste the formula into TC2000 version 12.2 as there is no option to right-click and select Paste.

Personal Criteria Formula Conditions