Excel DDE and IB

Discussion in 'Order Execution' started by prisma, Oct 8, 2002.

  1. dozu888

    dozu888

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


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

    Help appreciated.
     
    #21     Oct 22, 2002
  2. dozu888

    dozu888

    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.
     
    #22     Oct 24, 2002
  3. Simon-IB

    Simon-IB

    Try the following:

    Private Sub Tws1_errMsg(ByVal id As Long, ByVal errorCode As Long, ByVal errorString As String)
     
    #23     Oct 25, 2002
  4. are you using a "macro" to link the Excel to the order router in IB?
     
    #24     Oct 28, 2002
  5. mskl

    mskl

    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
     
    #25     Oct 28, 2002
  6. Simon-IB

    Simon-IB

    Yes, Im aware if this problem and currently working on a fix
     
    #26     Oct 28, 2002
  7. mskl

    mskl

    great.

    thanks
     
    #27     Oct 28, 2002
  8. just21

    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.
     
    #28     Oct 28, 2002
  9. Bob111

    Bob111

    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))))))
     
    #29     Oct 28, 2002
  10. dozu888

    dozu888


    this still gives compile error. please advise.


    NEVER MIND... FIGURED OUT THE ERROR.
     
    #30     Nov 11, 2002