ImpliedVolatilityEx (Function)

The ImpliedVolatilityEx function calculates the market implied volatility for the specified option.

ImpliedVolatilityEx(DaysLeft, StrikePr, Rate100, MktVal, PutCall, AssetPr);

A numeric value representing the implied volatility of the specified option.

Name	Type	Description
DaysLeft	Numeric	Sets the number of days until option expiration. This can be passed in as partial days, if desired (e.g., 5.23)
StrikePr	Numeric	Sets the strike price of the option.
Rate100	Numeric	Sets the short-term risk free interest rate, usually the 90-day T-Bill, as a percentage (enter 4.9 for 4.9%).
MktVal	Numeric	Sets the market value of the option.
PutCall	Numeric	Sets if it is a Put or Call option. Put or 2 = Puts; Call or 3 = Calls.
AssetPr	Numeric	Sets the price of underlying asset.

Assigns to Value1 the market implied volatility of a 70 strike Call option expiring in 12 days with the short-term 90-day T-Bill at 4.9%.

Value1 = ImpliedVolatilityEx(12, 70, 4.9, 8.125, Call, 73.875);