Extracting and Matching Data from an Excel file with Eikon API

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