How to download the carbon (CO2) emission data for companies around the world (especially, the co...

...mpanies in the US, Europe and Asia) using python code?

Customer is looking to download the carbon (CO2) emission data for companies around the world (especially, the companies in the US, Europe and Asia) from 2000 to 2022? If possible to get python code for API for the downloading.

Find more posts tagged with

eikon-data-api

#content

Accepted answers

raksina.samasiri

Hi @navamani.p ,

The CodeCreator application provided in Eikon Desktop/Refinitiv workspace can be used to create the Python code for this. To access it, type 'CODECR' in the Eikon search bar, and after the CodeCreator app is launched, please follow the explanation of steps in the screenshot below

Put the RICs in the instruments field
The data item can be searched here, I put 'ESG Score' and the result shown
Click on the field name to add it to the code
Click Parameters & Quick Functions to apply parameters
Here I select the Last 5 FY (Fiscal Year). You can apply other parameters here as well
Click this to copy code into the clipboard

Then you can paste the code on any Python compiler, you can also use CodeBook application in Eikon Desktop/Refinitiv Workspace as well, the result is

Please note that I adjust the code a bit to retrieve the data date

import refinitiv.data.eikon as ek

ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY')

df, err = ek.get_data(
    instruments = [
        'AAPL.O',
        'MSFT.O'
    ],
    fields = ['TR.TRESGScore.date', 'TR.TRESGScore'],
    parameters = { 'Period': 'FY0', 'Frq': 'FY', 'SDate': '0', 'EDate': '-4'}
)

display(df)

hope this helps and please let me know in case you have any further questions

All comments

raksina.samasiri

Hi @navamani.p ,

Put the RICs in the instruments field
The data item can be searched here, I put 'ESG Score' and the result shown
Click on the field name to add it to the code
Click Parameters & Quick Functions to apply parameters
Here I select the Last 5 FY (Fiscal Year). You can apply other parameters here as well
Click this to copy code into the clipboard

Then you can paste the code on any Python compiler, you can also use CodeBook application in Eikon Desktop/Refinitiv Workspace as well, the result is

Please note that I adjust the code a bit to retrieve the data date

import refinitiv.data.eikon as ek

ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY')

df, err = ek.get_data(
    instruments = [
        'AAPL.O',
        'MSFT.O'
    ],
    fields = ['TR.TRESGScore.date', 'TR.TRESGScore'],
    parameters = { 'Period': 'FY0', 'Frq': 'FY', 'SDate': '0', 'EDate': '-4'}
)

display(df)

hope this helps and please let me know in case you have any further questions

EXPLORE OUR SITES