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.

DuongNHTT_1401

https://community.developers.refinitiv.com/discussion/comment/124116#Comment_124116

dear @jason.ramchandani01

Thank you very much. However, when I run it, I got the below error

LDError: The access to field(s) denied. Requested universes: ['TSLA.O', 'IBM.N']. Requested fields: ['TR.COMPANYGREENREVENUEPERCENTAGE.PERIODENDDATE', 'TR.COMPANYGREENREVENUEPERCENTAGE']

Could you please help me in this problem. Thank you very much

DuongNHTT_1401

https://community.developers.refinitiv.com/discussion/comment/124116#Comment_124116

dear @jason.ramchandani01 It seems like my account doesn't have permission to use ld.get_data(). Could you please help me in ek.get_data or rd.get_data()? Very much appreciated

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/124119#Comment_124119

@DuongNHTT_1401

I got the same error when using the LSEG Data Platform session.

LDError: The access to field(s) denied. Requested universes: ['TSLA.O', 'IBM.N']. Requested fields: ['TR.COMPANYGREENREVENUEPERCENTAGE.PERIODENDDATE', 'TR.COMPANYGREENREVENUEPERCENTAGE']

It runs fine with the desktop session. Please contact your LSEG account team or sales team to verfiy the permissions. We can't modify the clients' permissions.