TWS API - dde/excel, extracting arrays from historical data.

Discussion in 'Data Sets and Feeds' started by jjk2, Jan 1, 2008.

  1. jjk2


    i've read thru the wiki, the guides, but there just doesnt seem to be any information in how to access, or find the array that suposedly holds the downloaded history data for an instrument.

    is anyone having the same problem ?
  2. jjk2


    figured it out after going thu the code a lot more slowly. :D
  3. simsim67


    i use jTWSdump for IB historical data requests.
  4. jjk2


    ihave a simple

    sub something()

    put formula into cells, and so on for getting historical stuff, and

    end sub

    it would work perfectly when i run it the first time. then i modify
    some codes, and run the macro, it works okay.

    however, when shut excel down but TWS still open,

    i open excel again, but this time, when i try to run it, it will
    say "PROCESSING" and will not load anything.

    what am i doing wrong?

    and yes i've enabled macros and allowed it to connect....its weird because it is returning prices, but not the historical....

    Should I close TWS everytime i close excel ?