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()

zoya faberov

Hello @dawat1354,

Could you please be more specific, and paste in the request, so we know exactly what you are attempting to do?

get_data function or get_timeseries?

TR. fields or CF_ ?

dawat1354

https://community.developers.refinitiv.com/discussion/comment/56384#Comment_56384

Hi @zoya could you please see the update and give me an answer?

Thanks