How to extract GICS sectors data based of of only company names in DAPI

Hi everyone, a client is currently struggling to extract GICS sectors based of of company names only via Nikon Data API. The company names may not necessarily be similar to the ones used in EIKON. Client has no other symbology available like ISIN etc.

Best Answer


  • @Almir Purisic Thanks for you question. So this is possible using the RD library and search service as follows:

    import refinitiv.data as rd
    rd.open_session()

    rd.discovery.search(query="*ome* *dep* ",
                        filter = "IsPublic eq true",
                       view=rd.discovery.Views.ORGANISATIONS,
                       select="BusinessEntity,DocumentTitle,PI,OAPermID,PrimaryRIC,Gics,GicsCode,GicsIndustryLeaf,GicsName"
    )

    1694513948427.png

    This will return a suggested list of companies - the first one is the most likely. Note I have put wildcards around the words in the company name to provide some fuzzy matching. This is the best we have. I hope this can help.