Missing Environmental Data for Textile & Apparel group

iana.ladygina

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.

chavalit-jintamalit

Hi @iana.ladygina

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.