Live IBKR Data in Excel

A CSV export is a snapshot. The OptionsRealTime add-in streams live values from Interactive Brokers accounts into Excel through Real-Time Data (RTD) formulas, so a cell updates as the market moves. No file is exported or imported.

The Accounts sheet of the template workbook, with an RTD formula in the formula bar
The Accounts sheet: one formula per cell, values arriving live from each IBKR account.

Easy to use formulas to access portfolio and account data

The OptionsRealTime backend is built on streaming live tables, which makes an Excel spreadsheet a natural data consumer. Four tables are available for any account: position, underlying, portfolio and system. Simple to use formulas can access any of these tables, and retrieve values such as PnL, Greeks, implied volatility, bid, ask and Net Liquidation.

Positions for one IBKR account in Excel, with PnL, theta, delta, gamma and vega columns
Positions for one account, with PnL and Greeks pulled field by field from the position table.
A volatility scenario grid in Excel, charted across underlying moves and implied volatility levels
Scenario values in a grid: one metric across underlying moves and implied volatility levels.

The download includes a template workbook

The workbook has sheets for accounts, underlyings, positions by account, positions by underlying, positions by expiration, vol scenarios, vol exposure and system health. You choose the account by name from a dropdown on each sheet, so no account ID appears in the file. It is a plain .xlsx with no Visual Basic and no macros.

The underlying sheet of the template workbook, with the account chosen by name from a dropdown
A template sheet: the account is chosen by name at the top, and the sheet tabs run along the bottom.

Excel reads the same data as the browser

Excel and the browser show the same numbers at the same moment. Excel can run on multiple machines on your local area network. The browser does not need to be open.

Documentation

The function reference lists each RTD formula and its arguments.