So, I've been trying to build an excel sheet that I use to backtest data under certain criteria. However, I want to be able to measure market swings and their retracements with percents. So, like the first swing, the measure what percent it has retraced. Then for the next swing, I want it to measure what percent it has moved more or less compared to the previous swing. I'm going to post a picture showing what I mean...
example1.PNG

If anyone knows how to do this, that'll be much appreciated, thanks!