IB and Excel DDE

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

  1. in56

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

    EdgeAnalytix.net Vendor

    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.