Screening for FTSE 100 companies on Bloomberg
16/09/2015
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 Bloomberg 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 right of the screen.
To view the company list, click ‘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.
To add a new column to display additional data, use the ‘Add Column’ search box to type in the variable you require. Select what you require and click Enter to refresh the display.
To transfer data to Excel, click ‘Output’ 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:
Using EQS, in addition to the criteria listed on the menu, you can also filter companies by financial variables. In the EQS search screen, type the variable required into the ‘Add Criteria’ box and select your parameters for filtering.
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…
Gear up for the future of vehicle design: Introducing the MSc in Virtual Prototyping for Vehicle Structures (VPVS)
The automotive and motorsport industries are in a constant state of evolution. Light weighting, electrification, and ever-stringent safety regulations are driving a revolution in vehicle design. But this innovation requires a ...
Finding industry profiles in Library resources
When researching an industry; its size, value and performance; competitors, brands and trends in the market etc., we recommend having a look at the following services. These can all be accessed via the SOM Library's ...
Setting up a shared group folder in a reference manager
Many of our students are now busy working on their group projects. One easy way to share references amongst a group is to set up group folders in a reference manager like Mendeley or Zotero. ...
Where are they now? From a Women in STEM scholar to a Sustainability Senior Professional
We recently caught up with Karoline, a previous Women in STEM scholar to find out where her scholarship and Cranfield master’s has taken her. How has Cranfield impacted your career? Studying at Cranfield University ...
Alan Harrison Half-Fee Scholarship 2024/2025 Recipient: A transition from working life back to student life, filled with learning, challenges, and rewarding moments
My first term at Cranfield has been filled with learning, new challenges and rewarding moments. Coming in with only a basic understanding of procurement and supply chain management, I knew the first term would ...
Moving with the times: The ‘new-look’ Cranfield Management MSc
For more than a decade, the Cranfield Management MSc has been at the forefront of management education worldwide. Ranked best Management MSc in the UK for value for money and international student experience by ...