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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
iana.ladygina avatar image
5 ●0 ●1 ●0

Missing Environmental Data for Textile & Apparel group

Hi,

I'm trying to retrieve all environmental data (with all 121 criteria) for several years, for instance, 2009. However, I get a lot of missing values ( more than a half).

For instance, the code for emission data for 2009 I'm using (in R) is as follows:

Emission09TEX <- get_data(instruments, list("TR.PolicyEmissions(Period=CY2009)",
"TR.TargetsEmissions(Period=CY2009)",
"TR.BiodiversityImpactReduction(Period=CY2009)",
"TR.AnalyticCO2(Period=CY2009)",
"TR.CO2EmissionTotal(Period=CY2009)",
"TR.CO2DirectScope1(Period=CY2009)",
"TR.CO2IndirectScope2(Period=CY2009)",
"TR.CO2IndirectScope3(Period=CY2009)",
"TR.CarbonOffsetsCredits(Period=CY2009)",
"TR.AnalyticEstimatedCO2Total(Period=CY2009)",
"TR.CO2EstimationMethod(Period=CY2009)", 
"TR.EmissionsTrading(Period=CY2009)",
"TR.CementCO2Emission(Period=CY2009)",
"TR.ClimateChangeRisksOpp(Period=CY2009)",
"TR.FlaringGases(Period=CY2009)",
"TR.OzoneDepletingSubstances(Period=CY2009)",
"TR.NOxSOxEmissionsReduction(Period=CY2009)", 
"TR.NOxEmissions(Period=CY2009)",
"TR.SOxEmissions(Period=CY2009)",
"TR.AnalyticVOCorPMReduction(Period=CY2009)",
"TR.VOCEmissionsReduction(Period=CY2009)",
"TR.PMReduction(Period=CY2009)",
"TR.VOCEmissions(Period=CY2009)",
"TR.AnalyticTotalWaste(Period=CY2009)",
"TR.AnalyticWasteRecyclingRatio(Period=CY2009)",
"TR.AnalyticHazardousWaste(Period=CY2009)",
"TR.WasteTotal(Period=CY2009)", 
"TR.NonHazardousWaste(Period=CY2009)",
"TR.WasteRecycledTotal(Period=CY2009)",
"TR.WasteRecyclingRatio(Period=CY2009)",
"TR.HazardousWaste(Period=CY2009)",
"TR.WasteReductionInitiatives(Period=CY2009)",
"TR.eWasteReduction(Period=CY2009)", 
"TR.AnalyticDischargeWaterSystem(Period=CY2009)", 
"TR.WaterDischarged(Period=CY2009)", 
"TR.WaterPollutantEmissions(Period=CY2009)", 
"TR.ISO14000(Period=CY2009)", 
"TR.EMSCertifiedPct(Period=CY2009)", 
"TR.EnvRestorationInitiatives(Period=CY2009)", 
"TR.StaffTransportationReduction(Period=CY2009)", 
"TR.AccidentalSpills(Period=CY2009)",
"TR.AnalyticEnvExpenditures(Period=CY2009)", 
"TR.EnvExpenditures(Period=CY2009, Curn=USD)",
"TR.EnvProvisions(Period=CY2009, Curn=USD)", 
"TR.EnvInvestments(Period=CY2009)", 
"TR.SelfReportedEnvFines(Period=CY2009, Curn=USD)",
"TR.EnvPartnerships(Period=CY2009)", 
"TR.InternalCarbonPricing(Period=CY2009)", 
"TR.InternalCarbonPriceTonne(Period=CY2009, Curn=USD)", 
"TR.EmissionReductionTargetPctage(Period=CY2009)", 
"TR.EmissionReductionTargetYear(Period=CY2009)"));

The similar code I'm using to get the values for a Fiscal year:

Emissionf09TEX <- get_data(instruments, list("TR.PolicyEmissions(Period=FY2009)",
"TR.TargetsEmissions(Period=FY2009)",
"TR.BiodiversityImpactReduction(Period=FY2009)",
"TR.AnalyticCO2(Period=FY2009)",
"TR.CO2EmissionTotal(Period=FY2009)",
"TR.CO2DirectScope1(Period=FY2009)",
"TR.CO2IndirectScope2(Period=FY2009)",
"TR.CO2IndirectScope3(Period=FY2009)",
"TR.CarbonOffsetsCredits(Period=FY2009)",
"TR.AnalyticEstimatedCO2Total(Period=FY2009)",
"TR.CO2EstimationMethod(Period=FY2009)", 
"TR.EmissionsTrading(Period=FY2009)",
"TR.CementCO2Emission(Period=FY2009)",
"TR.ClimateChangeRisksOpp(Period=FY2009)",
"TR.FlaringGases(Period=FY2009)",
"TR.OzoneDepletingSubstances(Period=FY2009)",
"TR.NOxSOxEmissionsReduction(Period=FY2009)", 
"TR.NOxEmissions(Period=FY2009)",
"TR.SOxEmissions(Period=FY2009)",
"TR.AnalyticVOCorPMReduction(Period=FY2009)",
"TR.VOCEmissionsReduction(Period=FY2009)",
"TR.PMReduction(Period=FY2009)",
"TR.VOCEmissions(Period=FY2009)",
"TR.AnalyticTotalWaste(Period=FY2009)",
"TR.AnalyticWasteRecyclingRatio(Period=FY2009)",
"TR.AnalyticHazardousWaste(Period=FY2009)",
"TR.WasteTotal(Period=FY2009)", 
"TR.NonHazardousWaste(Period=FY2009)",
"TR.WasteRecycledTotal(Period=FY2009)",
"TR.WasteRecyclingRatio(Period=FY2009)",
"TR.HazardousWaste(Period=FY2009)",
"TR.WasteReductionInitiatives(Period=FY2009)",
"TR.eWasteReduction(Period=FY2009)", 
"TR.AnalyticDischargeWaterSystem(Period=FY2009)", 
"TR.WaterDischarged(Period=FY2009)", 
"TR.WaterPollutantEmissions(Period=FY2009)", 
"TR.ISO14000(Period=FY2009)", 
"TR.EMSCertifiedPct(Period=FY2009)", 
"TR.EnvRestorationInitiatives(Period=FY2009)", 
"TR.StaffTransportationReduction(Period=FY2009)", 
"TR.AccidentalSpills(Period=FY2009)",
"TR.AnalyticEnvExpenditures(Period=FY2009)", 
"TR.EnvExpenditures(Period=FY2009, Curn=USD)",
"TR.EnvProvisions(Period=FY2009, Curn=USD)", 
"TR.EnvInvestments(Period=FY2009)", 
"TR.SelfReportedEnvFines(Period=FY2009, Curn=USD)",
"TR.EnvPartnerships(Period=FY2009)", 
"TR.InternalCarbonPricing(Period=FY2009)", 
"TR.InternalCarbonPriceTonne(Period=FY2009, Curn=USD)", 
"TR.EmissionReductionTargetPctage(Period=FY2009)", 
"TR.EmissionReductionTargetYear(Period=FY2009)"));
Therefore, I want to ask if there is something missing in my code or the Eikon software does not provide such information.
eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonesgr-studio
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
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

Hi @Iana

I tried the same fields on Eikon Data API(Python) with 'IBM.N' and '0005.HK' instruments.


Then I randomly check the TR.EmissionReductionTargetYear(Period=CY2009) field.


So it seems to me that there is nothing wrong with the API because the data is not available.

In general, you can use "Data Item Browser" to double-check if the field value is available or not. Here is a tutorial which explains how to use "Data Item Browser"

Or you can contact Refinitiv Content Helpdesk at https://my.refinitiv.com/ to verify the content.


By the way, just want to bring out the API limitation guideline that the return data point in a single API call should not exceed 10000 data point for get_data(), refer to this document.

Because I do not know how many instruments you have in the same API call.

So please make sure that it does not exceed the limit.


ahs2.png (87.3 KiB)
ahs1.png (87.4 KiB)
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.

Click below to post an Idea Post Idea