PDA

View Full Version : [SOLVED] How to find out URL from where on the website CSV data is benign downloaded



jdvisaria
11-08-2017, 11:59 PM
Hi,

Can someone please go through attached word file and help.

I am not able to post the query directly here

Thanks in advance.

snb
11-09-2017, 04:10 AM
Any specific question ?

jdvisaria
11-09-2017, 04:24 AM
Yes "nsb"

Hope you check the "Data Download Issue.docx" attached with the post. I was not able to post a query directly in forum that is why have posted it as word document.

I am struggling to figure out the dynamically created URL from where CSV file is downloaded using macros.

I have attached both the files, i.e. word file explaining my issue and, excel file where actual macro code is there.

Thanks.

snb
11-09-2017, 04:46 AM
Please spell aliases correctly.

Why can't you formulate your question in the post ?

jdvisaria
11-09-2017, 04:53 AM
Sorry for the mis spell...

System is not allowing me to post? It is showing that I can not post links before minimum of 5 posts. Even after removing the links, post is not submitted. That is why have uploaded word document with question.

snb
11-09-2017, 06:44 AM
A question <> a link

jdvisaria
11-09-2017, 07:01 AM
Hi,

I used to download data from "nseindia" website using attached macro code.

Macro does the following job.
1. take the inputs from "Input" sheet about indices name, start date and end date.
2. Generate the URL according to input data. Dynamically created URL is mentioned in Second sheet.

In this URL "NIFTY%20BANK&fromDate=30-09-2017&toDate=31-10-2017" is dynamically created part of whole URL based on user input.

3. Download data available at this link in CSV format, in to "Total Return Index" sheet.
The CSV file is opened in web browser itself.

jdvisaria
11-09-2017, 07:03 AM
Now nseindia has come up with new website - niftyindices

I am not able to figure out new dynamic URL from where CSV files get downloaded. More specifically, I am not able to find out format of dynamic URL created by new site.

It will be helpful if someone can help me find out format of new dynamic URL for downloading CSV file.

Website path from where dynamic data is downloaded.

jdvisaria
11-09-2017, 07:04 AM
Old - v (https://nseindia.com/products/content/equities/indices/historical_total_return.htm)isit nseindia site -> go to "product" tab on top -> select "Indices" -> Select "Historic Data" -> Select "View Total Returns" -> Select Index as "Nifty 50" from drop down -> enter start and end date -> click "Get Data" button -> click "Download file in csv format"

New - visit niftyindices site - to to"reports" tab on top -> select "Historical Data" -> select "Total Returns Index Value" from drop down on left top side -> select start date and end date -> press "submit" button -> click on "csv format"