A League Table is a list of entities such as companies, teams, or individuals, ranked in order of achievement. In business, league tables most often refer to a list of investment banks ranked on the volume or value of such transactions as IPO’s or M&A deals. There are a very large number of combinations of league table variables (e.g. types of issues, country, time periods and currency). Here are descriptions of three financial databases that can help you construct a league table that fits your criteria.
(1) Bloomberg (available in Lippincott Library and Huntsman Hall)
Type LEAG and hit the green GO key.
The screen below is a list of investment banks ranked by amount of U.S. Bonds underwritten in 2013.
There are many customization options. Click on:
- Year (to choose dates from 1999 on)
- Period (to choose year, half year or quarter)
- Select a Market (to choose among markets for Debt, Equity, Structured Notes, and Syndicated Loans). You can also choose “custom markets” which will enable you to create a table based on detailed security, issuance and issuer data
- Related Functions (to choose among league tables for M&A, Legal Advisors, Clean Energy, Muni League, and to create a matrix table)
- View Ranks (to view a five year history and a detailed description of the table criteria)
Bloomberg also has hundreds of pre-formatted league tables with accompanying analysis. For a listing of these, type:
NI LEAG CRL and hit GO.
Here, for example, is the cover of a 40 page Bloomberg report on world M&A in 2013.
(2) Thomson One has League tables for M&A, Equity, Bonds and Loans.
Note that Thomson One only works in Internet Explorer and best in versions 7-9. See our blog post for an IE10 workaround.
To retrieve a league table for M&A, from the Thomson One main menu, click on the Market Views tab. Expand Deal Activity then expand M&A and select League Tables.
Substitute the words Equity, Bonds or Loans for M&A to retrieve League tables appropriate to these transactions. Thomson has some 40 pre-formatted league table reports for each type of transaction (e.g. M&A). An important limitation with league tables in Thomson One is that they only cover the current twelve months.
(3) SDC (Available in Lippincott Library at terminals 8A and 8B) is a subsidiary of Thomson Financial. It is a database of M&A deals (including joint ventures and strategic alliances), global new issues, corporate restructuring, and corporate governance. The SDC interface pre-dates the Internet by several years. For those of us brought up using the Internet, SDC will feel outdated and awkward to search. It is worth the trouble, however. SDC contains data going back to 1980. It allows you to structure and display searches with many more variables than are allowed on Thomson One.
Here is the search path to create a league table ranking underwriters of US Taxable Municipal debt in the past year.
- Click on Global New Issues => Select Market Place US => Select All public
- New Issues=> Select US Taxable Municipal Debt
- Enter Date Range
- Click on Execute Search => Click on LEAGUE icon
- Choose Managing Underwriters => Click on Execute search