Excel Price Feed is an Excel add-in which allows you to stream IBKR portfolio and market data. Set up TWS or Gateway once, then use portfolio and market data formulas in any workbook.
=EPF.IB.Stream_Portfolio(...) for live holdingsStream IBKR quotes into cells for stocks, options, FX and more - subject to your Interactive Brokers market data subscriptions.
=EPF.IB.Stream_Portfolio()=EPF.IB.Stream_Portfolio("Symbol,Position,DailyPnL,UnrealizedPnL,Value")=EPF.IB.Stream.MarketData("BidPrice","AAPL","STK","USD","SMART")=EPF.IB.Stream_MarketData_LastPrice_Symbol("AAPL")
Stream your live IBKR holdings into Excel with a single dynamic array formula.
Stream bids, asks, last prices and related fields from Interactive Brokers.
See how Interactive Brokers fits into Excel Price Feed data sources.
Connect Excel Price Feed to TWS or IB Gateway, then use the portfolio formula =EPF.IB.Stream_Portfolio() to stream your live Interactive Brokers holdings directly into Excel as a dynamic array. See the portfolio formula reference.
Yes. Excel Price Feed provides IBKR market data formulas such as =EPF.IB.Stream_MarketData and symbol/ConId helpers. You enter standard Excel formulas - no VBA macros required.
Yes. Excel Price Feed connects to your Interactive Brokers account through Trader Workstation (TWS) or IB Gateway. Enable the API in TWS/Gateway settings, then connect from the Excel Price Feed ribbon. Follow the setup guide.
Use =EPF.IB.Stream_Portfolio() for all default fields, or pass a field list such as =EPF.IB.Stream_Portfolio("Symbol,Position,DailyPnL,UnrealizedPnL,Value") to choose columns.
See the Interactive Brokers data source overview, portfolio formula reference and market data formula reference in the Excel Price Feed user guide.
Yes. Live IBKR market data in Excel follows your Interactive Brokers market data subscriptions and streaming line limits. Delayed data may be available depending on your account settings.