Skip to content

StreamXLS 1.2.0

Latest

Choose a tag to compare

@streamxls streamxls released this 18 Nov 23:52

This version refuses words before "StageOrder" that earlier versions silently ignored. It also ensures that if you made in-place changes to the demo workbook then those are preserved by the update.

Download signed installer: StreamXLS-Setup-1.2.0.exe

Requirements

  • Windows
  • Microsoft Excel (desktop)
  • IBKR Trader Workstation or IB Gateway
  • TWS API 10.47.01 or later. IBKR's download page now labels releases without the first dot (e.g., 1052.01 instead of 10.52.01) and offers only its current Stable and Latest, both newer than the minimum — install either.
  • 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

Changes

These changes can affect how an existing workbook behaves:

  • StageOrder now refuses a formula that has anything before "StageOrder" other than a blank or a connection argument. It also refuses a connection argument that has other keys joined to it with ; (for example "port=7497;hidden" or "127.0.0.1:7497:4;hidden"), wherever that argument is in the formula. Earlier versions could ignore these silently.
  • Formulas that name the host as localhost, ::1 or 127.0.0.1 with the same client ID, or none, now share one connection to TWS; earlier versions opened one per spelling. To keep two connections, give each its own clientid=.
  • An order that TWS reported Inactive and then dropped from its open orders (e.g., a rejected order) could keep showing Inactive as its Status until the next reconnect. It now shows TWS's final status, usually within one or two order refreshes: for a rejected order, Cancelled, with TWS's reason in CompletedStatus. A formula that tests for Inactive sees it only that long, except with TWS's Read-Only API setting on, where nothing changes.
  • If a formula passes IF(cond,"paper") before "StageOrder", write it as IF(cond,"paper",""): with no else branch Excel passes FALSE when the condition is false, and that is now refused like any other unknown word.
  • mult= is now read the same way in every Windows region and every formula: the period is the decimal mark, and a comma is refused. Earlier versions sent the multiplier to TWS as the region's number format reads it, so where the decimal symbol is a comma, mult=0.01 could reach TWS as 1 and mult=12.5 as 125 with no error (German, Italian, Spanish, Dutch and other regions that group thousands with a period), or the request failed before it reached TWS (French, Russian, Polish and others). What can need a change in a workbook: a comma in mult= is now refused in quote, option-definition, and position formulas (StageOrder already refused one), with the message "mult must be a plain number with a period for the decimal and no thousands separator, for example 0.01 or 1000 (got '')." That includes mult=1,000 in a U.S. region (write mult=1000). mult=1.000 is 1; in a region that groups thousands with a period, a formula that had mult=1.000 for 1000 must now say mult=1000. In a region whose decimal symbol is a comma, a multiplier built from a numeric cell needs its comma replaced: "mult="&SUBSTITUTE(B2,",",".").

What's new

  • If you have saved changes to the demo StreamXLS.xlsm in its installed location (by default %LOCALAPPDATA%\StreamXLS), an Update's Setup keeps your version beside the new one. Your version will be renamed like StreamXLS-20261116-0930-yours.xlsm. Uninstalling this version will not remove it.

What was fixed

Account and position data:

  • When a position formula written by symbol matched two positions and one of them closed, the formula could briefly show a size of 0 and the closed position's P&L instead of the open position's. It now shows the open position's figures, or #N/A until they arrive.
  • When a position formula written by symbol matched one open position and another position it also matched had closed earlier the same day, the formula could show #N/A for the rest of the day while StreamXLS re-requested positions from TWS without pause. It now shows the open position's figures.

Connections:

  • When TWS refuses a StreamXLS connection because its client ID is already in use, that connection's ConnectionError now names the client ID in use. The connection that holds the ID can still stop receiving P&L — see Known issues.

Notes

  • Docs & quickstart: https://streamxls.com/docs
  • Known issues: see the manual.
  • 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 computers used as the built-in Administrator, and on any computer where Excel is run as an administrator.
  • Free trial starts the first time StreamXLS runs after you accept the license agreement; purchase at https://streamxls.com/buy