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?
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
6.7k
●8 ●6 ●7
@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.
@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.
9.7k
●49 ●38 ●60
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.
9.7k
●49 ●38 ●60
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:
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!
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.
