Option Scanner

As an Options trader, you want to be as efficient as possible in finding the best option contracts to trade. With thousands of options contracts even on a few stocks, it becomes overwhelming and time-consuming to go over various contracts quickly. So, we have added an Option Scanner in MarketXLS which essentially lets you choose a group of stocks in Excel cells, get all the option contacts for those stocks and lets you choose the best options to trade.

In this article, I will explain how you can use MarketXLS’s option scanner to find stock option trading opportunities.

Step 1: Select stock symbols

Select a group of stocks that have the symbols of the stock for which you want to trade options. You can select up to 50 tickers at one go.

option scanner, stock symbols

Click on Utilities>>Option Scanner on the MarketXLS Menu.

Meet the #1 Excel-based Investment Research Solution for Serious Investors. Click here to learn more.  Get a demo

 

option scanner, menu

Step 2: Collect Option Chains and Quotes

Once you click on the Option Scanner with the symbol cells selected, MarketXLS will go and collect all option contracts for these stocks and put them together in an excellent form with which you will be able to start the filtering of options.

option scanner, search for implied volatility, volume and more.

Step 3: Add columns

Choose the columns from the columns browser for the columns you want to screen options. Most common and essential being unusual Contract Volume, Ask & Bid – for the spread, Change %, Implied Volatility, Delta, Expiry dates, etc. To add a column to the main screen, double click on the name of the column. The columns you need should now be available on the main form for you to start filtering.

Why spend thousands on institutional research & data platforms when you can get it all in Excel for just around $40 a month? Get access to 1 Billion market data points in your Excel. Get your MarketXLS Demo

option scanner, filtered option contracts

Step 4: Sorting, Filtering, Grouping Option Contracts

Now that you have the columns you want to screen the options on, you can start using the inbuilt filtering functionality to narrow down your search for the best option contracts to trade.

To filter on a column go to the column and click on the little filter button to the right of the column.

option scanner

Apart from filtering the numeric values with sliders, you can also use the Numeric Filters which have many preset filters. For example, to get the top 10 option contracts with the highest volume and click on Numeric Filters and click on top N.

Better Investments, Faster Decisions, Better Research. Meet MarketXLS. Get your free demo. 

option scanner MarketXLS

To remove a column from the form, click and drag the column to the end of the window. To sort a column by the values, click on the column header.

Step 5: Now, that you have filtered on the option contracts, click on the first checkbox on the left to select all of the contracts and, click on “Throw Filtered Records in Excel.” to copy all option contracts. Then go to Excel and press CTRL + V to paste the records in Excel.

Option scanner, get records in Excel

Filtered options contract.

Now, that you have the selected option contracts in Excel sheet, you can use functions like =qm_Last, =qm_stream_last and get the history of specific options, create charts many other option related MarketXLS functions to track these options contracts.

Like what you see?

Click Below to See Our Full Video with Option scanner, option functions and option templates.