How to retrieve the names and tickers from a List (DSWS)

dan.gabriel@lseg.com

Using Codebook, How do we map the names/tickers in the result below? It only shows Instrument number:

# get constituent list

df1 = ds.get_data(tickers='LS&PCOMP|L', fields=['P'], kind=0)

# get a subset of first 50 instruments

#slist = ','.join(df1['Instrument'].tolist()[0:50])

# get timeseries data for it

df2 = ds.get_data(tickers=slist, fields=['P','WC01001'], start='2022-02-01', end='2022-02-01', kind=1)

display(df2)

jonathan.legrand

Hi @dan.gabriel@lseg.com,

May I suggest that you look for the field you are after in the Datastream Portal? Specifically in the Datatype Search:

# get timeseries data for it
df2 = ds.get_data(
    tickers=slist,
    # fields=['P', 'WC01001', 'RIC'],
    fields=['RIC'],
    start='2022-02-01', end='2022-02-01',
    kind=0)
display(df2)

jonathan.legrand

ex resulting dataframe:

dan.gabriel@lseg.com

@jonathan.legrand

Thank you for the update. Just a question, I am using the below code but for some reason it does not work for LS&PCOMP but works for a sample I did with less than 50 constituents: LPSECOMP,LDAXINDX

List.PNG

Is there a special case for greater than 50 constitutents.

Regards,

Dan

dan.gabriel@lseg.com

In addition, does client need weightings permission seperately in DSWS to get the Constituent list for fee access Indices

jonathan.legrand

How can I use Python's Datastream DSWS to collect data above the limit of 50 instruments? - Forum | Refinitiv Developer Community