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.
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.
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.
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.