list of all insiders (executive management and directors) of companies primarily listed on SIX

mleocat

As part of our transaction monitoring efforts, we aim to identify our clients who are insiders within companies listed on the SIX.

Currently, our market abuse monitoring tool retrieves, via the API of a data provider, the list of companies listed on the SIX along with a set of data for each of them, including:

• The issuer's ISIN code
• The list of current board members and management team members, with the following details: first name, middle name, last name, job title, gender, date of birth, ISO code of nationality, and ISO code of country of residence.

Using a name-matching algorithm, we then perform a search within our client database. This allows us to create a list of "primary insiders," comprising all members of these companies who are also clients of the Bank.

In order to improve and optimize our current process, we would like to assess the quality of the data provided by Refinitiv Workspace. Would it be possible to provide us with a complete list of insiders of companies primarily listed on the SIX?

The list should include the following information for each insider:

Company Name	ISIN	First Name	Middle Name	Last Name	Gender	Birth Date	Nationality1	Nationality2	Nationality3

Kind regards,

Meven Léocat

Jirapongse

@mleocat

Thank you for reaching out to us.

You can use the LSEG Data Library for Python to retrieve data from the Workspace desktop session. The examples are available on GitHub.

If you know instrument identifies, such as RICs, you can use the ld.get_data method with RICs to retrieve data. However, you need to know the TR.xxx fields that can provide the required data. To search for the TR.xxx fields and parameters, you can use the Data Item Browser tool. Otherwise, you can contact 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.

However, if you don't know instrument identifiers, you can use the Search API to search for instruments. For more information regarding the Search API, please refer to this Building Search into your Application Workflow article.