Working with Real Time Data

MSN1979

New Member
Joined
Aug 23, 2018
Messages
1
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.
beginners-guide-trading-stocks.html


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.
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Forum statistics

Threads
1,223,104
Messages
6,170,126
Members
452,303
Latest member
c4cstore

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top