Get EOD data for Major US Indices – MarketXLS New Release 9.3.4.9
MarketXLS version 9.3.4.9 adds three things:
Try it in your own spreadsheet
Get the free MarketXLS sample workbook (.xlsx).
No account needed. MarketXLS live data requires a paid plan. Preview workbook
Explore more videos
- End-of-day (EOD) data for five US indices: CBOE Volatility Index (^VIX), S&P 500 Index (^SPX), NASDAQ Composite Index (^IXIC), Dow Jones Industrial Average (^DJI), and NASDAQ-100 Index (^NDX).
- Two option helper functions,
=ExpirationNextand=StrikeNext, which return the next expiration date or strike for an underlying. - Performance enhancements.
1) ExpirationNext and StrikeNext functions
The “ExpirationNext” and “StrikeNext” functions in MarketXLS help users retrieve information about thenextexpiration 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 returns the first strike above the at-the-money strike. For example, if the at-the-money strike is 350 and strikes are spaced 2.5 apart, it returns 352.5. =StrikeNext("MSFT",0) returns the at-the-money strike.
=StrikeNext(“MSFT”,-1): This formula returns the first strike below the at-the-money strike (347.5 in the same example).
Try the and templates to use these functions.
2) Five years of EOD index data for ^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 aslast 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.
Explore month-on-month SPX seasonality with the .
3) Performance enhancements
This build includes performance optimizations aimed at the speed-related and OLE-based errors users reported in earlier versions.
Our team has also performedminor optimizationsto run MarketXLS smoothly. Please email us atsupport@marketxls.comwith any concerns or issues you face.
Join the MarketXLS Discord community to join ourDiscord ** community** and engage with other MarketXLS users.
Help us improve MarketXLS by sharing your feedback.
