cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PemaChoki
Regular Visitor

Connect to Indian stock market from https://www.nseindia.com/

I am trying to connect to Indian stock market https://www.nseindia.com/ and pick a historical data for particular stock HCLTECH.

PemaChoki_0-1619413605482.png

While connecting to the web source, all data from the table should be picked and when auto refresh is enable in power Bi, the data picked from web source should be refreshed.

 

Same had been done in yahoo finance and we were successful.

Web source for yahoo finance for stock ARKW picking data for 2 years and interval 1 day

https://query1.finance.yahoo.com/v8/finance/chart/ARKW?range=2y&interval=1d

 

2 REPLIES 2
amitchandak
Super User
Super User

@PemaChoki , check, you should able to get on this page

https://www1.nseindia.com/products/dynaContent/equities/equities/histHighLowSearch.htm



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Thank you for the recommendation and prompt response.

 

Actually I am trying to connect to stock historical data through the web source with power BI. 

 

The solution sir have mentioned is at the view level in website.To extra data for particular stock we have have to apply filter at the view level in website.Hope this will not have impact on the auto-schedule that is set on power BI gateway.

PemaChoki_4-1619419500297.png

 

Actually i want is to be able to connect to india stock website, for particular stock pick the stock data daily direcly in power Bi.We have add range in yahoo finance to reduce the data load time.

 

We have set auto schedule for all the stock connected to the yahoo finance.The link enable as to pick the latest stock data updated in the website.If we refresh the data today, today's data in daily for the range two year is picked in power BI.

 

PemaChoki_5-1619420105966.png

https://query1.finance.yahoo.com/v8/finance/chart/FB?range=2y&interval=1d

 


PemaChoki_6-1619420122020.png

 

We have tried the same method with india stock website but it is not working.We are not able to connect to the webiste only.

 

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!