Forum Discussion
we couldn't authenticate with the credentials provided - excel get data from web error
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
Please help .
excel version - 2019
PS : I am currently making a refreshable historical stock data pulling query in excel from this tutorial >>https://www.bing.com/videos/search?q=nse+historical+data+excel&docid=608023032622091335&mid=E1EDD7D7DB393D5E561DE1EDD7D7DB393D5E561D&view=detail&FORM=VIRE
- did you ever figure this out?
