MarketXLS New Release 9.3.7

Release Date: June 25th, 2024

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

We are excited to announce the release of MarketXLS Version 9.3.7. This update delivers major performance improvements and introduces AI-powered features to enhance your investment research workflow.

Key Updates Summary

1. Up to 10x Faster Refreshes — Huge optimizations on speed, performance and stability.
2. XLSolve AI — Get instant answers to your MarketXLS and Excel questions.
3. RTI (Real-time Intelligence) Functions — Streaming RSI, SMA and many other time-based functions.
4. ChatGPT Integration — Ask questions about your spreadsheets using your own API key.

1. Up to 10x Faster Refreshes

(Available on Windows)

In this update, we have made several optimizations to enhance the platform's speed and stability:

• Refresh Speed: Implemented local-level caching to dramatically improve refresh speeds.
• Inserting Rows and Columns: Fixed the issue where Excel could not insert columns and rows when streaming is on.
• Optimized for Exceptions: The plugin no longer gets disabled due to exceptions.
• OLE Action Completion: Resolved the issue of Excel waiting for an OLE action to complete.

Overall, this update provides significantly better performance and speed.

2. Save Time & Get Instant Answers with XLSolve AI

To improve your experience and assist with your queries, we are introducing MarketXLS XLSolve AI. This tool has been trained on five years of customer queries to help you quickly find the right functions along with detailed explanations.

We value your feedback, so please share your thoughts after using it to help us enhance the service further.

3. Real-time Intelligence Functions

(Available on Windows)

We are introducing a new category of functions that provide Real-time Intelligence on stocks and options with 1m, 5m, 15m, and 1h interval granularity. If you are a day trader, do not miss this update.

Example:

=RTI_RSI("Symbol","Interval","Lookback","Field","Index")
=RTI_RSI("MSFT","1","7","Last",0)

Formula documentation: RTI_RSI

This will return the most recent 7-period streaming real-time RSI on the symbol on the last price on 1-minute intervals. Watch markets in real-time with our new RTI functions.

Available parameters for RTI functions:

lasttradedprice, last, volumetraded, volume, lasttradedquantity, tradedquantity, size, vwap, openinterest, bidprice, askprice, bidsize, asksize, accumulatedvolume, price, quantity

4. ChatGPT Integration

(Available on Windows)

MarketXLS 9.3.7 adds a ChatGPT integration: you enter your own OpenAI API key, and you can ask ChatGPT questions about your spreadsheet data, which comes from MarketXLS.

Installation Instructions

For Windows Users (COM Add-in):

1. Close Excel completely before starting the installation process.
2. Go to Control Panel > Add or Remove Programs
3. Look for MarketXLS, select it and click Uninstall
4. Download the latest version from: marketxls.com/software
5. Double click on the downloaded file and follow the installation process.

For Mac Users & Excel Online/Office 365 Users:

The updates for macOS/Office 365 and Excel Online are automatic, so no action is required on your end.

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