For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 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-apipythonworkspaceworkspace-data-apirefinitiv-dataplatform-eikonbondsdate
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.3k 76 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.3k 76 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 0 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.