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 MIRC.
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…
Tell us what you think of Library Services!
We want our students to have a great experience during their time at Cranfield. Each month, the University runs a short “Topic of the month” survey to focus on one service or facility and find ...
Air Transport Management alumni stories: SangHo (Henry) Han, Strategic Planning Manager in South Korea
SangHo (Henry) Han is a strategic planning manager at Air Premia in South Korea. He graduated from Cranfield University with an MSc in Air Transport Management in 2018. Here, Henry talks about his passion for ...
Life on campus and studying an Advanced Water Management MSc at Cranfield
After a year of working in the water, sanitation, and hygiene sector, I started to look for opportunities to further my knowledge about water resources. Researching water organisations on LinkedIn led me to find ...
Sign up to our ‘Making your research open access’ webinar – 9 February
Do you know your green from your gold? What are publisher deals, and how can they help you? My paper acknowledges UKRI funding, do I need to do anything special? What does an author accepted ...
How the Executive Logistics and Supply Chain Management MSc improved my career outlook
Hear from Harrison Jnr Ilodiwe, Executive Logistics and Supply Chain Management MSc, on his student experience at Cranfield. Why did you choose to study the Executive Logistics and Supply Chain Management MSc at Cranfield ...
Engineering problem to solve? Let Knovel help you find a solution
Did you know that Knovel provides you with more than just eBooks? Knovel is a key database for many engineering, mechanical and materials courses here at Cranfield University, and contains content from an extensive range ...