IB - Historical Data Request in Excel via DDE: Return Values?

Discussion in 'Data Sets and Feeds' started by BillCh, Aug 28, 2007.

  1. BillCh

    BillCh

    Hi,

    I am trying to request historical intraday data in Excel via DDE. I tried it in IBs Demo (TwsDde.xls) which works as it writes the data into a new sheet. Problem, there is a bunch load of Subs and Functions all over the place calling each other. I was not able to pin the core commands.

    On a plain new Excel sheet, what can I do to get certain data into a cell (or if necessary, to write it in a new sheet first), e.g. the Open of today which is part of the single line resulting from this:

    =xyzaccount|hist!'id01?req?YM_FUT_200709_ECBOT_USD_{}_20070828singleSpace21singleColon15singleColon00singleSpaceGMT_1singleSpaceD_11_TRADES_1_1_FALSE'

    If I put this in a cell, I get the message "RECEIVED" in this cell, which is nice. But how do I proceed from there? Where the heck is the related data line (or lines) or arrays or whatever?

    Thanks a lot!