question

Upvotes
Accepted
vitali avatar image
19 ●1 ●1 ●4

Research API, combine "Views" selectors.

Hello everyone! I'm currently progressing on a project focused on companies that have been delisted. For this project, I'm utilizing the Refinitiv Search API. I've successfully managed to extract data on US companies that were delisted, including the reasons for their delisting, which are currently limited to two categories: Acquisition and Merger. 

 response = rd.discovery.search(
        view = "Organisations",
        filter = "OrganisationStatus xeq 'Delisted' and RCSCountryHeadquartersLeaf eq 'Uni       ted States'",
        select ="DocumentTitle,CommonName, DelistedDate, OrganisationStatus,DTCharacteristics, FormOfTransactionCode, ReasonDelisted",
        top = 1000
)

screenshot-2024-02-16-at-112414.png

Given these constraints, I've decided to make the best of the available data.

My current objective is to delve deeper into the specifics of Acquisition and Merger deals to enable the calculation of Delisting Returns for these companies. To achieve this, I've been exploring the DealsMergersAndAcquisitions View, which offers a plethora of fields that could potentially aid in my analysis. However, I've encountered a significant hurdle: the API does not support the simultaneous use of two Views.

What I aim to do is integrate certain selectors from the DealsMergersAndAcquisitions View into the Organisation View or combine data from two views for the same companies into one. This integration would allow me to maintain a comprehensive list of delisted companies, complete with reasons for delisting and detailed information about the corresponding deals. Does anyone know how to accomplish this integration effectively?

Would appreciate any help! Thank you in advance!

pythonrefinitiv-dataplatform-eikon#technologyrkd-apicodebookcompany-research
screenshot-2024-02-16-at-112414.png (194.5 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

· Write an Answer
Upvotes
Accepted
nick.zincone avatar image
17.4k ●82 ●39 ●63

Hi @vitali

The Search service does not support the ability to specify a list of views as you discovered. However, there is the option of using 'SEARCH_ALL' which should cover every View. What this may do is introduce hits/results that you are not interested in, i,e. more data than you need. However, because Search does provide filtering, you can filter out hits based on relevant criteria. For example, within the Search article, you can review some of the Common Properties as a way to filter unwanted data. Properties such as: 'SearchAllCategoryv3', 'RCSAssetCategory', 'RCSTRBC2012' can potentially help. There is not a specific property that filters out Views but I believe some of the above are pretty close to aligning with the View organization. Because Search is so rich and granular, this does require more investigation. What really aids in this activity is utilizing the browser capabilities as presented in the "Building queries easily using Refinitiv's Search API.." article. Using that, you have a nice way of looking at all properties and their values as well as the domain of values available within navigator properties. This does provide a nice way of understand how data is categorized and thus much easier for you to build intelligent filters.

Hope this helps

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

vitali avatar image vitali

Hi, @nick.zincone! Thanks for your response! Could you possibly shed some light on why the additional fields I'm utilizing are not displaying? 

OfferingType,AcquirerStockPriceOnAnnouncementDay,AcquirerRIC,AcquirerBusinessDescriptionLong,TradingValue,AnalystEstimatedValue

: 

 response = rd.discovery.searc
        view = "SearchAll
        filter = "OrganisationStatus xeq 'Delisted' and RCSCountryHeadquartersLeaf eq 'United States'",
        select ="DocumentTitle,OfferingType,CommonName,AcquirerStockPriceOnAnnouncementDay,AcquirerRIC,AcquirerBusinessDescriptionLong,TradingValue,AnalystEstimatedValue, DelistedDate, OrganisationStatus,DTCharacteristics, FormOfTransactionCode, ReasonDelisted",
        top = 1000,
    )

screenshot-2024-02-16-at-112414.pngJust the same output, without additional selectors.

screenshot-2024-02-16-at-112414.png (194.5 KiB)
Upvotes
nick.zincone avatar image
17.4k ●82 ●39 ●63

Hi @vitali

These data properties are not populated based on your request. For example:

1708122337766.png

In general, when there is no data available, nothing is returned for that property. You can either use the browser to review values to figure which properties would possibly be relevant or of interest to you or open a content ticket and ask a specialist what data you are after.

I usually utilize the browser to give me a picture of what is available. For example:

1708122675065.png



1708122337766.png (32.9 KiB)
1708122675065.png (72.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.