Calculating drawdowns from 52 week highs

Here’s a post to a blog article on how to calculate drawdowns from a 52 week high, including the current, maximum, and 1 year average:

Calculating Drawdowns

Attached is workbook for the S&P500 companies showing max and average 52 week drawdowns:

Drawdowns.owb (214 KB)