Controversy details extraction

jaime.oliver
jaime.oliver
in Eikon Data APIs

We are having issues extracting controversy details using the Eikon python API. When querying for General Electrics alone we get 11 controversy details, but querying at the same time for GE and other company we get less controversy details

Tagged:

Answers

  • jaime.oliver
    jaime.oliver

    An example of the problem can be reproduced using the following code: 

    # Output for the fields
    outputs = [
        "fperiod",
        "esgsourcetitle",
        "esgsourcedate",
        "esgsourcepublisher",
        "esgsourceurl",
        "esgsourceabstract",
    ]
    # Set parameters
    params = {
        "AddSource": True,
        "EDate": -2,
        "Period": "FY0",
        "Frq": "FY",
        "CH": "Fd",
        "RH": "IN",
    }

    # Metrics 
    controversies = ['TR.ControvEnv',
     'TR.RecentControvEnv',
     'TR.ControvCopyrights',
     'TR.ControvPublicHealth',
     'TR.ControvBusinessEthics',
     'TR.ControvTaxFraud',
     'TR.ControvAntiCompetition',
     'TR.ControvCriticalCountries',
     'TR.RecentControvPublicHealth',
     'TR.RecentControvBusinessEthics',
     'TR.RecentControvTaxFraud',
     'TR.RecentControvAntiCompetition',
     'TR.RecentControvCriticalCountries',
     'TR.RecentControvCopyrights',
     'TR.ControvHumanRights',
     'TR.ControvFreedomofAssociation',
     'TR.ControvChildLabor',
     'TR.RecentControvHumanRights',
     'TR.RecentControvChildLabor',
     'TR.ControvConsumer',
     'TR.RecentControvConsumer',
     'TR.ControvCustomerHS',
     'TR.ControvResponsibleRD',
     'TR.ControvPrivacy',
     'TR.ControvRespMarketing',
     'TR.ControvProductAccess',
     'TR.ProductRecall',
     'TR.RecentControvPrivacy',
     'TR.RecentControvRespMarketing',
     'TR.RecentControvProductAccess',
     'TR.RecentControvResponsibleRD',
     'TR.ControvDiversityOpportunity',
     'TR.RecentControvDiversity',
     'TR.MgtDepartures',
     'TR.ControvWorkingCondition',
     'TR.RecentControvWorkingCondition',
     'TR.ControvEmployeesHS',
     'TR.RecentControvEmployeesHS',
     'TR.ControvMgtComp',
     'TR.ControvRecentMgtComp',
     'TR.ControvShareholders',
     'TR.RecentControvShareholders',
     'TR.ControvInsiderDealings',
     'TR.ControvAccounting',
     'TR.RecentControvInsiderDealings',
     'TR.RecentControvAccounting']

    metrics = [c + '.' + o for o in outputs for c in controversies]
    features = [{m:{'params':params}} for m in metrics

    If i make the API call for several companies: 

    ek.get_data( ['US3696041033','US0378331005'], features) 

    I get 5 controversies for ISIN US3696041033, while making the call one-by-one, I get 11


  • jaime.oliver
    jaime.oliver

    Do we have any update on this matter?

    Thank you

  • zoya faberov
    zoya faberov

    Hello @jaime.oliver,

    We have tested this request, and it looks like the discrepancy in the number of controversies tat you were observing previously, was fixed on the back end.

    Could you please verify on your side?

    Thanks,

    -AHS

  • jaime.oliver
    jaime.oliver

    I have tested the same code and still get the discrepancy

  • rd1021
    rd1021

    jaime.oliver

Categories