Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 1 1 4

How to translate Excel formula into python syntax?

I need to extract historcal ESG through Refinitiv Eikon Python.

i have the following Excel formula and need to translate it into python syntax, please!

=@RDP.Data("AAPL.O","TR.TRESGScore(RollPeriods=True IncludePartialYear=True)","Period=FY0 Frq=FY SDate=2019-01-01 EDate=2022-12-31 CH=Fd RH=IN;date",C3)



eikon-data-apipython#technologypython apiesg
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Accepted
80k 257 52 75

@RamadanEA

Thank you for reaching out to us.

Please try this one:

df, err = ek.get_data(['AAPL.O'],
                     fields=['TR.TRESGScore(RollPeriods=True,IncludePartialYear=True)'],
                     parameters={
                         'Period':'FY0',
                         'SDate':'2019-01-01',
                         'EDate':'2022-12-31'
                                }
                     )
df

The output is:

1688694880856.png



1688694880856.png (19.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
1 1 1 4

@Jirapongse Thank you!

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.