Subject: Re: New Highs and New Lows
Here are the Excel formulas I calculated for this. Hope it saves others some time.
Assuming row 14 (4/1/22) thru 21 (9/1/21)
Column E
=IF(B14=MAX(B14:B20),1,0)
Column F
=IF(C14=MIN(C14:C20),1,0)
Column G
=SUM(E14:E20)
Column H
=SUM(F14:F20)
Column I
=IF(G14>=H14,1,0)