Count number of temperature swings over a 2 month period

[Barque]

I have searched the forums and have not seen a question like this asked:

I am trying to count the number of times Average temperature moves by X %, up or down, over a specified time period, or on a rolling N day lookback.

For example: Over the past 20 days, how many times has Avg Temp moved (ABS, up or down) by 10%, 30%? Over the past 40 days? etc.

I am trying to work things using local min and max values, and countifs but cannot get much traction.

My data looks like the below. Any suggestions or links are appreciated.

 

[maabadi]

I think you can use with helper column and then hide it.
Formula for Helper Column ( first Average temp at C2):

=((C3-C2)/C2)*100

and then Use countif:

=COUNTIF(G2:G19,">"&10)