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

Marketxls New Release Version 9.1

Written by MarketXLS Team on 
Tue Jun 09 2020
 about Getting StartedHow to use MarketXLSRelease Notes
Marketxls New Release Version 9.1 - MarketXLS
Boost your market advantage with MarketXLS. Real-time, enterprise-grade data. Book a demo or subscribe now!
Marketxls New Release Version 9.1 - MarketXLS

Key Updates in this release


New Function Search Utility

To make it easier for you to search for a function and get the details on it, in this release, we have a new Search and Help button on the extreme left of the MarketXLS menu. So, instead of browsing through the Excel-based function list, we will update this form with example usage, function names, and other details. We have more than 600 custom functions now.Click on the Search and Help button on the MarketXLS to open the search form. You can search for a function like “dividends,” “options,” “ETFs,” and so on.

Marketxls New Release Version 9.1Search for a function MarketXLS2

New ETFs data and functions category

In this release, we have added the following functions in MarketXLS, which can give you detailed information on the Holdings within various ETFs. Alongside the holdings within the ETFs, other data like ETF Fund Family, Net Assets, Total Assets, etc. are also available.

Stock ETF functions3

New Stock Volatility Functions

We have added the following functions in this release, which will get you the historical volatility on stocks. These functions are the standard deviation of historical daily stock returns. We calculate the volatility on all US and Canadian stocks and ETFs after every day’s close. The calculation is the standard deviation of the daily returns of a stock.

Stock Volatility Functionsstockvolatility4

Optimizations on Real-time streaming functions, Refresh All, Refresh Selected Buttons

1) The system will not automatically recognize a changed symbol in a cell and will start streaming the real-time data for the new ticker symbol, instead of needing to click on refresh buttons. 

2) The system will understand if the value of a result is nothing, and then it will return NA instead of a message.

3) Various other minor optimizations on the way the streaming data works, to make it faster.

4) New Streaming On-Off checkbox for you to quickly turn off the streaming data if you need to.

Marketxls New Release Version 9.15

Options Filter function

This function will allow you to quickly filter out the option chain for the strike prices and expiry dates. qm_list function can also be used for this purpose. But this is a quick and easy way to get to the right options.  

As an example the following function call will return all the contracts from the option chain where the strike price is 10% above the current price. And the expiry dates are between 2020-06-30 and 2020-08-05

=QM_OptionChainFilter(A1,Last(A1)*1.1, , “2020-06-30”, “2020-08-05”)Marketxls New Release Version 9.1Marketxls New Release Version 9.1

Edit your caption text here

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
I agree to the MarketXLS Terms and Conditions
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu


I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.


Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord