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.
