New version 18 available now


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


New account application Trading resources
Margin rates Stock & option commissions

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

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 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: 64,082

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 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: 64,082

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.