How to get the requested Data item on Codebook

SrinivasDhananjay

For a given instrument ISIN (TW00000719B4 for instance), is there an easy way (maybe using codebook) to get the issuer company's TR.TRBCEconomicSector, TR.TRBCBusinessSector, TR.TRBCIndustryGroup, and similar TRBC information). I have around 1000 ISINs and I wondered if there is a better than manual way to do it. Thank you

raksina.samasiri

Hi @SrinivasDhananjay ,

The get_data() function can be used, its example can be found at Example.DataLibrary.Python/Examples/1-Access/EX-1.01.01-GetData.ipynb at lseg-data-examples · LSEG-API-Samples/Example.DataLibrary.Python

Or in Codebook, go to file Examples/01. Data Retrieval and Discovery/01.01. LSEG Data Library/Access__Get_Data.ipynb

Then convert your ISIN list to Python list format and use it as an input of get_data function.

import lseg.data as ld


ld.open_session()


isin_list = ['TW00000719B4']


ld.get_data(

    universe=isin_list,

    fields=['TR.TRBCEconomicSector', 'TR.TRBCBusinessSector', 'TR.TRBCIndustryGroup']

)

To find the fields name to be used, you can use Data Item Browser | Devportal or CodeCreator