Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
dawat1354 avatar image
1 ●2 ●2 ●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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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 512.0 KiB each and 1.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

zoya faberov avatar image   zoya faberov

Hello @dawat1354,

Thank you for your participation in the forum.

Is the reply below satisfactory in resolving your query?

If so, please click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.

Thanks

-AHS

chavalit-jintamalit avatar image   chavalit-jintamalit

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such. Thanks, AHS


1 Answer

· Write an Answer
Upvotes
Accepted
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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