Submit Orders to IB through Excel

S

shorty_mcshort

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
 
You must log in or register to reply here.
Back
Top