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
vishal.kak avatar image
9 ●1 ●8 ●13

how can I retrieve sedol from isin using eikon data api

eikon-data-api
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.

wasin.w avatar image   wasin.w

Hello @vishal.kak

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

raksina.samasiri avatar image   raksina.samasiri

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,
AHS

3 Answers

· Write an Answer
Upvotes
Accepted
Gurpreet avatar image
22.1k ●59 ●14 ●21

Hi @vishal.kak ,

Ideally you can use the symbology call in the Eikon Aata API to get the symbol conversion. E.g:

ek.get_symbology(
    ['US5949181045', 'US02079K1079', 'US4592001014'], 
    from_symbol_type='ISIN', 
    to_symbol_type='RIC')

However, this might not work when using ISIN as a source, since there is a one to many mapping, and no best match.

1637942466123.png


I would recommend that you speak with Eikon content experts at my.refinitiv.com to see if there is another means to do this.


Update: You can use the get_data call to get the SEDOL using this call:

1637942714926.png



1637942466123.png (8.3 KiB)
1637942714926.png (6.8 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
vishal.kak avatar image
9 ●1 ●8 ●13

Thanks for your response

Why am I getting "No best match available" error when I try to search for Microsft ISIN - US5949181045

df = ek.get_symbology("US5949181045", from_symbol_type="ISIN", to_symbol_type="SEDOL")
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.

Gurpreet avatar image Gurpreet
I edited the previous answer. Try to use the get_data call instead.
Upvotes
vishal.kak avatar image
9 ●1 ●8 ●13

perfect, that worked - thanks

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.

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.