For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
10 2 2 3

Retrieving bond returns (historical values)

Hello

Following up on @Student-10 question, I would like to know how to download bond returns ?

There are several variables of interest in the Item Browser (Bond_fields). However, the values only work for the last available date, not the historical ones.

How do we specify ek.get_data() in order to have the historical values?

Bond_fields = ["TR.FiEOMPriceReturn","TR.FiEOMTotalReturn", "TR.FiClosingPrice", "TR.FiPrevPriceReturn", "TR.FiEOMPriceReturn.date"] 
Bond_RICs = ["CN1920029=","CN1720052=","CN1720012=","CN1920001=", "CN1702002=","CN101751004=","CN101901057="]
df, err = ek.get_data(Bond_RICs, Bond_fields,{'SDate':'2015-01-01','EDate':'2020-12-06'}) 
df

Additionally, calculating the bid/mid/ask prices returns (%change) from previous gives me extremely low results (0.000001). Is there another way to calculate bond returns using closing prices? Maybe I am just missing something.

https://community.developers.refinitiv.com/questions/70286/refinitiv-eikon-retriving-bond-historical-prices.html


eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikondatahistoricalbonds
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.

1 Answer

Upvotes
Accepted
18.1k 21 12 20

Hi @ricardo.henriquez

You can use the "Code Creator" app to check supporting parameters for each field.

To launch "Code Creator" app, type in CODECR in the Eikon Search bar.

The field you used does not support SDate and EDate parameters.


You may contact the Refinitiv Content Helpdesk to clarify what fields might be available and the content question about calculating the bid/mid/ask prices returns (%change).

The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application.
Or by calling the Helpdesk number in your country.
Or at https://my.refinitiv.com/


ahs2.jpg (105.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.