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:
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'})
@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.
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'})