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

Warsame

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?

nick.zincone

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:

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:

I hope this can help.

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.

Warsame

https://community.developers.refinitiv.com/discussion/comment/88160#Comment_88160

@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

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

Thanks in advance!

Warsame

https://community.developers.refinitiv.com/discussion/comment/88401#Comment_88401

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

https://community.developers.refinitiv.com/discussion/comment/88412#Comment_88412

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.