ARTICLE SYNOPSIS...CALCULATING HISTORICAL VOLATILITY - Technical Analysis, Inc. Historical volatility is the annualized standard deviation of the one-day price changes of the security or futures contract. To perform this calculation in a Microsoft Excel spreadsheet (as ca