ejv python

Question

REFINITIV

Question by Taya.Mahendrarajah · Jan 18 at 03:02 PM · python

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

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2022-01-18T17:01:37Z

REFINITIV

Best Answer

Answer by jason.ramchandani01 · Jan 18 at 05:01 PM

@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 (29.4 KiB)

0 · Share

10 |1500 characters needed characters left characters exceeded

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

ejv python

1 Reply

Watch this question

Related Questions