Hi @Ollivier Taramasco,

I believe the Search API (more on it here, in Nick's article) is what you're after. Having had a look myself, I found that 'EQUITY_QUOTES' is the view you're after; for e.g., with an excel workbook 'resulttable.xlsx' like this:

I wrote the below with the RD Lib for Python (which is the new version of Eikon's Data API) (more on the RD Lib for Python can be found here):

import refinitiv.data as rd
import pandas as pd
try:  # The following libraries are not available in Codebook, thus this try loop
    rd.open_session(
        config_name="C:\\Example.DataLibrary.Python-main\\Configuration\\refinitiv-data.config.json", # this is where my config file is located
        name="desktop.workspace")
except:
    rd.open_session()

resulttable_df = pd.read_excel("resulttable.xlsx")

response=rd.content.search.Definition(
    view=rd.content.search.Views.EQUITY_QUOTES,
    query=resulttable_df.Company.iloc[0],
    filter = "RIC ne null",
    select = "RIC, _, IndustrySectorDescription",
    top = 20,
    ).get_data()
display(response.data.df)

I assumed, above, that you were after floated companies; therefore the EQUITY_QUOTES was the best `view`; but you can choose another from the list found in `help(rd.content.search.Views)`; in line with this assumption - and to make it more likely that the correct company comes up 1st in `response.data.df`, I added "Ordinary Share" at the end of what could be seen as the comany name.

I would advise using the `filter` more, to make it more likely that the correct company comes up 1st in `response.data.df`. E.g.: filter by company country, market cap, industry, ... The list of filter fields can be found with this browser or with:

response_EQ_Q = rd.content.search.metadata.Definition(
    view = rd.content.search.Views.EQUITY_QUOTES).get_data()
response_EQ_Q.data.df.to_excel("EQUITY_QUOTES.xlsx")

The 'grammar' you can use these fields in is described in Nick's article as well as on the Playgound Reference.

Thank you for your response @jonathan.legrand. I appreciate your time and effort! Yes, I am interested in floated companies and the EQUITY_QUOTES is the best view option. However, the output shows that no RIC was found for any of the companies. I made modifications to the view, query, etc but had the same issue.

One probable cause which i suspect is that some of the companies no longer exist. However, I am interested in their financial data, eg MarketCap, based on the year a particular patent application was filed, as given in the resulttable.xlsx, before the firm was dissolved. Can I, and how do I, account for this in the code?

Also, from the company name search, I am interested in getting the first, and probably the likeliest result from which I can extract a RIC.

Here are snippets of my current workflow:

import eikon as tr
import pandas as pd
import refinitiv.data as rdp
from refinitiv.data.content import search

tr.set_app_key('xxx')

rdp.open_session()

resulttable_df = pd.read_excel(r'C:\xxx\resulttable.xlsx')

for company_name in resulttable_df['person_name'].unique():
    # Converting the company_name to a string
    company_name = str(company_name)

   # Use RDP for searching the company and getting its RIC
search_results = rdp.content.search.Definition(
    view=rdp.content.search.Views.EQUITY_QUOTES,
    query=resulttable_df.person_name.iloc[0],
    filter="RIC ne null",
    select="RIC, _, IndustrySectorDescription",
    top=1,
)

# Extract the RIC from the search results
ric = None
if not search_results.empty:
    first_result = search_results.iloc[0]
    ric = first_result.get('RIC')

# Call the function to get financial data if RIC is not None
if ric is not None:
    financial_data = get_financial_data(ric)

    # Print or process the financial data as needed
    if financial_data is not None:
        print(f"For {company_name}, Market Cap: {financial_data}")
    else:
        print(f"No financial data found for {company_name}")
else:
    print(f"No RIC found for {company_name}")

@nick.zincone