TWS API Implementation

Real Money

Real Money

Hi guys. I am intimidated by the IB API syntax. Please help!

GOAL****

1) Send RTD into Excel Cell from IB API (10 cells -- 10 symbols)

This it. I need RTD into the cells.

I can't find any REALLY basic instructions on how to implement this functionality.

All I want to do is have the MIDPOINT, BID, or ASK put into the cell in real-time.

The problem is that IBKR seems to think I'm intent on developing some insanely complex interface with the socket client and so they give you that excel sample sheet which is waaay to much crap that I don't need.

I know this is simple but there is no obvious resource I can find to do this. Can somebody point me in the right direction here?

Oh yea the symbols are just NQ, ES, YM,RTY, EMD.

I don't wan't to reverse engineer the damn excel sample workbook and I don't need layers and layers of checks, status look-ups, and ordering functionality.

Thanks.
 
Last edited:
Real Money said:
Hi guys. I am intimidated by the IB API syntax. Please help!

GOAL****

1) Send RTD into Excel Cell from IB API (10 cells -- 10 symbols)

This it. I need RTD into the cells.

I can't find any REALLY basic instructions on how to implement this functionality.

All I want to do is have the MIDPOINT, BID, or ASK put into the cell in real-time.

The problem is that IBKR seems to think I'm intent on developing some insanely complex interface with the socket client and so they give you that excel sample sheet which is waaay to much crap that I don't need.

I know this is simple but there is no obvious resource I can find to do this. Can somebody point me in the right direction here?

Oh yea the symbols are just NQ, ES, YM,RTY, EMD.

I don't wan't to reverse engineer the damn excel sample workbook and I don't need layers and layers of checks, status look-ups, and ordering functionality.

Thanks.
More...

The IBKR API supports numerous languages - java, python, c++. c#, ActiveX and dde

You are talking socks but as it seems you are not a programmer, I would point you to try DDE. There is numerous links on the internet for support which you can find via search, from our site, did you look here:

DDE
https://www.interactivebrokers.com/en/index.php?f=1062

The link above provides a comprehensive A-Z with a sample spreadsheet.
 
Hi Def thanks any comment on this. I need fast data into the cell.

XL.png
 
Thanks, I'm just worried about excel actually, I am gonna be doing lots of formulas on the data and stuff. I'm thinking I'll use RTD Server...
 
Do you have to use IB? I use both IB and Thinkorswim. My ToS account is minimally funded but it allows me to use their RTD server to get realtime price data into Excel. Dirt simple.
 
You must log in or register to reply here.
Back
Top