# StreamXLS > StreamXLS streams Interactive Brokers (IBKR) data — market data, account values, positions, P&L, and orders — into Microsoft Excel through native `=RTD()` formulas against ProgID `Tws.Rtd`. It is a production-grade Windows RTD server for Trader Workstation (TWS) and IB Gateway, with a 30-day auto-starting trial. Closed-source commercial software by StreamXLS LLC. (Note: StreamXLS cannot send or trigger live orders. Staged orders do not transmit to the market unless a user clicks in TWS to submit.) Key facts: no add-in or ribbon — the invisible engine loads when a formula asks for it; the visible companion app is the StreamXLS Control Panel (license activation, TWS-API status, settings). Requires TWS API >= 10.47.01 (market data negotiates ServerVersion >= 206); install the current release. Fields fail loud: `#N/A` instead of stale values. ## Documentation - [Get Started](https://streamxls.com/docs): requirements, install and the 30-day trial, enabling the TWS/IB Gateway API, first =RTD() formulas, troubleshooting, trial & license. - [Reference](https://streamxls.com/docs-reference): the complete =RTD() grammar — topic families (status, market data, account, position/positions, order/orders), contract specification methods, all field names. - [Configuration](https://streamxls.com/docs-config): environment variables, logging, market-data type (delayed vs realtime), the TWS-API version floor, multiple connections. ## Product - [How it works](https://streamxls.com/how-it-works): architecture and the fail-loud design principle. - [FAQ](https://streamxls.com/faq): instruments, IBKR setup, licensing, data privacy. - [Pricing](https://streamxls.com/buy): Personal and Professional subscriptions. - [Download](https://streamxls.com/download): the signed Windows installer, its SHA-256 checksum, how to verify the Authenticode signature, and why SmartScreen may warn on a new release. - [Support](https://streamxls.com/support): email support, what to include in a report. - [EULA](https://streamxls.com/eula.md): the full license agreement, served as its source markdown (HTML at https://streamxls.com/eula). - [About](https://streamxls.com/about): who builds StreamXLS and how it is engineered. ## Guides - [IBKR in Excel: the account/positions/orders gap](https://streamxls.com/ibkr-excel-account-positions-orders): IBKR's free Excel RTD sample streams market data only; DDE and ActiveX carry account/positions/orders but are heavier — and how desks fill the gap. - [IBKR RTD not working / #N/A](https://streamxls.com/ibkr-rtd-troubleshooting): why =RTD() cells show #N/A or stop updating — ProgID/registration, TWS API not enabled, port mismatch, 32/64-bit, throttle interval, 50-msg/sec limit, market-data lines, stale TWS API version. - [RTD vs DDE vs ActiveX](https://streamxls.com/ibkr-excel-rtd-vs-dde-vs-activex): the four ways to get IBKR data into Excel (RTD, DDE, ActiveX, manual export) with honest trade-offs. - [Python in Excel vs RTD](https://streamxls.com/python-in-excel-vs-rtd): why Python in Excel's cloud, recalculation-driven model can't stream live local data, vs RTD's local push model. ## Optional - [Why Excel](https://streamxls.com/why-excel): essay on the spreadsheet as trading surface. - [Beyond market data](https://streamxls.com/beyond-market-data): essay on production RTD engineering. - [Keeping the dashboard current](https://streamxls.com/keeping-the-dashboard-current): essay on TWS reconnection engineering. - [When Excel stops listening](https://streamxls.com/when-excel-stops-listening): essay on Excel's undocumented RTD contract at production scale. - [The last click](https://streamxls.com/the-last-click): essay on order staging from a spreadsheet and the never-zero discipline. - [Demo workbook](https://streamxls.com/StreamXLS.xlsm): every feature illustrated in one .xlsm. ## Markdown mirrors Every page listed above is also served as clean markdown at the same path plus `.md` — no navigation, CSS or scripts, with tables, formulas and FAQ entries as markdown structure. Generated from the HTML at build time, so a mirror is never staler than the page. - https://streamxls.com/index.md - https://streamxls.com/how-it-works.md - https://streamxls.com/docs.md - https://streamxls.com/docs-reference.md - https://streamxls.com/docs-config.md - https://streamxls.com/faq.md - https://streamxls.com/support.md - https://streamxls.com/buy.md - https://streamxls.com/download.md - https://streamxls.com/writing.md - https://streamxls.com/why-excel.md - https://streamxls.com/beyond-market-data.md - https://streamxls.com/keeping-the-dashboard-current.md - https://streamxls.com/when-excel-stops-listening.md - https://streamxls.com/the-last-click.md - https://streamxls.com/ibkr-excel-account-positions-orders.md - https://streamxls.com/ibkr-rtd-troubleshooting.md - https://streamxls.com/ibkr-excel-rtd-vs-dde-vs-activex.md - https://streamxls.com/python-in-excel-vs-rtd.md - https://streamxls.com/about.md - https://streamxls.com/privacy.md - https://streamxls.com/terms.md