CapIQ question

Does anybody know if there is a capiq formula for automatically looking up the CIQ ID by referencing the company name?

How to Use Capital IQ to Look Up Company ID


S&P Capital IQ is a powerful tool for market data, especially when used with its Excel plugin. When looking for a formula, you can try their handy formula cheat sheet or ping other users here on WSO. Community members provide these tips for how to look up CIQ ID by referencing the company name.

From WSO user @hcanalyst13" :

=CIQRANGEA(A1,"IQ_COMPANY_ID_QUICK_MATCH",1,1,,,,,"QUICK MATCH COMPANY ID")

This range formula will populate the cell to the right of it with the first returned CapIQ ID of the searched cell (so you can search by company name). Always a good idea to check the IQ_COMPANY_NAME to make sure you grabbed the correct CIQ ID.

From WSO user @spstack0507" :

  • Go to the S&P Capital IQ tab at the top of the screen and open up the "Templates" tab under the "Data" category.
  • Go to SPCIQ Excel Plug-In Tools and open the SPCIQ Identifier Converter.
  • This should help explain the ID conversion process.

From Certified Corporate Development Professional – Director @jackofalltrades" :
If you're doing a big screening, bring in the Excel ID in when you export in the first place. If you get in the zone you can go through a 200-name list in no time. Quickest manual way (excel 2007):

  1. Set up a blank column to the right of the column with all the company names
  2. Ctrl+C company name
  3. Right arrow to blank cell
  4. Click the button on the keyboard that brings up the mouse right-click menu
  5. I, Enter
  6. Ctrl+V, Enter
  7. Keep pressing tab until the search results show up, then tab to the correct name
  8. Spacebar (to highlight the name)
  9. Alt+O to insert the ID
  10. Right arrow + Down arrow to next Company and repeat from step 2...

Client Services to the Rescue

If all else fails, just give them a call. The Client Services team at CapIQ is known for being responsive and helpful. Contact them here:

  • Email [email protected]
  • Instant Message them from the link in the "Contact Us" drop-down menu at the top of the Capital IQ web page
  • EMEA: +44 (0) 20 7176 1234
  • AMERICAS: +1 888 806 5541
  • ASIA PACIFIC: + 852 2533 3565

Want to improve your financial modeling skills?

Check out WSO’s side-by-side comparison of financial modeling courses and get a WSO discount.

Financial Modeling Course

 
Best Response

Easiest way (If you're doing a big screening or something) is to bring in the Excel ID in when you export in the first place.

Other than that, it's a bitch to do. Thankfully, with practice you can go through many names very quickly via keyboard-only shortcuts. I.e., hands off the mouse!

Quickest manual way (excel 2007):

  1. Set up a blank column to the right of the column with all the company names
  2. Ctrl+C company name
  3. Right arrow to blank cell
  4. Click the button on the keyboard that brings up the mouse right-click menu
  5. I, Enter
  6. Ctrl+V, Enter
  7. Keep pressing tab until the search results show up, then tab to the correct name
  8. Spacebar (to highlight the name)
  9. Alt+O to insert the ID
  10. Right arrow + Down arrow to next Company and repeat from step 2...

If you get in the zone you can go through a 200-name list in no time.

-- Support WSO.com and visit these links! Financial Modeling Training Guide to Finance Interviews
 
jackofalltrades:
Easiest way (If you're doing a big screening or something) is to bring in the Excel ID in when you export in the first place.

Other than that, it's a bitch to do. Thankfully, with practice you can go through many names very quickly via keyboard-only shortcuts. I.e., hands off the mouse!

Quickest manual way (excel 2007):

  1. Set up a blank column to the right of the column with all the company names
  2. Ctrl+C company name
  3. Right arrow to blank cell
  4. Click the button on the keyboard that brings up the mouse right-click menu
  5. I, Enter
  6. Ctrl+V, Enter
  7. Keep pressing tab until the search results show up, then tab to the correct name
  8. Spacebar (to highlight the name)
  9. Alt+O to insert the ID
  10. Right arrow + Down arrow to next Company and repeat from step 2...

If you get in the zone you can go through a 200-name list in no time.

Oh yeah, forgot about that.... you can use the CapIQ web site to input all the companies you want into a list, then edit display columns and add Excel ID, then export that to Excel and copy the Excel ID columns over. Also, so long as they are public companies, you can use their tickers.

 

This is way after the question, but if anyone's interested or gets this in a google search this range formula will populate the cell to the right of it with the first returned CapIQ ID of the searched cell (so you can search by company name). Always a good idea to check the IQ_COMPANY_NAME to make sure you grabbed the correct CIQ ID.

=CIQRANGEA(A1,"IQ_COMPANY_ID_QUICK_MATCH",1,1,,,,,"QUICK MATCH COMPANY ID")

 

Velit neque nulla nihil. Incidunt et optio libero a officia placeat perspiciatis. Ipsum sed iste animi blanditiis. Distinctio soluta hic quas. Qui pariatur ad aspernatur officia vero fugit quaerat placeat. Tempora dolorem ut porro omnis impedit asperiores.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
GameTheory's picture
GameTheory
98.9
6
dosk17's picture
dosk17
98.9
7
DrApeman's picture
DrApeman
98.9
8
CompBanker's picture
CompBanker
98.9
9
kanon's picture
kanon
98.9
10
numi's picture
numi
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”