EXCEL DDE for TWS

Discussion in 'App Development' started by Real Money, Sep 4, 2019.

  1. Hey guys I can't seem to load the mini dow contract ticker data into the excel dde spreadsheet.

    I tried

    GLOBEX
    ECBOT
    CBOT

    as the exchange and that didn't work. What should I do?

    Hmm, it says

    ID: 18
    CODE: 200
    Message: No security definition has been found for the request.

    I have data streaming for ES,NQ,RTY already! Any help would be appreciated.
     
    Last edited: Sep 4, 2019
  2. Which ticker symbol did you use? The exchange is the same as for ES, NQ, RTY.
    Edit: I checked IB's contract search tool. The symbol is MYM, and exchange is ECBOT. The larger size contract is called YM.
     
    Last edited: Sep 4, 2019
    Real Money likes this.
  3. I'm using

    ESU9 GLOBEX USD
    NQU9 GLOBEX USD
    RTYU9 GLOBEX USD
    MYMU9 ECBOT USD

    ARE working. THANKS!

    I'm also gonna need the

    SPX
    RUT
    DJX
    NDX

    indexes.
     
    Last edited: Sep 4, 2019
  4. I don't use IB anymore (so can't try it out), but try YMU19 or MYMU19 (for micro) exchange ECBOT
     
    Real Money likes this.