Registered User 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.
|
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
|
Registered User Joined: 7/28/2011 Posts: 14
|
thanks bruce!
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|