Create Your Own Industry-Specific League Tables

The Lippincott Library has several great resources for finding league tables. However, the majority of these pre-populated league tables are typically geared towards specific geographies and companies rather than industry-specific information. What happens if you would like to look at a league table for a specific industry? You are going to have to construct your own. Fortunately, we have a resource that will enable you to do just that. Thomson ONE, which has league tables for M&A, Equity, Bonds, and Loans, enables you to build league tables that are customized to your specifications. One great thing about the customized league tables is that, unlike the pre-populated league tables in Thomson ONE, the ones that you build yourself can pull data from a customized data range, and not just the last twelve months. Note that Thomson One only works in Internet Explorer and best in versions 7-9. See our blog post for an IE10 workaround. ImageOnecropped To start, click on  Screenings & Analysis at the top of the Thomson One home screen, then click on Deals & League Tables > M&A > Advanced Search in the subsequent drop down menus. Next, check the box for “All Mergers and Acquisitions” and then click “Continue” in the bottom right-hand corner of the screen.   image2_cropped You can customize your league table by using the filters in the menu on the left-hand side of the screen. In order to generate a league table for a specific industry or set of industries, you will need to enter the NAICS codes for the industries you want to look at. You can search within Thomson ONE or you can browse by keyword  at the U.S. Census.   Screenshot7_cropped Once you have selected your industry search criteria, continue to select additional data items to filter, such as  limiting your search to deals within the last year (or the date range of your choice) by clicking on “Deal Info”>”Dates”>”Dates Effective” and selecting the relevant dates. image3_cropped Once you have selected your search criteria, you can create your league table by clicking “Rankings” at the bottom of the screen, and then selecting “Advisors Rank by Value” from the drop down menu. Click “Create New”, adjust your specifications as necessary, and click “Apply to Search”. Click “Execute” in the bottom right hand corner of the screen. This will generate your league table, which can be exported to Excel using the button in the top right corner. image4_cropped For additional information on league tables in Thomson One, see this post, A League of Your Own. For other sources for league tables, see the business FAQ and check out our blog post on Zephyr, another Library database.

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