LSEG Workspace (formerly Refinitiv Workspace):
- Search for FTSE 100 in the search bar.
- Select Constituents tab to see the companies included in the index.
- Go to the Download to Excel option
Bloomberg (available in the Financial Room of Barcelona IESE Library. Ask staff for password). Open Bloomberg Terminal and type FTSE 100 Index and <GO>. Click on option 11) Member Weightings to view a list of FTSE 100 constituents. Finally, you can export the results to Excel, PDF, or other formats.
Go to the “Constituents and Weights" section by FTSE Russell, then click on "FTSE 100" to view the list of constituents.
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 go to the Datastream tab. Click on Datastream formula, then select Category and choose Constituent lists.
In the Series/Lists search bar, enter the stock exchange list you need, such as FTSE 100 Constituents. Next, click on Datatypes/Expressions to select the equities item you want to analyze. Finally, use the Start Date and End Date fields to define the date range, and select Frequency to specify whether you want daily, weekly, or monthly data. Click Insert to complete the search.
