Implied Volatility Function: Returns the annualized volatility of an underlying security implied by the market price of a European call or put option on that security, based on Black-Scholes valuation.

For each Excel Function that calculates an Option Greek or other Options statistic, there are certain parameters required as shown in the formula(s) above. Not all functions use all parameters. Here is a description of each parameter:

- OptionType: "C" or "P"
- UnadjustedPrice: Current price of the underlying Stock.
- StrikePrice: Strike Price (aka Excercise Price).
- StartDate: Usually the current Date and Time. You can use the "Now()" Function in Excel to provide this or enter a Date and Time.
- EndDate: Expiration Date and Time.
- OptionPremium: Current Option price.
- RiskFreeRate: Annualized risk-free rate of interest corresponding a period roughly equal to the remaining life of the option, expressed in continuous compounding terms (see ContCompRate function). Leave empty for 0.
- DividendYield: The annualized dividend yield of the underlying security, expressed in continuous compounding terms (see ContCompRate function). Leave empty for 0.
- WeekdaysOnlyMode: 0 or omitted = OFF; 1 = ON.
- Precision: The acceptable error for the function's result. By default this function will return a correct value ±0.1% (±0.001). Since the function iterates to return its value, setting a higher value will speed up execution. The lower the Value, the more precise your result will be. Example: If the actual implied volatility is 20%, setting "Precision" to .005 will cause the function to return a value between 19.95% and 20.05%.

WeekdaysOnlyMode: Whethere to include or not include weekends and holidays in your Implied Volatility calculation is a personal preference. Generally, markets are closed on weekends and holidays and some say for this reason, WeekdaysOnlyMode should be set to "ON" thereby calculating an Implied Volatility based on roughly a 252 Day Trading year. Personally, I prefer if off because it's a more accurate representation of a true year and because those that are short options over a weekend still get paid which means the market is really never closed!

StartDate and EndDate: These are not affected based on how WeekDaysOnly Mode is set. Using actual Calendar dates and times when entering the StartDate and EndDate values is the most accurate way to go.

European vs American call options have the same theoretical value. However American Puts are more difficult to value than European Puts. Most professionals agree that the Black-Scholes model provides a reasonably accurate estimation of value.