I have PermID and Issuer names and I need to retrieve the cik numbers for these issuers. Can some...

s1910010

I have PermID and Issuer names and I need to retrieve the cik numbers for these issuers. Can someone help me with the code to do this? I am using Workspace in my computer.

Find more posts tagged with

refinitiv-dataplatform-eikon

workspace-data-api

company-research

#technology

Accepted answers

m.bunkowski

Hi @s1910010

You can do it using search. Sample code for Apple:

import refinitiv.data as rd
from refinitiv.data.content import search
rd.open_session()
response = search.Definition(
                            filter = "IssuerOAPermID eq '4295905573'",
                            top = 1,
                            select = "IssuerCikNumber" ).get_data()
response.data.df

All comments

m.bunkowski

Hi @s1910010

You can do it using search. Sample code for Apple:

import refinitiv.data as rd
from refinitiv.data.content import search
rd.open_session()
response = search.Definition(
                            filter = "IssuerOAPermID eq '4295905573'",
                            top = 1,
                            select = "IssuerCikNumber" ).get_data()
response.data.df

s1910010

@m.bunkowski Thank you! Is there any way I can run a loop to search for different permIDs? I have a list of them I need to find the CIK for.

m.bunkowski

Hi @s1910010

Here is a sample:

permids = ['4295904307','4295905573','4297089638']
for p in permids:
    response = search.Definition(
                filter = f"IssuerOAPermID eq '{p}'",
                top = 1,
                select = "IssuerOAPermID, IssuerCikNumber,ShortName" ).get_data()
    print(response.data.df)

EXPLORE OUR SITES