Periodic Total Return for specified dates & currencies using Datastream in Python

Farrep

Hi, I would like to replicate the below excel formula using the python api.

The goal is to get the total return of an Isin for a given period in a specific currency. In this case EUR. As we wish to do this for a considerable amount of Isins over multiple time periods, we wish to move from excel to Python to achieve this. Your help would be gratefully appreciated.

=IFERROR((@DSGRID ($B107,"PCH#(X"&$H107&","&TEXT(AE$8,"DD/MM/YY")&","&TEXT($AD$8,"DD/MM/YY")&")","Latest Value","","","RowHeader=False;ColHeader=False;DataTypeDefLink=False;DispSeriesDescription=False;DispDatatypeDescription=False",""))/100,"")

$B107 = BE6328398217

$H107 = (RI)~E

AE$8 & $AD$8 = Start & End Date

Jirapongse

@Farrep

Thank you for reaching out to us.

I am using the Datastream Web Service Python library (DatastreamPy).

The code looks like this:

start_date_pch = '01/01/26'
end_date_pch = '31/01/26'

fields = "PCH#(X(RI)~E,{},{})".format(start_date_pch, end_date_pch)
df=ds.get_data(tickers='BE6328398217', fields=[fields], kind = 0)
df