New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
1 1 1 1

How do I fetch the date in the coupon history?

I am able to fetch the coupon rates, but don't know what is the date for that coupon rate.


This is because it's not always quarterly. In some cases, it is monthly:

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apibondsdate
1570776083688.png (78.5 KiB)
1570776229631.png (222.0 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.

Upvotes
Accepted
39.4k 78 11 27

I see. Thanks for the explanation. To get coupon dates using Eikon Data API you can use the following call

ek.get_data('XS0309234309=RRPS', 
            ['TR.CMOABSCouponRate.date', 'TR.CMOABSCouponRate'], 
            {'SDate': '1999-01-01', 'EDate': '2009-12-31'})
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.

Upvotes
39.4k 78 11 27

@mjoshi
This forum is dedicated to software developers using Refinitiv APIs. Your question is about data search and explanation and about using Eikon application, which is best directed to Refinitiv Helpdesk. The moderators on this forum do not have deep expertise in every type of content available through Eikon to answer questions such as yours. I see you already opened some tickets with Refinitiv Helpdesk. I suggest you continue working with the Helpdesk and add this query to your discussion or open a new ticket.

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.

Upvotes
1 1 1 1

Thanks for your reply, but I am not sure about that conclusion. I tried this and it works for coupon rates which is great, except, I do not know the name of the date field to use here. Your help is greatly appreciated. I tried a number of date fields as seen in Data Item Browser but met with no luck so far.

df = ek.get_data([ric], ['TR.CMOABSCouponRate', 'TR.FIIssueDate'], {'SDate': '1999-01-01', 'EDate': '2009-12-31'})
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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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