Dear Trainers,

I have a question regarding the TTM Squeeze formula that was posted

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) * 4 / 3 / ((AVGH20 - AVGL20) / 2 + (ABS(H - C1) + ABS(L - C1) + ABS(H1 - C2) + ABS(L1 - C2) + ABS(H2 - C3) + ABS(L2 - C3) + ABS(H3 - C4) + ABS(L3 - C4) + ABS(H4 - C5) + ABS(L4 - C5) + ABS(H5 - C6) + ABS(L5 - C6) + ABS(H6 - C7) + ABS(L6 - C7) + ABS(H7 - C8) + ABS(L7 - C8) + ABS(H8 - C9) + ABS(L8 - C9) + ABS(H9 - C10) + ABS(L9 - C10) + ABS(H10 - C11) + ABS(L10 - C11) + ABS(H11 - C12) + ABS(L11 - C12) + ABS(H12 - C13) + ABS(L12 - C13) + ABS(H13 - C14) + ABS(L13 - C14) + ABS(H14 - C15) + ABS(L14 - C15) + ABS(H15 - C16) + ABS(L15 - C16) + ABS(H16 - C17) + ABS(L16 - C17) + ABS(H17 - C18) + ABS(L17 - C18) + ABS(H18 - C19) + ABS(L18 - C19) + ABS(H19 - C20) + ABS(L19 - C20)) / 40 + .000001)

If i want to use this formula in a scan, does it mean that if the result is less than 1, the BB is inside of the KC (keltner Channel) and if it is more than 1, the BB is outside of the KC?

Thanks

Also, I try to plot this pcf as a indicator on the chart, would you please explain it to me what does it mean when the line (the indicator on the chart)  goes up, when it goes down and when it stay in the middle?

thanks

let me see if i understand this formula (plotted line) correctly,  if the line is at the bottom, that means the stock price is in a squeeze, and if the line is at the top, it means that BB/volatility is very high.

am i correct?

The Indicator Formula is the ratio of 2 times the 20-Period Standard Deviation to 1.5 times the 20-Period Simple Moving Average of True Range.

A value of less than one would mean Bollinger Bands 20, 2.00 were inside a Simple Keltner Channel 20, 1.50 if the centerlines of the Bollinger Bands and Keltner Channels were the same (which they are not). This would indicate the Bollinger Bands were "squeezed".

I really can't say much beyond that as the trainers can't give setting, interpretation or investment advice.

Is their a way to modify so as to visually represent the negative values (which can be color coded)?

We could theoretically set 1 to 0 by just subtracting 1 from the result:

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) * 4 / 3 / ((AVGH20 - AVGL20) / 2 + (ABS(H - C1) + ABS(L - C1) + ABS(H1 - C2) + ABS(L1 - C2) + ABS(H2 - C3) + ABS(L2 - C3) + ABS(H3 - C4) + ABS(L3 - C4) + ABS(H4 - C5) + ABS(L4 - C5) + ABS(H5 - C6) + ABS(L5 - C6) + ABS(H6 - C7) + ABS(L6 - C7) + ABS(H7 - C8) + ABS(L7 - C8) + ABS(H8 - C9) + ABS(L8 - C9) + ABS(H9 - C10) + ABS(L9 - C10) + ABS(H10 - C11) + ABS(L10 - C11) + ABS(H11 - C12) + ABS(L11 - C12) + ABS(H12 - C13) + ABS(L12 - C13) + ABS(H13 - C14) + ABS(L13 - C14) + ABS(H14 - C15) + ABS(L14 - C15) + ABS(H15 - C16) + ABS(L15 - C16) + ABS(H16 - C17) + ABS(L16 - C17) + ABS(H17 - C18) + ABS(L17 - C18) + ABS(H18 - C19) + ABS(L18 - C19) + ABS(H19 - C20) + ABS(L19 - C20)) / 40 + .000001) - 1

And use the formula in a Custom PCF Indicator. If you click on the Custom PCF Indicator and select Show values is WatchList it will create a WatchList Column. Then right-click on the WatchList Column Header for the WatchList and select Edit Columns. You can then set the Positive Color, Zero Color and Negative Color for the WatchList Column as desired.

Not only did you give me a MUCH better indicator to use (esp in histogram, color coded) but you gave me a way to scan for the condition in my watchlist AND add a column (color coded) to help  me analyze momentum w/in the squeeze. OUTSTANDING. Thank you, Bruce. Have a great weekend!!

Bruce, Can I use the above DAILY formula (which I use for the indicator/condition in my chart and watchlist) for WEEKLY chart/watchlist or does it need tweaking? (I really want to scan for when the weekly fires first...)

You can use the same formula for Daily and Weekly in TC2000 version 12.3. There is a Time Frame drop-down menu in the Edit PCF window when you create or edit a PCF. In addition, there are Time Frame options available in most of the places where you would use a PCF such as a WatchList Column or EasyScan Condition.

Ah that was easy. Thanks! 

Bruce, I realize now the above formula from Fri March 22 at 11:31 that you gave me is set for 20 periods and I would like 21 for both BB and KC. Can you pls resend?

Also, is it possible to make the KC based on exponential vs. simple? (separate formula as I want to see which i prefer)

Finally, if I wanted to change the ATR multiplier on the KC, can I do that easiliy or must I ask you to reformulate?

Thank you kindly,

There isn't a huge difference, but it is probably easier for me to make than changes than for you  to make the changes:

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 - 21 * AVGC21 ^ 2) / 21) * 4 / 3 / ((AVGH21 - AVGL21) / 2 + (ABS(H - C1) + ABS(L - C1) + ABS(H1 - C2) + ABS(L1 - C2) + ABS(H2 - C3) + ABS(L2 - C3) + ABS(H3 - C4) + ABS(L3 - C4) + ABS(H4 - C5) + ABS(L4 - C5) + ABS(H5 - C6) + ABS(L5 - C6) + ABS(H6 - C7) + ABS(L6 - C7) + ABS(H7 - C8) + ABS(L7 - C8) + ABS(H8 - C9) + ABS(L8 - C9) + ABS(H9 - C10) + ABS(L9 - C10) + ABS(H10 - C11) + ABS(L10 - C11) + ABS(H11 - C12) + ABS(L11 - C12) + ABS(H12 - C13) + ABS(L12 - C13) + ABS(H13 - C14) + ABS(L13 - C14) + ABS(H14 - C15) + ABS(L14 - C15) + ABS(H15 - C16) + ABS(L15 - C16) + ABS(H16 - C17) + ABS(L16 - C17) + ABS(H17 - C18) + ABS(L17 - C18) + ABS(H18 - C19) + ABS(L18 - C19) + ABS(H19 - C20) + ABS(L19 - C20) + ABS(H20 - C21) + ABS(L20 - C21)) / 42 + .000001) - 1

MUCH better. thank you.

Bruce, I am trying to solve a discrepency:

The following formula accounts for a BB 21 period, 2 SD inside a KC 21 period, 1.5 multiplier, so that when I scan for US stocks w/this condition, I can tell when they are 'squeezing': 

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 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 21) < 1.5 * ((XAVGH21 - XAVGL21) / 2 + .04549783 * (ABS(H - C1) + ABS(L - C1) + 10 / 11 * (ABS(H1 - C2) + ABS(L1 - C2) + 10 / 11 * (ABS(H2 - C3) + ABS(L2 - C3) + 10 / 11 * (ABS(H3 - C4) + ABS(L3 - C4) + 10 / 11 * (ABS(H4 - C5) + ABS(L4 - C5) + 10 / 11 * (ABS(H5 - C6) + ABS(L5 - C6) + 10 / 11 * (ABS(H6 - C7) + ABS(L6 - C7) + 10 / 11 * (ABS(H7 - C8) + ABS(L7 - C8) + 10 / 11 * (ABS(H8 - C9) + ABS(L8 - C9) + 10 / 11 * (ABS(H9 - C10) + ABS(L9 - C10) + 10 / 11 * (ABS(H10 - C11) + ABS(L10 - C11) + 10 / 11 * (ABS(H11 - C12) + ABS(L11 - C12) + 10 / 11 * (ABS(H12 - C13) + ABS(L12 - C13) + 10 / 11 * (ABS(H13 - C14) + ABS(L13 - C14) + 10 / 11 * (ABS(H14 - C15) + ABS(L14 - C15) + 10 / 11 * (ABS(H15 - C16) + ABS(L15 - C16) + 10 / 11 * (ABS(H16 - C17) + ABS(L16 - C17) + 10 / 11 * (ABS(H17 - C18) + ABS(L17 - C18) + 10 / 11 * (ABS(H18 - C19) + ABS(L18 - C19) + 10 / 11 * (ABS(H19 - C20) + ABS(L19 - C20) + 10 / 11 * (ABS(H20 - C21) + ABS(L20 - C21) + 10 / 11 * (ABS(H21 - C22) + ABS(L21 - C22) + 10 / 11 * (ABS(H22 - C23) + ABS(L22 - C23) + 10 / 11 * (ABS(H23 - C24) + ABS(L23 - C24) + 10 / 11 * (ABS(H24 - C25) + ABS(L24 - C25) + 10 / 11 * (ABS(H25 - C26) + ABS(L25 - C26) + 10 / 11 * (ABS(H26 - C27) + ABS(L26 - C27) + 10 / 11 * (ABS(H27 - C28) + ABS(L27 - C28) + 10 / 11 * (ABS(H28 - C29) + ABS(L28 - C29) + 10 / 11 * (ABS(H29 - C30) + ABS(L29 - C30) + 10 / 11 * (ABS(H30 - C31) + ABS(L30 - C31) + 10 / 11 * (ABS(H31 - C32) + ABS(L31 - C32) + 10 / 11 * (ABS(H32 - C33) + ABS(L32 - C33) + 10 / 11 * (ABS(H33 - C34) + ABS(L33 - C34) + 10 / 11 * (ABS(H34 - C35) + ABS(L34 - C35) + 10 / 11 * (ABS(H35 - C36) + ABS(L35 - C36) + 10 / 11 * (ABS(H36 - C37) + ABS(L36 - C37) + 10 / 11 * (ABS(H37 - C38) + ABS(L37 - C38) + 10 / 11 * (ABS(H38 - C39) + ABS(L38 - C39) + 10 / 11 * (ABS(H39 - C40) + ABS(L39 - C40) + 10 / 11 * (ABS(H40 - C41) + ABS(L40 - C41) + 10 / 11 * (ABS(H41 - C42) + ABS(L41 - C42) + 10 / 11 * (ABS(H42 - C43) + ABS(L42 - C43) + 10 / 11 * (ABS(H43 - C44) + ABS(L43 - C44) + 10 / 11 * (ABS(H44 - C45) + ABS(L44 - C45) + 10 / 11 * (ABS(H45 - C46) + ABS(L45 - C46) + 10 / 11 * (ABS(H46 - C47) + ABS(L46 - C47) + 10 / 11 * (ABS(H47 - C48) + ABS(L47 - C48) + 10 / 11 * (ABS(H48 - C49) + ABS(L48 - C49) + 10 / 11 * (ABS(H49 - C50) + ABS(L49 - C50) + 10 / 11 * (ABS(H50 - C51) + ABS(L50 - C51) + 10 / 11 * (ABS(H51 - C52) + ABS(L51 - C52) + 10 / 11 * (ABS(H52 - C53) + ABS(L52 - C53) + 10 / 11 * (ABS(H53 - C54) + ABS(L53 - C54) + 10 / 11 * (ABS(H54 - C55) + ABS(L54 - C55) + 10 / 11 * (ABS(H55 - C56) + ABS(L55 - C56) + 10 / 11 * (ABS(H56 - C57) + ABS(L56 - C57) + 10 / 11 * (ABS(H57 - C58) + ABS(L57 - C58) + 10 / 11 * (ABS(H58 - C59) + ABS(L58 - C59) + 10 / 11 * (ABS(H59 - C60) + ABS(L59 - C60) + 10 / 11 * (ABS(H60 - C61) + ABS(L60 - C61) + 10 / 11 * (ABS(H61 - C62) + ABS(L61 - C62) + 10 / 11 * (ABS(H62 - C63) + ABS(L62 - C63) + 10 / 11 * (ABS(H63 - C64) + ABS(L63 - C64) + 10 / 11 * (ABS(H64 - C65) + ABS(L64 - C65) + 10 / 11 * (ABS(H65 - C66) + ABS(L65 - C66) + 10 / 11 * (ABS(H66 - C67) + ABS(L66 - C67) + 10 / 11 * (ABS(H67 - C68) + ABS(L67 - C68) + 10 / 11 * (ABS(H68 - C69) + ABS(L68 - C69) + 10 / 11 * (ABS(H69 - C70) + ABS(L69 - C70) + 10 / 11 * (ABS(H70 - C71) + ABS(L70 - C71) + 10 / 11 * (ABS(H71 - C72) + ABS(L71 - C72) + 10 / 11 * (ABS(H72 - C73) + ABS(L72 - C73)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

BUT...the TTM Squeeze formula you gave me which should do the same thing gave me a lot more stocks (122 vs 50): 

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) * 4 / 3 / ((AVGH20 - AVGL20) / 2 + (ABS(H - C1) + ABS(L - C1) + ABS(H1 - C2) + ABS(L1 - C2) + ABS(H2 - C3) + ABS(L2 - C3) + ABS(H3 - C4) + ABS(L3 - C4) + ABS(H4 - C5) + ABS(L4 - C5) + ABS(H5 - C6) + ABS(L5 - C6) + ABS(H6 - C7) + ABS(L6 - C7) + ABS(H7 - C8) + ABS(L7 - C8) + ABS(H8 - C9) + ABS(L8 - C9) + ABS(H9 - C10) + ABS(L9 - C10) + ABS(H10 - C11) + ABS(L10 - C11) + ABS(H11 - C12) + ABS(L11 - C12) + ABS(H12 - C13) + ABS(L12 - C13) + ABS(H13 - C14) + ABS(L13 - C14) + ABS(H14 - C15) + ABS(L14 - C15) + ABS(H15 - C16) + ABS(L15 - C16) + ABS(H16 - C17) + ABS(L16 - C17) + ABS(H17 - C18) + ABS(L17 - C18) + ABS(H18 - C19) + ABS(L18 - C19) + ABS(H19 - C20) + ABS(L19 - C20)) / 40 + .000001) - 1

I visually looked at both lists and all stocks returned TTM squeeze value of <0; all were in a squeeze.

What gives, any idea?

--Samantha

They are not the same.

The top formula checks for 21-Period Bollinger Bands and 21-Period Exponential Keltner Channels.

The bottom formula checks for 20-Period Bollinger Bands and 20-Period Simple Keltner Channels.

Both formulas compare the width of the channels and assume the centerline is exactly the same even thought that might not necessarily be the case.

i see. thank you

Bruce!

So the Squeeze works great--as an indicator and condition for scans. NOW, what I would like to ask from you is the formula to find stocks that have squeezed OUT over the PAST 2, 3, 4 and 5 bars (just like you gave me for the standard deviation).

Below is the formula (which you gave me and works great) to identify this condition for TODAY but I don't check every day so I would like to in essence 'back test'. The formula you gave me to identify when a stock leaves the squeeze represents when BB 21-2 move outside of KC 21-1.5 so please work from this and THANK YOU!

 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 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 21) > 1.5 * ((XAVGH21 - XAVGL21) / 2 + .04549783 * (ABS(H - C1) + ABS(L - C1) + 10 / 11 * ABS(H1 - C2) + ABS(L1 - C2) + 10 / 11 * (ABS(H2 - C3) + ABS(L2 - C3) + 10 / 11 * (ABS(H3 - C4) + ABS(L3 - C4) + 10 / 11 * (ABS(H4 - C5) + ABS(L4 - C5) + 10 / 11 * (ABS(H5 - C6) + ABS(L5 - C6) + 10 / 11 * (ABS(H6 - C7) + ABS(L6 - C7) + 10 / 11 * (ABS(H7 - C8) + ABS(L7 - C8) + 10 / 11 * (ABS(H8 - C9) + ABS(L8 - C9) + 10 / 11 * (ABS(H9 - C10) + ABS(L9 - C10) + 10 / 11 * (ABS(H10 - C11) + ABS(L10 - C11) + 10 / 11 * (ABS(H11 - C12) + ABS(L11 - C12) + 10 / 11 * (ABS(H12 - C13) + ABS(L12 - C13) + 10 / 11 * (ABS(H13 - C14) + ABS(L13 - C14) + 10 / 11 * (ABS(H14 - C15) + ABS(L14 - C15) + 10 / 11 * (ABS(H15 - C16) + ABS(L15 - C16) + 10 / 11 * (ABS(H16 - C17) + ABS(L16 - C17) + 10 / 11 * (ABS(H17 - C18) + ABS(L17 - C18) + 10 / 11 * (ABS(H18 - C19) + ABS(L18 - C19) + 10 / 11 * (ABS(H19 - C20) + ABS(L19 - C20) + 10 / 11 * (ABS(H20 - C21) + ABS(L20 - C21) + 10 / 11 * (ABS(H21 - C22) + ABS(L21 - C22) + 10 / 11 * (ABS(H22 - C23) + ABS(L22 - C23) + 10 / 11 * (ABS(H23 - C24) + ABS(L23 - C24) + 10 / 11 * (ABS(H24 - C25) + ABS(L24 - C25) + 10 / 11 * (ABS(H25 - C26) + ABS(L25 - C26) + 10 / 11 * (ABS(H26 - C27) + ABS(L26 - C27) + 10 / 11 * (ABS(H27 - C28) + ABS(L27 - C28) + 10 / 11 * (ABS(H28 - C29) + ABS(L28 - C29) + 10 / 11 * (ABS(H29 - C30) + ABS(L29 - C30) + 10 / 11 * (ABS(H30 - C31) + ABS(L30 - C31) + 10 / 11 * (ABS(H31 - C32) + ABS(L31 - C32) + 10 / 11 * (ABS(H32 - C33) + ABS(L32 - C33) + 10 / 11 * (ABS(H33 - C34) + ABS(L33 - C34) + 10 / 11 * (ABS(H34 - C35) + ABS(L34 - C35) + 10 / 11 * (ABS(H35 - C36) + ABS(L35 - C36) + 10 / 11 * (ABS(H36 - C37) + ABS(L36 - C37) + 10 / 11 * (ABS(H37 - C38) + ABS(L37 - C38) + 10 / 11 * (ABS(H38 - C39) + ABS(L38 - C39) + 10 / 11 * (ABS(H39 - C40) + ABS(L39 - C40) + 10 / 11 * (ABS(H40 - C41) + ABS(L40 - C41) + 10 / 11 * (ABS(H41 - C42) + ABS(L41 - C42) + 10 / 11 * (ABS(H42 - C43) + ABS(L42 - C43) + 10 / 11 * (ABS(H43 - C44) + ABS(L43 - C44) + 10 / 11 * (ABS(H44 - C45) + ABS(L44 - C45) + 10 / 11 * (ABS(H45 - C46) + ABS(L45 - C46) + 10 / 11 * (ABS(H46 - C47) + ABS(L46 - C47) + 10 / 11 * (ABS(H47 - C48) + ABS(L47 - C48) + 10 / 11 * (ABS(H48 - C49) + ABS(L48 - C49) + 10 / 11 * (ABS(H49 - C50) + ABS(L49 - C50) + 10 / 11 * (ABS(H50 - C51) + ABS(L50 - C51) + 10 / 11 * (ABS(H51 - C52) + ABS(L51 - C52) + 10 / 11 * (ABS(H52 - C53) + ABS(L52 - C53) + 10 / 11 * (ABS(H53 - C54) + ABS(L53 - C54) + 10 / 11 * (ABS(H54 - C55) + ABS(L54 - C55) + 10 / 11 * (ABS(H55 - C56) + ABS(L55 - C56) + 10 / 11 * (ABS(H56 - C57) + ABS(L56 - C57) + 10 / 11 * (ABS(H57 - C58) + ABS(L57 - C58) + 10 / 11 * (ABS(H58 - C59) + ABS(L58 - C59) + 10 / 11 * (ABS(H59 - C60) + ABS(L59 - C60) + 10 / 11 * (ABS(H60 - C61) + ABS(L60 - C61) + 10 / 11 * (ABS(H61 - C62) + ABS(L61 - C62) + 10 / 11 * (ABS(H62 - C63) + ABS(L62 - C63) + 10 / 11 * (ABS(H63 - C64) + ABS(L63 - C64) + 10 / 11 * (ABS(H64 - C65) + ABS(L64 - C65) + 10 / 11 * (ABS(H65 - C66) + ABS(L65 - C66) + 10 / 11 * (ABS(H66 - C67) + ABS(L66 - C67) + 10 / 11 * (ABS(H67 - C68) + ABS(L67 - C68) + 10 / 11 * (ABS(H68 - C69) + ABS(L68 - C69) + 10 / 11 * (ABS(H69 - C70) + ABS(L69 - C70) + 10 / 11 * (ABS(H70 - C71) + ABS(L70 - C71) + 10 / 11 * (ABS(H71 - C72) + ABS(L71 - C72) + 10 / 11 * (ABS(H72 - C73) + ABS(L72 - C73)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND 2 * 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 - 21 * AVGC21.1 ^ 2) / 21) <= 1.5 * ((XAVGH21.1 - XAVGL21.1) / 2 + .04549783 * (ABS(H1 - C2) + ABS(L1 - C2) + 10 / 11 * (ABS(H2 - C3) + ABS(L2 - C3) + 10 / 11 * (ABS(H3 - C4) + ABS(L3 - C4) + 10 / 11 * (ABS(H4 - C5) + ABS(L4 - C5) + 10 / 11 * (ABS(H5 - C6) + ABS(L5 - C6) + 10 / 11 * (ABS(H6 - C7) + ABS(L6 - C7) + 10 / 11 * (ABS(H7 - C8) + ABS(L7 - C8) + 10 / 11 * (ABS(H8 - C9) + ABS(L8 - C9) + 10 / 11 * (ABS(H9 - C10) + ABS(L9 - C10) + 10 / 11 * (ABS(H10 - C11) + ABS(L10 - C11) + 10 / 11 * (ABS(H11 - C12) + ABS(L11 - C12) + 10 / 11 * (ABS(H12 - C13) + ABS(L12 - C13) + 10 / 11 * (ABS(H13 - C14) + ABS(L13 - C14) + 10 / 11 * (ABS(H14 - C15) + ABS(L14 - C15) + 10 / 11 * (ABS(H15 - C16) + ABS(L15 - C16) + 10 / 11 * (ABS(H16 - C17) + ABS(L16 - C17) + 10 / 11 * (ABS(H17 - C18) + ABS(L17 - C18) + 10 / 11 * (ABS(H18 - C19) + ABS(L18 - C19) + 10 / 11 * (ABS(H19 - C20) + ABS(L19 - C20) + 10 / 11 * (ABS(H20 - C21) + ABS(L20 - C21) + 10 / 11 * (ABS(H21 - C22) + ABS(L21 - C22) + 10 / 11 * (ABS(H22 - C23) + ABS(L22 - C23) + 10 / 11 * (ABS(H23 - C24) + ABS(L23 - C24) + 10 / 11 * (ABS(H24 - C25) + ABS(L24 - C25) + 10 / 11 * (ABS(H25 - C26) + ABS(L25 - C26) + 10 / 11 * (ABS(H26 - C27) + ABS(L26 - C27) + 10 / 11 * (ABS(H27 - C28) + ABS(L27 - C28) + 10 / 11 * (ABS(H28 - C29) + ABS(L28 - C29) + 10 / 11 * (ABS(H29 - C30) + ABS(L29 - C30) + 10 / 11 * (ABS(H30 - C31) + ABS(L30 - C31) + 10 / 11 * (ABS(H31 - C32) + ABS(L31 - C32) + 10 / 11 * (ABS(H32 - C33) + ABS(L32 - C33) + 10 / 11 * (ABS(H33 - C34) + ABS(L33 - C34) + 10 / 11 * (ABS(H34 - C35) + ABS(L34 - C35) + 10 / 11 * (ABS(H35 - C36) + ABS(L35 - C36) + 10 / 11 * (ABS(H36 - C37) + ABS(L36 - C37) + 10 / 11 * (ABS(H37 - C38) + ABS(L37 - C38) + 10 / 11 * (ABS(H38 - C39) + ABS(L38 - C39) + 10 / 11 * (ABS(H39 - C40) + ABS(L39 - C40) + 10 / 11 * (ABS(H40 - C41) + ABS(L40 - C41) + 10 / 11 * (ABS(H41 - C42) + ABS(L41 - C42) + 10 / 11 * (ABS(H42 - C43) + ABS(L42 - C43) + 10 / 11 * (ABS(H43 - C44) + ABS(L43 - C44) + 10 / 11 * (ABS(H44 - C45) + ABS(L44 - C45) + 10 / 11 * (ABS(H45 - C46) + ABS(L45 - C46) + 10 / 11 * (ABS(H46 - C47) + ABS(L46 - C47) + 10 / 11 * (ABS(H47 - C48) + ABS(L47 - C48) + 10 / 11 * (ABS(H48 - C49) + ABS(L48 - C49) + 10 / 11 * (ABS(H49 - C50) + ABS(L49 - C50) + 10 / 11 * (ABS(H50 - C51) + ABS(L50 - C51) + 10 / 11 * (ABS(H51 - C52) + ABS(L51 - C52) + 10 / 11 * (ABS(H52 - C53) + ABS(L52 - C53) + 10 / 11 * (ABS(H53 - C54) + ABS(L53 - C54) + 10 / 11 * (ABS(H54 - C55) + ABS(L54 - C55) + 10 / 11 * (ABS(H55 - C56) + ABS(L55 - C56) + 10 / 11 * (ABS(H56 - C57) + ABS(L56 - C57) + 10 / 11 * (ABS(H57 - C58) + ABS(L57 - C58) + 10 / 11 * (ABS(H58 - C59) + ABS(L58 - C59) + 10 / 11 * (ABS(H59 - C60) + ABS(L59 - C60) + 10 / 11 * (ABS(H60 - C61) + ABS(L60 - C61) + 10 / 11 * (ABS(H61 - C62) + ABS(L61 - C62) + 10 / 11 * (ABS(H62 - C63) + ABS(L62 - C63) + 10 / 11 * (ABS(H63 - C64) + ABS(L63 - C64) + 10 / 11 * (ABS(H64 - C65) + ABS(L64 - C65) + 10 / 11 * (ABS(H65 - C66) + ABS(L65 - C66) + 10 / 11 * (ABS(H66 - C67) + ABS(L66 - C67) + 10 / 11 * (ABS(H67 - C68) + ABS(L67 - C68) + 10 / 11 * (ABS(H68 - C69) + ABS(L68 - C69) + 10 / 11 * (ABS(H69 - C70) + ABS(L69 - C70) + 10 / 11 * (ABS(H70 - C71) + ABS(L70 - C71) + 10 / 11 * (ABS(H71 - C72) + ABS(L71 - C72) + 10 / 11 * (ABS(H72 - C73) + ABS(L72 - C73) + 10 / 11 * (ABS(H73 - C74) + ABS(L73 - C74)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

A Condition Formula that checks over 5-bars would be 5 times as long as a Condition Formula that just checks over 1-bar. That is too long and slow to be practical or post in the forums.

What you can do is use the Condition Formula you already have as the Boolean Formula in a Custom PCF % True Indicator. Set the Average Type to Simple and the Period to 5. This will return a value greater than 0% any time that the Boolean Formula was true at least once during the most recent 5-bars.

This allows you to click on the Custom PCF % True Indicator and select Create Scan Condition to check for the result being greater than 0. This Condition should return true for the desired symbols.

Create Conditions from Your Chart

Understand. I'll play with it and work it out. 

Thanks so much, Bruce. Have a great weekend!

--Samantha

Bruce, The above formula I use for the TTM Squeeze and represent pos/neg values w/blue/red colors: red means stock is in the squeeze. If I create a condition for a SQUEEZING OUT scan (first positive value in blue) versus create a scan from the indicator (Crossing Up Value >0)--both based on the same formula--I get different results. Why? How can I fixd this so I am sure I am getting the correct/best result?

Thanks in advance!

--Samantha

There are six different formulas in this topic. I have no idea which two formulas are being referenced.

good point: the last one posted on  Friday, May 10, 2013 3:09:19 PM

This is the TTM Squeeze Indicator Formula:

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) * 4 / 3 / ((AVGH20 - AVGL20) / 2 + (ABS(H - C1) + ABS(L - C1) + ABS(H1 - C2) + ABS(L1 - C2) + ABS(H2 - C3) + ABS(L2 - C3) + ABS(H3 - C4) + ABS(L3 - C4) + ABS(H4 - C5) + ABS(L4 - C5) + ABS(H5 - C6) + ABS(L5 - C6) + ABS(H6 - C7) + ABS(L6 - C7) + ABS(H7 - C8) + ABS(L7 - C8) + ABS(H8 - C9) + ABS(L8 - C9) + ABS(H9 - C10) + ABS(L9 - C10) + ABS(H10 - C11) + ABS(L10 - C11) + ABS(H11 - C12) + ABS(L11 - C12) + ABS(H12 - C13) + ABS(L12 - C13) + ABS(H13 - C14) + ABS(L13 - C14) + ABS(H14 - C15) + ABS(L14 - C15) + ABS(H15 - C16) + ABS(L15 - C16) + ABS(H16 - C17) + ABS(L16 - C17) + ABS(H17 - C18) + ABS(L17 - C18) + ABS(H18 - C19) + ABS(L18 - C19) + ABS(H19 - C20) + ABS(L19 - C20)) / 40 + .000001) - 1

And this is the TTM Squeezing Condition Formula:

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 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 21) > 1.5 * ((XAVGH21 - XAVGL21) / 2 + .04549783 * (ABS(H - C1) + ABS(L - C1) + 10 / 11 * ABS(H1 - C2) + ABS(L1 - C2) + 10 / 11 * (ABS(H2 - C3) + ABS(L2 - C3) + 10 / 11 * (ABS(H3 - C4) + ABS(L3 - C4) + 10 / 11 * (ABS(H4 - C5) + ABS(L4 - C5) + 10 / 11 * (ABS(H5 - C6) + ABS(L5 - C6) + 10 / 11 * (ABS(H6 - C7) + ABS(L6 - C7) + 10 / 11 * (ABS(H7 - C8) + ABS(L7 - C8) + 10 / 11 * (ABS(H8 - C9) + ABS(L8 - C9) + 10 / 11 * (ABS(H9 - C10) + ABS(L9 - C10) + 10 / 11 * (ABS(H10 - C11) + ABS(L10 - C11) + 10 / 11 * (ABS(H11 - C12) + ABS(L11 - C12) + 10 / 11 * (ABS(H12 - C13) + ABS(L12 - C13) + 10 / 11 * (ABS(H13 - C14) + ABS(L13 - C14) + 10 / 11 * (ABS(H14 - C15) + ABS(L14 - C15) + 10 / 11 * (ABS(H15 - C16) + ABS(L15 - C16) + 10 / 11 * (ABS(H16 - C17) + ABS(L16 - C17) + 10 / 11 * (ABS(H17 - C18) + ABS(L17 - C18) + 10 / 11 * (ABS(H18 - C19) + ABS(L18 - C19) + 10 / 11 * (ABS(H19 - C20) + ABS(L19 - C20) + 10 / 11 * (ABS(H20 - C21) + ABS(L20 - C21) + 10 / 11 * (ABS(H21 - C22) + ABS(L21 - C22) + 10 / 11 * (ABS(H22 - C23) + ABS(L22 - C23) + 10 / 11 * (ABS(H23 - C24) + ABS(L23 - C24) + 10 / 11 * (ABS(H24 - C25) + ABS(L24 - C25) + 10 / 11 * (ABS(H25 - C26) + ABS(L25 - C26) + 10 / 11 * (ABS(H26 - C27) + ABS(L26 - C27) + 10 / 11 * (ABS(H27 - C28) + ABS(L27 - C28) + 10 / 11 * (ABS(H28 - C29) + ABS(L28 - C29) + 10 / 11 * (ABS(H29 - C30) + ABS(L29 - C30) + 10 / 11 * (ABS(H30 - C31) + ABS(L30 - C31) + 10 / 11 * (ABS(H31 - C32) + ABS(L31 - C32) + 10 / 11 * (ABS(H32 - C33) + ABS(L32 - C33) + 10 / 11 * (ABS(H33 - C34) + ABS(L33 - C34) + 10 / 11 * (ABS(H34 - C35) + ABS(L34 - C35) + 10 / 11 * (ABS(H35 - C36) + ABS(L35 - C36) + 10 / 11 * (ABS(H36 - C37) + ABS(L36 - C37) + 10 / 11 * (ABS(H37 - C38) + ABS(L37 - C38) + 10 / 11 * (ABS(H38 - C39) + ABS(L38 - C39) + 10 / 11 * (ABS(H39 - C40) + ABS(L39 - C40) + 10 / 11 * (ABS(H40 - C41) + ABS(L40 - C41) + 10 / 11 * (ABS(H41 - C42) + ABS(L41 - C42) + 10 / 11 * (ABS(H42 - C43) + ABS(L42 - C43) + 10 / 11 * (ABS(H43 - C44) + ABS(L43 - C44) + 10 / 11 * (ABS(H44 - C45) + ABS(L44 - C45) + 10 / 11 * (ABS(H45 - C46) + ABS(L45 - C46) + 10 / 11 * (ABS(H46 - C47) + ABS(L46 - C47) + 10 / 11 * (ABS(H47 - C48) + ABS(L47 - C48) + 10 / 11 * (ABS(H48 - C49) + ABS(L48 - C49) + 10 / 11 * (ABS(H49 - C50) + ABS(L49 - C50) + 10 / 11 * (ABS(H50 - C51) + ABS(L50 - C51) + 10 / 11 * (ABS(H51 - C52) + ABS(L51 - C52) + 10 / 11 * (ABS(H52 - C53) + ABS(L52 - C53) + 10 / 11 * (ABS(H53 - C54) + ABS(L53 - C54) + 10 / 11 * (ABS(H54 - C55) + ABS(L54 - C55) + 10 / 11 * (ABS(H55 - C56) + ABS(L55 - C56) + 10 / 11 * (ABS(H56 - C57) + ABS(L56 - C57) + 10 / 11 * (ABS(H57 - C58) + ABS(L57 - C58) + 10 / 11 * (ABS(H58 - C59) + ABS(L58 - C59) + 10 / 11 * (ABS(H59 - C60) + ABS(L59 - C60) + 10 / 11 * (ABS(H60 - C61) + ABS(L60 - C61) + 10 / 11 * (ABS(H61 - C62) + ABS(L61 - C62) + 10 / 11 * (ABS(H62 - C63) + ABS(L62 - C63) + 10 / 11 * (ABS(H63 - C64) + ABS(L63 - C64) + 10 / 11 * (ABS(H64 - C65) + ABS(L64 - C65) + 10 / 11 * (ABS(H65 - C66) + ABS(L65 - C66) + 10 / 11 * (ABS(H66 - C67) + ABS(L66 - C67) + 10 / 11 * (ABS(H67 - C68) + ABS(L67 - C68) + 10 / 11 * (ABS(H68 - C69) + ABS(L68 - C69) + 10 / 11 * (ABS(H69 - C70) + ABS(L69 - C70) + 10 / 11 * (ABS(H70 - C71) + ABS(L70 - C71) + 10 / 11 * (ABS(H71 - C72) + ABS(L71 - C72) + 10 / 11 * (ABS(H72 - C73) + ABS(L72 - C73)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND 2 * 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 - 21 * AVGC21.1 ^ 2) / 21) <= 1.5 * ((XAVGH21.1 - XAVGL21.1) / 2 + .04549783 * (ABS(H1 - C2) + ABS(L1 - C2) + 10 / 11 * (ABS(H2 - C3) + ABS(L2 - C3) + 10 / 11 * (ABS(H3 - C4) + ABS(L3 - C4) + 10 / 11 * (ABS(H4 - C5) + ABS(L4 - C5) + 10 / 11 * (ABS(H5 - C6) + ABS(L5 - C6) + 10 / 11 * (ABS(H6 - C7) + ABS(L6 - C7) + 10 / 11 * (ABS(H7 - C8) + ABS(L7 - C8) + 10 / 11 * (ABS(H8 - C9) + ABS(L8 - C9) + 10 / 11 * (ABS(H9 - C10) + ABS(L9 - C10) + 10 / 11 * (ABS(H10 - C11) + ABS(L10 - C11) + 10 / 11 * (ABS(H11 - C12) + ABS(L11 - C12) + 10 / 11 * (ABS(H12 - C13) + ABS(L12 - C13) + 10 / 11 * (ABS(H13 - C14) + ABS(L13 - C14) + 10 / 11 * (ABS(H14 - C15) + ABS(L14 - C15) + 10 / 11 * (ABS(H15 - C16) + ABS(L15 - C16) + 10 / 11 * (ABS(H16 - C17) + ABS(L16 - C17) + 10 / 11 * (ABS(H17 - C18) + ABS(L17 - C18) + 10 / 11 * (ABS(H18 - C19) + ABS(L18 - C19) + 10 / 11 * (ABS(H19 - C20) + ABS(L19 - C20) + 10 / 11 * (ABS(H20 - C21) + ABS(L20 - C21) + 10 / 11 * (ABS(H21 - C22) + ABS(L21 - C22) + 10 / 11 * (ABS(H22 - C23) + ABS(L22 - C23) + 10 / 11 * (ABS(H23 - C24) + ABS(L23 - C24) + 10 / 11 * (ABS(H24 - C25) + ABS(L24 - C25) + 10 / 11 * (ABS(H25 - C26) + ABS(L25 - C26) + 10 / 11 * (ABS(H26 - C27) + ABS(L26 - C27) + 10 / 11 * (ABS(H27 - C28) + ABS(L27 - C28) + 10 / 11 * (ABS(H28 - C29) + ABS(L28 - C29) + 10 / 11 * (ABS(H29 - C30) + ABS(L29 - C30) + 10 / 11 * (ABS(H30 - C31) + ABS(L30 - C31) + 10 / 11 * (ABS(H31 - C32) + ABS(L31 - C32) + 10 / 11 * (ABS(H32 - C33) + ABS(L32 - C33) + 10 / 11 * (ABS(H33 - C34) + ABS(L33 - C34) + 10 / 11 * (ABS(H34 - C35) + ABS(L34 - C35) + 10 / 11 * (ABS(H35 - C36) + ABS(L35 - C36) + 10 / 11 * (ABS(H36 - C37) + ABS(L36 - C37) + 10 / 11 * (ABS(H37 - C38) + ABS(L37 - C38) + 10 / 11 * (ABS(H38 - C39) + ABS(L38 - C39) + 10 / 11 * (ABS(H39 - C40) + ABS(L39 - C40) + 10 / 11 * (ABS(H40 - C41) + ABS(L40 - C41) + 10 / 11 * (ABS(H41 - C42) + ABS(L41 - C42) + 10 / 11 * (ABS(H42 - C43) + ABS(L42 - C43) + 10 / 11 * (ABS(H43 - C44) + ABS(L43 - C44) + 10 / 11 * (ABS(H44 - C45) + ABS(L44 - C45) + 10 / 11 * (ABS(H45 - C46) + ABS(L45 - C46) + 10 / 11 * (ABS(H46 - C47) + ABS(L46 - C47) + 10 / 11 * (ABS(H47 - C48) + ABS(L47 - C48) + 10 / 11 * (ABS(H48 - C49) + ABS(L48 - C49) + 10 / 11 * (ABS(H49 - C50) + ABS(L49 - C50) + 10 / 11 * (ABS(H50 - C51) + ABS(L50 - C51) + 10 / 11 * (ABS(H51 - C52) + ABS(L51 - C52) + 10 / 11 * (ABS(H52 - C53) + ABS(L52 - C53) + 10 / 11 * (ABS(H53 - C54) + ABS(L53 - C54) + 10 / 11 * (ABS(H54 - C55) + ABS(L54 - C55) + 10 / 11 * (ABS(H55 - C56) + ABS(L55 - C56) + 10 / 11 * (ABS(H56 - C57) + ABS(L56 - C57) + 10 / 11 * (ABS(H57 - C58) + ABS(L57 - C58) + 10 / 11 * (ABS(H58 - C59) + ABS(L58 - C59) + 10 / 11 * (ABS(H59 - C60) + ABS(L59 - C60) + 10 / 11 * (ABS(H60 - C61) + ABS(L60 - C61) + 10 / 11 * (ABS(H61 - C62) + ABS(L61 - C62) + 10 / 11 * (ABS(H62 - C63) + ABS(L62 - C63) + 10 / 11 * (ABS(H63 - C64) + ABS(L63 - C64) + 10 / 11 * (ABS(H64 - C65) + ABS(L64 - C65) + 10 / 11 * (ABS(H65 - C66) + ABS(L65 - C66) + 10 / 11 * (ABS(H66 - C67) + ABS(L66 - C67) + 10 / 11 * (ABS(H67 - C68) + ABS(L67 - C68) + 10 / 11 * (ABS(H68 - C69) + ABS(L68 - C69) + 10 / 11 * (ABS(H69 - C70) + ABS(L69 - C70) + 10 / 11 * (ABS(H70 - C71) + ABS(L70 - C71) + 10 / 11 * (ABS(H71 - C72) + ABS(L71 - C72) + 10 / 11 * (ABS(H72 - C73) + ABS(L72 - C73) + 10 / 11 * (ABS(H73 - C74) + ABS(L73 - C74)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

It is pretty much the same issue as was brought up in your Thursday, April 11, 2013 2:49:49 PM ET post. The first formula is using periods of 20 for both indicators and a simple moving average for the true range while the second is using periods of 21 for both indicators and an exponential moving average for the true range.

If you want the first formula to use periods of 21 and an exponential moving average for the true range, it would become:

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 - 21 * AVGC21 ^ 2) / 21) * 4 / 3 / ((XAVGH21 - XAVGL21) / 2 + .04549783 * (ABS(H - C1) + ABS(L - C1) + 10 / 11 * ABS(H1 - C2) + ABS(L1 - C2) + 10 / 11 * (ABS(H2 - C3) + ABS(L2 - C3) + 10 / 11 * (ABS(H3 - C4) + ABS(L3 - C4) + 10 / 11 * (ABS(H4 - C5) + ABS(L4 - C5) + 10 / 11 * (ABS(H5 - C6) + ABS(L5 - C6) + 10 / 11 * (ABS(H6 - C7) + ABS(L6 - C7) + 10 / 11 * (ABS(H7 - C8) + ABS(L7 - C8) + 10 / 11 * (ABS(H8 - C9) + ABS(L8 - C9) + 10 / 11 * (ABS(H9 - C10) + ABS(L9 - C10) + 10 / 11 * (ABS(H10 - C11) + ABS(L10 - C11) + 10 / 11 * (ABS(H11 - C12) + ABS(L11 - C12) + 10 / 11 * (ABS(H12 - C13) + ABS(L12 - C13) + 10 / 11 * (ABS(H13 - C14) + ABS(L13 - C14) + 10 / 11 * (ABS(H14 - C15) + ABS(L14 - C15) + 10 / 11 * (ABS(H15 - C16) + ABS(L15 - C16) + 10 / 11 * (ABS(H16 - C17) + ABS(L16 - C17) + 10 / 11 * (ABS(H17 - C18) + ABS(L17 - C18) + 10 / 11 * (ABS(H18 - C19) + ABS(L18 - C19) + 10 / 11 * (ABS(H19 - C20) + ABS(L19 - C20) + 10 / 11 * (ABS(H20 - C21) + ABS(L20 - C21) + 10 / 11 * (ABS(H21 - C22) + ABS(L21 - C22) + 10 / 11 * (ABS(H22 - C23) + ABS(L22 - C23) + 10 / 11 * (ABS(H23 - C24) + ABS(L23 - C24) + 10 / 11 * (ABS(H24 - C25) + ABS(L24 - C25) + 10 / 11 * (ABS(H25 - C26) + ABS(L25 - C26) + 10 / 11 * (ABS(H26 - C27) + ABS(L26 - C27) + 10 / 11 * (ABS(H27 - C28) + ABS(L27 - C28) + 10 / 11 * (ABS(H28 - C29) + ABS(L28 - C29) + 10 / 11 * (ABS(H29 - C30) + ABS(L29 - C30) + 10 / 11 * (ABS(H30 - C31) + ABS(L30 - C31) + 10 / 11 * (ABS(H31 - C32) + ABS(L31 - C32) + 10 / 11 * (ABS(H32 - C33) + ABS(L32 - C33) + 10 / 11 * (ABS(H33 - C34) + ABS(L33 - C34) + 10 / 11 * (ABS(H34 - C35) + ABS(L34 - C35) + 10 / 11 * (ABS(H35 - C36) + ABS(L35 - C36) + 10 / 11 * (ABS(H36 - C37) + ABS(L36 - C37) + 10 / 11 * (ABS(H37 - C38) + ABS(L37 - C38) + 10 / 11 * (ABS(H38 - C39) + ABS(L38 - C39) + 10 / 11 * (ABS(H39 - C40) + ABS(L39 - C40) + 10 / 11 * (ABS(H40 - C41) + ABS(L40 - C41) + 10 / 11 * (ABS(H41 - C42) + ABS(L41 - C42) + 10 / 11 * (ABS(H42 - C43) + ABS(L42 - C43) + 10 / 11 * (ABS(H43 - C44) + ABS(L43 - C44) + 10 / 11 * (ABS(H44 - C45) + ABS(L44 - C45) + 10 / 11 * (ABS(H45 - C46) + ABS(L45 - C46) + 10 / 11 * (ABS(H46 - C47) + ABS(L46 - C47) + 10 / 11 * (ABS(H47 - C48) + ABS(L47 - C48) + 10 / 11 * (ABS(H48 - C49) + ABS(L48 - C49) + 10 / 11 * (ABS(H49 - C50) + ABS(L49 - C50) + 10 / 11 * (ABS(H50 - C51) + ABS(L50 - C51) + 10 / 11 * (ABS(H51 - C52) + ABS(L51 - C52) + 10 / 11 * (ABS(H52 - C53) + ABS(L52 - C53) + 10 / 11 * (ABS(H53 - C54) + ABS(L53 - C54) + 10 / 11 * (ABS(H54 - C55) + ABS(L54 - C55) + 10 / 11 * (ABS(H55 - C56) + ABS(L55 - C56) + 10 / 11 * (ABS(H56 - C57) + ABS(L56 - C57) + 10 / 11 * (ABS(H57 - C58) + ABS(L57 - C58) + 10 / 11 * (ABS(H58 - C59) + ABS(L58 - C59) + 10 / 11 * (ABS(H59 - C60) + ABS(L59 - C60) + 10 / 11 * (ABS(H60 - C61) + ABS(L60 - C61) + 10 / 11 * (ABS(H61 - C62) + ABS(L61 - C62) + 10 / 11 * (ABS(H62 - C63) + ABS(L62 - C63) + 10 / 11 * (ABS(H63 - C64) + ABS(L63 - C64) + 10 / 11 * (ABS(H64 - C65) + ABS(L64 - C65) + 10 / 11 * (ABS(H65 - C66) + ABS(L65 - C66) + 10 / 11 * (ABS(H66 - C67) + ABS(L66 - C67) + 10 / 11 * (ABS(H67 - C68) + ABS(L67 - C68) + 10 / 11 * (ABS(H68 - C69) + ABS(L68 - C69) + 10 / 11 * (ABS(H69 - C70) + ABS(L69 - C70) + 10 / 11 * (ABS(H70 - C71) + ABS(L70 - C71) + 10 / 11 * (ABS(H71 - C72) + ABS(L71 - C72) + 10 / 11 * (ABS(H72 - C73) + ABS(L72 - C73)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) - 1

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 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 21) < 1.5 * ((XAVGH21 - XAVGL21) / 2 + .04549783 * (ABS(H - C1) + ABS(L - C1) + 10 / 11 * (ABS(H1 - C2) + ABS(L1 - C2) + 10 / 11 * (ABS(H2 - C3) + ABS(L2 - C3) + 10 / 11 * (ABS(H3 - C4) + ABS(L3 - C4) + 10 / 11 * (ABS(H4 - C5) + ABS(L4 - C5) + 10 / 11 * (ABS(H5 - C6) + ABS(L5 - C6) + 10 / 11 * (ABS(H6 - C7) + ABS(L6 - C7) + 10 / 11 * (ABS(H7 - C8) + ABS(L7 - C8) + 10 / 11 * (ABS(H8 - C9) + ABS(L8 - C9) + 10 / 11 * (ABS(H9 - C10) + ABS(L9 - C10) + 10 / 11 * (ABS(H10 - C11) + ABS(L10 - C11) + 10 / 11 * (ABS(H11 - C12) + ABS(L11 - C12) + 10 / 11 * (ABS(H12 - C13) + ABS(L12 - C13) + 10 / 11 * (ABS(H13 - C14) + ABS(L13 - C14) + 10 / 11 * (ABS(H14 - C15) + ABS(L14 - C15) + 10 / 11 * (ABS(H15 - C16) + ABS(L15 - C16) + 10 / 11 * (ABS(H16 - C17) + ABS(L16 - C17) + 10 / 11 * (ABS(H17 - C18) + ABS(L17 - C18) + 10 / 11 * (ABS(H18 - C19) + ABS(L18 - C19) + 10 / 11 * (ABS(H19 - C20) + ABS(L19 - C20) + 10 / 11 * (ABS(H20 - C21) + ABS(L20 - C21) + 10 / 11 * (ABS(H21 - C22) + ABS(L21 - C22) + 10 / 11 * (ABS(H22 - C23) + ABS(L22 - C23) + 10 / 11 * (ABS(H23 - C24) + ABS(L23 - C24) + 10 / 11 * (ABS(H24 - C25) + ABS(L24 - C25) + 10 / 11 * (ABS(H25 - C26) + ABS(L25 - C26) + 10 / 11 * (ABS(H26 - C27) + ABS(L26 - C27) + 10 / 11 * (ABS(H27 - C28) + ABS(L27 - C28) + 10 / 11 * (ABS(H28 - C29) + ABS(L28 - C29) + 10 / 11 * (ABS(H29 - C30) + ABS(L29 - C30) + 10 / 11 * (ABS(H30 - C31) + ABS(L30 - C31) + 10 / 11 * (ABS(H31 - C32) + ABS(L31 - C32) + 10 / 11 * (ABS(H32 - C33) + ABS(L32 - C33) + 10 / 11 * (ABS(H33 - C34) + ABS(L33 - C34) + 10 / 11 * (ABS(H34 - C35) + ABS(L34 - C35) + 10 / 11 * (ABS(H35 - C36) + ABS(L35 - C36) + 10 / 11 * (ABS(H36 - C37) + ABS(L36 - C37) + 10 / 11 * (ABS(H37 - C38) + ABS(L37 - C38) + 10 / 11 * (ABS(H38 - C39) + ABS(L38 - C39) + 10 / 11 * (ABS(H39 - C40) + ABS(L39 - C40) + 10 / 11 * (ABS(H40 - C41) + ABS(L40 - C41) + 10 / 11 * (ABS(H41 - C42) + ABS(L41 - C42) + 10 / 11 * (ABS(H42 - C43) + ABS(L42 - C43) + 10 / 11 * (ABS(H43 - C44) + ABS(L43 - C44) + 10 / 11 * (ABS(H44 - C45) + ABS(L44 - C45) + 10 / 11 * (ABS(H45 - C46) + ABS(L45 - C46) + 10 / 11 * (ABS(H46 - C47) + ABS(L46 - C47) + 10 / 11 * (ABS(H47 - C48) + ABS(L47 - C48) + 10 / 11 * (ABS(H48 - C49) + ABS(L48 - C49) + 10 / 11 * (ABS(H49 - C50) + ABS(L49 - C50) + 10 / 11 * (ABS(H50 - C51) + ABS(L50 - C51) + 10 / 11 * (ABS(H51 - C52) + ABS(L51 - C52) + 10 / 11 * (ABS(H52 - C53) + ABS(L52 - C53) + 10 / 11 * (ABS(H53 - C54) + ABS(L53 - C54) + 10 / 11 * (ABS(H54 - C55) + ABS(L54 - C55) + 10 / 11 * (ABS(H55 - C56) + ABS(L55 - C56) + 10 / 11 * (ABS(H56 - C57) + ABS(L56 - C57) + 10 / 11 * (ABS(H57 - C58) + ABS(L57 - C58) + 10 / 11 * (ABS(H58 - C59) + ABS(L58 - C59) + 10 / 11 * (ABS(H59 - C60) + ABS(L59 - C60) + 10 / 11 * (ABS(H60 - C61) + ABS(L60 - C61) + 10 / 11 * (ABS(H61 - C62) + ABS(L61 - C62) + 10 / 11 * (ABS(H62 - C63) + ABS(L62 - C63) + 10 / 11 * (ABS(H63 - C64) + ABS(L63 - C64) + 10 / 11 * (ABS(H64 - C65) + ABS(L64 - C65) + 10 / 11 * (ABS(H65 - C66) + ABS(L65 - C66) + 10 / 11 * (ABS(H66 - C67) + ABS(L66 - C67) + 10 / 11 * (ABS(H67 - C68) + ABS(L67 - C68) + 10 / 11 * (ABS(H68 - C69) + ABS(L68 - C69) + 10 / 11 * (ABS(H69 - C70) + ABS(L69 - C70) + 10 / 11 * (ABS(H70 - C71) + ABS(L70 - C71) + 10 / 11 * (ABS(H71 - C72) + ABS(L71 - C72) + 10 / 11 * (ABS(H72 - C73) + ABS(L72 - C73)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

I posted above accidentally wo the comment, apologies, but I wanted to ask how that TTM Squeeze indicator formula compares to the one you just presented.

Bruce, I use BB 21-2 w/SMA and KC 21-1.5 w/EMA, so does your most recent formula posting (4:03 today) match this? (If so, thank you for catching my error. I clearly had the wrong formula based on past discussions.)

Finally, am I correct to be using one formula for the squeeze indicator and one condition formula to identify when they squeeze out?  

Thanks so much for clarifying. I will take care so not to bother you again w/my poor memory/organization.

How would you modify the 21/21/EMA Squeeze formula for KC 13, which I use on hourly chart?

And is there a recommended KC period for 15 and 5 min charts? And what would the formula look like then?

Thanks Bruce.

The formulas are basically the same. One of them is boolean and returns true when the formula returning a numeric value is less than 0. Both formulas use 21-Period Bollinger Bands and Keltner Channels with the Keltner Channels being exponential.

There isn't a recommended period for any particular time frame. The trainers can't give setting, interpretation or investment advice.

The following Indicator Formulas assume you still want the periods of the BB and KC to match, the KC are exponential and all of the widths remain unchanged).

The 13-Period version should be:

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 - 13 * AVGC13 ^ 2) / 13) * 4 / 3 / (XAVGH13 - XAVGL13 + .142996 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + 12 / 14 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 12 / 14 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 12 / 14 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 12 / 14 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 12 / 14 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 12 / 14 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 12 / 14 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 12 / 14 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 12 / 14 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 12 / 14 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 12 / 14 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 12 / 14 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 12 / 14 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 12 / 14 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 12 / 14 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 12 / 14 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 12 / 14 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + 12 / 14 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + 12 / 14 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + 12 / 14 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + 12 / 14 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + 12 / 14 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + 12 / 14 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + 12 / 14 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + 12 / 14 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + 12 / 14 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + 12 / 14 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + 12 / 14 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + 12 / 14 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + 12 / 14 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + 12 / 14 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + 12 / 14 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + 12 / 14 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + 12 / 14 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + 12 / 14 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + 12 / 14 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + 12 / 14 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + 12 / 14 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + 12 / 14 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + 12 / 14 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + 12 / 14 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + 12 / 14 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + 12 / 14 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + 12 / 14 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44))))))))))))))))))))))))))))))))))))))))))))))) - 1

The 15-Period version should be:

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 - 15 * AVGC15 ^ 2) / 15) * 4 / 3 / (XAVGH15 - XAVGL15 + .1251207 * ((H < C1) * (H - C1) + (C1 < L) * (C1 - L) + 14 / 16 * ((H1 < C2) * (H1 - C2) + (C2 < L1) * (C2 - L1) + 14 / 16 * ((H2 < C3) * (H2 - C3) + (C3 < L2) * (C3 - L2) + 14 / 16 * ((H3 < C4) * (H3 - C4) + (C4 < L3) * (C4 - L3) + 14 / 16 * ((H4 < C5) * (H4 - C5) + (C5 < L4) * (C5 - L4) + 14 / 16 * ((H5 < C6) * (H5 - C6) + (C6 < L5) * (C6 - L5) + 14 / 16 * ((H6 < C7) * (H6 - C7) + (C7 < L6) * (C7 - L6) + 14 / 16 * ((H7 < C8) * (H7 - C8) + (C8 < L7) * (C8 - L7) + 14 / 16 * ((H8 < C9) * (H8 - C9) + (C9 < L8) * (C9 - L8) + 14 / 16 * ((H9 < C10) * (H9 - C10) + (C10 < L9) * (C10 - L9) + 14 / 16 * ((H10 < C11) * (H10 - C11) + (C11 < L10) * (C11 - L10) + 14 / 16 * ((H11 < C12) * (H11 - C12) + (C12 < L11) * (C12 - L11) + 14 / 16 * ((H12 < C13) * (H12 - C13) + (C13 < L12) * (C13 - L12) + 14 / 16 * ((H13 < C14) * (H13 - C14) + (C14 < L13) * (C14 - L13) + 14 / 16 * ((H14 < C15) * (H14 - C15) + (C15 < L14) * (C15 - L14) + 14 / 16 * ((H15 < C16) * (H15 - C16) + (C16 < L15) * (C16 - L15) + 14 / 16 * ((H16 < C17) * (H16 - C17) + (C17 < L16) * (C17 - L16) + 14 / 16 * ((H17 < C18) * (H17 - C18) + (C18 < L17) * (C18 - L17) + 14 / 16 * ((H18 < C19) * (H18 - C19) + (C19 < L18) * (C19 - L18) + 14 / 16 * ((H19 < C20) * (H19 - C20) + (C20 < L19) * (C20 - L19) + 14 / 16 * ((H20 < C21) * (H20 - C21) + (C21 < L20) * (C21 - L20) + 14 / 16 * ((H21 < C22) * (H21 - C22) + (C22 < L21) * (C22 - L21) + 14 / 16 * ((H22 < C23) * (H22 - C23) + (C23 < L22) * (C23 - L22) + 14 / 16 * ((H23 < C24) * (H23 - C24) + (C24 < L23) * (C24 - L23) + 14 / 16 * ((H24 < C25) * (H24 - C25) + (C25 < L24) * (C25 - L24) + 14 / 16 * ((H25 < C26) * (H25 - C26) + (C26 < L25) * (C26 - L25) + 14 / 16 * ((H26 < C27) * (H26 - C27) + (C27 < L26) * (C27 - L26) + 14 / 16 * ((H27 < C28) * (H27 - C28) + (C28 < L27) * (C28 - L27) + 14 / 16 * ((H28 < C29) * (H28 - C29) + (C29 < L28) * (C29 - L28) + 14 / 16 * ((H29 < C30) * (H29 - C30) + (C30 < L29) * (C30 - L29) + 14 / 16 * ((H30 < C31) * (H30 - C31) + (C31 < L30) * (C31 - L30) + 14 / 16 * ((H31 < C32) * (H31 - C32) + (C32 < L31) * (C32 - L31) + 14 / 16 * ((H32 < C33) * (H32 - C33) + (C33 < L32) * (C33 - L32) + 14 / 16 * ((H33 < C34) * (H33 - C34) + (C34 < L33) * (C34 - L33) + 14 / 16 * ((H34 < C35) * (H34 - C35) + (C35 < L34) * (C35 - L34) + 14 / 16 * ((H35 < C36) * (H35 - C36) + (C36 < L35) * (C36 - L35) + 14 / 16 * ((H36 < C37) * (H36 - C37) + (C37 < L36) * (C37 - L36) + 14 / 16 * ((H37 < C38) * (H37 - C38) + (C38 < L37) * (C38 - L37) + 14 / 16 * ((H38 < C39) * (H38 - C39) + (C39 < L38) * (C39 - L38) + 14 / 16 * ((H39 < C40) * (H39 - C40) + (C40 < L39) * (C40 - L39) + 14 / 16 * ((H40 < C41) * (H40 - C41) + (C41 < L40) * (C41 - L40) + 14 / 16 * ((H41 < C42) * (H41 - C42) + (C42 < L41) * (C42 - L41) + 14 / 16 * ((H42 < C43) * (H42 - C43) + (C43 < L42) * (C43 - L42) + 14 / 16 * ((H43 < C44) * (H43 - C44) + (C44 < L43) * (C44 - L43) + 14 / 16 * ((H44 < C45) * (H44 - C45) + (C45 < L44) * (C45 - L44) + 14 / 16 * ((H45 < C46) * (H45 - C46) + (C46 < L45) * (C46 - L45) + 14 / 16 * ((H46 < C47) * (H46 - C47) + (C47 < L46) * (C47 - L46) + 14 / 16 * ((H47 < C48) * (H47 - C48) + (C48 < L47) * (C48 - L47) + 14 / 16 * ((H48 < C49) * (H48 - C49) + (C49 < L48) * (C49 - L48) + 14 / 16 * ((H49 < C50) * (H49 - C50) + (C50 < L49) * (C50 - L49) + 14 / 16 * ((H50 < C51) * (H50 - C51) + (C51 < L50) * (C51 - L50) + 14 / 16 * ((H51 < C52) * (H51 - C52) + (C52 < L51) * (C52 - L51)))))))))))))))))))))))))))))))))))))))))))))))))))))) - 1 

I am all set--all is in alignment now.

I hope ;-)

Thanks, Bruce.

You're welcome.