I used the non-centered method of calculating historic volatility by multiplying the standard deviation of the natural log of the daily price changes for each month by the square root of 252, the number of trading days in a year. The spreadsheet can be downloaded here.
@metricsmaestro 