Excel DDE

Discussion in 'Automated Trading' started by econometrics, Oct 28, 2010.

  1. sorry am new to automating trades,

    say i have a VBA code that will analyze a set od stock prices and show me the names that meet my investment criteria.
    I wanna run this code "continuously" throughout the first 10 mins of the day.

    How od you get Excel to keep executing a set of codes?
    Do you just use a loop for Application.OnTime...?
  2. Sintra


    Hi, I just replied a few days ago to somebody else. Forgot the name of the thread. Try google on "setlinkondata" this works on dde/formulas other links. When one is updated(and/or combined with your if statement) it runs a code.

    Where did you study econometrics?