Answered By: IESE Library Last Updated: May 18, 2018 Views: 1
This data can be found on Datastream (available at Barcelona and Madrid Libraries through Thomson Reuters Eikon).
Open Microsoft Excel and click on the Datastream tab. Click on Time Series Request and then Find Series. Click on the drop down list next to Equities and select Constituent Lists.
Use the advanced search option to search for the stock exchange list that you want e.g. FTSE.
Click on Datatypes to select the equities item that you want.
Finally use the Start and End Date boxes to select the date range that you want and Frequency to specify if you want the data to be daily, weekly, monthly etc.
Click on Run Now to complete the search.