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

Get EOD data for Major US Indices – MarketXLS New Release 9.3.4.9

Written by Shubham Shah on 
Fri Oct 13 2023
 about MarketXLSRelease Notes
Get EOD data for Major US Indices – MarketXLS New Release 9.3.4.9
Boost your market advantage with MarketXLS. Real-time, enterprise-grade data. Book a demo or subscribe now!
Get EOD data for Major US Indices – MarketXLS New Release 9.3.4.9

Get EOD data for Major US Indices – MarketXLS New Release 9.3.4.9

With great excitement, we announce the release of MarketXLS Version 9.3.4.9.

Key Updates Summary:-

  • Next Expiration & Next Strike functions give the next expiration date or strike for an underlying. Example, =ExpirationNext(“MSFT”,1) if today’s 22nd June 2023 (Wednesday) it will show the 23rd June 2023 expiration date.
  • Added EOD data for these Indices CBOE Volatility Index , S&P 500 Index , NASDAQ Composite Index, Dow Jones Industrial Average , NASDAQ-100 Index.
  • Performance Enhancements

Here are the new updates:-

1) Next Expiration & Next Strike functions can be used to get the next expiration date or strike of a symbol.

The “ExpirationNext” and “StrikeNext” functions in MarketXLS help users retrieve information about the next expiration date and strike for a given underlying.

Here’s how you can use the ExpirationNext function:

=ExpirationNext(“MSFT”,1): This formula will return the next expiration date for the symbol. Example if today’s 22nd June 2023 (Wednesday) it will show the 23rd June 2023 expiration date.

Here’s how you can use the StrikeNext function:

=StrikeNext(“MSFT”,1): This formula will return the first above-the-money strike price for a call option, Example if the current strike price is 350 it will show 357.5 and so on.

=StrikeNext(“MSFT”,-1): This formula will return the first below-the-money strike price for a call option, Example if the current strike price is 350 it will show 352.5 and so on.

Two use cases have been provided below using Option Matrix and Option Chain templates.

Option Matrix TemplateOption Chain Template

 

2) We have added indices data for the past 5 years for the following symbols: ‘^VIX’, ‘^SPX’, ‘^IXIC’, ‘^DJI’, and ‘^NDX’.

The latest release of MarketXLS now includes End-of-Day (EOD) data for five major indices: CBOE Volatility Index (‘^VIX’), S&P 500 Index (‘^SPX’), NASDAQ Composite Index (‘^IXIC’), Dow Jones Industrial Average (‘^DJI’), and NASDAQ-100 Index (‘^NDX’).

You can utilize MarketXLS functions such as last price, close price, technical indicators, historical data, and stock return functions to gain valuable insights and make informed investment decisions based on the data for these indices.

Using this we updated the seasonality of SPX below (month-on-month)

Click here to Download the Template.

Seasonality returns Template

 

3) Performance Enhancement

In this build, we have implemented performance enhancement optimizations. This version is designed to address all speed-related and OLE-based errors that users encountered previously.


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

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

MarketXLS focuses on delivering the best Excel experience to its users; help us improve MarketXLS by sharing your feedback.

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.

We respect your privacy and will never share your email.
MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

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.

Dave

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