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

Copied and Patse Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
danielfromcebu
Posted : Tuesday, March 26, 2019 11:42:08 AM
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)))

Bruce_L
Posted : Tuesday, March 26, 2019 12:02:08 PM


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
danielfromcebu
Posted : Tuesday, March 26, 2019 12:31:08 PM
Registered User
Joined: 7/23/2015
Posts: 46

Bruce There is an error for this too..

danielfromcebu
Posted : Tuesday, March 26, 2019 12:41:07 PM
Registered User
Joined: 7/23/2015
Posts: 46

Bruce, I copied and paste to a notepad and still there is still error

danielfromcebu
Posted : Tuesday, March 26, 2019 12:54:48 PM
Registered User
Joined: 7/23/2015
Posts: 46

Bruce I tried again, now it works

Thanks

Bruce_L
Posted : Tuesday, March 26, 2019 12:59:16 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You're welcome.



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