Unable to collect data for the field 'TR.GICSSector' and some specific identifier(s). Requested uni

Vikram_2910

Query: Hello, I want to make a request on DataStream/Refinitiv using Python. I tested for 3 ISINs. I first tried with import refinitiv.data then with lseg.data, but I always get the same error:

 

Erreur pour DE000A1EWWW0 : Unable to collect data for the field 'TR.GICSSector' and some specific identifier(s). Requested universes: ['DS:DE000A1EWWW0']. Requested fields: ['TR.GICSSECTOR', 'TR.GICSINDUSTRYGROUP', 'TYPE']

 

Erreur pour FR0000120073 : Unable to collect data for the field 'TR.GICSSector' and some specific identifier(s). Requested universes: ['DS:FR0000120073']. Requested fields: ['TR.GICSSECTOR', 'TR.GICSINDUSTRYGROUP', 'TYPE']

 

Erreur pour FR0000120628 : Unable to collect data for the field 'TR.GICSSector' and some specific identifier(s). Requested universes: ['DS:FR0000120628']. Requested fields: ['TR.GICSSECTOR', 'TR.GICSINDUSTRYGROUP', 'TYPE']

 

ISIN INSTRUMENT TYPE GICS SECTOR GICS INDUSTRY GROUP
0 DE000A1EWWW0 NaN NaN NaN
1 FR0000120073 NaN NaN NaN
2 FR0000120628 NaN NaN NaN

 

My code:

 

import lseg.data as ld
import pandas as pd

 

combined_df = pd.DataFrame({
"ISIN": ["DE000A1EWWW0", "FR0000120073", "FR0000120628"]
})

 

ld.open_session()

 

instrument_types = {}
gics_sectors = {}
gics_industries = {}

 

for isin in combined_df["ISIN"].dropna().unique():
try:
result = ld.get_data(
universe=[f"DS:{isin}"],
fields=["TYPE", "TR.GICSSector", "TR.GICSIndustryGroup"]
)

 

if not result.empty:
row = result.iloc[0]
instrument_types[isin] = row.get("TYPE", None)
gics_sectors[isin] = row.get("TR.GICSSector", None)
gics_industries[isin] = row.get("TR.GICSIndustryGroup", None)
else:
print(f"Aucune donnée pour {isin}")
except Exception as e:
print(f"Erreur pour {isin} : {e}")

 

ld.close_session()

 

combined_df["INSTRUMENT TYPE"] = combined_df["ISIN"].map(instrument_types)
combined_df["GICS SECTOR"] = combined_df["ISIN"].map(gics_sectors)
combined_df["GICS INDUSTRY GROUP"] = combined_df["ISIN"].map(gics_industries)

 

print(combined_df)

 

Can you tell me how I can make a request on DataStream/Refinitiv using Python, please? I want to find the type of instrument and various GICS codes for a given ISIN.

Jirapongse

@Vikram_2910

Thank you for reaching out to us.

The code could be like this:

isins = ["DE000A1EWWW0", "FR0000120073", "FR0000120628"]


result = ld.get_data(
    universe=isins,
    fields=["TR.SharesType",  "TR.GICSSector", "TR.GICSIndustryGroup"]
    )


result

You can use the Data Item Browser tool to search for the available fields and parameters.