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.
LogoLogo
IBKR HomeIBKR CampusLog InOpen Account
Excel ActiveXExcel DDEExcel RTDChangelog
Excel ActiveXExcel DDEExcel RTDChangelog
    • Introduction
  • Notes & Limitations
    • Introduction
    • macOS / Unix Support For Excel DDE
    • Unset Value Responses
    • Excel DDE Setup
    • Review Trust Center Settings
  • Best Practice: Configure TWS / IB Gateway for DDE
    • Introduction
    • Memory Allocation
    • API Settings
    • Weekly Reauthentication
    • Order Precautions
    • Connected IB Server Location in TWS
    • SMART Algorithm
  • DDE Socket Bridge
    • Introduction
    • Steps to launch DDE Socket Bridge
    • Frequently Asked Questions
    • Architecture
  • Requests in DDE
    • Introduction
    • Excel Formula Structure
    • DDE Poke Requests
  • DDE Response Structures
    • Introduction
    • Single value responses
    • Array Value Responses
  • Sample Spreadsheet Guide
    • Introduction
    • Initial Connection
    • Locating the Sample Spreadsheet
    • Navigating Through The Sample
    • Requesting Data
    • Underlying Requests
  • Use Case
    • Introduction
    • Requesting Live Data
    • Placing Conditional Order
    • Requesting Open Orders
    • Requesting Positions
    • Requesting Option Chain
  • 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
IBKR HomeIBKR CampusLog InOpen Account
Sample Spreadsheet Guide

Locating the Sample Spreadsheet

|View as Markdown|Open in Claude|

After launching the socket bridge and while having TWS open and all the necessary API settings are set on it, as show in Configure Trader Workstation for DDE, we can then locate and open our sample sheet. Navigate to C:\TWS API\samples\Excel and select “TwsDde.xls”.

Sample Sheet Location.

Was this page helpful?
Edit this page
Previous

Initial Connection

Next

Navigating Through The Sample

Built with