How to get the latest segment name of listed companies, including annual report or Quarterly

yuejia1_

I want to obtain the latest segment name information of listed companies from Eikon, both annual report information and quarterly report information are acceptable.

But when running the results with the following code, there are no results for 300 companies, here are a few examples 2382.HK, 0196.HK, 0834.HK.

I think this code can run latest available segment information, for 2382.HK is 30/Jun/2024，But the result returned is NA.

Instrument Segment Name Financial Period Absolute Period End Date
0 2382.HK <NA> <NA> <NA>

import pandas as pd  

import refinitiv.dataplatform.eikon as rd

universe = '2382.HK'

fields = [    "TR.BGS.BusTotalRevenue.segmentName", "TR.BGS.BusTotalRevenue.fperiod",      "TR.BGS.BusTotalRevenue.periodenddate"] 

df, err = rd.get_data(universe, fields)

if err:   

print(f"Error: {err}")

else:  print(df)

Jirapongse

@yuejia1_

Thank you for reaching out to us.

This forum is dedicated to software developers using LSEG APIs. The moderators on this forum do not have deep expertise in every bit of content available through LSEG products, which is required to answer content questions such as this one.

The best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through MyAccount. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

You may ask for the Workspace Excel formula (=@RDP.Data) that can be used to retrieve the required data. After that, we can convert the Excel formula to Python code.