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....