I am getting 'No best match available' on many sedols although I can get Rics using excel plugin
=TR('BWY54W4','TR.RIC')
Any suggestions?
-------------------------------------- code to reproduce -------------------
import eikon as ek
import pandas as pd
sedols = ['BWY54W4','B17MT31','BD60093']
data=ek.get_symbology(sedols, from_symbol_type='SEDOL', to_symbol_type=['RIC']);
See the answer to similar question on this thread.
For explanation of "Error code 429 | Client Error: Too Many Requests" see Eikon Data APIs Usage and Guidelines document.
Do you know why it can't find matches on these sedols?
I have many many more examples where sedols won't map in eikon api but maps using Excel Plugin.
Sedols to RICs do not have a one to one relationship. If you're looking to get the primary RIC corresponding to a SEDOL your best bet is to use get_data method rather than get_symbology.
ek.get_data(['BWY54W4','B17MT31','BD60093'], ['TR.RIC'])