Finance

Look up a list of companies (or people) by name with the SPCIQ Identifier Converter.

• Submit name (includes related and approximate matches), ticker*, CIQ-ID, ISIN*, or CUSIP (6, 8, or 9 digits)*
  * Companies lookup only
• Return as many as five results per identifier for name, CIQ-ID, and more
  Edit results to return additional fields (e.g.: GVKEY; ISIN; CIK)

Requirements:

• Your S&P Capital IQ (CIQ) account
• Excel (for Windows) with the CIQ Excel plug-in
• At least one identifier (see above) for a company or person

Download the template:

1. Open Excel.
2. From the menu ribbon, select S&P Capital IQ > (Data) Templates > Get/Update Templates.
3. Expand and select SPCIQ Excel Plug-In Tools > SPCIQ Identifier Converter.xlsm.
4. Download.

Run the converter:

1. Select S&P Capital IQ > (Data) Templates > SPCIQ Excel Plug-In Tools > SPCIQ Identifier Converter to open the template.
2. Enter one or more identifiers (one per row) under Search Item Input (column AH).
   Note: Start CUSIPs with ' to retain leading zeros.
3. Search.

Adapt the converter to return other entity-level values:

1. Run the converter as above.
2. Unhide columns to the left of column AG.
3. In the formulas (columns M through AF), replace each mention of a given IQ_... variable with your preferred CIQ variable (e.g.: IQ_GVKEY; IQ_ISIN; IQ_CIK).

Note: Do not Search again. The search button macro will reset your edited functions.