Skip to content

Latest commit

 

History

History
48 lines (30 loc) · 4.46 KB

install.md

File metadata and controls

48 lines (30 loc) · 4.46 KB

Install + first run

The authoritative, step-by-step install and first-run guide — with SmartScreen and signature-verification screenshots — is at streamxls.com/download and streamxls.com/docs. This page is a summary.

Requirements:

  • Windows
  • Microsoft Excel (desktop)
  • Interactive Brokers TWS or IB Gateway
  • TWS API 10.47.01 or later. IBKR's download page labels releases without the first dot (1051.01 is 10.51.01) and offers only its current Stable and Latest, both newer than the minimum — install either.
  • The Microsoft Visual C++ 2015–2022 Redistributable (x64; x86 as well if you run 32-bit Excel). Nearly every Windows PC already has this; a freshly built Windows Server image may not.

Install

  1. Download StreamXLS-Setup-<version>.exe from the Releases page. It is signed by StreamXLS LLC; before running it you can right-click → Properties → Digital Signatures and confirm the signer reads StreamXLS LLC. Each installer's SHA-256 is published with the release (the asset's digest) and at streamxls.com/download for independent verification (Get-FileHash -Algorithm SHA256 <path>).
  2. Windows SmartScreen may warn on first run (the certificate is still building reputation at current download volume). streamxls.com/download shows exactly what the expected prompt looks like and how to proceed.
  3. Run the installer.

First run

  • Open your TWS or IB Gateway and enable API access: File → Global Configuration → API → Settings → Enable ActiveX and Socket Clients.
  • Open the demo workbook from the Start menu → StreamXLS Control Panel. Pick any sheet and click Activate Formulas (Live) to start the streaming data.

Administrator installs

By default StreamXLS installs for the user who launches the installer. This requires no admin rights, puts the software in %LOCALAPPDATA%\StreamXLS, and registers the COM server under HKCU\Software\Classes.

On a Windows machine you use through the built-in Administrator account: choose "Install for all users." This puts it in Program Files and registers it under HKLM\Software\Classes. Windows does not let a program running with full administrator rights use an installation registered to one user, and on that account every program runs that way — including Excel — so a single-user install simply fails to load StreamXLS. Installing from a named administrator account you created yourself also works. This is the single most common cause of a completely dead sheet on a trading VPS; see Every StreamXLS cell shows #N/A for the full explanation. The same applies on any machine if you launch Excel with "Run as administrator" — start it normally, or install for all users.

Pre-installing StreamXLS in a Windows image

Ensure that the image has the Microsoft Visual C++ 2015–2022 Redistributable (x64) (download), and the x86 one as well if its users will run 32-bit Excel. A bare Windows Server image does not.

Install StreamXLS using:

StreamXLS-Setup-<version>.exe /ALLUSERS /VERYSILENT /NORESTART

and nothing else — do not start Excel, do not open the Control Panel, and do not accept the license agreement on the template.

Each person who later signs in to a machine built from the image accepts the license agreement themselves, the first time they open the StreamXLS Control Panel (Start menu → StreamXLS). Until they do, StreamXLS formulas show a license message instead of data — Accept the StreamXLS license agreement in the StreamXLS Control Panel (Start menu → StreamXLS) — and =RTD("Tws.Rtd",, "LICENSE_STATE") returns AssentRequired.

The Control Panel also checks for a newer version at that moment and offers it, so an image pinned to one release still starts each customer on current bits. The update is always offered, never installed silently.