Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.

 Consolidation after recent high Rate this Topic:
 Previous Topic · Next Topic Watch this topic · Print this topic ·
chris100
 Posted : Wednesday, December 05, 2012 12:21:21 PM
Gold Customer

Joined: 7/28/2011
Posts: 14

Is there a way to determine the % difference between a recent high and then the lowest point after that recent high?

Basically what im trying to do is determine if there was a tight consolidation after a stock made a recent high.

Lets say im using MAXH50 intraday and the value of that was 10 bars ago before it broke out to a new high. I want to know what was the low between the MAXH50 and the most recent new high.

Thanks.

Bruce_L
 Posted : Wednesday, December 05, 2012 1:06:07 PM

Worden Trainer

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

OK, I'm doing this without Excel so it is only as good as my typing skills, but you could use the techniques given in the Days Since Last Peak (or other day-counting needs) topic to create something like the following to calculate the low (note that this version of the formula includes the low of the high bar in calculating the lowest low after the high):

ABS(H = MAXH50) * L - NOT(H = MAXH50) * (ABS(H1 = MAXH50) * MINL2 - NOT(H1 = MAXH50) * (ABS(H2 = MAXH50) * MINL3 - NOT(H2 = MAXH50) * (ABS(H3 = MAXH50) * MINL4 - NOT(H3 = MAXH50) * (ABS(H4 = MAXH50) * MINL5 - NOT(H4 = MAXH50) * (ABS(H5 = MAXH50) * MINL6 - NOT(H5 = MAXH50) * (ABS(H6 = MAXH50) * MINL7 - NOT(H6 = MAXH50) * (ABS(H7 = MAXH50) * MINL8 - NOT(H7 = MAXH50) * (ABS(H8 = MAXH50) * MINL9 - NOT(H8 = MAXH50) * (ABS(H9 = MAXH50) * MINL10 - NOT(H9 = MAXH50) * (ABS(H10 = MAXH50) * MINL11 - NOT(H10 = MAXH50) * (ABS(H11 = MAXH50) * MINL12 - NOT(H11 = MAXH50) * (ABS(H12 = MAXH50) * MINL13 - NOT(H12 = MAXH50) * (ABS(H13 = MAXH50) * MINL14 - NOT(H13 = MAXH50) * (ABS(H14 = MAXH50) * MINL15 - NOT(H14 = MAXH50) * (ABS(H15 = MAXH50) * MINL16 - NOT(H15 = MAXH50) * (ABS(H16 = MAXH50) * MINL17 - NOT(H16 = MAXH50) * (ABS(H17 = MAXH50) * MINL18 - NOT(H17 = MAXH50) * (ABS(H18 = MAXH50) * MINL19 - NOT(H18 = MAXH50) * (ABS(H19 = MAXH50) * MINL20 - NOT(H19 = MAXH50) * (ABS(H20 = MAXH50) * MINL21 - NOT(H20 = MAXH50) * (ABS(H21 = MAXH50) * MINL22 - NOT(H21 = MAXH50) * (ABS(H22 = MAXH50) * MINL23 - NOT(H22 = MAXH50) * (ABS(H23 = MAXH50) * MINL24 - NOT(H23 = MAXH50) * (ABS(H24 = MAXH50) * MINL25 - NOT(H24 = MAXH50) * (ABS(H25 = MAXH50) * MINL26 - NOT(H25 = MAXH50) * (ABS(H26 = MAXH50) * MINL27 - NOT(H26 = MAXH50) * (ABS(H27 = MAXH50) * MINL28 - NOT(H27 = MAXH50) * (ABS(H28 = MAXH50) * MINL29 - NOT(H28 = MAXH50) * (ABS(H29 = MAXH50) * MINL30 - NOT(H29 = MAXH50) * (ABS(H30 = MAXH50) * MINL31 - NOT(H30 = MAXH50) * (ABS(H31 = MAXH50) * MINL32 - NOT(H31 = MAXH50) * (ABS(H32 = MAXH50) * MINL33 - NOT(H32 = MAXH50) * (ABS(H33 = MAXH50) * MINL34 - NOT(H33 = MAXH50) * (ABS(H34 = MAXH50) * MINL35 - NOT(H34 = MAXH50) * (ABS(H35 = MAXH50) * MINL36 - NOT(H35 = MAXH50) * (ABS(H36 = MAXH50) * MINL37 - NOT(H36 = MAXH50) * (ABS(H37 = MAXH50) * MINL38 - NOT(H37 = MAXH50) * (ABS(H38 = MAXH50) * MINL39 - NOT(H38 = MAXH50) * (ABS(H39 = MAXH50) * MINL40 - NOT(H39 = MAXH50) * (ABS(H40 = MAXH50) * MINL41 - NOT(H40 = MAXH50) * (ABS(H41 = MAXH50) * MINL42 - NOT(H41 = MAXH50) * (ABS(H42 = MAXH50) * MINL43 - NOT(H42 = MAXH50) * (ABS(H43 = MAXH50) * MINL44 - NOT(H43 = MAXH50) * (ABS(H44 = MAXH50) * MINL45 - NOT(H44 = MAXH50) * (ABS(H45 = MAXH50) * MINL46 - NOT(H45 = MAXH50) * (ABS(H46 = MAXH50) * MINL47 - NOT(H46 = MAXH50) * (ABS(H47 = MAXH50) * MINL48 - NOT(H47 = MAXH50) * (ABS(H48 = MAXH50) * MINL49 - NOT(H48 = MAXH50) * MINL50))))))))))))))))))))))))))))))))))))))))))))))))

The percent change from the high to the low would be:

100 * ((ABS(H = MAXH50) * L - NOT(H = MAXH50) * (ABS(H1 = MAXH50) * MINL2 - NOT(H1 = MAXH50) * (ABS(H2 = MAXH50) * MINL3 - NOT(H2 = MAXH50) * (ABS(H3 = MAXH50) * MINL4 - NOT(H3 = MAXH50) * (ABS(H4 = MAXH50) * MINL5 - NOT(H4 = MAXH50) * (ABS(H5 = MAXH50) * MINL6 - NOT(H5 = MAXH50) * (ABS(H6 = MAXH50) * MINL7 - NOT(H6 = MAXH50) * (ABS(H7 = MAXH50) * MINL8 - NOT(H7 = MAXH50) * (ABS(H8 = MAXH50) * MINL9 - NOT(H8 = MAXH50) * (ABS(H9 = MAXH50) * MINL10 - NOT(H9 = MAXH50) * (ABS(H10 = MAXH50) * MINL11 - NOT(H10 = MAXH50) * (ABS(H11 = MAXH50) * MINL12 - NOT(H11 = MAXH50) * (ABS(H12 = MAXH50) * MINL13 - NOT(H12 = MAXH50) * (ABS(H13 = MAXH50) * MINL14 - NOT(H13 = MAXH50) * (ABS(H14 = MAXH50) * MINL15 - NOT(H14 = MAXH50) * (ABS(H15 = MAXH50) * MINL16 - NOT(H15 = MAXH50) * (ABS(H16 = MAXH50) * MINL17 - NOT(H16 = MAXH50) * (ABS(H17 = MAXH50) * MINL18 - NOT(H17 = MAXH50) * (ABS(H18 = MAXH50) * MINL19 - NOT(H18 = MAXH50) * (ABS(H19 = MAXH50) * MINL20 - NOT(H19 = MAXH50) * (ABS(H20 = MAXH50) * MINL21 - NOT(H20 = MAXH50) * (ABS(H21 = MAXH50) * MINL22 - NOT(H21 = MAXH50) * (ABS(H22 = MAXH50) * MINL23 - NOT(H22 = MAXH50) * (ABS(H23 = MAXH50) * MINL24 - NOT(H23 = MAXH50) * (ABS(H24 = MAXH50) * MINL25 - NOT(H24 = MAXH50) * (ABS(H25 = MAXH50) * MINL26 - NOT(H25 = MAXH50) * (ABS(H26 = MAXH50) * MINL27 - NOT(H26 = MAXH50) * (ABS(H27 = MAXH50) * MINL28 - NOT(H27 = MAXH50) * (ABS(H28 = MAXH50) * MINL29 - NOT(H28 = MAXH50) * (ABS(H29 = MAXH50) * MINL30 - NOT(H29 = MAXH50) * (ABS(H30 = MAXH50) * MINL31 - NOT(H30 = MAXH50) * (ABS(H31 = MAXH50) * MINL32 - NOT(H31 = MAXH50) * (ABS(H32 = MAXH50) * MINL33 - NOT(H32 = MAXH50) * (ABS(H33 = MAXH50) * MINL34 - NOT(H33 = MAXH50) * (ABS(H34 = MAXH50) * MINL35 - NOT(H34 = MAXH50) * (ABS(H35 = MAXH50) * MINL36 - NOT(H35 = MAXH50) * (ABS(H36 = MAXH50) * MINL37 - NOT(H36 = MAXH50) * (ABS(H37 = MAXH50) * MINL38 - NOT(H37 = MAXH50) * (ABS(H38 = MAXH50) * MINL39 - NOT(H38 = MAXH50) * (ABS(H39 = MAXH50) * MINL40 - NOT(H39 = MAXH50) * (ABS(H40 = MAXH50) * MINL41 - NOT(H40 = MAXH50) * (ABS(H41 = MAXH50) * MINL42 - NOT(H41 = MAXH50) * (ABS(H42 = MAXH50) * MINL43 - NOT(H42 = MAXH50) * (ABS(H43 = MAXH50) * MINL44 - NOT(H43 = MAXH50) * (ABS(H44 = MAXH50) * MINL45 - NOT(H44 = MAXH50) * (ABS(H45 = MAXH50) * MINL46 - NOT(H45 = MAXH50) * (ABS(H46 = MAXH50) * MINL47 - NOT(H46 = MAXH50) * (ABS(H47 = MAXH50) * MINL48 - NOT(H47 = MAXH50) * (ABS(H48 = MAXH50) * MINL49 - NOT(H48 = MAXH50) * MINL50))))))))))))))))))))))))))))))))))))))))))))))))) / MAXH50 - 1)

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
chris100
 Posted : Wednesday, December 05, 2012 1:25:29 PM
Gold Customer

Joined: 7/28/2011
Posts: 14

thanks bruce!

Bruce_L
 Posted : Wednesday, December 05, 2012 1:31:27 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 Customer Training & Support - Ask a Trainer - TC2000 version 12/18 - Ask a Trainer - TC2000 version 7 - Ask a Trainer - StockFinder 5.0 - PCFs, EasyScan and Custom Indicators General Discussions - Stock and Market Talk - TC2000 version 12 or 18 - TC2000 version 7 - StockFinder 5.0 - RealCode for StockFinder 5.0 Tutorial Videos - TC2000 version 12 tutorial videos - TC2000 version 7 tutorial videos 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.