Excel DDE with OEC Trader

Discussion in 'App Development' started by Hennie, Sep 8, 2017.

  1. Hennie

    Hennie

    Can someone please be so kind to help me answer 2 questions about Excel DDE with OEC Trader?
    1. How can I call DDE functions from VBA? From an Excel cell, they are called like this:
      • =QuotesBySymbol("User", "Bid", "NQU7")
      • =User|quote!NQU7?Bid
    2. Having trouble with the SendTimed function (market orders):
      • When triggering SendTimed on a condition (checking Positions), it sometimes makes multiple trades before checking Positions. So the result is that I end up with more trades than what was planned. So it needs to wait until Positions is updated before being able to make the next trade. How can this be done?
    Thank you.