Downloading stock data from NSE India

[sonm10]

Hello,

I have a requirement to load the stock data from NSE website (nseindia.com). I found that they have the option to download historical data in a csv and the url of the download link (https://www.nseindia.com/api/historical/cm/equity?symbol=HCLTECH&series=[%22EQ%22]&from=26-03-2021&t...). Through the link, I can succesfully download the required data. However, I have to load the data on a daily basis so wanted to connect directly through Power BI Desktop. I tried with the web source in the Desktop but the query keeps loading till I get a "timeout" error. I tried the same url through Postman and got the result instantly. I tried playing with the headers but no luck so far. Any suggestions is appreciated.

I also found that there is a python package (nsepy) that scraps the data from NSE site. However, with the python script, the package cannot be added to the service and requires Personal Gateway(I have standard) for using the packages.

[Anonymous]

@sonm10 

"Resource Not Found" for me. Is this data displayed in a table in the webpage or it is a csv file for downloading?

Paul Zheng _ Community Support Team

[sonm10]

@AnonymousThank you for your response.

The link is for downloading the csv file. The link only works when we visit nesindia.com first. Must be some header params or likes.

They display the data in the website also - HCL Technologies Limited Share Price Today, Stock Price, Live NSE News, Quotes, Tips – NSE India > Historical Data. I think the NSEPY library is scraping this page (Not sure though, i didn't verify).

Any help is appreciated.