Answered By: IESE Library
Last Updated: May 20, 2016     Views: 231

For ownership data of companies worldwide, go to Orbis (International) and for Spanish companies, go to Sabi (Spain). Type in your company name. Choose your company. Click on Company Report and click on Shareholders, also click on Graphs.

For current and historic holdings, go to Thomson One:

  • For current holdings:

1.     Search for the company you want.

2.     Click on the Share Ownership and select your report.

  • For current and historic holdings

1.     Click on Share Ownership.

2.     Select the ownership report you want:

o    To view the Top Ten Investing Firms or Funds, cursor down to Top Ten Investors.

o    To view historical ownership, choose Shareholders Momentum reports.

Note: this resource only works in Internet Explorer‚Äč

Use Bloomberg (access to Barcelona Library Documentation room). Try Bloomberg functions OWN or PHDC and select institutional holders.

Examples:
IBM [EQUITY] hds [GO]

For statistics:
IBM [EQUITY] des4 [GO]

Search companies alphabetically or by size of holdings:
IBM [EQUITY] phdcs [GO]

You can search for institutional holdings through Thomson-Reuters Institutional Holdings (13F) in WRDS (you need to obtain your WRDS account).

Please note: Thomson Reuters institutional data (formerly called Spectrum) is based on the actions of money managers of institutions holding stock. It does not focus on the companies issuing the stock. CUSIPs for the companies issuing the stocks must be looked up beforehand in the CRSP database on WRDS and then used in the Thomson database. CUSIPs are not available through the Code Lookup feature.

Search for CUSIPs

Choose Database

  • Select Thomson Reuters
  • Under Institutional (13f) Holdings - s34 on left select s34 Master File

Step One: Date Range

  • Set Beginning Date month and year
  • Set Ending Date month and year

Step Two: Search

  • Set code format to CUSIP
  • Copy and paste the CUSIPs you have already looked up into the Company Codes box under Manually enter insider codes
  • Enter multiple codes by leaving a single space between them
  • Leave all other boxes in this step as is

Step Three: Variables

  • In Manager Description Information check Manager Name
  • In Holdings Information check Company Name and Shares Held
  • Leave all other boxes in this step as is.

Step Four: Output

  • Choose Tab-delimited text (*.txt) format
  • Leave all other boxes in this step as is
  • Click Submit Query 
  • Data Request Summary window will open
  • Right mouse click on the highlighted file name
  • Choose Save Target As option
  • Save as a .txt file to your computer
  • Open file in Excel

Related Topics

Contact Us