question

Upvotes
Accepted
Taya.Mahendrarajah avatar image
3 ●0 ●0 ●1

ejv python

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


python
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
jason.ramchandani01 avatar image
8.2k ●11 ●6 ●9

@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

1642525451579.png


1642525451579.png (29.4 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.