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
vuk.magdelinic avatar image
1 ●2 ●5 ●6

ek.get_data returns wrong informations

Hi,


Our process of pulling data is to pull TR.FiIssuerOrganization using ISIN of a security via ek.get_data and then use that org_id to perform another ek.get_data call to get all the fields needed for that organization.

However, we've been getting some cases where the information seemed incorrect. I'll be listing out several case examples:

1. ISIN="KR6066261AA9"

- Below is the data from isin pull

- ['KR6066261AA9', '165496', 'LGCRPS', 'LGCRP', 'S&I CORP']

- Below is the data from org_id pull

- ['165496', '3 Banken Portfolio-Mix A', '', 'http://www.sni.co.kr/', '82237731114', '', '', '', '', '', '', '', '', None, '', '', '4295881132', 'Austria', '2002-01-01', None, '', '', 'Service Company', 'Service - Other']

As you can see, the get_data pulled a Fund profile instead of S&I Corp.


2. ISIN=

- Below is the data from isin pull

- ['CND100045HT7', '75877', 'SHSHI', 'GEFRN', 'SHANGHAI SHIMAO CO LTD']

- Below is the data from org_id pull

- ['75877', 'Shanghai Shimao Co Ltd', 'http://www.shimaoco.com', '862120203388', '862120203399', 60102030, '600823', 15979976791.86, 2615, '', 'AAA', 'Real Estate Development', '', '2021-12-31', 149304753980, '4297714707', 'China', '1992-07-01', None, '', '', 'Other Financial', 'Real Estate Investment Trust']

As you can see, The ticker information of one doesn't match the other. (SHSHI != 600823)


3. ISIN="SGXF51098246"

- Below is the data from isin pull

- ['SGXF51098246', '42122', 'HPPS', 'HLDIN', 'HOTEL PROPERTIES LTD']

- Below is the data from org_id pull

- ['42122', 'Hotel Properties Ltd', 'https://www.hotelprop.com.sg/', '6567345250', '6567320347', 25301020, 'H15', 1788711560.93, '', '', '', 'Hotels, Resorts & Cruise Lines', None, '2020-12-31', 3388229000, '5042257290', 'Singapore', '1980-01-28', None, '', '', 'Service Company', 'Lodging']

As you can see, The ticker information of one doesn't match the other. (HPPS != H15)


I would consider Case2 and Case3 to be similar but these are the three cases we've observed so far and would like to know how we can pull the correct information.


Thank you so much for your time.

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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.

chavalit-jintamalit avatar image   chavalit-jintamalit

Thank you for your participation in the forum.
Is the reply below satisfactory in answering your question?
If yes please click the 'Accept' text next to the reply.
This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS


wasin.w avatar image   wasin.w

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
Upvote
Accepted
Alex Putkov.1 avatar image
39.4k ●77 ●11 ●27

@vuk.magdelinic

1. If you don't restrict the type of input, you're running the risk of ambiguity, where the same exact code may refer to multiple entities, as is the case in this example. 165496 is the Org ID for S&I Corp, and it's also WKN (German Wertpapierkennnummer) for 3 Banken Portfolio-Mix T fund. To restrict the input type to Org ID, append "@orgid" to the Org ID number. E.g.

ek.get_data('165496@orgid', ['TR.CommonName'])

returns "S&I Corp".

2. You didn't specify the fields you're using, but I'm guessing you're not using the same field names in the 1st and 2nd request, as the 1st request returns the fixed income ticker for the bond with ISIN CND100045HT7, whereas the 2nd request returns the exchange ticker for the issuer's common stock.

3. Same as #2.

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.