Screening for FTSE 100 companies on Bloomberg
11/12/2025
So you’re researching an index and need some data on its constituent companies? Bloomberg’s Equity Screening tool makes light work of this, not just for the FTSE, but for indices, exchanges and sectors worldwide.
Type EQS into the Bloomberg search and either hit Enter or select ‘Equity Screening’ from the Functions menu. The EQS tool displays the options you can employ to screen companies within Bloomberg.
From here, to find your index, select the ‘Indices’ option from the Screening Criteria and either browse your way to or search for the index you require within it. As you do this, you will see your choices reflected in the ‘Selected Screening Criteria’ panel at the bottom of the screen.
To view the company list, click ‘See Results’ at the bottom right of your screen. Companies that fit your criteria are displayed ranked by Market Cap with a pre-defined set of financial data in columns to the right. To rank by any other variable, click on the appropriate column header.
If you would like to add data columns to your report, click on ‘Actions’ > ”Edit Custom Universe’ to return to the Screening criteria page. Here you can add any piece of financial data. Here we are adding the WACC, the weighted average cost of capital. By searching for it and selecting the option ‘No condition, display only’ below and clicking on Enter, a new data column will be added to your report to display the additional data.
If however, you would like to filter your company list by a piece of financial data, e.g. a price earnings ratio greater than 15, here you would select ‘> Greater than’ and enter a figure before clicking on Enter.
You will see your changes reflected in the Selected Screening Criteria panel before you view your results.
From the report screen, to transfer data to Excel, click ‘Export’ on the red menu bar and select ‘Excel’ > ‘All Securities’. Make sure you have installed the Bloomberg Office Add In before you do this. See our previous post on this for details.
USEFUL TO KNOW:
You can also use EQS to pull historical constituent lists for indices etc. At the top right of the search screen you will see the words ‘As Of’ and an orange box with today’s date. Bloomberg can screen companies back to December 1992. Enter your date here and click enter to view results.
Any questions on this or any other aspect of Bloomberg, please do not hesitate to contact us.
Feature image from Pixabay. Available at: https://pixabay.com/photos/architecture-building-business-city-1868667/
Categories & Tags:
Leave a comment on this post:
You might also like…
Screening for FTSE 100 companies on Bloomberg
So you’re researching an index and need some data on its constituent companies? Bloomberg’s Equity Screening tool makes light work of this, not just for the FTSE, but for indices, exchanges and sectors worldwide. Type EQS ...
Accelerating my future: How Cranfield put me on the fast track to automotive safety innovation
Hello! I’m Michaela Kaiser, and I’m thrilled to share my journey studying abroad. I’m from Calgary, Canada, and I recently graduated from Cranfield’s MSc Automotive Engineering course. My path to Cranfield ...
From Myanmar to Cranfield: My path to Renewable Energy
As someone who is passionate about sustainability, my career goal is to build a path in the renewable energy sector. My aspirations comes from the benefits of developing sustainable energy sources and ensuring energy ...
From lifelong dream to circular economy leader: Q&A with Himesha Randeni on the Environmental Management for Business MSc
What does it take to turn a lifelong passion for the planet into a fulfilling and impactful career? For Himesha Randeni, the answer was the Environmental Management for Business MSc at ...
Library services over the Christmas period
Kings Norton Library will be open 24/7 throughout the holiday period as a study space. Library staff will work until 6pm on Friday 19 December and will resume their normal working hours from 9am on ...
From the control tower to Cranfield: My journey to shaping the future of airports
Hi, I’m Karima Lakouz, and this is the new me! I’m a Moroccan full-time student, aiming to graduate in 2026 with an MSc in Airport Planning and Management from Cranfield University. ...