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.
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.