Skip to navigation
Troubleshooting

Unset Value

View as MarkdownOpen in Claude

What is an Unset Value?

In many cases, customers might see a response for a given market data column which displays N/A, 0, -1 in some of their cells. This can be occur for a few different reasons.

  1. While you may have part of the required market data subscription on the instrument, you may not have all of it. This is particularly common for derivatives traders who may not have a market data subscription for the given underlying.
  2. You might also encounter this by requesting too many symbols simultaneously. This is discussed further in Outgoing Message Rate Limitations.
  3. Similar to (2) above, every client has a maximum number of market data lines shared between TWS and their API. By default, all customer’s have a maximum of 100 market data lines, allowing for 100 unique contracts to be requested at any one time. If you surpass this limit, you may find that some fields can not be returned.
  4. This may also happen in the event your machine, in tandem with Excel, simply can not handle the volume of data requested. While the machine limitations are unique to each user, you may explore and modify the refresh rate as described in our documentation

’NA’ Connection Unavailable

Clients who may have installed the API into a unique location may receive an #NA message in each RTD cell. While this is often indicative of a reference error, the #NA reference may be failing to call an installed DLL essential for the connection with Trader Workstation. To resolve this error, please follow the steps listed below:

  1. Uninstall the API from the “Add/Remove Tool” in the Windows Control Panel as usual
  2. Delete the C:\TWS API 10XX.xx folder if any files are still remaining to prevent a version mismatch.
  3. Locate and delete the file at C:\Windows\SysWOW64\TwsSocketClient.dll.