Registered User Joined: 7/23/2015 Posts: 46
|
Bruce says there is an Error....
Hi:
This produces a signal when the price goes below the bottom Bollinger Band and then is followed by the next green candle. I've used it successfully as a buy signal & need help making it now do the opposite (price goes above top Bollinger Band followed by next red candle). Thanks, Fred
C > O AND ((L1 <= AVGC20.1 - 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 - 20 * AVGC20.1 ^ 2) / 20) AND L2 > AVGC20.2 - 2 * SQR(ABS(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 - 20 * AVGC20.2 ^ 2) / 20)) OR (C1 <= O1 AND L2 <= AVGC20.2 - 2 * SQR(ABS(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 - 20 * AVGC20.2 ^ 2) / 20) AND L3 > AVGC20.3 - 2 * SQR(ABS(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 - 20 * AVGC20.3 ^ 2) / 20)) OR (C1 <= O1 AND C2 <= O2 AND L3 <= AVGC20.3 - 2 * SQR(ABS(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 - 20 * AVGC20.3 ^ 2) / 20) AND L4 > AVGC20.4 - 2 * SQR(ABS(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 - 20 * AVGC20.4 ^ 2) / 20)))
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Let's start by shortening that a bit using newer syntax.
C > O AND (XDOWN(L1, BBBOT(2, 20, 1)) OR (C1 <= O1 AND XDOWN(L2, BBBOT(2, 20, 2))) OR (C1 <= O1 AND C2 <= O2 AND XDOWN(L3, BBBOT(2, 20, 3))))
That should make inverting it a bit easier.
C < O AND (XUP(H1, BBTOP(2, 20, 1)) OR (C1 >= O1 AND XUP(H2, BBTOP(2, 20, 2))) OR (C1 >= O1 AND C2 >= O2 AND XUP(H3, BBTOP(2, 20, 3))))
If the issue is actually the copy and paste, try copying the formula into a text editor (so something like Notepad and not a word processor such as Word). Then copy and paste from the text editor into TC2000.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 7/23/2015 Posts: 46
|
Bruce There is an error for this too..
|
Registered User Joined: 7/23/2015 Posts: 46
|
Bruce, I copied and paste to a notepad and still there is still error
|
Registered User Joined: 7/23/2015 Posts: 46
|
Bruce I tried again, now it works
Thanks
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|