Receiving "Cannot connect to Excel" or all fields are returned as "0"

View as MarkdownOpen in Claude

Excel may begin to display a value of “0” or a “Cannot connect to TWS” error message. Before contacting support, please adhere to these steps:

  1. Validate the TWS Settings are configured properly
  2. Uninstall the Trader Workstation and the TWS API
  3. Upgrade to the Latest Trader Workstation.
  4. Download and install the Latest TWS API

In some instances, users will also need to manage their DLLs.