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?
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
1
●0 ●0 ●2
Is there a possibility to get all the RICs for a particular exchange with ek.get_symbology (Python API)?
38.1k
●69 ●35 ●53
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:
