TWS users running add-on applications in Excel using DDE on a Windows 64-bit operating systems may receive the following error message upon log in or when enabling the DDE client:
This message is usually displayed for the following reasons:
You are running an instance of TWS that is using the 64-bit version of the Java Virtual Machine while attempting to load the ddedll.dll library, which has been compiled for 32-bit Java. This error can be corrected by re-installing TWS 32-bit from our website.
Instructions to resolve issue A
Installing 32-bit TWS
Please open the page http://www.ibkr.com in your browser and perform the steps below:
Click on the Log In button at the top right corner of the page.
Click on Download Trader Workstation:
Click on the red button TWS Latest:
On the next page, click on the link Download for Other Operating Systems:
Click on the item Windows 32-bit:
Make sure that the description under the DOWNLOAD button has changed to "Windows: 32 bit". Click now on DOWNLOAD:
Launch the downloaded file. The Trader Workstation installation will start. At this point, you may see the warning message "Trader Workstation latest is already installed...". Ignore this warning and click on the button Next > to continue the installation:
Your "Trader Workstation" Desktop icon will be automatically updated. You can now launch the 32-bit Trader Workstation by a double click on that icon.
The API Components (and consequently the library ddedll.dll) have not yet been installed but you already enabled the DDE Client Connection for TWS. This error can be corrected by installing the API Components.
Note: On certain systems you will need to apply the fixes for both issue A and B. If you applied the fix for issue A (or if you are already sure you are using the 32 bit version of the TWS) and you are still receiving the error message, then please apply as well the fix for issue B.
Instructions to resolve issue B
Installing the API components
Click the GET API SOFTWARE button below:
This will direct you to our API License Agreement, please review.
Click the I Agree button at the bottom:
Under the section Windows on the left side, download one of our API packages listed and install it:
Once the installation has completed, log back into TWS.
Please be aware that there are some programs that can effect the legacy DDE Client connections, for example: Chrome, VLC Player, Adobe Creative Cloud or Microsoft One Drive. In case you are using these programs, please keep them closed while you are using the Excel DDE workbook.
The newer DDE version uses a Java socket based on 64-bit, and should no longer have any conflicting software.