Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
22 4 5 5

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.

eikon-data-api#technologygics
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvote
Accepted
10.3k 18 6 9

               

@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.


1694513948427.png (143.7 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.