sporadic hist!request behavior in DDE/Excel

i dont know what im doing wrong. everything else is working very
smoothly, requesting tik, placing orders.

it seems when i request historical data, it will work fine the first
time. i enable "macro" and everything runs smoothly.

then i close, without saving.

i reopen the worksheet.

now it will not work. it just says "PROCESSING"

and throws errors like, historical data not found.

i've made sure i waited at least a full 5 minutes before each new
requests.

i'm not even requesting a lot, just yesterday's data.


should I be clearing all formula fields when opening book, and just
before closing it?

i'v been trying to figure it out for a while....
 
Back
Top