OptionsScreenersStock investments

Implied Volatility Screener

Written by Ashesh Mathur (Individual Contributor)
Mon Dec 14 2020
Export to Excel
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
Export to Excel
 

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.

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

Top 100 Gainers Today

Top 100 losers Today

Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

CRA InternationalInc. logo

CRA InternationalInc.

89.32
 
USD
 
1.50
 
(1.71%)
81
Rank
Optionable: Yes
Market Cap: 646 M
Industry: Business Services
52 week range    
78.05   
   115.47
Booz Allen Hamilton Holding Corporation logo

Booz Allen Hamilton Holding Corporation

90.36
 
USD
 
1.83
 
(2.07%)
81
Rank
Optionable: Yes
Market Cap: 11,592 M
Industry: Business Services
52 week range    
69.32   
   90.99
Gaming and Leisure Properties Inc. logo

Gaming and Leisure Properties Inc.

45.86
 
USD
 
-0.26
 
(-0.56%)
79
Rank
Optionable: Yes
Market Cap: 11,555 M
Industry: REIT - Diversified
52 week range    
40.57   
   48.57
General Mills Inc. logo

General Mills Inc.

75.45
 
USD
 
0.73
 
(0.98%)
79
Rank
Optionable: Yes
Market Cap: 42,311 M
Industry: Packaged Foods
52 week range    
55.38   
   75.00
Sanderson Farms Inc. logo

Sanderson Farms Inc.

215.53
 
USD
 
-3.08
 
(-1.41%)
78
Rank
Optionable: Yes
Market Cap: 4,908 M
Industry: Packaged Foods
52 week range    
175.42   
   221.63
Ituran Location and Control Ltd. logo

Ituran Location and Control Ltd.

24.49
 
USD
 
0.01
 
(0.04%)
77
Rank
Optionable: Yes
Market Cap: 504 M
Industry: Communication Equipment
52 week range    
19.61   
   29.50
Republic Services Inc. logo

Republic Services Inc.

130.87
 
USD
 
1.12
 
(0.86%)
76
Rank
Optionable: Yes
Market Cap: 40,406 M
Industry: Waste Management
52 week range    
109.24   
   145.00
ConAgra Brands Inc. logo

ConAgra Brands Inc.

34.24
 
USD
 
-0.09
 
(-0.26%)
76
Rank
Optionable: Yes
Market Cap: 16,287 M
Industry: Packaged Foods
52 week range    
29.80   
   36.67
Penske Automotive Group Inc. logo

Penske Automotive Group Inc.

104.69
 
USD
 
-5.36
 
(-4.87%)
75
Rank
Optionable: Yes
Market Cap: 8,406 M
Industry: Auto & Truck Dealerships
52 week range    
71.77   
   123.60
Franklin Covey Company logo

Franklin Covey Company

46.18
 
USD
 
8.15
 
(21.43%)
75
Rank
Optionable: Yes
Market Cap: 557 M
Industry: Education & Training Services
52 week range    
33.41   
   52.52

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!