We are running the following DDE query every 2 minutes. =Sjexxx856|hist!'id100?req2?ESM9_FUT_GLOBEX_USD_~/20190318singleSpace9singleColon16singleColon00_3000singleSpaceS_6_TRADES_0_1' This is set to run every 2 minutes changing the end time highlighted above. This returns results for about 97 times from TWS and then stops. The formula value becomes '0' instead of the usual 'Received' every time we get the results. On checking TWS log file, there is no trace of the last query in it. Apparently, it was never sent to TWS. On restarting XL, we still get the values 0. But if we restart both TWS and Excel then it works again for about 97 times. We ran it with one min bars querying every minute. Again it failed after about 97 queries. This has been tested at different time frames from different computers with the same result. We checked with 2 different TWS help desk personnel and they were sure that there no issue with the connectivity and TWS and they think that the problem is in our Excel. Any help or pointers will be greatly appreciated. Thanks Dilip
What version of TWS api are you using? It has been upgraded recently. https://www.interactivebrokers.co.uk/en/index.php?f=24356#974
We are using TWS 9.73.02. Thanks for the link on the release notes. Went through the same and there does not seem to be any reference in it to suggest that our issue may be solved in any of the subsequent releases.