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?
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
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
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
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:
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!
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.
@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.
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.