I am working on a project that entails comparing daily prices for 200+ bonds, organized by date. Is there such a formula that exists that can help me to do the following:
1. Find three or more consecutive days where there are equal increments (+ or -) of bond prices fluctuated?
2. Find three or more consecutive days where these prices fluctuated (equally) by more than $1.00 at a time?
If ANYONE has any guidance on this, it would be greatly appreciated, as finding this answer would save me days of extra manual work!