How can I record live intraday data in Excel from NSE? I want to create a chart in Excel with a 5 min interval.

Answer 1

You have to run macros to be able to record live data in Excel. The data won't update in real time since you need to have some sort of API for such functionality.