get_symbology() from SEDOL to RIC returns "no best match available"

I am trying to convert SEDOL to RIC through get_symbology, but it returns "no best match available". Meanwhile, Same SEDOL is able to convert SEDOL to ISIN.

However, I tested it with other SEDOL, it is able to convert SEDOL to RIC.

Those unavailable assets are mainly ETFs, and I wonder is this the reason that cause the issue, thank you.

Find more posts tagged with

python

symbology

eikon-data-api

workspace-data-api

#technology

Accepted answers

All comments

Jirapongse

@AxiomaMDS

Thank you for reaching out to us.

The error indicate that it can't return the best match RIC for BRC16M3. You need to set the best_match to false.

data = ek.get_symbology(["BRC16M3"], 
                       from_symbol_type="SEDOL", 
                       to_symbol_type="RIC", 
                       best_match=False)
                
data["RICs"].tolist()

It will return the mapped RICs.

Otherwise, you can use the Symbology API in the LSEG Data Library for Python.

response = symbol_conversion.Definition(
    symbols=["BRC16M3"],
    from_symbol_type=symbol_conversion.SymbolTypes.SEDOL,
    to_symbol_types=[
        symbol_conversion.SymbolTypes.RIC,
        symbol_conversion.SymbolTypes.ISIN
    ]
).get_data()

response.data.df

The examples are on GitHub.

AxiomaMDS

https://community.developers.refinitiv.com/discussion/comment/125937#Comment_125937

Regarding best_match method, it seems not working for my side. Also, will the asset type affect the usage of get_symbology? I have tried a list of ETFs and it returns no best match available, while common stocks work normally.

Jirapongse

@AxiomaMDS

What URL are you using to send this request?

AxiomaMDS

https://community.developers.refinitiv.com/discussion/comment/125987#Comment_125987

The same url works for non-ETFs asset, so I wonder is it relate to asset type?

Jirapongse

@AxiomaMDS

As far as I know, this should not be our endpoint.

It seems that you are developing a web app, which could be used by other individuals or machines; it would violate the Workspace contract. The data from Eikon Data API can be used outside the Workspace machine. Please contact your LSEG account team or Sales team directly to verify this kind of usages.

We offer other RESTful API's like Data Platform for those purposes.

EXPLORE OUR SITES