This website uses cookies to collect usage information in order to offer a better browsing experience. By browsing this site or by clicking on the "ACCEPT COOKIES" button you accept our Cookie Policy.


Contributor: Interactive Brokers

Level: Beginner

This course covers the API basics and how you can use Excel together with TWS to manage your account and automate your trading. You can follow along with our samples and test it out for yourself using your paper trading account.

Read More

Lesson: #1 Introduction to the TWS Excel API & Initial Setup

In this video, we’ll show you the basis - how to download, install and configure the TWS API.

Lesson: #2 Using RealTimeData (RTD) server for Excel

Once the TWS API has been set up, this lesson will show you how to set up Excel RTD to create your own custom watchlist.

Lesson: #3 The Dynamic Data Exchange (DDE) in Excel using a sample spreadsheet

This lesson will show you how to use DDE in Excel with TWS.

Lesson: #4 ActiveX in Excel, with a TWS Sample spreadsheet

We will cover the basics of using ActiveX controls in Excel to gather and share information with TWS.

Lesson: #5 Advanced TWS DDE Functionality

This lesson will go over the advanced functionality of the TWS sample spreadsheet, including placing orders.

Lesson: #6 Diagnosing Issues and Troubleshooting with the TWS API

Here, we will go over how to diagnose and troubleshoot some common issues.

trading top