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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
etudiant1 avatar image
0 ●1 ●2 ●3

What is the syntax of the Fixed Income End-of-month (FiEOM) variables?

Dear Refinitiv DevCommunity,

I want to extract end-of-month data in a panel data format from a list of corporate bonds. From the CodeCreator app in Eikon, I found a category called: Val. Historic Valuation with a bunch of variables with the prefix 'TR.FiEOM...' that look really promising for my purposes. However, I could not find good examples of the code syntax to retrieve the data.

So far, I have tried the following code with no luck, it gives me only the latest values. 

df, err = ek.get_data(instruments = isin_bonds, fields = ['TR.ISIN', 'TR.BIDPRICE.date','TR.BIDPRICE','TR.FiEOMTotalReturn','TR.FiEOMPrice','TR.FiEOMCouponReturn', 'TR.FiEOMFitchRating'], parameters={'EDdate':'2015-11-01','Frq':'M','SDate':'2020-12-01'})

My thoughts were to loop the get_data() function for each month with SDate and EDate different from ≠0, however, I always end up getting the same last values.

Any other thoughts on the best way to access historical data?

I really appreciate any help you can provide,

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apibonds
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
chavalit-jintamalit avatar image
18.1k ●21 ●12 ●21

Hi @etudiant1

I believe that the fields you used in your API call, they do not support timeseries retrieval.

You can use "Data Item Browser" to confirm that.



ahs.png (74.2 KiB)
ahs1.png (62.5 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.