Does anyone know how to analyze this in excel, or a program? Or if someone can write me a program I would be willing to pay. Basically I have a lot of data in excel format on the open and close of a number of trading days (over 1000). I am trying to find how often this stock has moved up (for example) 5 dollars without a retracement of $1. Anyone know how to do this in Excel or any other program? Any help appreciated. thanks!