Answered By: IESE Library
Last Updated: Oct 09, 2023     Views: 171

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 LSEG Workspace (formerly Refinitiv Workspace).

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.

Related Topics

Contact Us

Useful links