do you have the python code requiring the permid of all companies for which Refinitiv can provide ESG scores or data ?
@Huma
Thank you for reaching out to us.
I used the method mentioned in this Evolution of ESG Disclosures article.
The code should look like this:
df = ld.get_data(["SCREEN(U(IN(Equity(active,public,private,primary))/*UNV:PublicPrivate*/), TR.TRESGScore(Period=FY2002)>=0)"], ['TR.CommonName','TR.TRESGScore','TR.OrganizationID']) df
However, please contact the helpdesk team directly via MyAccount to verify the screener formula and those fields.
@Jirapongse When I tried using the above on Code book in Workspace , I got the below output with error.
---------------------------------------------------------------------------NameError Traceback (most recent call last)/tmp/ipykernel_112/1360442533.py in <module>----> 1 df = ld.get_data(["SCREEN(U(IN(Equity(active,public,private,primary))/*UNV:PublicPrivate*/), TR.TRESGScore(Period=FY2002)>=0)"], 2 ['TR.CommonName','TR.TRESGScore','TR.OrganizationID']) 3 4 dfNameError: name 'ld' is not defined
Please refer to the __Examples__/01. Data Retrieval and Discovery/01.01. LSEG Data Library/Access__Get_Data.ipynb example on Codebook.
Hello @Jirapongse Upon checking didn't find "__Examples__/01. Data Retrieval and Discovery/01.01. LSEG Data Library/Access__Get_Data.ipynb" on Codebook(CODEBK), can you please share the path on Codebook(CODEBK).
And also can you please let us know if there any alternate python code to retrieve Perm Id of all companies for which Refinitiv can provide ESG scores or data ?
