Find Non-Periodic Maxima & Minima of a Set of Stock Market Data

Hello there!

I have searched far and wide for an answer to this question, but have yet to find one. My question is this: How does one take a set of fairly noisy stock data and locate local maxima and minima for a given appreciation / depreciation event (positive / negative reversal)?

Here are my criteria that I would ideally like to maintain as variable inputs.

The minimum appreciation of the stock price in order to be identified as a significant trend should be 3.33%
The minimum depreciation of the stock price in order to be identified as a significant trend should be -3.33%

Ultimately, I am trying to develop a summary of the dates that correspond to every instance of the maximum / minimum point of the data, which lies between price trends that meet the appreciation and depreciation criteria.

In one of my many attempts at solving this problem, I developed a table of every possible appreciation / depreciation event that occur for the given set of data. I tried to use this information to map out bearish and bullish (negative & positive) reversals, but couldn't quite make it work. I have attached a representative sample of data that includes the date and corresponding price. Unfortunately the appreciation / depreciation scenario spreadsheet is too big to attach (3MB). If you deem this to be integral to a solution, then I will try and find a way to upload it.

Your help is much appreciated. Thanks in advance for your time.

Anyone have an idea?

......Bump