salilbhatnagar
New Member
- Joined
- Aug 23, 2016
- Messages
- 2
I have a web query to import yearly financial results from moneycontrol.com with URL
"http://www.moneycontrol.com/financials/relianceindustries/results/yearly/RI"
Data on the web page is organized in sets of 5 years per page. The query imports first 5 columns (Most recent 5 Financial years data) in excel. I want to import additional previous 5 years of data which is displayed on screen by clicking "previous years" on the web page. The issue is that the URL does not change when the link is clicked and hence data query is not able to import previous financial years data in excel.
Can anyone please help how to make web query import data from multiple pages organized under same URL?
Thanks in advance!
Here is the web query
WEB
1
-http://www.moneycontrol.com/financials/relianceindustries/results/yearly/RI-
Selection=5,6
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
"http://www.moneycontrol.com/financials/relianceindustries/results/yearly/RI"
Data on the web page is organized in sets of 5 years per page. The query imports first 5 columns (Most recent 5 Financial years data) in excel. I want to import additional previous 5 years of data which is displayed on screen by clicking "previous years" on the web page. The issue is that the URL does not change when the link is clicked and hence data query is not able to import previous financial years data in excel.
Can anyone please help how to make web query import data from multiple pages organized under same URL?
Thanks in advance!
Here is the web query
WEB
1
-http://www.moneycontrol.com/financials/relianceindustries/results/yearly/RI-
Selection=5,6
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False