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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
miriam.benito avatar image
13 ●2 ●2 ●6

Force to get_data() function to look for an orgId

Hi,

I am trying to get some info about some companies looking for the orgid code. For that, I am considering the orgid as the instrument. I have some problems when the orgid can be contained in another code, such as the ISIN.

Is there any way to force get_data() function to look for the orgid codes?

orgid                                   17051
companyname          COCA-COLA AMATIL LIMITED
TR.CommonName    AXA Europe Small Cap A C EUR
TR.Orgidcode                              NaN

The first two rows are the info about the company that I want to look for, and the last two rows are the retrieved data.

Thanks in advance,

Miriam

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
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.

1 Answer

Upvotes
Accepted
marcin.bunkowski avatar image
3.8k ●4 ●4 ●6

Hi @miriam.benito

If you want to use OrgID as an input please use syntax as below:

df, err=ek.get_data('17051@orgid', ['TR.RIC','TR.CommonName','TR.OrgidCode']) df
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.

miriam.benito avatar image miriam.benito

Really?? Thank you so much!!!!

miriam.benito avatar image miriam.benito

How this syntax has to be changed to use permid? I mean, permid is 10-digit number, hence, it could be included inside an ISIN string, right?

Alex Putkov.1 avatar image Alex Putkov.1 miriam.benito

I don't think you need to worry about ambiguity when using permID as input without any qualifiers. When requesting data from Eikon using get_data method the symbology resolution is looking for the exact match, not an approximate match. ISIN cannot be confused with permID because permID is purely numeric (it's a 64-bit integer) whereas ISIN always starts with two alphabetic characters (alpha-2 ISO 3166-1). But if you'd like to specifically restrict the input to organization permID you can use the input in the form of xxx@organizationid where "xxx" is the organization permID, e.g. for Coca-Cola Amatil Ltd you could use

ek.get_data('4295856928@organizationid', 
            ['TR.RIC','TR.CommonName',
             'TR.OrganizationId','TR.OrgidCode'])
Click below to post an Idea Post Idea