The Expected Price Movement Calculator is designed to generate an approximate projected trading range for the underlying security, specific for selected contract expiration date. The at-the-money implied volatility (IV) of the stock or ETF (exchange-traded fund) is used to achieve this valuable information.

Inherent in the spreadsheet is a conversion formula that recalibrates the annualized IV stat into one specific for the contract being traded. Easily accessed option-chain data is entered into the white cells at the top of the spreadsheet and calculations will appear in the yellow cells below.