Help with Retrieving 'TR.CompanyGreenRevenuePercentage' via API with Date Correspondence

DuongNHTT_1401

Hi everyone,

I am trying to retrieve the 'TR.CompanyGreenRevenuePercentage' data using the API with the following code:

df = ek.get_data(
    universe=batch,  
    fields=['TR.CompanyGreenRevenuePercentage'],
    parameters={'SDate': '20131231', 'EDate': '20221231'}  
)

However, the output does not include the corresponding dates. I attempted to add 'TR.CompanyGreenRevenuePercentage.date', but it didn't work.

Could you please help me retrieve this data along with the associated dates?

Thank you very much!

jason.ramchandani01

@DuongNHTT_1401 Thanks for your question. We have a newer library which is much better than the Eikon Data library which is now 2 generations old (but the fields and parameters will work with ek.get_data). It is called the LSEG Data library and can be downloaded from 'pip install lseg-data'.

import lseg.data as ld

import pandas as pd

ld.open_session()

df = ld.get_data(
    universe=['TSLA.O', 'IBM.N'],
    fields=['TR.CompanyGreenRevenuePercentage.periodenddate','TR.CompanyGreenRevenuePercentage'],
    parameters ={'SDate':0,'EDate':-9,'Period':'FY0','Frq':'FY'}
)

df

I hope this can help.