Calculating Historical Volatility in Excel To calculate the volatility of a given security in a Microsoft Excel spreadsheet, first determine the time frame for which the metric will be computed.