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.

The price of time is influenced by various factors, such as the time until expiration, stock price, strike price, and interest rates. Still, none of these is as significant as implied volatility.