URL to demonstration video: https://youtu.be/bYxhVcQ_x7I
This solution provides a trading execution template in Excel for Interactive Brokers (IB) Trader Workstation (TWS).
It provides the user with one-click execution of the following BUY and SELL order types:
- (Buy/Sell) Market Orders
- (Buy/Sell) Limit Orders
- With user-specified Limit Price
- (Buy/Sell) Stop Limit Orders
- With user-specified Limit Price, Stop Price
- (Buy/Sell) Trailing Stop Limit Orders
- With user-specified Limit Price, Stop Price, Trailing Amount
All Excel VBA modules are fully exposed, with no password protection.
Developers may use this tool to build their own automated trading algorithms.
The download comes complete with:
- Installation package:
- TWS API Installer [TWS API Install 971.06.msi]
- TWS Installer [tws-latest-windows-x86.exe]
- Step-by-step Installation Instructions [_installation_instructions.pdf]
- Excel Trading Execution Template Spreadsheet [TwsDde_TET_973.2e_wylie888_QB002.xlsm]
- 2018/08/28: Tested to work with IB TWS 973.2e
Please contact us
if you have requests to customize the spreadsheet, implement a trading algorithm, or request for a demonstration/walk-through via skype.
- Interactive Brokers (IB) Trader Workstation (TWS) – Installation Package with Correct Version is provided in the product download.
- Microsoft Excel 2016/2013/2010/2007