How to log data from a single refreshing real time cell

Please help!!! I have a trading application from which the data is running into Excel in real time. For the information that I require, I have set up a second worksheet where 2 variables are continuously updating (at a rate of about 1 second) These variables are Time and Price. However, I wish to be able to do analysis using these figures and am unable to do so at present as the data is going into one cell each and continuously refreshing, therefore no previous data is held. I need to know how to log this data so it becomes in effect, a long list of figures from start to finish, showing all refreshes. I would be really grateful if someone out there can help!!Many thanks for your time.