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

Implied Volatility Screener

Written by Ashesh Mathur (Individual Contributor)
Mon Dec 14 2020
Implied Volatility Screener - MarketXLS
See how MarketXLS helps you take advantage in the markets.
Download Option Template →
Implied Volatility Screener - MarketXLS

Implied volatility helps investors gauge future market volatility. It has a positive correlation with the expectation of stock price and is one of the six parameters used to determine the price of an option.
As an options trader, implied volatility is one of the most important factors to be kept in mind while trading. It not only shows how volatile the market might the but can also help to determine the likelihood of a stock reaching a specific price by a certain time.

In this post, I’ll be discussing how to find the options with maximum and minimum implied volatility using MarketXLS.

Step 1: Select stock symbols
Open a new excel worksheet and go to the MarketXLS tab. List down the symbols of stocks for which you want to trade options. You can select up to 40 tickers at one go. Then click on Utilities -> Option Scanner

Select stock symbols

Step 2: Filter Options
Marketxls Stock Screener window will pop up.

Implied Volatility Screener

 

In this window, Options can be filtered by Volume, Moneyness, Expiration, Type, and Strike Price.
First of all, click on remove zero volume contracts to remove all options contracts with no volume.
Now, you can filter down the options as per your need –
• Expiration – include only options that expire from the dates selected from the dropdown.
• Calls or puts – Select from the dropdown if you want a call, put, or any.
• Stock – From all the stocks initially selected, you can filter out the stocks you would like to see from the dropdown.
• Option Type – Select if you want weekly, monthly, or any kind of option.
• Strike Range – Set the sliders to the minimum and maximum prices. Only options with a price between the minimum and maximum prices will be included on the screen.
You can also select the strike from the dropdown.
Nearest strike Above Last (1) – Selects option with strike price just above the current stock price
Nearest strike Above Last (2) – Selects option with strike price just above the current stock price
Nearest strike Below Last (1) – Selects option with strike price just below the current stock price
Nearest strike Below Last (1) – Selects option with strike price just below the current stock price
• Contract Volume – Only options with a daily volume between the minimum and maximum volume will be included on the screen.
• Moneyness – refers to the number of strikes an option is in or out of the money. From the dropdown, you can select in the money, out of the money, or any.

Step 3: Remove Unnecessary columns
Select the columns you wish to remove by simply drag and drop. I have removed vega for demonstration purposes.

Remove Unnecessary columns

Step 4
Click on any column header and select the range of values you wish.

Clear All Filters

You can also click on numeric filters to get a more specific search such as top N options with the highest implied volatility.

Numeric Filter

I have selected the top 6 options with the highest implied volatility of ‘NMTR’ expiring on 21 May 2020.

Top 6

To remove all the filters, click on the bottom left cross mark.

Step 5: Export to Excels
Click on ‘Send these to Excel’ to get the filtered values in a new excel worksheet.
You will get all the data in a new worksheet with the name ‘Option Scanner Data’.

Export to Excel

You can use the ‘qm_last’ function in a new column to get the latest options price.

MarketXLS lets you analyze all the options of over 40 stocks at a time. You get the freedom to filter the options on all important factors. It becomes easier to eliminate options that are not meeting your requirements and give emphasis on those options that are well inside your defined metrics.

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
For further reading on implied volatility click here.

Reverse Iron Condor Template

Get Real-Time Options Pricing in Excel


Use MarketXLS to stream real-time Stock Option Pricing in Excel. Save hundreds of hours searching for reliable financial information and get all the options data you need to make your trading decisions in real-time.

Download Sample Template
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.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today

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

Get started today