Posts Tagged ‘screening’

Capital IQ Common pitfalls and webinars

19 June 2013 Leave a comment

Capital IQ webinars listS&P Capital IQ provides regular training webinars which are free to join. Simply log into Capital IQ in the usual manner and go to the Help link at the top-right.

There is also a video archive of all the past topics you can choose from. These include:

  • 5 Common Pitfalls to Avoid in Screening
  • Assessing Counterparty Credit Risk
  • Corporate Valuations Series
  • New Portfolio Templates
  • Value Investing Using S&P Capital IQ
  • Excel Trilogy: Basic/Intermediate/Advanced

Capital IQ webinar Java warningYou will need to have Java installed, and to allow it to run, and to accept the warning messages.

It should work on Windows and Mac OS in any modern web browser, but please leave a comment below if you find otherwise.

Please enter your University email address and your name when accessing these resources. Remember we only have an extended trial subscription for Capital IQ here at The University of Manchester Library so only one person can use it at a time.

The most recent webinar was titled “5 Common Pitfalls to Avoid in Screening” and we shall look at the first example from it.

Linking criteria and identifying a company as public on a given date in history

Capital IQ screening (linking)

In this example we want to screen for a list of public materials companies that closed an M&A deal in the last 12 months with total revenue greater than US$1,000,000,000 one day prior to the closure of the deal.

  1. Begin by choosing the Screening tab in the menu bar and clicking on Companies.
  2. The first criteria must return no more than 1,000,000 results. From the first column, choose Company Details > Industry Classifications and click on Materials, then Add Criteria.
  3. From the last column, choose M&A Details > Dates then in the list choose Closed Date, with the Time Frame: Last 12 Months. This metric refers to a transaction, not to a company, but we can still use it for screening. Click Add Criteria.
  4. We now want to identify the company as a public company. It might be tempting to go for Company Details > Company Type: Public Company, but that would apply to the status today, not on the date of the transaction. To get the status on the date of the transaction, you need a metric relating to the Transaction (about the target company).So again from the last column, choose M&A Details > Valuations and in the list choose Pre-Deal Share Performance with the Data Point: Target Market Cap 1-Day Prior  and the Value: Greater Than 0. This means the company was publicly listed. Ensure that Target/Issuer is displayed in the box below, and choose Type: AND from the radio buttons at the bottom. Click Add Criteria.Why Type: AND instead of Type: New (the default)? Because this criteria is part of a Transaction detail, and we are in Company Screening, we need to combine all the Transactions criteria together, using logical AND. It is a bit confusing, as all the criteria are combined with AND rather than OR, but it is essential when linking these types of screenings.
  5. Finally, to limit to target companies with Total Revenue greater than $1 billion at the time of the deal and not at the present day, choose from the last column M&A Details > Valuations then from the list Target/Issuer LTM Financials (at Announcement) with the Data Point: Total Revenue, Value: Greater Than 1000 (the units are millions of US Dollars). Again, ensure Target/Issuer is displayed below this and choose Type: AND to link it to the Transaction criteria. Click Add Criteria, then View Results.

The most important thing to take away from this is to consider using Pre-Deal Share Performance with the Data Point: Target Market Cap 1-Day Prior and the Value: Greater Than 0 to identify a company as public from a transaction, using the Type: AND operator after choosing a deal date.

Equity screening in Bloomberg

Equity screening (refine)Following an enquiry asking how many companies are in Bloomberg, the Bloomberg help desk directed me to the Equity Screening tool, EQS<GO>.

Like the screening tools in other databases, it starts of with all securities it has (Security Universe, today 654012 matches), then begins to refine the screening with the currently active primary quotes (Actively Traded Primary Security of Company, today 67292 matches). You can add further criteria in the amber box across the middle of the screen; simply type and select the auto-complete entry. In this example, I typed “United Kingdom” to select Country of Domicile (1808 matches), then “Technology” to select the Sector (141 matches).

Equity Screening (Results)Once this is done, click on 1) Results at the bottom-right of the screen to go to the results page. This is a table of companies with several columns of data.

If you want to use this list elsewhere (for example in Datastream), it would be wise to add an extra column, ISIN, to use as a company identifier. (Click in the amber bar across the top of the screen labelled Add Column, type ISIN Number, select the first match and press Enter.)

Equity Screen (Results in Excel)

Finally,  to export the table to Excel, click on the red menu bar option Output > Excel > All Securities, which will automatically open in Excel after you accept any warning messages about file formats.