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

Implied Volatility function, Spreadsheet Builder & more (New Release 9.3.4.7)

Written by Param Shah
Wed Oct 19 2022
See how MarketXLS helps you take advantage in the markets.
Download Option Template →

With great excitement, we announce the release of MarketXLS Version 9.3.4.7 today (October 17th, 2022). As highlighted below, this update includes new implied volatility for option functions, a new spreadsheet builder, and many other changes.

Key Updates Summary:-

  • New Functions to get all the strikes and expiration dates for the underlying symbol. =Strikes(“MSFT”), =Expirations(“MSFT”)
  • 18 New IV Functions and IV Rank functions. for example =ImpliedVolatility(“MSFT”), =ImpliedVolatilityRank1m(“MSFT”)
  • New Spreadsheet Builder tool inside MarketXLS. Select stocks and metrics and click a button to create a starter MarketXLS Sheet
  • New Function to get top options. For example =TopOptionsByVolume(“MSFT”), =TopOptionsByOpenInterest(“MSFT”)
  • New GetOptionChain Function optimization. The system now adds a blank row at the end of the Options chain to represent the end of the chain.
  • “Streaming Off” button optimization – This button will now completely disconnect the streaming service.
  • Historical Prices on weekends with =CloseHistorical Functions –  we have updated the functions to return the value of the last working day before the weekend.
  • New Reverse Iron Condor Template
  • New 100 pre-built screeners on the website, and you can access them inside excel from the pre-built screener button under the screener tab.

Here are the new updates:-

1) Get all the strikes and expiration dates for the underlying symbol

The gap in strike prices of underlying symbols of all options may differ. In response to requests from our Reddit community, this version contains the following new functions.
=Expirations(“MSFT”)
=Strikes(“MSFT”)

 

2) New Implied Volatility functions and Earnings Implied Volatility functions

We are introducing IV Rank functions in this release. Our results have been tested against multiple platforms, and we are satisfied with them. Sometimes, our IV Ranks may differ from other platforms, like TOS, Barchart, etc. Each function is explained below. We also summarized them in a blog post here. We would appreciate any feedback you may have on these functions.

 

3) New Spreadsheet Builder

We are happy to offer an automated way to create the initial MarketXLS Starter spreadsheet.

Once you download the latest version, it will be available for you.

Choose your stocks and metrics, then click a button to generate a fully automated spreadsheet with formulas updating the stocks in a column.  MarketXLS’s spreadsheet builder is located on the first tab of the menu, as shown below.

It has been designed intuitively based on the user’s feedback.

  1. The left column allows you to select an initial list of symbols (up to 40). The symbols can be searched by company name or symbol.
  2. Choose metrics in the right column, then use the function or categories to narrow your search.
  3. After clicking “Create the Spreadsheet”, you can save and customize it.

 

Instantly generate the entire spreadsheet filled with data using MarketXLS.

 

 

 

4) Get Top Options

This version contains the following new functions to get top options by volume and open interest quickly
=TopOptionsByVolume(“MSFT”)
=TopOptionsByOpenInterest(“MSFT”)

 

5) Get Options Chain Optimization

Option chain records differ for different stocks and ETFs; results pasted as a table sometimes overwrite the previous data. To help you recognize the new table, we added a blank row at the end. By pressing CTRL + Down arrow, you will reach the table’s end.

 

6) Streaming Off Button Optimizations

In this release, we have optimized the streaming Off/On button to stop streaming when the Streaming Off button is completely clicked. The spreadsheet should keep the last number but perform any calculations in the background. If you have both streaming and non-streaming functions in your spreadsheet, this should make it faster.

 

7) Historical Data on Weekends

Now the open, close, low, and high functions used to return #N/A on the weekends in the past. We have updated the functions in this update to return the value of the last working day before the weekend.

 

8) New Reverse Iron Condor Template

We have updated the previous Reverse Iron Condor Template formatting and functions for a better user experience. Please feel free to use it. Download Now.

 

9) Pre-built Stock Screens

We have added about 100 pre-built screens on the MarketXLS.com website, and you can also access these inside excel from the pre-built screener button under the screener tab, as shown below.

 

Our team has also performed minor optimizations to run MarketXLS smoothly. Email us at support@marketxls.com with any concerns or issues you face.

Click here to join our Reddit community and engage with other MarketXLS users.

MarketXLS is focused on delivering the best Excel experience to its users; help us make MarketXLS better by sharing your feedback.

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Template
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.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get 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

Academy Sports and Outdoors Inc logo

Academy Sports and Outdoors Inc

48.24
 
USD
 
-1.68
 
(-3.37%)
84
Rank
Optionable: Yes
Market Cap: 3,991 M
Industry: Beer, Wine, and Liquor Stores
52 week range    
25.10   
   52.34
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

55.02
 
USD
 
0.88
 
(1.63%)
83
Rank
Optionable: No
Market Cap: 2,827 M
Industry: Auto & Truck Dealerships
52 week range    
44.18   
   60.01
Rush Enterprises Inc. Class A Common Stock logo

Rush Enterprises Inc. Class A Common Stock

53.64
 
USD
 
1.44
 
(2.76%)
82
Rank
Optionable: Yes
Market Cap: 2,751 M
Industry: Auto & Truck Dealerships
52 week range    
42.72   
   60.89
Group 1 Automotive Inc. logo

Group 1 Automotive Inc.

188.93
 
USD
 
-3.23
 
(-1.68%)
81
Rank
Optionable: Yes
Market Cap: 2,791 M
Industry: Auto & Truck Dealerships
52 week range    
136.16   
   211.37
CRA InternationalInc. logo

CRA InternationalInc.

118.47
 
USD
 
-3.42
 
(-2.81%)
81
Rank
Optionable: Yes
Market Cap: 864 M
Industry: Business Services
52 week range    
78.35   
   125.80
Best Buy Co. Inc. logo

Best Buy Co. Inc.

84.32
 
USD
 
-2.28
 
(-2.63%)
81
Rank
Optionable: Yes
Market Cap: 18,947 M
Industry: Specialty Retail
52 week range    
60.79   
   112.96
Utah Medical Products Inc. logo

Utah Medical Products Inc.

101.88
 
USD
 
12.98
 
(14.60%)
80
Rank
Optionable: No
Market Cap: 321 M
Industry: Medical Instruments & Supplies
52 week range    
80.10   
   116.60
SCIENCE APPLICATIONS INTERNATIONAL CORPORATION logo

SCIENCE APPLICATIONS INTERNATIONAL CORPORATION

113.96
 
USD
 
4.70
 
(4.30%)
79
Rank
Optionable: Yes
Market Cap: 6,039 M
Industry: Information Technology Services
52 week range    
78.10   
   117.94
Guess? Inc. logo

Guess? Inc.

20.86
 
USD
 
-0.32
 
(-1.51%)
79
Rank
Optionable: Yes
Market Cap: 1,107 M
Industry: Apparel Stores
52 week range    
14.27   
   25.27
Buckle Inc. (The) logo

Buckle Inc. (The)

44.66
 
USD
 
0.24
 
(0.54%)
79
Rank
Optionable: Yes
Market Cap: 2,232 M
Industry: Apparel Stores
52 week range    
26.50   
   51.55

More Features