White Eagle
New Member
- Joined
- May 15, 2019
- Messages
- 1
Hi All,
I'm working as analyst and I have been using web queries in Excel as a way to automatically get stats into my spreadsheets which are formatted for further analysis.
Previously i was getting data from a different website which is no more operational. Now I have to import data through web query from below mentioned link but power query is not recognizing table on web page.
http://www.scstrade.com/MarketStatistics/MS_MarketValuations.aspx?sectorid=-1&name=KSE 100 Index
Can anyone guide me how to import data?
I'm working as analyst and I have been using web queries in Excel as a way to automatically get stats into my spreadsheets which are formatted for further analysis.
Previously i was getting data from a different website which is no more operational. Now I have to import data through web query from below mentioned link but power query is not recognizing table on web page.
http://www.scstrade.com/MarketStatistics/MS_MarketValuations.aspx?sectorid=-1&name=KSE 100 Index
Can anyone guide me how to import data?