For AI agents: a documentation index is available at the root level at /llms.txt. Append /llms.txt to any URL for a page-level index, or .md for the markdown version of any page.

IBKR Home IBKR Campus Log In Open Account

Excel ActiveX Excel DDE Excel RTD Changelog

Skip to navigation

Use Case

Introduction

|View as Markdown|Open in Claude|

This page is for Excel.

This guide is intended to introduce new customers to the DDE Excel example use cases.

Was this page helpful?

Edit this page

Built with

Excel ActiveX Excel DDE Excel RTD Changelog

- Introduction
Notes & Limitations
- Excel DDE Setup
- Review Trust Center Settings
Best Practice: Configure TWS / IB Gateway for DDE
DDE Socket Bridge
- Frequently Asked Questions
- Architecture
Requests in DDE
DDE Response Structures
Sample Spreadsheet Guide
- Underlying Requests
Use Case

Introduction
Introduction
macOS / Unix Support For Excel DDE
Unset Value Responses
Excel DDE Setup
Review Trust Center Settings
Introduction
Memory Allocation
API Settings
Weekly Reauthentication
Order Precautions
Connected IB Server Location in TWS
SMART Algorithm
Introduction
Steps to launch DDE Socket Bridge
Introduction
Configure the Connecting ClientId
Configure the Connecting Host IP Address
Configure the Connecting Service Name
Configure the Connecting Socket Port
Frequently Asked Questions
Architecture
Introduction
Excel Formula Structure
DDE Poke Requests
Introduction
Single value responses
Array Value Responses
Introduction
Initial Connection
Locating the Sample Spreadsheet
Navigating Through The Sample
Requesting Data
Introduction
Receiving Data: In-row data
Receiving Data: New Page
Underlying Requests
Introduction
Requesting Live Data
Placing Conditional Order
Requesting Open Orders
Requesting Positions
Requesting Option Chain

Home
Web API
TWS API
Excel
FIX
Third-Party Integrations
General