NUMBER OF DAYS SINCE 2% PULLBACK

[excelbetter]

I am doing a project and need to find a way to count the number of days since a 2% pullback in a given stock.

The way I think about this is that I need to find the "recent" high in a given stock price, and count the # of days since there has been a 2% pullback in the stock.

I envision the raw data having two columns.

Column A = Date
Column B = Closing Price of the stock

Any ideas of how to do this?

Any help is greatly appreciated!!

TY

 

[etaf]

how are you calculating the 2% ?
difference between previous cell

Column C = (B1-B2)/B1

will this happen multiple times or just for one trough so to speak
COUNTIF( range , "<="&0.02)
but that will count all the range below 2%

Perhaps a sample of the data and expected result would help
you can use XL2BB see menu or my signature , to post a sample
Or link to dropbox / onedrive - although the XL2BB is preferred as it stays on the forum , for people searching, where as a link can disappear