StreamXLS 1.1.4

This release removes ETF price fields that Interactive Brokers has deprecated, adds a status field to provide connection error details, and improves handling of some low memory scenarios.

Download signed installer: StreamXLS-Setup-1.1.4.exe

Requirements

• Windows
• Microsoft Excel (desktop)
• IBKR Trader Workstation or IB Gateway
• TWS API 1047.01 or later. (Current stable release is 1050.02.)
• Microsoft Visual C++ 2015–2022 Redistributable (x64), plus the x86 one if you run 32-bit Excel — nearly every Windows PC has them already; a freshly built server image may not

What's new

• The license agreement has been updated to version 1.1. Each Windows user must accept it: in Setup if you run the installer yourself, otherwise in the Control Panel.
• ETFNAVHIGH, ETFNAVLOW and ETFFROZENNAVLAST are retired: Interactive Brokers has removed these from TWS and its API.

Connections:

• A new status field, ConnectionError, returns why a connection is failing, when StreamXLS knows, under any Error display setting: =RTD("Tws.Rtd",, "status", "ConnectionError"), plus any host=, port= or clientid= your other formulas use.
• With Error display set to NA and Preserve values on disconnect off (the default): account, P&L, position and positions-list formulas again return #N/A during a connection outage, as before v1.1.3, so a total over them returns #N/A; the reason is now in ConnectionError. Reasons that name a fix, such as an invalid port=, still show as text.

Low memory handling:
When Excel's process runs short of memory, a small allocation inside StreamXLS can fail, and at certain moments such a failure could leave cells wrong or stuck; StreamXLS now contains it at several such moments, including the two below. If memory runs out completely, Excel can still fail or close.

• An error in StreamXLS's background logging or timers could close Excel without warning; StreamXLS now contains those errors.
• As a workbook opened, a memory failure as StreamXLS began checking your license could leave the check stuck: data formulas entered meanwhile never filled in, and LICENSE_MESSAGE stayed on its "verifying" text. StreamXLS now starts the check again to avoid that.

Notes

• Docs & quickstart: https://streamxls.com/docs
• Installer includes the StreamXLS Control Panel for license activation, settings, and updates.
• Per-user install by default; no administrator rights required. An Install for all users option is offered on a first install — needed on machines used as the built-in Administrator, and on any machine where Excel is run as an administrator.
• Free trial starts when you accept the license agreement; purchase at https://streamxls.com/buy