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?
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:
@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.
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.
@nick.zincone is there a way to do this for multiple bonds at once?
Thanks in advance!
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.
