Extracting Data from DDE Excel

Does anyone know how to copy / paste a price from 'live' update to excel, say price at 10:00am without losing it when time goes to 10:01am?
Thanks