We recommending using the sample Excel spreadsheet that we provide as a starting point toward creating your own DDE for Excel API. Follow the steps below to download the sample spreadsheet.
To install the sample DDE Spreadsheet
1 From the IB homepage, select Application Programming from the Software menu.
2 Click the Proprietary API tab, then In the column appropriate to your operating system, click Download latest version.
Note: Windows users can download the beta test version of the API by using the Windows Beta column, or revert to the previous production version by selecting Downgrade to Previous Version.
3 Save the installation program, InstallAX.exe (or InstallAX_beta.exe), to your computer, and if desired, select a different directory. Click Save.
4 Close any versions of TWS and Excel that you have running.
5 Locate the InstallAX.exe (or InstallAX_beta.exe) program you just saved to your computer, then double-click the file to begin the API installation.
6 Follow the instructions in the installation wizard. By default, the sample DDE spreadsheet is saved to C:/Jts/Excel/TwsDde.xls.
Before you can use the spreadsheet, you must have TWS running and configured to support the DDE API.