Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 1 1

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-apirefinitiv-dataplatform-eikonworkspaceworkspace-data-apisymbology
icon clock
10 |1500

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

Upvotes
Accepted
10.1k 18 6 9

@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 512.0 KiB each and 1.0 MiB total.

Upvotes
1 0 1 1

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 512.0 KiB each and 1.0 MiB total.

@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)

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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