Hi Bruce.. Have this condition for stock that closes avbove upper BollingerBand. Would like to have one that shows same condition for YESTERDAY.. Any easy way to do this? 

C > AVGC21 + 2 * SQR(((C - AVGC21) ^ 2 + (C1 - AVGC21) ^ 2 + (C2 - AVGC21) ^ 2 + (C3 - AVGC21) ^ 2 + (C4 - AVGC21) ^ 2 + (C5 - AVGC21) ^ 2 + (C6 - AVGC21) ^ 2 + (C7 - AVGC21) ^ 2 + (C8 - AVGC21) ^ 2 + (C9 - AVGC21) ^ 2 + (C10 - AVGC21) ^ 2 + (C11 - AVGC21) ^ 2 + (C12 - AVGC21) ^ 2 + (C13 - AVGC21) ^ 2 + (C14 - AVGC21) ^ 2 + (C15 - AVGC21) ^ 2 + (C16 - AVGC21) ^ 2 + (C17 - AVGC21) ^ 2 + (C18 - AVGC21) ^ 2 + (C19 - AVGC21) ^ 2 + (C20 - AVGC21) ^ 2) / 20

You need to add 1 to all of the bars ago parameters.

C1 > AVGC21.1 + 2 * SQR(((C1 - AVGC21.1) ^ 2 + (C2 - AVGC21.1) ^ 2 + (C3 - AVGC21.1) ^ 2 + (C4 - AVGC21.1) ^ 2 + (C5 - AVGC21.1) ^ 2 + (C6 - AVGC21.1) ^ 2 + (C7 - AVGC21.1) ^ 2 + (C8 - AVGC21.1) ^ 2 + (C9 - AVGC21.1) ^ 2 + (C10 - AVGC21.1) ^ 2 + (C11 - AVGC21.1) ^ 2 + (C12 - AVGC21.1) ^ 2 + (C13 - AVGC21.1) ^ 2 + (C14 - AVGC21.1) ^ 2 + (C15 - AVGC21.1) ^ 2 + (C16 - AVGC21.1) ^ 2 + (C17 - AVGC21.1) ^ 2 + (C18 - AVGC21.1) ^ 2 + (C19 - AVGC21.1) ^ 2 + (C20 - AVGC21.1) ^ 2 + (C21 - AVGC21.1) ^ 2) / 20

thanks.. I just tried that.. says theres an unattached parentthesis at 476?  Wont verify

i cant find any unattached )

It is because your original is messed up. Try testing it....

I think it is just missing the closing parenthesis at the end. So your original should be as follows.

C > AVGC21 + 2 * SQR(((C - AVGC21) ^ 2 + (C1 - AVGC21) ^ 2 + (C2 - AVGC21) ^ 2 + (C3 - AVGC21) ^ 2 + (C4 - AVGC21) ^ 2 + (C5 - AVGC21) ^ 2 + (C6 - AVGC21) ^ 2 + (C7 - AVGC21) ^ 2 + (C8 - AVGC21) ^ 2 + (C9 - AVGC21) ^ 2 + (C10 - AVGC21) ^ 2 + (C11 - AVGC21) ^ 2 + (C12 - AVGC21) ^ 2 + (C13 - AVGC21) ^ 2 + (C14 - AVGC21) ^ 2 + (C15 - AVGC21) ^ 2 + (C16 - AVGC21) ^ 2 + (C17 - AVGC21) ^ 2 + (C18 - AVGC21) ^ 2 + (C19 - AVGC21) ^ 2 + (C20 - AVGC21) ^ 2) / 20)

And the altered version becomes the following.

C1 > AVGC21.1 + 2 * SQR(((C1 - AVGC21.1) ^ 2 + (C2 - AVGC21.1) ^ 2 + (C3 - AVGC21.1) ^ 2 + (C4 - AVGC21.1) ^ 2 + (C5 - AVGC21.1) ^ 2 + (C6 - AVGC21.1) ^ 2 + (C7 - AVGC21.1) ^ 2 + (C8 - AVGC21.1) ^ 2 + (C9 - AVGC21.1) ^ 2 + (C10 - AVGC21.1) ^ 2 + (C11 - AVGC21.1) ^ 2 + (C12 - AVGC21.1) ^ 2 + (C13 - AVGC21.1) ^ 2 + (C14 - AVGC21.1) ^ 2 + (C15 - AVGC21.1) ^ 2 + (C16 - AVGC21.1) ^ 2 + (C17 - AVGC21.1) ^ 2 + (C18 - AVGC21.1) ^ 2 + (C19 - AVGC21.1) ^ 2 + (C20 - AVGC21.1) ^ 2 + (C21 - AVGC21.1) ^ 2) / 20)

Ok thx.. funny the original seems to work..Ill try it..

Your original really doesn't work as posted in the forums actually. It could just be a copy and past error when going from the program into the forums (it happens to me sometimes).

that was it.. for some reason that last ) didnt copy when i pasted it..

Thanks!!

You're welcome.