I have 'live' Microsoft shares price on my Excel spreadsheet via Real Time
Data (RTD). I would like to have snapshots of the last traded prices in say,
every 10 seconds and have them mapped out on the spreadsheet at the end of
the trading day. How can I do this using Macro function?