I got the overflow message with IB Excel API last week and after following their instructions on how to fix it I finally got it to work, sometimes. In excel it is telling me that I submitted the orders but in TWS the number of orders I submitted is about half of what it shows in Excel. I submit about 90 orders a day. So obviously I am looking outside of the IB API excel sheet. So here is my question I am looking at other software to simply submit orders in Excel. I have all my formulas in excel and all I need is to submit them in excel that is compatible is IB and can handle advisor accounts. I have looked at some software this weekend and http://www.spooztoolz.com looks like it would best fit my needs but I dont really want to pay $80/month in order to use it if I find something a little cheaper. TradeBullet looks promising also. Does anyone know of a simple easy way to submit orders to IB (advisor account) through Excel? I am not a programmer although I would like to learn how to do this stuff. I have immediate needs to take care of first. Thanks
Just to clarify. Are you saying that you changed "DAYS_PRIOR_TO_DDE_API = 37000" to "Const DAYS_PRIOR_TO_DDE_API = 39000" (posted by users as a fix in the ib forums) and now you submit orders without the overflow message, but the orders are wrong/partial? If so I have some work/testing/troubleshooting to do. Thanks for any info.
After I downloaded both new API software and TWS and tried it again (for the 100th time) I was able to finally get it to work today the way it should. All orders submitted and not one missed. Eric