Folks: How to find out when a new 52 week Low was set in the past 90 days?. I'd like to find the date or the barssince this occured.
FiftyTwoWeek_Low=L <=LLV(low,252); FiftyTwoWeek_Low_New=FiftyTwoWeek_Low and Ref(FiftyTwoWeek_Low,-1)==0; But once a new 52 week low is cut below, new 52 week low emerges and if trend continues, we will have new 52 week lows everyday. What I am looking for is the VERY FIRST occurance of the "FiftyTwoWeek_Low_New" in the past 90 days. Any thoughts on this?. Thanks,Padhu
