sporadic hist!request behavior in DDE/Excel

Discussion in 'Automated Trading' started by jjk2, Jan 9, 2008.

  1. jjk2


    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

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


    fixed it.
  3. Slawrence


    Oh goody.