MarketXLS New Release 9.3.4.7

Release Date: October 17th, 2022

See it in actionMarketXLS video

The full MarketXLS demo

Watch full demoBook a demo

Try it in your own spreadsheet

Get the free MarketXLS sample workbook (.xlsx).

Email address

Download free workbook

No account needed. MarketXLS live data requires a paid plan. Preview workbook

Explore more videos +

IntroductionHistorical DataOptions DataUse-cases

MarketXLS Version 9.3.4.7 (October 2022) added =Strikes() and =Expirations() for option strikes and expiration dates, 18 implied volatility and IV rank functions such as =ImpliedVolatilityRank1y, a Spreadsheet Builder that generates starter sheets, Top Options functions, and access to 100+ pre-built screeners from Excel. These are historical release notes; for the current function list, see /formulas.

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.