Finding the price of matured bonds that don't have RIC

Warsame
Warsame
in Eikon Data APIs

Is there a way to get prices of matured bonds that don't have a RIC? For example, I want to know the yearly clean price and dirty price of the bond with ISIN code IT0005175176 and FR0123725170 until it reaches maturity. Is this possible?

Tagged:

Best Answer

  • nick.zincone
    nick.zincone
    Answer ✓

    Hi @Warsame

    Search does provide a way to perform searching across multiple instruments. For example, the variable bonds is a simple array that you can populate and use the following:

    ahs.png

Answers

  • jason.ramchandani01
    jason.ramchandani01

    @Warsame so I'm not sure I understand your question - once a bond matures it no longer trades. So to find out the date and redemption value you can try:

    df, err = ek.get_data('IT0005175176',['TR.FIMaturityDate','TR.FiRedemptionValue'])
    df

    alternatively you can open the data item browser app (type DIB into eikon search) then enter the ISIN and look at all the available fields and values:

    1638806459591.png


    I hope this can help.

  • nick.zincone
    nick.zincone

    Hi @Warsame

    I would suggest you reach out to the helpdesk and they can involve a content specialist to determine if these details can be captured.

    I did attempt to use the "Search" facility to determine these values but it doesn't look like this service will perform calculations for the 'clean' and 'dirty' prices. I also attempted to see if these details could be derived, but you would need to confirm if that is possible, i.e.

    ahs.png

  • Warsame
    Warsame
    @jason.ramchandani01 I know that matured bonds no longer trade that is why I want to know the yearly clean price and dirty price of these types of bonds because you can't find them in the same way as trading bonds.
  • Warsame
    Warsame

    @nick.zincone is there a way to do this for multiple bonds at once?

    Thanks in advance!

  • Warsame
    Warsame
    Hi
    @nick.zincone


    Is there a limit on the number of instruments in an array can have because I can only get a table for a maximum of 9 instruments? If this is the case, is there a way to do more than that? I am new on refinitiv so I don't have a lot of experience.

    Thanks in advance!


  • nick.zincone
    nick.zincone
    Hi @Warsame

    I don't know what the limit is, but I believe you should be able to define more than 9. What could be happening is that if you don't specify a 'Top' parameter, the number of hits will default to 10.

Categories