Skip to content

StreamXLS 1.0.5

Choose a tag to compare

@streamxls streamxls released this 01 Aug 21:15

Improvements in this release touch every component — installer, updates, connection monitoring, the demo workbook — and most are designed to go unnoticed: things simply work better.

Download signed installer: StreamXLS-Setup-1.0.5.exe

Requirements

What's new

  • Cleaner installs and uninstalls. The uninstaller is signed, preserves any custom settings, and notifies you if an open file would prevent a clean removal.
  • Reliable update notifications. When a StreamXLS update is available, alerts are now genuine Windows notifications that persist in the Action Center. The routine update check also catches up if the machine was off for a previously scheduled check.
  • Improved demo workbook (StreamXLS.xlsm). Every topic is illustrated, including complete field references for orders and account keys. A simplified design makes it easier than ever to get started with StreamXLS.

Data-integrity hardening

  • Enhanced connection health monitoring. A heartbeat monitor added on the API side detects a TWS connection that reports connected but has silently died.
  • Order-feed monitor. New LastOrderPollUTC status field lets you see when the last complete order snapshot arrived, so you can verify order poll cadence even when no order data is changing.
  • Partial outages confined. When just one API subsystem doesn't respond as expected, only the affected formulas report #N/A while StreamXLS repairs it.
  • Clarified data-status messages. TWS's delayed-data switchover notice (10167) is informational and is never returned to market data formulas; the "delayed market data is not enabled" notice (10168) now returns its diagnostic message.
  • Multi-currency account values. When TWS reports per-currency account values, an account formula that does not specify a currency will return a value when it is unambiguous (i.e., one currency holds the only non-zero balance, or every currency is zero). Otherwise it lists the available currencies and asks you to pick one (cur=EUR). Currency/RealCurrency requests list the available currencies on an account's TWS ledgers.

Notes