Re: IB's own SAMPLE Excel files still refer to de-supported order attributes so they don't work at all -- how do I bypass / fix??
|
As far as the legacy version goes, it should be as simple as removing the relevant rows (for example row 39 for NBBO Price Cap) from the Extended Order Attributes page, and the corresponding columns (for example column BF for NBBO Price Cap) from the Basic Orders page: and I think the other ones are in rows 37 and 38 and columns BD and BE. I¡¯d have to actually work through the code to confirm that this will be sufficient, and I don¡¯t have time for that. So take a backup copy of the workbook, make these changes, and give it a whirl. I can¡¯t test this myself because I¡¯m not set up for legacy DDE. ? If it doesn¡¯t work, then I can make a further suggestion to fix the actual VBA code, but I don¡¯t think that should be necessary. ? In the longer term, the obvious answer is to switch to the ¡®new¡¯ Java-based DDE interface. The sample spreadsheet for that ¨C TwsDde.xls ¨C doesn¡¯t appear to make use of these de-supported order attributes. ? This is something you¡¯re going to have to do eventually. It may well be that IBKR aren¡¯t going to continue to support the legacy DDE going forward. It¡¯s not difficult to set it up, and it will probably save you time and trouble in the future (as well as providing more functionality, as I understand it). ? Richard
|
