For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
ugurdeniz.sahin avatar image
1 ●0 ●0 ●0

GetSymbology function in ekiondataAPI does not return results for conversion from ISIN to RIC code.

List<SymbologyType> toSymbolType = new List<SymbologyType> {SymbologyType.RIC };

var responseSymbol = eikon.GetSymbology(isin, SymbologyType.ISIN, toSymbolType);

{series [ error => series [ XS1816199373 => No best match available; US900123BY51 => No best match available; TRT120822F16 => No best match available; US900123BZ27 => No best match available; TRT140723F14 => No best match available; ... ; US900123CM05 => No best match available]]}


What should I do to reach the RIC code from the ISIN code?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonsymbology
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

2 Answers

Upvotes
Accepted
jason.ramchandani01 avatar image
6.7k ●8 ●6 ●7

@ugurdeniz.sahin So the service cannot find a best match for the isin so it returns the message no best match - for such outcomes try setting the best_match = False parameter and it will return a list of instruments it thinks are relevant. Usually it is the top one in the list. 

df = ek.get_symbology('XS1816199373', from_symbol_type='ISIN', to_symbol_type='RIC',best_match=False)
df

1629903243617.png

I hope this can help.


1629903243617.png (39.9 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
ugurdeniz.sahin avatar image
1 ●0 ●0 ●0

Can the getdata function be used in this sense?

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

jason.ramchandani01 avatar image jason.ramchandani01

@ugurdeniz.sahin So I checked with the following and I believe it is using the first RIC of best_match = False return set:

df,err = ek.get_data('XS1816199373',['TR.InstrumentDescription','TR.RIC'])
df

1629910832764.png

So if that is ok for you go ahead.

You could also try to use the RDP Search API to confirm correctness of those edge cases:

import refinitiv.dataplatform as rdp
session = rdp.open_desktop_session('YOUR APP KEY HERE')

rdp.search("XS1816199373")

1629911214389.png

I hope this can help.

1629910832764.png (30.5 KiB)
1629911214389.png (302.6 KiB)
Click below to post an Idea Post Idea