RECORDING LTP in EXCEL


#1

hello,
I need little help in excel.
in zerodha Pi we can send our market watch to excel via “link to excel” button.
now as it sends live data feed so LTP of any script keeps changing and it is so fast that I can’t write it down, but I need to record first 3 LTP on the script when the market opens.
can someone help me with this?
Thanks.


#2

You’ll need a rough Idea of Excel VBAs for this. Watch some youtube videos on the basics of VBAs and then in the VBA module try playing around with the code given in here.