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
can be seen in sidebar Figure 1), follow these steps. First, convert the price changes to
percentage daily price basis.