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...?
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?