Market Cap from ISIN. Used to work, does not work anymore.

Some weeks ago I downloaded the market capitalization from a list of ISINs using the following code. Now, the same code does not work anymore. Why?

Find more posts tagged with

python api

eikon-data-api

Accepted answers

jason.ramchandani01

@popescua So i think the issue here is that the implied ISIN to RIC symbology conversion could not return a 'best match' singular resolution. In cases such as these you can use the get_symbology API call and set the best_match parameter to false and then select the first RIC suggested.

ric = ek.get_symbology('AU0000069130',from_symbol_type='ISIN',to_symbol_type='RIC',best_match=False)

params = {'SDate':'20220101','EDate':'20200101','Frq':'D'}
df,err = ek.get_data(ric['RICs'][0][0],['TR.CompanyMarketCapitalization.date','TR.CompanyMarketCapitalization'],params)
df

I hope this can help.

All comments

jason.ramchandani01

ric = ek.get_symbology('AU0000069130',from_symbol_type='ISIN',to_symbol_type='RIC',best_match=False)

params = {'SDate':'20220101','EDate':'20200101','Frq':'D'}
df,err = ek.get_data(ric['RICs'][0][0],['TR.CompanyMarketCapitalization.date','TR.CompanyMarketCapitalization'],params)
df

I hope this can help.

EXPLORE OUR SITES