Retrieving company data items from LEI code

asli.sahin · November 2023

Hi,

From a list of LEI codes, how can I get the data items for those companies with a workspace licence using worksphace APIs?

Thanks.

m.bunkowski · November 2023

Hi @asli.sahin

For that purpose you can use refinitiv.data library and convert the LEI codes to RIC codes which can be later on used as standard inputs in api.

import refinitiv.data as rd
rd.open_session()

rd.get_data("213800TB53ELEUKM7Q61@LEI","TR.RIC")

asli.sahin01 · November 2023

https://community.developers.refinitiv.com/discussion/comment/111006#Comment_111006

Thanks very much @m.bunkowski

And from there 1) How do I bring the data items related 2) if it is a list of LEI instead of only one, how do I need to add the list of LEI in the code?

Many thanks

m.bunkowski · November 2023

https://community.developers.refinitiv.com/discussion/comment/111068#Comment_111068

Hi @asli.sahin01

If you insist on using the list of LEI codes you can do it like this:

lei_codes = ['213800TB53ELEUKM7Q61','213800LH1BZH3DI6G760','2138002P5RNKC5W2JZ46']
lei_codes_2 =  [f'{lei}@LEI'; for lei in lei_codes]
rd.get_data(lei_codes_2,"TR.RIC,TR.COMMONNAME,TR.CLOSEPRICE,TR.DIVIDENDYIELD")

However it is recommended to use the RIC codes and here is how you can easily tranform a LEI list to a RIC list

df = rd.get_data(lei_codes_2,"TR.RIC")
rics = df['RIC'].tolist()

Retrieving company data items from LEI code

Best Answer

Answers

Categories

EXPLORE OUR SITES

Retrieving company data items from LEI code

Best Answer

Answers

Categories