How to retreive SIC codes via Eikon Data API?
So far I have searched for the data item via DIB and formula wizzard quite extensively. I have found NAICS, TRBCs and several else but no SICs.
Have I missed it? How can I retrieve it via Eikon Data API?
Best Answer
-
Hi @MisterM - yup the above code will only work for Fixed Income Instruments. We provide a number of classification schemas including as you have found NAICS, GICS, TRBC. Those you can find via the Eikon Data API. Sadly we dont provide SIC codes via the Eikon Data API.
I found a site that seems to map bi-directionally NAICS to SIC and vice versa - depending on the level of detail you are after eg sector, subsector, industry group etc. You can find that here. You can get the NAICS code and then try converting it on that site using the SIC Crosswalk. I did it here for AAPL.O at the lowest level of granularity in terms of NAICS code. You can select which level of aggregation is most appropriate to you. Its not great but it might help you.
The following code should get you all the NAICS codes you need (you can of course add multiple instruments
- df,err = ek.get_data(['AAPL.O','MSFT.O'], ['TR.NAICSSectorCode','TR.NAICSSubsectorCode', 'TR.NAICSIndustryGroupCode','TR.NAICSInternationalIndustryCode','TR.NAICSNationalIndustryCode'])
- df
1
Answers
-
Hi @MisterM
Try with Fixed Income instruments as inputs. There is TRFISIC field that gives you Industry of the issuer based on the Bureau of the Budget Standard Industrial Classification (SIC) code. Structure uses the standard four-digit SIC.
df,err = ek.get_data('09702LBJ3=', 'TR.FISIC')
df1 -
Thank you for that suggestion, that code works as intended. However, it became clear to me that I have not given you some relevant information.
I'm trying to retrieve SIC codes for equities. I have large a list of RICs, that includes publicly traded companies from the U.S.
0 -
Thank you for that suggestion, that code works as intended. However, it became clear to me that I have not given you some relevant information.
I'm trying to retrieve SIC codes for equities. I have large a list of RICs, that includes publicly traded companies from the U.S.
0 -
Thank you for the help, I was afraid that might be the case.
I am thinking about using Datastream to retrieve the SICs, even though I would have to use the Excel plug-in, because I cant access DSWS. Would you agree that this seems to be the better option for my case (1000s of RICs)?
Will I run into trouble using RICs in Datastream? I have actually found conflicting information on that matter. Should I rather use an alternative identifier?
0 -
I will need to check that and get back to you if thats ok - in terms of the data its definitely there - see the series labels below:
1 -
Thanks a lot. It would be great if you let me know what you find out.
0 -
Hi @MisterM
You can also try some workaround. First you retrieve bond RIC for each company, then choose the first bond one and get the SIC code from there. I do not guarantee that it will work 100%. I have also observed that not all the bonds from the same issuer have the same SIC numbers.
df,err = ek.get_data(['C','IBM'],'TR.BONDRIC')
df.drop_duplicates(subset ="Instrument", keep = "first", inplace = True)
df['SIC'] = ""
for i in df.index:
df.at[i, 'SIC'] = [ek.get_data(df.at[i,'Bond RIC'],'TR.FISIC')[0].iloc[0,1]][0]
df1 -
Hi, you can you RIC within DFO. You need to use <> parenthesis either side of the RIC. Please speak with your account manager with regards to accessing DSWS
1 -
Hey everyone,
I totally get the frustration, @MisterM. I've been down that rabbit hole too, searching high and low for those elusive SIC codes via the Eikon Data API. It turns out, though, that they don't provide them through the API, which is a bit of a bummer.
But hey, don't lose hope! I stumbled upon a site that could be a workaround for you (thanks to jason.ramchandani01). It's this site that maps NAICS to SIC codes and vice versa. Depending on how detailed you need it (sector, sub sector, etc.), it might do the trick. I tried it out with AAPL.O using the lowest level of NAICS granularity, and it seemed to work. I've been through this before while working on a project at Andersen, and if I had known the information given here earlier - it would have saved me. But better to find out late than never
Oh, and for those who might be wondering, if you're dealing with Fixed Income Instruments, the code you mentioned won't work. The classifications like NAICS, GICS, and TRBC are accessible via the API, just not SIC codes.
For those looking to fetch SIC codes, consider exploring this mapping site alongside the other classifications.
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛