IB and Excel DDE

Discussion in 'Automated Trading' started by in56, Aug 1, 2006.

  1. in56


    I'm not sure if this is the right place to ask my question but anyway...

    I use DDE link in Excel and at 10am I want to stop the link. What is the easiest way to do it? I understand I can close Excel and re-open without update, or cut and paste just values. But I wonder if I can just stop the link to TWS? anybody?
  2. I have wrestled with the same issue of cutting off the DDe link since XL repaints everytime a DDE value changes which locked up mu CPU. I finally ended up with putting the DDE link somewhere far to the right, then using cut and paste and deleting the formula to get 'snapshot" values when I need it. In addition, try to use the screenupdate=false as an alternative.