MarketXLS New Release 9.3.4.7

Release Date: October 17th, 2022

We are excited to announce the release of MarketXLS Version 9.3.4.7. This update includes new implied volatility functions, a brand new spreadsheet builder, and many other enhancements.

Key Updates Summary

1. New Strikes & Expirations Functions — Get all strikes and expiration dates for any symbol.
2. 18 New IV Functions — Implied Volatility and IV Rank functions.
3. New Spreadsheet Builder — Auto-generate starter sheets with selected stocks and metrics.
4. Top Options Functions — Get top options by volume and open interest.
5. GetOptionChain Optimization — Blank row end marker for easier navigation.
6. Streaming Off Optimization — Completely disconnects streaming service.
7. Weekend Historical Data — Returns last working day values.
8. New Reverse Iron Condor Template
9. 100+ Pre-built Screeners — Accessible from Excel.

1. Get All Strikes and Expiration Dates

New functions to retrieve complete options data for any symbol:

• =Expirations("MSFT") — Returns all expiration dates
• =Strikes("MSFT") — Returns all available strike prices

2. New Implied Volatility Functions

We are introducing IV Rank functions in this release. Our results have been tested against multiple platforms.

3. New Spreadsheet Builder

We are happy to offer an automated way to create your initial MarketXLS starter spreadsheet. Choose your stocks (up to 40) and metrics, then click a button to generate a fully automated spreadsheet with formulas. The Spreadsheet Builder is located on the first tab of the MarketXLS menu.

4. Get Top Options

New functions to quickly find the most active options:

• =TopOptionsByVolume("MSFT") — Returns options with highest volume
• =TopOptionsByOpenInterest("MSFT") — Returns options with highest open interest

5. GetOptionChain Optimization

Option chain records differ for different stocks and ETFs. To help you recognize table boundaries, we added a blank row at the end. Press CTRL + Down arrow to quickly reach the table's end.

6. Streaming Off Button Optimization

The Streaming Off/On button now completely stops streaming when clicked. The spreadsheet keeps the last values but stops all background calculations, making spreadsheets with mixed streaming and non-streaming functions faster.

7. Historical Data on Weekends

The open, close, low and high functions previously returned #N/A on weekends. Now they return the value of the last working day before the weekend.

8. New Reverse Iron Condor Template

We have updated the Reverse Iron Condor Template with improved formatting and functions for a better user experience.

9. 100+ Pre-built Stock Screeners

We have added about 100 pre-built screens on the MarketXLS website. You can also access these inside Excel from the pre-built screener button under the screener tab.

Installation Instructions

For Windows Users:

1. Close Excel
2. Go to Control Panel > Add and Remove Programs > MarketXLS > Uninstall
3. Download the latest version from: marketxls.com/software
4. Double click on the downloaded .msi file to install.

For any questions, please feel free to email us at support@marketxls.com or call us at 1-877-778-8358.