§ Mac

IBKR data in Excel for Windows, on a Mac

StreamXLS is Windows software. On a Mac with Apple silicon, it runs in Windows 11 under Parallels Desktop, with TWS in the same Windows or on the Mac.

Excel for Mac cannot load StreamXLS: it is a COM component, and only Excel for Windows loads those.

What you need

  • A Mac with Apple silicon and macOS 14.7 or later (on macOS 15, version 15.5 or later).
  • Parallels Desktop.
  • Windows 11, installed in Parallels.
  • Excel, installed in Windows.
  • TWS API installed in Windows.

Set it up

  1. Install Parallels Desktop and create a Windows 11 virtual machine; Parallels can download Windows for you. The Windows license is separate.
  2. Activate Windows.
  3. In Windows, install Excel or Microsoft 365.
  4. In Windows, install the TWS API. Unless TWS will run on the Mac (step 7), also install TWS in Windows and turn on its API (TWS setup).
  5. In Windows, download StreamXLS and follow Get started.
  6. Run one TWS instance, in Windows or on the Mac. IBKR serves market data to only one host per user: if you also log in elsewhere, in IBKR Mobile or Client Portal for instance, TWS may get no quotes (details).
  7. To keep TWS on the Mac instead of in Windows: in TWS’s API settings on the Mac (File → Global Configuration → API → Settings), turn on the API as in step 4, turn off “Allow connections from localhost only” and add the virtual machine’s address (ipconfig in Windows shows it) under “Trusted IPs”; in the StreamXLS Control Panel, set TWS host to the Mac’s address on Parallels’ shared network (ifconfig on the Mac lists it: the one whose first three numbers match the virtual machine’s; ours: the Mac 10.211.55.2, the virtual machine 10.211.55.3) and TWS port to the socket port TWS shows in the same settings (by default 7497 for a paper login, 7496 for live), then restart Excel. The TWS API still has to be installed in Windows.

Your license

Windows in Parallels counts as one computer under your StreamXLS license (license agreement, §1). Windows in Parallels and another Windows PC are two computers: add one at checkout, or in your account if you already subscribe (the same person can add a second computer at 50% off).

Before you move Windows to another Mac or delete it, click Deactivate in the StreamXLS Control Panel, then activate StreamXLS in the new Windows. If you couldn’t (the Mac died, or Windows was restored or copied), email [email protected] and we’ll free the seat.

Before you buy

Set up Windows and run the free 30-day trial before you buy. In Windows, download StreamXLS; the trial starts on first run, with no card and no sign-up.