Answered By: IESE Library Last Updated: Jan 09, 2020 Views: 7
This data can be found on Datastream (available in the Financial Room of IESE’s Barcelona Library as well as at the Madrid Library, through Eikon).
Open Microsoft Excel and click on the Datastream tab. Click on Time Series Request and then Find Series. Click on “Choose a single category” and select Constituent lists.
Select the stock exchange list that you want, in this case: FTSE 100 Constituents. Click on Datatypes to select the equities item that you want. Lastly, 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 Submit to complete the search.