Wednesday, May 20, 2020 at 9:09 AM #180444
Does anyone know if it’s possible to get the industry (or sector) of an entity?
Any help is really appreciated!
Thursday, May 21, 2020 at 12:27 PM #180627
Hi Juan, within the SEC Financial Statement Data Sets quarterly releases ( https://www.sec.gov/dera/data/financial-statement-data-sets.html), there is a text file named “sub”. Within it, each entity is given an sic code. You can use that sic code to match with the SEC provided sic list (https://www.sec.gov/info/edgar/siccodes.htm). Since the sic codes have 4 digits, you can further classify them by Division, Major Group, Industry Group and Industry by using the structure at this website https://siccode.com/
Tuesday, May 26, 2020 at 12:34 PM #181115
Hi Juan – in addition to the resources Tim provided, you can get the SIC code when you include
report.sic-codein the fields you return for
/reportqueries using the XBRL API. The attribute is searchable on the these endpoints.
See pages 11 and 17 of the PDF documentation https://xbrl.us/xbrl-api-documentation
You must be logged in to reply to this topic.
Extraction and Interpretation of Operating Lease Data 1 day, 1 hour ago
Getting started with the XBRL Google Sheet and add-on 1 day, 9 hours ago
Specifying reports for results 2 days, 2 hours ago
Getting started with the XBRL Google Sheet and add-on 2 days, 2 hours ago
Entity's industry 2 days, 2 hours ago
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Interactive Documentation
- XBRL API Documentation (PDF)
- Getting Started with Google Sheets
- Sample API Queries (works with Insomina) or Excel Power Query Template
these options require account provision
Using the XBRL API with the Public Filings Database
Unless otherwise agreed to in writing, any and all use of the XBRL API to authenticate and retrieve data from the XBRL US Database of Public Filings implies user consent and agreement with the XBRL US API Agreement. If you are unable to agree to these terms, do not use the XBRL API.
Ready to work with the API in Excel's Power Query, or with your own system or app?
Contact us at firstname.lastname@example.org to have your existing XBRL US Web account provisioned to generate client ID/Secret pairs to work with the XBRL API in a REST client or other application, including Excel's Power Query.
NOTE: You do not need to generate client ID/Secret pairs if you use the Google Add-on and Google Sheet exclusively to access data - the XBRL API Authentication Add-on handles this automatically.
Your account needs to be provisioned before you can login and generate client ID/secret pairs.
Login or register for a free account.
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table