Use of excel for data from NSE

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

Name:Phone:
Email:City:
State:
Are you a day trader?