How do I fetch the date in the coupon history?

mjoshi
mjoshi Newcomer
in Eikon Data APIs

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

image


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

image

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    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'})

Answers

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭

    @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.

  • mjoshi
    mjoshi Newcomer

    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'})

Categories