I have been trying to pull data from www.nseindia.com ( historical data of stocks )
Going into excel > data > get data from web > advanced > enter the "request url" from https://www.nseindia.com/get-quotes/equity?symbol=SBIN website from its network tab in inspect element > enter the headers - accept-encoding , accept-language , cookie , user-agent respectively > click ok > select anonymous
and then i get an error
we couldn't authenticate with the credentials provided . Please try again
because of this I cannot connect to the web query to get data