Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

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

Written by  MarketXLS Team on 
Tue Nov 17 2020
 about OptionsOptions strategies
Volatility Surface Chart (It’S Impact On The Profitability Of Option Trades) - MarketXLS

Meet The Ultimate Excel Solution for Investors

  • Live Streaming Prices Prices in your Excel
  • All historical (intraday) data in your Excel
  • Real time option greeks and analytics in your Excel
  • Leading data in Excel service for Investment Managers, RIAs, Asset Managers, Financial Analysts, and Individual Investors.
  • Easy to use with formulas and pre-made sheets
Volatility Surface Chart (It’S Impact On The Profitability Of Option Trades) - MarketXLS

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

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 Surface Chart (It’S Impact On The Profitability Of Option Trades)

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 Chart (It’S Impact On The Profitability Of Option Trades)

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.


Implied Volatility Surface for AAPL

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

Conclusion
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

Disclaimer

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.

References:

Volatility smile and skew, here.

visualizing the volatility surface, here.

 

 

Ad slot not ready
#1 Excel Solution for Investors

Get Market data in Excel easy to use formulas

  • Real-time Live Streaming Option Prices & Greeks in your Excel
  • Historical (intraday) Options data in your Excel
  • All US Stocks and Index options are included
  • Real-time Option Order Flow
  • Real-time prices and data on underlying stocks and indices
  • Works on Windows, MAC or even online
  • Implement MarketXLS formulas in your Excel sheets and make them come alive
  • Save hours of time, streamline your option trading workflows
  • Easy to use with formulas and pre-made templates
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University

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

Get started today

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord