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.

Best Answer

  • 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']
    )

Answers

  • @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.