Symbology: SEDOL → RIC returns null in Python, but Workspace finds a RIC (ETF holdings use SEDOL)

Baruch

I’m building an ETF holdings pipeline. Provider files list constituents primarily by SEDOL. I need to resolve these SEDOLs to pricing RICs (and also capture ISIN/CUSIP). I’m using the Python Eikon/Workspace API.

What works / what doesn’t

• In Workspace (desktop), if I search by SEDOL I can see the security and its RIC.
• In Python, calling get_symbology returns RIC = NaN for many of the same SEDOLs. Because I have 1,000+ symbols, manual lookup isn’t feasible.

Sample Code I am Using:

import pandas as pd
import eikon as ek # Workspace/Eikon Python

for k, sedol in enumerate(df1['fld_sedol']):
tempDF = ek.get_symbology(sedol, from_symbol_type='SEDOL', to_symbol_type='RIC')
if 'RIC' in tempDF.columns and not pd.isna(tempDF['RIC'][0]):
tempRIC = tempDF['RIC'][0]
idenDF = ek.get_symbology(tempRIC) # expand to CUSIP/ISIN
if {'CUSIP','ISIN','RIC'}.issubset(idenDF.columns):
df1.loc[k,'fld_cusip'] = idenDF['CUSIP'][0]
df1.loc[k,'fld_isin'] = idenDF['ISIN'][0]
df1.loc[k,'fld_ric'] = idenDF['RIC'][0]
else:
print(f"SEDOL {sedol} → RIC = NaN")

Highlighted is sample record for which, we unable to get RIC via API.

But the same sedol has RIC in workstation:

Jirapongse

@Baruch

Thank you for reaching out to us.

Eikon Data API is outdated. You need to use the LSEG Data Library for Python instead.

You can use the get_data method to get RICs, and ISINs from SEDOLs. For example:

df = ld.get_data(
    universe =['BTFRHR4','B4KR8B5','BP3RL43'],
    fields = ['TR.RIC','TR.ISIN']
)

You can refer to the examples on GitHub. You can also refer to the Symbology and Search example. Regarding the Search API, please refer to the Building Search into your Application Workflow article.