excelbetter
Board Regular
- Joined
- Oct 13, 2010
- Messages
- 190
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
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