Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Size and subsequent Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
0002ct
Posted : Wednesday, November 29, 2017 2:31:12 PM
Registered User
Joined: 11/19/2015
Posts: 459

Hello.

I'm looking to build a specific 200-day count where, count true if:

-the current bar's range is at least 23% bigger than the previous bar's range
-price then went up a minimum of 33% within the subsequent (to the range criteria-event above) three bars

If possible, would the price gain be measured from the low of the initial-range bar.

Hopefully this makes sense. Thank you very much for taking a look.

 

 

0002ct
Posted : Wednesday, November 29, 2017 2:38:09 PM
Registered User
Joined: 11/19/2015
Posts: 459

"Nothing can make sense if you don't bother reading before you hit post," I said to me.
 

If possible, please measure the price gain from the low of the initial-range bar.

 
Bruce_L
Posted : Wednesday, November 29, 2017 2:49:28 PM


Worden Trainer

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

If you want to exclude everything but the low of the initial range bar from the percent change calculations (so calculate the percent change from only after the period where the signal initial signal has triggered).

CountTrue(MAXH3 >= 1.33 * L3 AND H3 - L3 >= 1.23 * (H4 - L4), 200)

If you want to include the close of the initial range bar in the percent change calculations (this has to have happened after the low).

CountTrue(GREATEST(MAXH3, C3) >= 1.33 * L3 AND H3 - L3 >= 1.23 * (H4 - L4), 200)

If you want to include the high of the initial range bar in the percent change calculations (there is no guarantee this happened after the low).

CountTrue(MAXH4 >= 1.33 * L3 AND H3 - L3 >= 1.23 * (H4 - L4), 200)

Note that the above allow for three bars after the initial range bar, not including the initial range bar.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
0002ct
Posted : Wednesday, November 29, 2017 2:56:27 PM
Registered User
Joined: 11/19/2015
Posts: 459

Yes, these are great. Bruce, thank you for your incredible problem solving and fast help.

 

0002ct
Posted : Thursday, December 14, 2017 2:00:19 PM
Registered User
Joined: 11/19/2015
Posts: 459

Bruce, circling back to this, if I want to create a signal to watch for the intial condition (the current range compared to the last range, percent difference), is this correct?

-the current bar's range is at least 23% bigger than the previous bar's range

H - L >= 1.23 * (H1 - L1)

Thank you very much for taking a look.

Bruce_L
Posted : Thursday, December 14, 2017 2:36:43 PM


Worden Trainer

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

Yes, that is correct, but you may want to check that the current bar has range.

H - L >= 1.23 * (H1 - L1) AND H > L

Or possibly even that the previous bar has range.

H - L >= 1.23 * (H1 - L1) AND H1 > L1



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
0002ct
Posted : Thursday, December 14, 2017 2:37:38 PM
Registered User
Joined: 11/19/2015
Posts: 459

Thanks, Bruce. I wouldn't have thought of that. 

Much appreciated. Thanks again.

Bruce_L
Posted : Thursday, December 14, 2017 2:51:14 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.