Finding lowest low in a pullback

[sam mcgee]

In a series of rising pricebars for a stock, I'm trying to find the
value of the lowest low in a pullback. I have to find this low value
separate from price bars that preceded the pullback.

The maximum number of bars I look back is 6, but in those 6 bars there
may be lower lows before the pullback started. The pullback starts when
one of the highs is lower than the previous high.

I've attached pictures to clarify what I'm trying to do. Does anyone
have any ideas? Thank you for your help.


+-------------------------------------------------------------------+
|Filename: pullback spreadsheet.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4194 |
+-------------------------------------------------------------------+

 

[Domenic]

Try...

=IF(COUNTIF(D2:INDEX(D29,MATCH(2,1/(D29=MAX(D29)))),"<"&MAX(D29)),MIN(D2:INDEX(D29,MATCH(2,1/(D29=MAX(D29))))),"No
Lessor Values after Peak")

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Adjust the
range accordingly.

Hope this helps!