Do we have todays intraday return of 000120.KS?

Provided TR.TotalReturn as per definition - Total return incorporates the price change and any relevant dividends for the specific period. Date 02/09/2026 and calc date is 2/10/2026

As per client -

if you check that field... for that code, it returns 7.6pct, whch is yesterday's return
the return for today should be ~13pct

Find more posts tagged with

python

#content

Accepted answers

All comments

Jirapongse

@AndreiBersamin

Thank you for reaching out to us.

This forum is dedicated to software developers using LSEG APIs. The moderators on this forum do not have deep expertise in every bit of content available through LSEG products, which is required to answer content questions such as this one.

The best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through LSEG Support. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

You need to ask for the Excel formula, such as =RDP.Data, that can be used to retrieve the required data. Then, we can help you converting that formula to Python code.

AndreiBersamin

we need assistance to manually replicate this formula (current price close + Dividends)/previous price close – 1) *100 in API".,

AndreiBersamin

we need assistance to manually replicate this formula (current price close + Dividends)/previous price close – 1) *100 in API".,

Can you replicate this in Workspace Excel?

Then, I will try to convert it to Python code.

AndreiBersamin

@Jirapongse

=@TR (A4,"TRDPRC_1;TR.CLOSEPRICE(Sdate=-1Y),TR.DpsCommonStock(Sdate=1D,Edate=-1Y)")

Where as A4 is 000120.KS

raksina.samasiri

Hi @AndreiBersamin ,

It is converted to the code below, is this what you're looking for?

ld.get_data(

    universe=['000120.KS'],

    fields=['TRDPRC_1', 'TR.CLOSEPRICE(Sdate=-1Y)', 'TR.DpsCommonStock(Sdate=1D,Edate=-1Y)']

)

Regarding parameters field, you can use the date itself in the SDate and EDate, for example

ld.get_data(

    universe=['000120.KS'],

    fields=['TR.TotalReturn','TR.TotalReturn.date','TR.TotalReturn.calcdate'],

    parameters={'SDate':'2026-02-09'}

)

Output parameters .date and .calcdate can be added into the fields to see its value, the available parameters of each field can be found in DIB or CODECR in the Workspace application

AndreiBersamin

@raksina.samasiri

Can we do this real time? Please refer to screenshot. G4 total return

=@TR (A4,"TRDPRC_1;TR.CLOSEPRICE(Sdate=-1Y),TR.DpsCommonStock(Sdate=1D,Edate=-1Y)")

Jirapongse

@AndreiBersamin

It looks like that we don't have any TR field that can directly return the Total Return value.

Therefore, we need to calculate it from those values. Therefore, the code will look like this:

df = ld.get_data(
    universe=['000120.KS'],
    fields=['TRDPRC_1', 'TR.CLOSEPRICE(Sdate=-1Y)', 'TR.DpsCommonStock(Sdate=1D,Edate=-1Y)']
)
current = float(df["TRDPRC_1"][0])
dividends = df["DPS - Common Stock Primary Issue"][0]
prev_close = df["Close Price"][0]

total_return = (((current + dividends)/prev_close) -1) * 100
total_return

Or,

df = ld.get_data(
    universe=['000120.KS'],
    fields=['TRDPRC_1', 'TR.CLOSEPRICE(Sdate=-1Y)', 'TR.DpsCommonStock(Sdate=1D,Edate=-1Y)']
)
df["Total Retun"] = (((float(df["TRDPRC_1"]) + df["DPS - Common Stock Primary Issue"])/df["Close Price"])-1) * 100
df

AndreiBersamin

@Jirapongse Please advise on below follow up

I don’t think the latest response below answers my question. As a reminder, I want the intraday return, I.e. the return from previous days close to *now*. I think the response answers for 1 year total return? However, I think we are closer?

It should be some combination of TRDPRC_1 (which is the intraday price), the TR.CLOSEPRICE(SDate=0D), and The Dividend field

Jirapongse

@AndreiBersamin

Because the forum moderators are not content experts, please provide the Workspace Excel formula and confirm its results with the client.

After that, I can translate it into Python code.

EXPLORE OUR SITES