Question on how to retrieve data from EIKON Refinitiv add in in Excel

Hello dear community,


I am trying to retrieve the following data (time series, from 01.01.2003 to 01.01.2015) from companies using their ISIN code as reference in the Eikon Refinitiv add in in Excel:

S&P's, Moody's and/or Fitch's (depending on data availability) credit ratings on the same bonds;
value of the bond issue in millions (amount of bonds issued * price of one bond);
the years to maturity of the bond;
the dates of the issuance of the bond and ratings;
a dummy variable indicating whether the debt is senior or not


Does anyone know how the function would look like? The ones I have used so far haven't worked...

I also have the Eikon desktop app, in case you find it better to retrieve this type of data.

Thank you so much in advance and happy holidays!


Best

Felipe

Best Answer

  • raksina.samasiri
    Answer ✓

    Hi @hansenfe ,

    Thank you for posting the question in
    this forum. However, this forum is dedicated to an API usage question hence,
    the moderators on this forum do not have deep expertise in every type of
    content available through Refinitiv products. Such expertise is available
    through Refinitiv Helpdesk, which can be reached via MyRefinitiv. To be of help, ticket number 13183242 was raised on your
    behalf and the support team is going to contact you directly to assist with
    this.

    Hope this helps and please let me
    know in case you have any further questions.