shares / indexes

I have some work, in an Excel spreadsheet. I need to analyse daily sharemarket data for 2 shares and 2 indexes going back 15 years as follows:Where the daily closing price increases or decreases by more than x % over a period of x days, then give me the % increase or decrease in the price x days later.  Eg. Whenever the gold price changed by more than 2% over 2 days, what was the % change in the gold price 10 days later ?