By checking I meant that you look for the new sample code exactly on the function/procedure where you get your errors?with the old excel sample, check the differences. I think on the excel sample there is an example of how to use the whatif functionality, isn't it?
El dom, 16 jul 2023 a las 9:06, Zoran via (<zoran_sevo=
[email protected]>) escribi¨®:
Hi Joan,
Thanks for your comments and suggestions. I¡¯ve tried using the newest API from IB but I get number of compile errors with my Excel file. I¡¯ll have to look first at those issues.?
I thought it would be easier if I just update TWS and stay with my current API since everything works well.
Best
?
Hi Zoran!
I don't use the whatif API function yet and?I can not check this, but why don't you download the newest API software from IB (first rename the old folder usually on C:\TWS API) and then check the "new" IB's sample excel again? Maybe there is some new logic there and you could adapt your excel easily.
Hope that helps
El vie, 14 jul 2023 a las 23:30, Zoran via (<zoran_sevo=
[email protected]>) escribi¨®:
Dear all,
I am using ExcelActiveX spreadsheet to connect to TWS and to relay my orders. The spreadsheet is based on IB¡¯s sample ExcelActiveX spreadsheet where I added some VBA code to make it more user-friendly for everyday trading.
?
I've been using TWS version 981.3c for number of years without problems. Communication between ExcelActiveX spreadsheet and TWS worked flawlessly.
Recently IB has announced that they will stop supporting this version and that the minimum supported version will be 1019.2.
Normally, I would first construct an order inside Excel sheet and before sending it for execution to TWS, I would always first send a "What-If" order to get information on the Margin impact of such order. After I updated TWS to 1019.2 version I started experiencing following problem.
When I send a request for "What-If" order I get following error messages from TWS:
Error: 2169 WARNING: The 'FirmQuoteOnly' order attribute is not supported"
Error: 10268 The 'EtradeOnly' order attribute is not supported.
?
To bypass these errors, I specified the 'firmQuoteOnly' and ¡®EtradeOnly¡¯ order attributes as false.
?
With the above modification the error message was gone, my order was sent and TWS responded with the message ¡®Submitted¡¯. However, my order never arrived at TWS. There was nothing listed under that tab showing active orders.
?
Does anyone knows what are the changes in the TWS version 1019.2 comparing to 981.3c that could cause that my software can not place order any more?
?
How can I find out what went wrong when placing the order?
?
Thank you in advance for you help.
