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

J

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 ?
 
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 ?
 
You must log in or register to reply here.
Back
Top