re: "Basically, you need to define how a 'drop' both ends and begins."
I understand that. I am still formulating the details.
My gut is telling me that some implementation of the HIGHEST(CLOSE,nn) and LOWEST(CLOSE,nn) functions with a sliding date window is the way to go.
Start with the earliest...