Maximum Drawdown in VBA

This VBA function and the accompanying Excel spreadsheet calculate the maximum drawdown of a series of investment returns. The maximum drawdown is the largest percentage drop in asset price over a specified time period.