Excel DDE and IB

dozu888 · Oct 22, 2002

Tws1.reqMktData 1, "HSI", "FUT", "200210", 0, "", "HKFE", "HKD"

trying to get HangSeng data this way but nothing happens. What gives?

Help appreciated.

dozu888 · Oct 24, 2002

I am trying to catch TWS API error using the errMsg event:

Private Sub Tws1_errMsg(ByVal id As Integer, ByVal errorCode As Integer, ByVal errorString As String)

this gives me compile error. help appreciated.

Simon-IB · Oct 25, 2002

Try the following:

Private Sub Tws1_errMsg(ByVal id As Long, ByVal errorCode As Long, ByVal errorString As String)

limitdown · Oct 28, 2002

are you using a "macro" to link the Excel to the order router in IB?

mskl · Oct 28, 2002

Simon,

Are you aware that account information via DDE (ie. cash, margin requirements etc) do not update in real time? (positions update in real time)

Any ETA on this fix?

thanks

Simon-IB · Oct 28, 2002

Yes, Im aware if this problem and currently working on a fix

mskl · Oct 28, 2002

great.

thanks

just21 · Oct 28, 2002

Can I again ask for the 40 quote limit to be reviewed. I am trading option spreads so I need the stock price and two option prices per position. Currently therefore I can only monitor 13 positions in excel. The more positions I can monitor in excel then the more commissions I generate for IB.

thanks.

Bob111 · Oct 28, 2002

Originally posted by just21
Can I again ask for the 40 quote limit to be reviewed. I am trading option spreads so I need the stock price and two option prices per position. Currently therefore I can only monitor 13 positions in excel. The more positions I can monitor in excel then the more commissions I generate for IB.

thanks.

you can monitor as many as you need, sign up for real time from CBOE($10), write little app (or ask someone to do it for you) in any language and that about it))))))

dozu888 · Nov 11, 2002

Quote from Simon-IB:

Try the following:

Private Sub Tws1_errMsg(ByVal id As Long, ByVal errorCode As Long, ByVal errorString As String)

this still gives compile error. please advise.

NEVER MIND... FIGURED OUT THE ERROR.