Forum Discussion

shoof's avatar
shoof
Regular Visitor
2 years ago

Modifying the URL of a data source to get all historical data.

So I have this url that is connected to an investment index site. 

 

https://app2-nv.msci.com/products/index-data-search/regional_chart.jsp?asOf=22/Feb/2024&size=Standard%20(Large%2BMid%20Cap)&scope=R&style=None&currency=USD&priceLevel=STRD&indexId=990300&indexName=EAFE&suite=C

 

I want to modify this url to collect all the data available.  The site has a drop down to select all available data however when you do this the URL doesn't change so it forces you to manually download.  I have looked at the source code of the page in search of a different url but I'm not that experienced with that kind of stuff.

I have attemped to modify the URL with some success however I can't get the complete date range...

This link goes to Dec 31, 2020 to Feb 23, 2024 (Today)

https://www.msci.com/end-of-day-history?chart=regional&priceLevel=0&scope=R&style=C&asOf=Dec%31,%202024&currency=15&size=36&indexId=108

 

This link goes to Dec 31, 1969 (the Inception date which is what I want) to Jan 01, 1999

https://app2-nv.msci.com/products/indexes/performance?chart=regional&priceLevel=0&scope=R&style=C&asOf=Dec%2031,%201969&currency=15&size=36&indexId=108#

 

I just can't seem to figure out how to tackel this.  Has anyone else run into this problem?  Also, this complete data is not available on other websites as I have looked.

1 Reply

  • In addition to the issues you already mentioned their actual download is in .xls format.  That is not ideal, as it would require you to install additional drivers both on your PC and on the gateways.  Looks like a time sink to me.