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
solik avatar image
1 ●0 ●1 ●2

Is there a possibility to get all the RICs for a particular exchange with ek.get_symbology (Python API)?

For example I would get 5 RICs with the following request: RSearch("EQUITY","Search:SG2D00968206 ExchangeName:'Singapore Exchange Securities Trading Ltd'","NBROWS:10",..). How can I do the same by ek.get_symbology?

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-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 @solik

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

zoya faberov avatar image   zoya faberov

Hello @solik,

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

Thanks,

-AHS

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
78.8k ●250 ●52 ●74

@solik

You can use ek.get_symbology to convert ISIN to RICs. Then, from the returned RICs, you can retrieve CF_EXCHNG (the exchange identifier on which the instrument trades). Next, you need to filter RICs by CF_EXCHNG.

For example:

ricsList = ek.get_symbology(["SG2D00968206"], from_symbol_type="ISIN",  to_symbol_type="RIC", raw_output=True,  bestMatch=False)

df = ek.get_data(ricsList['mappedSymbols'][0]['RICs'], ['CF_EXCHNG'])

print (df[0].loc[df[0]['CF_EXCHNG']=='SES'])

The output is:


ses.png (24.5 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.

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.