For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
dawat1354 avatar image
1 ●0 ●1 ●1

Why when pulling data using the RIC the values are correct but it is showing Null when using the 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

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
2020-03-04-10h00-29.png (16.8 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

zoya faberov avatar image 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 avatar image dawat1354 zoya faberov

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


Thanks

1 Answer

Upvotes
Accepted
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

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

ahs1.png (67.7 KiB)
ahs2.png (25.7 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea