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

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

  1. jjk2

    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 ?
     
    #1     Jan 1, 2008
    Share
  2. jjk2

    jjk2

    figured it out after going thu the code a lot more slowly. :D
     
    #2     Jan 1, 2008
    Share
  3. simsim67

    simsim67

    i use jTWSdump for IB historical data requests.
     
    #3     Jan 4, 2008
    Share
  4. jjk2

    jjk2

    ihave a simple

    sub something()

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

    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 ?
     
    #4     Jan 4, 2008
    Share