Release Date: June 25th, 2024
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
- Up to 10x Faster Refreshes — Huge optimizations on speed, performance and stability.
- XLSolve AI — Get instant answers to your MarketXLS and Excel questions.
- RTI (Real-time Intelligence) Functions — Streaming RSI, SMA and many other time-based functions.
- 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)
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)
With MarketXLS 9.3.7, leverage the power of ChatGPT to transform your data analysis and financial workflows. All required data comes from MarketXLS, and with an easy-to-use interface, you can ask questions to ChatGPT using your own API key at regular intervals.
Installation Instructions
For Windows Users (COM Add-in):
- Close Excel completely before starting the installation process.
- Go to Control Panel > Add or Remove Programs
- Look for MarketXLS, select it and click Uninstall
- Download the latest version from: marketxls.com/software
- 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.
