ejv python

Taya.Mahendrarajah

hello ,

I need to get bond data(ejv) using python code

here is an example using excel :

=RData("US853254BW97","EJV.X.ADF_STRUCTURE";"EJV.X.ADF_COUPON",,,"TRANSPOSE:YES",D24)

response is :

FRN structure :

ACC:A0 ALIMIT:NO CALL:14OCT2022:1 CCM:MMA0 CFADJ:YES CLDR:USA_FI CPNFORMULA:14OCT2020:'@ROUND(@CMP(#SOFR<2d),0.00001)+1.25' CRRND:0.00001 DATED:14OCT2020 DMC:M EMC:S FRCD:14JAN2021 FRQ:4 INDEXCM:CMP INDEXDATE:START ISSUE:14OCT2020 NOTC:30 NOTIONAL:1 PX:C PXRND:1E-6:NEAR REFDATE:MATURITY RESETFRQ:1WD RESETTYPE:PERIODSHIFT RP:1 SETTLE:2WD SPREADCM:SIMPLE XD:NO

Coupon :

1.3

jason.ramchandani01

@Taya.Mahendrarajah Please try the following - I hope this can help.

import refinitiv.dataplatform.eikon as ek
ek.set_app_key('YOUR APP KEY HERE')

df,err = ek.get_data('US853254BW97',['TR.ADF_STRUCTURE','TR.ADF_COUPON'])
df