Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS
OptionsOptions strategies

Volatility Surface Chart (It’S Impact On The Profitability Of Option Trades)

Written by admin
Tue Nov 17 2020
Implied Volatility Surface for AAPL
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
Implied Volatility Surface for AAPL

Volatility surface is the plot that can help you determine the best combination of the strike and the expiry date to maximize the profits on an Options Trade.


Volatility is basically the fluctuation in the price of a product or a derivative. The more is the swing, the more is the volatility. There are many factors that cause volatility in the market, major ones being the increase in market participants and their anticipation of the market in the near future. Volatility is a very useful tool, especially for trading options. The profitability of an options trade revolves around volatility. However, an option seller is better off only when there is less volatility. But, volatility is also used by sellers to hedge their funds against sharp falls in stock prices.

For example, an option buyer will profit only from a huge move in the stock price as he has to pay a premium to the seller and he will have to earn at least equal to the premium to breakeven. We will discuss different types of volatility and how an options trader can gain from volatility in the market.

Volatility surface

Types of volatility
Volatility is broadly divided into two parts, historical and implied. Historical volatility is calculated on past data. It can be calculated using basic statistical tools like Standard deviation and variances in excel. But for a trader, historical data is bare of any use, and only the ability to forecast future volatility would help a trader to design strategies to maximize profits. And, this forecasting of future volatility is called implied volatility. It doesn’t give the exact data about volatility but it gives a rough idea to start with.

Implied volatility is calculated based on the news, good or bad that is to occur during the lifetime of an option. It also takes into account the current stock price and the strike price of the option.

Black-Scholes model (BSM)
This particular model cannot be overlooked while talking about volatility. It was a formula developed by three economists – Fischer Black, Myron Scholes, and Robert Merton in 1973. It was developed to calculate future option prices based on call option price, current stock price, strike price, risk-free rate, and time to maturity. But it had its own drawbacks. Firstly, it is only applicable to European markets, where the options can only be traded on the date of expiry, while in US markets an option can be traded prior to the date of maturity.

One more shortcoming of the model was observed after the “Black Monday” stock market crisis in 1987. The volatility of the same options was varying while BSM assumes the volatility to be constant for the same options while calculating Price. It was observed that the same options with different strike prices or maturity showed different changes in volatility. This gave rise to a new concept “Volatility smile” or “volatility skew”.

Volatility smile
It derives its name from the fact that when implied volatility is plotted against various strike prices the graph looks like a smile. The implied volatility is far from being flat which contradicts the BSM model. From the image below, we can say that implied volatility is high when the price is far from the strike price and decreases when the price approaches the strike price from either side. But it doesn’t always work this way.

Graphs are found to be skewed to their left or right based on market sentiments.

Volatility skew
volatility skew arises when the graph is not symmetric and is skewed towards left or right. Here we will discuss only left skew as it is more commonly seen in the markets, which is also known as reverse skewed.

Reverse skew happens when the IV is more on the put side because most of the options buyers are anticipating the stock to go down. There can be many reasons like news and the fact that most options traders are long on stocks and they want to hedge against a possible fall in the stock price. Forward skew is exactly the opposite.

Volatility surface
We have already seen how IV reacts to various strike prices. When we include the expiry date, we get a 3-dimensional structure which is known as the volatility surface.

A volatility surface is basically a plot to examine the best possible scenario based on the strike price and expiry date for the maximization of profits from an options trade. Normally, Options with a shorter time to maturity have multiple times the volatility compared to options with longer maturities.


AAPL.png”>AAPL.png” alt=”Implied Volatility Surface for AAPL” width=”1067″ height=”671″ />

Figure 4: Plot of IV against days to expiration and strike price.


To sum up, there are three major parameters an options trader should look into while buying or selling options which are implied volatility, strike price, and time to expiry. A good combination of these three can not only help a trader maximize his profits but also hedge his funds against huge losses. Normally a short expiry period and a strike price far from an anticipated price are preferred.

There are many strategies based on implied volatility. Some of them are listed below:
● Call spreads
Put spreads
● Long straddle
● Strip straddle
● Short condor spread
● Short butterfly spread
● Short albatross spread


None of the content published on marketxls.com constitutes a recommendation that any particular security, portfolio of securities, transaction, or investment strategy is suitable for any specific person. The author is not offering any professional advice of any kind. The reader should consult a professional financial advisor to determine their suitability for any strategies discussed herein.


Volatility smile and skew, here.

visualizing the volatility surface, here.



Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates
Stock screens
Public saved screens

Top 100 Gainers Today

Top 100 losers Today

Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONSGet started today
Search for a stock

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

Top MarketXLS Rank stocks

Dick's Sporting Goods Inc logo

Dick's Sporting Goods Inc

Optionable: Yes
Market Cap: 8,757 M
Industry: Specialty Retail
52 week range    
Academy Sports and Outdoors Inc logo

Academy Sports and Outdoors Inc

Optionable: Yes
Market Cap: 3,614 M
Industry: Beer, Wine, and Liquor Stores
52 week range    
Texas Roadhouse Inc. logo

Texas Roadhouse Inc.

Optionable: Yes
Market Cap: 5,743 M
Industry: Restaurants
52 week range    
Destination XL Group Inc. logo

Destination XL Group Inc.

Optionable: No
Market Cap: 340 M
Industry: Apparel Stores
52 week range    
Annaly Capital Management Inc logo

Annaly Capital Management Inc

Optionable: Yes
Market Cap: 8,363 M
Industry: REIT - Diversified
52 week range    
BJ's Wholesale Club Holdings Inc. logo

BJ's Wholesale Club Holdings Inc.

Optionable: Yes
Market Cap: 10,268 M
Industry: Specialty Retail
52 week range    
Waste Connections Inc. logo

Waste Connections Inc.

Optionable: Yes
Market Cap: 35,409 M
Industry: Waste Management
52 week range    
STORE Capital Corporation logo

STORE Capital Corporation

Optionable: Yes
Market Cap: 8,941 M
Industry: REIT - Diversified
52 week range    
Sprouts Farmers Market Inc. logo

Sprouts Farmers Market Inc.

Optionable: Yes
Market Cap: 2,909 M
Industry: Grocery Stores
52 week range    
Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

Optionable: Yes
Market Cap: 7,483 M
Industry: Auto & Truck Dealerships
52 week range    

More Features