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

jonathan.legrand

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?