Why when pulling data using the RIC the values are correct but it is showing Null when using the ...

dawat1354

...ISIN?

Same problem as posted in this question https://community.developers.refinitiv.com/questions/37734/why-when-pulling-data-using-the-ric-the-values-are.html?

When retreiveing data from EIKon with ISIN i get null values for some data whereas when using RIC's the data returned is just fine.

How do i fix this with EIKON?

If Source is to be used with ISIN then how do I provide source with Eikon-python-api package ?

UPDATE

ek.get_data(['IT0005366767', 'GB00BH3VJ782', 'NETW.L', 'NEXII.MI'],
                        ['TR.EPSACTVALUE(Period=FY0)',
                         'TR.EPSMEANESTIMATE(Period=FY0)',
                         'TR.EBIT(Period=FY0)',
                         'TR.NETDEBT(Period=FY0)',
                         'TR.TOTALLONGTERMDEBT(Period=FY0)',
                         'TR.COMMSHAREHOLDERSEQTY(Period=FY0)',
                         'TR.NUMBEROFSHARESOUTSTANDINGMEAN(Period=FY0)',
                         'TR.GICSSUBINDUSTRYCODE',
                         'TR.RIC',
                         'TR.ISIN'], field_name=True)

As u can see the resultant dataframe, row 1 and row 2 are queries with ISIN and row 3 and 4 are with RIC for the same company(asset). But results from ISIN query are NULL's in major of the columns whereas the once with RIC return values

What is the work around for this ? So ISIN returns values too

chavalit-jintamalit

Hi @dawat1354

Some database does not support ISIN identifier.

You can see it from the error message.

This is the same on Eikon Excel:

You can convert ISIN to RIC before making an API call.

df,e = ek.get_data('IT0005366767','TR.RIC')
ric = df['RIC'].tolist()


df,e = ek.get_data(ric,
                   ['TR.EPSACTVALUE(Period=FY0)',
                    'TR.EPSMEANESTIMATE(Period=FY0)',
                    'TR.EBIT(Period=FY0)',
                    'TR.NETDEBT(Period=FY0)',
                    'TR.TOTALLONGTERMDEBT(Period=FY0)',
                    'TR.COMMSHAREHOLDERSEQTY(Period=FY0)',
                    'TR.NUMBEROFSHARESOUTSTANDINGMEAN(Period=FY0)',
                    'TR.GICSSUBINDUSTRYCODE',
                    'TR.RIC',
                    'TR.ISIN'],
                   field_name=True)

df.transpose()