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

question

Upvotes
Accepted
1 1 2 2

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

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?

eikon-data-apipythonpython api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
Accepted
18.6k 85 39 63

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


ahs.png (118.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.

Upvotes
10.6k 20 6 9

@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.


1638806459591.png (333.9 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@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.
Upvotes
18.6k 85 39 63

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


ahs.png (71.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
1 1 2 2

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

Thanks in advance!

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.