Well, with the Redi AddIn for Excel, we simply take snapshots every 5 seconds for the first 5 minutes (or longer). This helps when researching which stocks to use in the opening, real time. DDE link. I would suppose that other programs with DDE to Excel should work as well.
Don
Don