Download
Download XLNative Beta
Install XLNative on your Mac, connect to TWS or IB Gateway, and stream live IBKR data into Excel.
This signed and notarized Apple silicon beta is available for testing through July 1, 2026. Beta builds expire by design, and a newer beta will be available before this build expires.
Beta notes
- M-series Mac only for the current beta.
- Requires the Microsoft Excel for Mac desktop app, version 16.4 or later.
- Excel for web, Excel for mobile, Windows Excel, and Intel Macs are not supported in the current beta.
- Requires TWS or IB Gateway running locally.
- Requires local API access enabled in TWS or IB Gateway.
- Read-only API access is recommended.
- Beta builds are time-limited and must be replaced when they expire.
Installation steps
- Download and open the XLNative disk image.
- Drag XLNative into the Applications folder when the installer window opens.
- Launch XLNative from Applications. The menu bar icon shows its connection status.
- Start TWS or IB Gateway.
- Enable API access in TWS or confirm the API settings in IB Gateway using the instructions below.
- Open Excel after launching XLNative. XLNative adds or refreshes the Excel add-in for the current Mac user.
- Try:
=XN.IB("AAPL","last")
Enable API access
XLNative connects to the API socket exposed by your local TWS or IB Gateway session. Read-only API access is recommended for XLNative.
Trader Workstation (TWS)
- Sign in to TWS and open Global Configuration using the gear icon. In some TWS layouts, use Edit > Global Configuration.
- In the left sidebar, open API > Settings.
- Select Enable ActiveX and Socket Clients.
- Leave Read-Only API selected. XLNative is designed for read-only data workflows.
- Confirm the Socket Port. The usual defaults are
7497for paper trading and7496for live trading. - Click Apply, then OK.
IB Gateway
- Sign in to IB Gateway and open Configure > Settings.
- In the left sidebar, open API > Settings.
- Confirm that Enable ActiveX and Socket Clients is selected. IB Gateway normally enables socket connections by default.
- Leave Read-Only API selected. XLNative is designed for read-only data workflows.
- Confirm the Socket Port. The usual defaults are
4002for paper trading and4001for live trading. - Click Apply, then OK.
XLNative connects locally using host 127.0.0.1. If you change the socket port in TWS or IB Gateway, use the same port in XLNative. On the first connection, TWS may ask you to approve the local API connection.
See the API setup reference or the official IBKR setup guide.
License delivery
Paid access will be delivered digitally through checkout. After purchase, you will receive an order confirmation email with your XLNative license key and a link to download the current macOS release. The current beta download is available for testing before checkout opens.
Existing customers can re-download the current XLNative release later from their order confirmation email or from Lemon Squeezy My Orders.
Read the license delivery details, refund and cancellation policy, and End User License Agreement.
Download details
Current build: Apple silicon beta DMG, 30 MB.
Beta expiration: July 1, 2026.
SHA-256: 1e2d3a2a6a80ed9f5cf509fde4879d576526efac37df1a10eb790c5ad21faf44