Cusip to gvkey. Apr 18, 2024 · Link any type of identifier (ticker, CUSIP, PERMNO, etc. The following is a list of common elements in some of the most heavily used financial databases. A CUSIP number is an exclusive nine-digit identification assigned to registered securities in the United States and Canada, following the Uniform Securities Identification Procedures (USIP). The word “ CUSIP number” may come up when you buy stocks, bonds, or other securities. For those reasons, most databases create permanent identifiers to indicate the same securities and companies. GVKEY-CIK Link Top of NCUSIP is the 8-digit historical CUSIP for CRSP securities. CUSIP identifiers are made up of up to 3 parts: Cusip issuer number – 6 digits Cusip issue number – 2… Mar 17, 2025 · For GVKEY use Compustat via WRDS (you need to obtain your WRDS account). S. Does the “successor firm” General Motors Company have the same GVKEY as General Motors Corporation? The same PERMNO? Can a CUSIP For GVKEY use Compustat. Use our Database Linking Tool to view linking procedures. *** If you just want the output linking table Aug 29, 2014 · This is in contrast to the Baldwin & Lyons example (GVKEY= 001982; first six CUSIP= 057755) where the Class A and Class B shares have the same GVKEY and first six CUSIP digits. May 27, 2025 · What Is a CUSIP Number? CUSIP numbers are used to create a concrete distinction between financial securities that are traded on public markets, including equity, debt, derivative, and The CUSIP Entity Identifier (CEI) is a 10-character code designed to uniquely identify legal entities in the syndicated loan market. A CUSIP (/ ˈkjuːsɪp /) is a nine-character numeric or alphanumeric code that uniquely identifies a North American financial security for the purposes of facilitating clearing and settlement of trades. Its primary purpose is to establish clear differentiation among publicly traded securities. Apr 24, 2017 · If you do not know whether Capital IQ provides the required company ID, run Formula Builder to confirm: eg: Click on Formula Builder, Search for GVKEY, GVKEY’s field name is `IQ_GVKEY’: Then input the names (or paste in, from cell A12) – a list of companies for which you require GVKEY and click on `Search’ at the right top. Use the Therefore, the requirement is to build a link from Compustat GVKEY/CUSIP (Current CUSIP) to historical CUSIP (e. This is a low-budget remedy if one does not have access to WRDS SEC Analytics Suite's linking table. 3 General Motors Corporation declared bankruptcy in June 2009. Step 2 (optional): Select individual linking options if needed. CUSIP stands for Committee on Uniform Securities Identification Procedures. 7. . For example, CRSP employs PERMNO to track stock, while Compustat uses GVKEY to follow companies and a combination of GVKEY and IID to track security. As indicated in Table above, both PERMNO and GVKEY (+IID) remain the same, regardless of changes in TICKER, CUSIP, and Company Names. and Canadian companies, commercial paper, and U. Requires subscription to WRDS SEC Analytics Suite. The U. Aug 1, 2023 · How to convert from GVKEY (or PERMNO) code to CUSIP code This post will help you to take a list of US or Canadian companies from CRSP or Compustat, convert the codes, then use them in Bloomberg, Eikon/Workspace, Datastream or Capital IQ Excel add-ins. CUSIP ® - Universally recognized identifier for financial instruments (CUSIPs are 9-character identifiers that capture an issue's important differentiating characteristics within a common structure) Dec 8, 2023 · The CUSIP number is a key identifying number used to help settle financial transactions. For a visual depiction see Linking Matrix View. This database has defined a proprietary identifier, the GVKEY, which can be used to track a company over time (a company name, CUSIP, or ticker may change over time). Oct 7, 2025 · If trying to match companies in many of the WRDS databases, WRDS has a matching feature. g. 2 The CIK comes from any of the company's SEC filings. 1. The CUSIP International Numbering System (CINS) is a 9-character alphanumeric identifier that employs the same 9 characters as CUSIP, but also contains a letter of the alphabet in the first position signifying the issuer’s country or geographic region. For the GVKEY, we provide four different sources: (1) the Compustat company table; (2) the Compustat security table, where we use the CUSIP from this table to link to the CUSIP from a company's Schedule 13D/G filings; (3) Capital IQ; and (4) CRSP/Compustat Merged. Here is a quick quiz to test your knowledge of firm identifiers. CUSIP PERMCO PERMNO COMPUSTAT GVKEY by CUSIP PERMNO COMPUSTAT GVKEY by CUSIP TAQ CRSP Link: provides the link between TAQ SYMBOL and Use the linking tables to map the SEC’s CIK to CUSIP and Compustat’s GVKEY. To convert 6 digit CUSIPs to 8 digit CUSIPs and vice versa, see the Cusip FAQ. Linking tables enable you to track all historical filings for public companies, helping to avoid selection and survivorship bias in research. CRSP also has a header variable named CUSIP that reflects only the most recent CUSIP for the entire time series. On Home page, select CRSP > CRSP/Compustat Merged > Linking Table. Sep 17, 2025 · Linking Queries by WRDS allows users to easily download link tables between various heavily used databases on the WRDS platform. To use, do the following: Step 1: Apply company codes individually, or as a list, or choose the entire database. , CRSP NCUSIP) to historical CIK to historical HQ locations ( WRDS has a (historical) CIK-CUSIP (or even GVKEY-CIK) link table) Manually, we can use 13D and 13G reportings to collect the mapping. For example: Bond CRSP Link: Directly link fixed income data at the individual bond level to the equity data from the CRSP database. Forked from leoliu0/cik-cusip-mapping MIT License Reeyarn Li 2023 This repository produces the link between cik and cusip using EDGAR 13D and 13G fillings, that is more robust than Compustat (due to backward filling of new cusip to old records). ) to GVKEY and one another. For example, CRSP employs PERMNO to track stocks, Compustat uses GVKEY to follow companies, and a combination of GVKEY and IID is used to track securities. Likewise, one can retrieve associated CUSIP numbers or ISINs for a given CIQ companyid or GVKEY using this table, as well as ID–GVKEY mapping. and Canadian securities such as stocks, bonds, mutual funds, and commercial Apr 17, 2025 · What Is a CUSIP Number? CUSIP numbers uniquely identify North American securities, facilitating faster trading. Example Code for Querying the WRDS_CIQSYMBOL Table The following code demonstrates how to retrieve the list of active primary stock tickers for Amazon, Inc. As indicated in the preceding table, both PERMNO and GVKEY (+IID) remain the same, regardless of changes in TICKER, CUSIP, and company names. Supporting over 75,000 commercial, academic, and government users at 500+ institutions in 37 countries, Wharton Research Data Services (WRDS) is the global gold standard in data management, innovative tools, analytics, and research services — all backed by the credibility and leadership of the Wharton School. 1 Firm identifiers: A quiz Our sense is that firm identifiers is one of those topics that seem easy, but is actually fairly tricky. The CUSIP is used for U. A change in CUSIP can occur due to various reasons, including non-fundamental events like splits and company name changes. government and municipal bonds. WRDS Database Linking Tool WRDS has over 600 datasets from more than 50 vendors. banking system uses this special number to keep track of securities. A CUSIP number identifies most financial instruments, including: stocks of all registered U. Jun 30, 2010 · Following a few queries about having a 6 digit cusip and requiring a 9 digit cusip. Type in the name, CUSIP, ticker, or various other identifiers of the company and WRDS will find corresponding elements. , companyid = 18749. CUSIP numbers, started in 1964 due to trade clearance delays, are integral to U.