Discover our blogs

Aerospace | Cranfield University

Aerospace

Agrifood | Cranfield University

Agrifood

Alumni | Cranfield University

Alumni

Careers | Cranfield University

Careers

Careers | Cranfield University

Defence and Security

Design | Cranfield University

Design

Energy and Power | Cranfield University

Energy and Sustainability

Environment | Cranfield University

Environment

Forensics | Cranfield University

Forensics

Libraries | Cranfield University

Libraries

Libraries | Cranfield University

Manufacturing and Materials

Libraries | Cranfield University

School of Management

Libraries | Cranfield University

Transport Systems

Water | Cranfield University

Water

Homepage / Researching IPOs in Bloomberg

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.

Screenshot - IPO Equity OfferingsScreenshot - Advanced search

In the top menu for Offer Criteria, select ‘Offer type’.

Screenshot - offer type

From the Offer Types listed, check the box to select ‘Initial Public Offering’.  Click at the bottom right to Update.

Screenshot - initial public offering

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.

Screenshot - company list

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.

Screenshot - date range

 

 

 

 

 

 

 

 

 

You have now set your criteria and are ready to see the IPOs which fit them.  Click on ‘Result’ (at the bottom right).

Screenshot - result

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:

Screenshot - deal list

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.

Screenshot - individual IPO

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.

Helen Holmes

Written By: Helen Holmes

An Assistant Business Librarian since 2023, Helen provides support for SOM students and staff

Categories & Tags:

Leave a comment on this post:

Sign up for more information about studying master’s and research degrees at Cranfield

Sign up now
Go to Top