Output issue for SUSTAINABILITY LINKED BOND ("SLB") DETAILS

nelson.ong

retrieving data via the Eikon Data API. client is get different results depending on how many "instruments" I give as input.

Below are 2 codes replicated using Refinitiv.Data. Only difference is the 1st has 2 ISINs while the 2nd has 3 ISINs.

Notice that ISIN SE0019914250 is correctly retrieved on the 1st code. The 0.6 payment has blank KPI ESG type an KPI Theme. However, when 3 ISINs are used, the blank moved to a different KPI leg which is incorrect.

Below is a screenshot of Bond Views for the data reference.

Can anyone advise how to fix this? Thanks!

Jirapongse

@nelson.ong

Thank you for reaching out to us.

I checked the problem and found that the internal service returned the misaligned data.

The following is the raw response after enable logging.

json = {"Entity": {"E": "DataGrid_StandardAsync", "W": {"requests": [{"instruments": ["SE0019914250", "XS2613472963", "XS2630496672"], "fields": [{"name": "TR.FIKPIESGTYPE"}, {"name": "TR.FISPTDATE"}, {"name": "TR.FIKPIACTIONTYPECODETR.FIKPITRIGGERBASECODE"}, {"name": "TR.FIPAYEFFECTIVEDATE"}, {"name": "TR.FIKPIPAYFREQUENCY"}, {"name": "TR.FIPAY"}, {"name": "TR.FICARBONCREDIT"}, {"name": "TR.FIKPITHEME"}], "parameters": {"SDate": "2023-01-01"}}]}}}
[2023-08-29T16:08:22.074301+07:00] - [sessions.desktop.workspace.0] - [DEBUG] - [147792 - MainThread] - [http_service] - [request] - HTTP Response id 3
    status_code = 200
    text = {"responses":[{"columnHeadersCount":1,"data":[
    ["SE0019914250","","2025-12-31","2026-07-06","One time",0.3,"",""],
    ["SE0019914250","Environmental","2025-12-31","2026-07-06","One time",0.3,"","Climate Change (GHG Emissions and Energy)"],
    ["SE0019914250","Environmental","2025-12-31","2026-07-06","One time",0.6,"","Climate Change (GHG Emissions and Energy)"],
    ["XS2613472963","Environmental","2030-12-31","2031-04-20","Annually",0.3,"","Climate Change (GHG Emissions and Energy)"],
    ["XS2613472963","Environmental","2030-12-31","2031-04-20","Annually",0.2,"","Raw Material Sourcing and Recycling (Circular Economy)"],
    ["XS2630496672","Environmental","2026-12-31","2027-06-14","One time",0.75,"","Climate Change (GHG Emissions and Energy)"]
    ],
    "headerOrientation":"horizontal","headers":[[{"displayName":"Instrument"},{"displayName":"KPI ESG Type","field":"TR.FIKPIESGTYPE"},{"displayName":"SPT Date","field":"TR.FISPTDATE"},{"displayName":"Pay Effective Date","field":"TR.FIPAYEFFECTIVEDATE"},{"displayName":"KPI Pay Frequency","field":"TR.FIKPIPAYFREQUENCY"},{"displayName":"Pay","field":"TR.FIPAY"},{"displayName":"Carbon Credit","field":"TR.FICARBONCREDIT"},{"displayName":"KPI Theme","field":"TR.FIKPITHEME"}]],"rowHeadersCount":1,"totalColumnsCount":8,"totalRowsCount":7}]}

Please contact the Eikon support team directly to verify the problem in the DataGrid_StandardAsync UDF service.