Researching IPOs in Bloomberg
14/11/2024
Are you researching IPOs? Do you want to find IPOs on a specific index (eg S&P 500, or UK AIM Index) for specific dates? Then Bloomberg is where you should be looking.
If you haven’t used Bloomberg before there’s a few things you should know:
- You can only access Bloomberg from the terminals in the Bloomberg Suite, which you can get to via the School of Management Library on the first floor of B111 on the Cranfield Campus.
- You will need to book a Bloomberg terminal, follow this link.
- Before you can use Bloomberg, you will need to have set up a Bloomberg account which you can do at a Bloomberg terminal. Follow the instructions here to set up your Bloomberg account.
- If you want to export results to Excel, you will need to have installed the Bloomberg Excel Add-In. Check Excel at your Bloomberg terminal to see if it’s already available and, if it’s not, follow the instructions here.
So now you’re ready to start your Bloomberg search for IPOs.
Once you’re logged into Bloomberg, type ‘IPO’ where the flashing blue cursor appears in the Command bar. Do not hit return.
This will display a list of functions, securities and news related to IPOs. Click on ‘IPO – Equity Offerings’ from the menu, then select ‘Advanced Search’ on the red tool bar.
In the top menu for Offer Criteria, select ‘Offer type’.
From the Offer Types listed, check the box to select ‘Initial Public Offering’. Click at the bottom right to Update.
Now select ‘Company List’. Using the black arrow at the side of each search box, change ‘Source’ to ‘Equity Index’ and choose the name of the index required. If you can’t see the index which you are interested in, just type in the name e.g. AXX is the FTSE All Share AIM index. Tick the box below to select issuer and click Update.
Now select ‘Date Range’. To select a specific date range, click on the black arrow on the right of the date range box and choose ‘Custom’. Enter your dates and specify what they apply to e.g. Announced Date. Click ‘Update’ to register your choices and return to the main search screen.
You have now set your criteria and are ready to see the IPOs which fit them. Click on ‘Result’ (at the bottom right).
This will take you to a summary screen. From here, you can view a list of the individual deals by clicking on the grey tab for ‘Deal List’. Your list should look like this:
To send this list to Excel, click on ‘Export’ on the red toolbar and choose ‘Excel – Simple Export’ or ‘Excel – Advanced Export’.
To view data on an individual IPO, select it from the list by clicking on it. The IPO information will be shown as below with the Overview on display. Additional information can be accessed via the menu down the left hand side of the screen.
For more information about Bloomberg, take a look at our Bloomberg blog posts. These are good posts to get you started: Bloomberg basics or Getting help with Bloomberg, but there are plenty more.
You could also look at our online pamphlet Bloomberg: a basic guide which contains lots of useful information about using Bloomberg.
If you have any further questions or you would like a demo of this resource, please do get in touch.
Categories & Tags:
Leave a comment on this post:
You might also like…
Unlocking Innovation: The Power of Design Thinking at Cranfield
Design thinking is more than a methodology—it’s a mindset that tackles real-world problems with innovative solutions. By blending creativity, technology, and strategic thinking, this approach empowers individuals and industries to address complex challenges ...
Real-World Readiness in Propulsion Engineering: Thermal Power and Propulsion MSc
In our recent conversation with Dr. Uyioghosa Igie, Programme Director for the Thermal Power and Propulsion MSc , we delved into what makes the course an exciting path for students interested in gas ...
Library support for new research students
Welcome! We are very excited to welcome you to Cranfield, and we are looking forward to supporting you throughout your research degree. We are always happy to help you – all you need to do ...
Securing an internship with a globally recognised brand
I recently completed my MSc in Management at Cranfield School of Management, an institution renowned for its exceptional faculty and world-class resources. As a 24-year-old student coming from India, I chose Cranfield because of its ...
My journey into the world of AI
I’m Mariam Gugushvili, a Georgian national, pursuing an MSc in Applied Artificial Intelligence (AAI) at Cranfield University this year. Before coming to Cranfield, I honed my skills in computer engineering at ...
Academic English is no-one’s first language!
Did you know we offer support for students who would like to improve their written and spoken communication to a postgraduate level? Our team of tutors are here to help you develop your academic skills ...