Bond issuers income statement data download

Giacomo_C

Hello everyone,

I am trying to download financial information regarding bond issuers, starting from a series of bond ISIN codes.

The query I am using is the following:

rd.get_data(
universe = ISIN_list,
fields = [
'TR.RIC','TR.NACEClassification',
"TR.DTSubjectName",
"TR.FIIssuerName",
'TR.FiOrgID',
"TR.F.TotRevenue",
"TR.F.TotAssets",
"TR.F.EBITDA",
"TR.F.MktCap",
"TR.F.EV",
"TR.F.TotDebtPctofTotAssets",
"TR.F.TotDebtPctofTotEq",
"TR.F.IntrCovRatio",
"TR.TotalAssetsActual.periodenddate"
]
)

I get many missing values for the financial variables (such as "TR.F.TotRevenue"), whereas I checked that for some issuers that information is instead available when searching the company name via the workspace search bar (for instance the ISIN "XS2552369469" issued by "REDEIA CORPORACION SA" has a 'NA' value for the TotRevenue variable using the get_data function, while if I look for that company in the search bar I can easily find that information).

I have also tried to retrieve the RIC code first and then use another get_data() to retrieve financial information but I encountered the same problem.

Could you help me?

thanks

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/123645#Comment_123645

@Giacomo_C

You can use the Data Item Browser tool to search for fields and parameters.

I found the TR.F.TotAssets, TR.EBITDAActValue, TR.CompanyNumEmploy, TR.F.EV, and TR.CompanyMarketCapitalization fields.

The fields also support sub-fields, such as TR.CompanyMarketCapitalization.date that can be used to get date those fields refer to.

Otherwise, you can contact the helpdesk support team directly via MyAccount and the support team can provide you with the requried fields.

[Deleted User]

Hi @Giacomo_C

Using the DIB, I found the issuer-company related field "TR.EUTaxTotalRevenue"; is this the one you are after?
If not, have you tried looking for a populated field on the DIB usiong hte filter?

[Deleted User]

Hi @Giacomo_C

Thankyou for your participation in the forum.

Is the reply above satisfactory in answering your question?

If yesplease click 'Yes' next to the text ‘Did this answer the question?’, and thenclose the question. This will guide all community members who have a similarquestion.

Otherwiseplease post again offering further insight into your question.

Thanks,

AHS

Giacomo_C

Hi Jonathan, thank you for the answer.
Indeed, using this field I was able to retrieve values that are missing for "TR.F.TotRevenue".
Do you know how I can also find populated fields for the other economic and financial variables I am looking for? (Total assets, EBITDA, number of employees, enterprise value, market capitalization)
Also, how do I get the year this field refers to?

thanks again