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
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
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
Hello @jaime.oliver,
It would be very helpful to provide the complete requests/python code excerpts that you are running, when you observe this?
Hello @jaime.oliver,
Unless you are able to provide more details, we are not able to be of help in answering your question.
Hello @jaime.oliver,
We are investigating and will be back with an update as soon as we can.
Thank you for your patience,
-AHS
Could you please confirm if you are still seeing a discrepancy in the number of controversies, or not?
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
Hello @jaime.oliver,
I see what you see on this. It is not obvious to me why, so we are investigating this further. We will get back with the findings.
Hello @jaime.oliver,
We have reported your findings to the product, and are awaiting their input.
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, are you still seeing a discrepancy in the number of controversies, or not ?
I have tested the same code and still get the discrepancy
Hello @jaime.oliver,
I see it as well, it is happening again. I am reporting this, to the relevant content group, and will await their response.
Thank you for your patience.
Can I get the complete code for extracting the ESG Controversies with Metric, starting Fy, ending FY, and ticker as parameters @jaime.oliver