I'm trying to get the names of committees a director is serving in a company. I use codebook, and I

I'm trying to get the names of x is serving in a company. I use codebook, and I cannot retrieve the information I see in the screen. For instance for company 3257.TW, Tao-Lin Chang is independent director, and also member in CSR reponsibility commitee, Audit and compensation committees. With the codebook I can only retrieve her being the independent director. Could you help me find the correct field please? I use this code:import refinitiv.data as rdrd.open_session()rd.get_data(universe=['3257.TW'],fields=['TR.Odofficerfullname(Odrnk=all)','TR.ODOfficerPositionDesc(ODRnk=ALL)','TR.ODOfficerPersonAge(ODRnk=ALL)','TR.ODOfficerPersonGender(ODRnk=ALL)','TR.ODOfficerStatus(ODRnk=ALL)','TR.ODOfficerPermID(ODRnk=ALL)','TR.ODOfficerCommitteeName(ODShowAllCommittees=True)','TR.ODOfficerCommitteePosition(ODShowAllCommittees=True)','TR.ODOfficerPositionRoleCode(ODRnk=ALL)','TR.ODOfficerStartDate(ODRnk=ALL)','TR.ODOfficerEndDate(ODRnk=ALL)' ,'TR.ODShareholdings(ODRnk=ALL)','TR.ODOfficerIsOfficer(ODRnk=ALL)','TR.ODOfficerIsDirector(ODRnk=ALL)','TR.ODOfficerIsNonExecutive(ODRnk=ALL)'],parameters={'RNK':'R1:R30'})

Find more posts tagged with

python

#content

Accepted answers

All comments

Jirapongse

@beebijankammar_1

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 LSEG Support. 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 need to ask for the Excel formula, such as =RDP.Data, that can be used to retrieve the required data. Then, we can help you converting that formula to Python code.

beebijankammar_1

@Jirapongse the field TR.ODOfficerCommitteeName is available for RIC <3257.TW>. You can retrieve this information using the following formula:=@RDP .Data("3257.TW","TR.ODOfficerCommitteeName(ODRnk=ALL);TR.ODOfficerPositionOrder(ODRnk=ALL)","CH=Fd RH=IN",B3)

How can we get this in API code

beebijankammar_1

the field

TR.ODOfficerCommitteeName

is available for

RIC <3257.TW>

. You can retrieve this information using the following formula:=@RDP .Data("3257.TW","TR.ODOfficerCommitteeName(ODRnk=ALL);TR.ODOfficerPositionOrder(ODRnk=ALL)","CH=Fd RH=IN",B3)

Jirapongse

@beebijankammar_1

I ran the formula and got this result.

Please confirm if the client would like to retrieve this data.

beebijankammar_1

Yes,the same client wants to retrieve.

beebijankammar_1

can you create the API CODE please

Jirapongse

For the following formula:

=@RDP.Data("3257.TW","TR.ODOfficerCommitteeName(ODRnk=ALL);TR.ODOfficerPositionOrder(ODRnk=ALL)","CH=Fd RH=IN",B3)

The code is:

import lseg.data as ld

ld.open_session()

df = ld.get_data(
    universe = ['3257.TW'],
    fields = ['TR.ODOfficerCommitteeName(ODRnk=ALL)','TR.ODOfficerPositionOrder(ODRnk=ALL)'])
df

The output is similar to the Workspace Excel, as shown below.

I am using the LSEG Data Library for Python to retrieve data. The LSEG Data Library for Python is a rebranded version of the Refinitiv Data Library (refinitiv.data).

EXPLORE OUR SITES