Home › Forums › The XBRL API › Code for publicly traded companies
- This topic has 3 replies, 2 voices, and was last updated 6 years, 4 months ago by David Tauriello.
-
AuthorPosts
-
-
Wednesday, August 14, 2019 at 2:41 PM #149582Tim BuiParticipant
Hi David,
Does XBRL US have a code to indicate if a CIK belong to a publicly-traded company, as opposed to a privately-held company?Thanks
-
Tuesday, August 20, 2019 at 5:43 PM #149960David TaurielloKeymaster
Hi Tim – sorry for the delayed response. I’m not aware of any privately-held companies that have CIKs – can you give me an example – ?
FWIW – a query like this (changing offset) should give you a full list of alpha-sorted companies and tickers:
/report/search?report.is-most-current=true&fields=dts.id,report.entity-name.sort(DESC),entity.ticker,entity.id,report.offset(0) -
Tuesday, August 20, 2019 at 6:17 PM #149961Tim BuiParticipant
Hi David,
Thank you for your reply and for the code. I will use that code to see how far I get. The Financial Data Sets that I download contains so many CIKs and I try to narrow the list down to public companies or companies that have stock prices so I can make investment decisions.
Regarding the CIK for privately held companies, I assume that they are privately held because I can’t find any stock information on them. I always assumed that the SEC gives each filer a CIK, whether they are public or private. My confusion could also come from companies changing their names.
Examples of a few CIKs that I can’t find information:
1425392 – Grant Hartford Group.
1441082 – Lake Forest Minerals Inc
1111741 – Dynaresource Inc
1403570 – Quantum Materials CorpThanks again, David!
Tim
-
Wednesday, August 21, 2019 at 12:06 AM #149966David TaurielloKeymaster
From the CIKs you shared, it looks like Grant Hartford stopped filing in 2012; the others are still filing with the SEC (listed on OTCMKTS):
/report/search?entity.cik=0001425392,0001441082,0001111741,0001403570&report.is-most-current=true&fields=report.entity-name,entity.ticker,report.document-type,report.filing-date.sort(DESC),dts.id,entity.id,report.sec-urlThere are some details on SEC’S CIK at the bottom of page 1: https://www.sec.gov/info/edgar/quick-reference/form-id.pdf
-
-
-
AuthorPosts
- You must be logged in to reply to this topic.
Search Forums
Recent Topics
- Income Statement data for a company by David Tauriello
- Normalized data presentation by David Tauriello
- Extract Director RSUs/Options Form 14A by Priyanka Goonetilleke
- Using the offset parameter by David Tauriello
- Spreadsheet Commands: Query Worksheet and Query Workbook Query Workbook by Liam Noailles
Recent Replies
-
Income Statement data for a company 5 months, 3 weeks ago
-
Income Statement data for a company 5 months, 3 weeks ago
-
Using the offset parameter 10 months ago
-
Using the offset parameter 10 months ago
-
Using the offset parameter 10 months ago
Documentation & Discussion
- Get started with Google Sheets OR
- Get started with Microsoft Excel OR
- Get access to as-filed data from us for other tools or your own app
- XBRL API Interactive Documentation
- Ten Tips & Techniques
- The XBRL API
- XBRL Data Community
- 2024 US GAAP Taxonomy Viewer
- Live support - Monday, 3:30 - 4:30 PM ET
Who's using this free data?
API Use 2024 || API Use 2023 || API Use 2022 || API Use 2021 || API Use 2020 || API Use 2019 || API Use 2018
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table
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.
To use the XBRL API outside of Google Sheets, your account needs to be provisioned for OAuth2 access.





