I am trying to pull a table(financial data) from the following website into Excel using the following link: https://www.moneycontrol.com/financials/relianceindustries/profit-lossVI/RI The link can be accessed directly In this webpage there is an option( a button) of “Print/copy to Excel sheet” and press "Go" button for converting the data so that it can be pasted into an Excel sheet. On pressing the Go button and choosing an option (say Profit loss statement), a page is displayed giving data for the years 2022 to 2018 . I have obtained the link of the page as below by selecting an element of the table and by right click- “Inspect”. The name is also appearing in the main wrapper class: https://www.moneycontrol.com/stocks/company_info/print_financials.php?sc_did=RI&type=profit Using above hyperlink in Web query, I am able to directly pull data for the years 2022 to 2018 into Excel. In the displayed webpage, there is also option of viewing data for the previous years (option highlighted in blue). On pressing this, data for the years 2017 to 2013 gets displayed. As above, I have obtained the link of the page by selecting an element of the table and by right clicking- “Inspect”. The link obtained is given below. Notice that the address of this second link is coming as same as the earlier link given above : https://www.moneycontrol.com/stocks/company_info/print_financials.php?sc_did=RI&type=profit Now, but using the second link I am not able to pull data for the years 2017 to 2013 which is displayed in the webpage into Excel. Every time the data for the years 2022 to 2018 is getting pulled through WebQuery and not the data for the years 2017 to 2013 displayed in the webpage. Why is this so ? What am I missing while getting the link address from the main wrapper ? How should I modify the link address in WebQuery to correctly pull the data for the years 2017 to 2013 ?
Asked
Active
Viewed 26 times
0
-
There might be more parameters in the request header or even in its body. You can inspect all request data with your browsers web development tools too! – lupz Aug 17 '22 at 06:39
-
Can you please have a look at the website and offer a solution please. – Debashish Datta Aug 17 '22 at 07:27