Use of excel for data from NSE

Can anybody guide me how to fetch this directly from NSE? There are many youtube videos for that (by using power query in excel ) but when I tried to do it I didnt get the NSE link, cookie, or other required information can the members from this forum guide me?

Zerodha – Open Paperless Account

Open online account with Zerodha. Free delivery trading and Max Rs 20 for Intraday, F&O, Currency and Commodity Trading. Intraday High leverage with MIS, CO and BO.

Are you a day trader?