I'm trying to analyse 13F filings and those provide CUSIPs and names. I hoped the names would be sufficient to find the relevant Edgar filings but the names are often imprecise (e.g., "ABBOTT LABS" instead of "ABBOTT LABORATORIES" so Edgar search fails).

If I had a way to reliably map CUSIPs to CIKs that would solve my problem - but "official" way of https://www.sec.gov/edgar/NYU/cik.coleft.c is a mapping from names to CIKs and again the names in 13F don't match the names in that file.

So my question is - what's the best free way to get from CUSIPs to CIKs? Or alternatively from CUSIPs to the same names as Edgar uses?

  • 2
    $\begingroup$ This really depends on which databases you have access to. If you can access WRDS or Bloomberg, it's straight forward to create a mapping table. Compustat has 9-digit (header) CUSIPs and CIKs, for example. $\endgroup$ – altabq Apr 16 '18 at 10:36
  • 1
    $\begingroup$ I don't have access to commercial databases. This is a hobby project. $\endgroup$ – John M Apr 16 '18 at 14:25

This repo gives a pretty straightforward process for building a CUSIP to CIK mapping CSV, it also includes a recent mapping CSV generated by the script.


| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.