A League Table of Your Own

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.

Bloomberg league default ok

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.

Blog league Bloom report

(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.

Blog league Thomson M&A

(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

SDC

For additional sources for League Tables, see our Business FAQ. See also our blog post on Zephyr, which is another source for league tables.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s