symbology (sedol to ric)

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']);

Best Answer

Answers

  • now I am getting different error. Is there a data limit and how can I check?

    Error code 429 | Client Error: Too Many Requests - Too many requests, please try again later.

  • 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.

  • 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'])