1
●0 ●0 ●0
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.
1.5k
●5 ●3 ●6
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
1
●0 ●0 ●0
@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.
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)
