InteractiveBroker Excel API example and support

 

for any of you who plan on moving to autotrading on Interactive Broker or who already are struggling:

for beginners who has no prior language exposure, Excel VBA was a good pick. but its not easy! IB API is very poorly documented and DDE is virtually completely ignored in most cases by IB's support.

Its very time consuming to read through the incomplete docs on DDE and spending hours looking for the solution on the forum and group page, trying to re-engineering even the simplest functions and commands from sample TWSdde.xls that came with the package which a lot of the simple stuff are well hidden and poorly described.

Also figuring out how to insert the proper formula, even tho when u have double checked multiple times with the docs, it will throw the most interesting errors as I have spent hours banging my head.

so if you feel discouraged or overwhelmed like i have before, let me help you out with what i can.

the example is completely automated spreadsheet with full easy to understand commenting explaining important lines without beating around the bush, all source code lines have DIRECT & CLEAR explanation. you may also enter some variables, simply click Go, and it will run the trading logic and enter trades for you.

If you are interested feel free to pm me.

 

what about a 3rd party charting program? Wouldn't that take a lot of the development work off?

I find a lot of software out there are geared heavily to IB such as ninjatrader, etc etc.

 

This product seems to be able to make excel (and lot of other software/platforms) work with IB if i understand what they say on the site correct.

But i have no idea how it work or even if it work. I only find the link posted somwhere.

twslink

Arctic4x

 
jbfx:
what about a 3rd party charting program? Wouldn't that take a lot of the development work off? I find a lot of software out there are geared heavily to IB such as ninjatrader, etc etc.

yes but thats not for the crowd i was aiming at.

 

Dde?

In fact thinking in DDE terms right now have not much sense, DDE have more than 20 years. Today we have OLE and COM which are more powerful.

I read in some place Vista does not come with DDE and is pretty understandable.

 

vista comes with DDE.

its used with bloomberg which exports xls files for financial analysis.

DDE personally i do not recommend it.

but its easy enough for anyone starting out.

 

help needed pls

hi

i am new to IB and just cann't find my hands with it's api/dde thing for excell.

i will be more than happy if you could mail me your demo file

thanks!!

 
jjk2:
for any of you who plan on moving to autotrading on Interactive Broker or who already are struggling:

for beginners who has no prior language exposure, Excel VBA was a good pick. but its not easy! IB API is very poorly documented and DDE is virtually completely ignored in most cases by IB's support.

Its very time consuming to read through the incomplete docs on DDE and spending hours looking for the solution on the forum and group page, trying to re-engineering even the simplest functions and commands from sample TWSdde.xls that came with the package which a lot of the simple stuff are well hidden and poorly described.

Also figuring out how to insert the proper formula, even tho when u have double checked multiple times with the docs, it will throw the most interesting errors as I have spent hours banging my head.

so if you feel discouraged or overwhelmed like i have before, let me help you out with what i can.

the example is completely automated spreadsheet with full easy to understand commenting explaining important lines without beating around the bush, all source code lines have DIRECT & CLEAR explanation. you may also enter some variables, simply click Go, and it will run the trading logic and enter trades for you.

If you are interested feel free to pm me.

does ib api works with open office?

want to send order base on excel cell value how to do on excel? any sample code?

Reason: