You can connect Microsoft Excel to TWS or IB Gateway using the MEXEM Excel APIs. These APIs allow you to retrieve account, market data and trading-related information into Excel, depending on the specific API method used and your configuration.
MEXEM supports different Excel API options, including RTD Server, ActiveX and DDE. DDE, or Dynamic Data Exchange, is a legacy Windows-based method, while RTD is commonly used for retrieving live market data into Excel.
Please note that IBKR Excel API tools are available for Windows with Microsoft Excel and are not supported on Mac OS.
fermer
-(1)%201%20(4).png)