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

s1910010
s1910010
in Refinitiv Data Platform
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.
Tagged:

Best Answer

  • m.bunkowski
    m.bunkowski
    Answer ✓

    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

Answers

  • m.bunkowski
    m.bunkowski

    Hi @s1910010

    You can do it search that is a part of a refinitiv data library. Here is a sample 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
    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
    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)

Categories