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
0 3 4 7

is it possible to get the Company Auditor

Hi im wondering if it possible to pull the company auditor from the api. Eg Apple auditor it Ernst & Young.

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.

1 Answer

· Write an Answer
Upvote
Accepted
39.4k 77 11 27

Use CodeCreator app for metadata discovery (finding field names and parameters) for use with Eikon Data APIs. Typing in Instruments: "AAPL.O", Data Items: "auditor" in CodeCreator app returns Auditor Details ('TR.F.Auditor') field among other fields whose description contains the word "auditor". Double clicking on a field produces a code snippet, which you can copy & paste into your code:

df, err = ek.get_data(
    instruments = ['AAPL.O'],
    fields = ['TR.F.Auditor']
)
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.

@Alex Putkov. Thanks for this, new to this so great to know about this code creator app. Instead of the instrument, is it possible to get the Auditor field and other fields etc by using the ticker 'APPL' not 'APPL.O'?

You can use any common instrument identifier such as CUSIP, ISIN, SEDOL, ticker etc. to retrieve most of the fields. Ticker needs to be appended with "@ticker", e.g.

df, err = ek.get_data(
    instruments = ['AAPL@ticker','09260D107'],
    fields = ['TR.RIC','TR.CommonName']
)

However there are some caveats. Real-time fields like CF_LAST, TRADE_DATE, HST_CLOSE etc. can only be retrieved using RIC symbology. And the fields that start with "TR.F." cannot be retrieved using tickers. The latter is a deficiency that I expect to be addressed in the future, but there are currently no plans to support any symbology other than RICs for the real-time data. For these reasons I would recommend converting tickers to RICs (as in the example above), and use RICs to retrieve any fields you need.

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.