How to retrieve data for all KPIs linked to the bond in CODEBK?

Screenshot 2026-03-06 at 14.40.49.png

I’m trying to retrieve data for the KPIs associated with a sustainability-linked bond (SLB).

Many SLBs contain multiple KPIs (structured as separate KPI legs). However, when I query the data in CodeBook, I only receive results for the first KPI leg, even though the bond in my example has four KPIs defined (see Screenshot).

When looking at the Excel functions for the variables of interest on the overview page of the bond, it shows the same excel function for each of the KPIs. For example =TR("BRVIVTDBS093=","TR.FIKPIReportedNumber") for KPI 1 to 4.

Any suggestions on how to retrieve data for all KPIs linked to the bond would be very helpful.

Find more posts tagged with

python

bonds

codebook

#content

Accepted answers

All comments

raksina.samasiri

Hi @Eugene Torres ,

I've tried adding 'TR.FIKPIDescription' into the field list. I got 4 KPI description but I cannot find how to get all detail of each KPI leg number.

As the moderators on this forum do not have deep expertise in every type of content available through LSEG products. Such expertise is available through the Helpdesk. If the Helpdesk can show you how to retrieve it using a formula in Workspace Excel, then the moderators on this forum can help you translate it into get_data method in the Data Library call. The Helpdesk can be reached via Home | LSEG Support. You can raise the ticket there and the support team is going to contact you directly to assist with this.

Hope this helps and please let me know in case you have any further questions.

raksina.samasiri

Hi @Eugene Torres ,

I've checked in the case you raised and found solution below

import lseg.data as ld

ld.open_session()

df = ld.get_data(

    universe = ['BRVIVTDBS093'],

    fields = ['TR.ISIN',

              'TR.RIC',

              'TR.FIKPILegNumber',

              'TR.FIKPITargetMet',

              'TR.FIComparedtoTarget',

              'TR.FIKPIReportedNumber',

              'TR.FIKPIReportingDate'],

    parameters = {

        'SDate': '1981-01-02',

        'EDate': '2026-11-14',

        'Frq': 'D'

    }

)

display(df)

Please note that

we would like to encourage users to transition/use LSEG data library which is the latest version of our python library instead of Refinitiv Data Library for the latest features and ongoing support. More detail can be found at

Essential Guide to the Data Libraries - Generations of Python library (EDAPI, RDP, RD, LD) | Devportal

EXPLORE OUR SITES