Request early access
§ · Topic schema

Six topic families. One Excel formula.

No add-in, no VBA glue, no Python runtime. Every value StreamXLS streams is a native =RTD() formula against ProgID Tws.Rtd, addressed by a uniform topic-string tuple. The same grammar covers market data, account values, positions, and orders. (Field names are case-insensitive and support TWS API aliases.)

Status
status, <field>
=RTD("Tws.Rtd", , "status", "IsConnected")
→ cell TRUE
Market data
<contract>, <field>
=RTD("Tws.Rtd", , "AAPL", "LAST")
→ cell 187.42
Accounts
account, <acct>, <field>
=RTD("Tws.Rtd", , "account", "U1234567", "NetLiquidation")
→ cell 1,284,902
Positions
position, <acct>, <contract>, <field>
=RTD("Tws.Rtd", , "position", "U1234567", "AAPL", "UnrealizedPnL")
→ cell 10,824.00
Order monitoring
orders, <accts>, <listfield>
=RTD("Tws.Rtd", , "orders", "*", "OpenListCsv")
→ cell 822;823
Order staging
SendOrder, <key=value>, …
=RTD("Tws.Rtd", , "SendOrder", "sym=AAPL", "side=BUY", "shares=100", "type=LMT", "limit=150.05", "exch=SMART")
→ cell Staged

The contract specification accepts five interchangeable forms — full key=value, compact slash notation (SYM@EXCH/SEC/Expiry/Right/Strike/Currency), conid-only, FX shorthand, and partial-with-defaults (stocks default to STK/SMART/USD). Beyond the families above, the same grammar reaches positions-list topics (positions, <acct>, SymbolsCsv), single orders by permId (order, <permId>, Status), and option-chain enumeration (OptionExpirationsCSV, OptionStrikesCSV).

Order staging passes order details to TWS with transmit=false. (Staged orders appear in TWS orders list with a Transmit button which must be clicked to actually send them to the market.)

← How it works Request early access