Working with Real Time Data

[MSN1979]

I am using SNAP to Excel feature for real time data from my trading terminal provided by sharekhan.

The Price gets updated automatically tick by tick every second. I am wondering If I can save that data in another sheet and then can use for later analysis.

here is the image of excel sheet

http://msnarang.blogspot.com/2018/08/beginners-guide-trading-stocks.html

WorkArea sheet is where price gets automatically updated. I would like to save this price with time and scrip name in new sheet named sheet1 (every time the price is updated in WorkArea) only for 1 scrip.

So it should read like

A B C
Time Scrip Name Price

I hope I am not asking too much. I am new to this and trying very hard to understand. Thanx in advance.