Forum Replies Created
-
AuthorPosts
-
Larry OkongoParticipant
Hello everyone,
I am a beginner with xbrl and so far I am doing some work with the xbrl instance documents from SEC. However, I have come across some something that is quite confusing. What is the major difference between xbrl and xbrli especially when used as root elements in the instance xbrl document?
Here are two separate scenarios:<xbrli:xbrl xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xlink=”http://www.w3.org/1999/xlink”…>. </xbrli:xbrl>
and
<xbrl xmlns:utr=”http://www.xbrl.org/2009/utr” xmlns:iso4217=”http://www.xbrl.org/2003/iso4217″…>…</xbrl>
I have searched for answers regarding this and all I can get are contradicting replies.
I appreciate any help in helping me better understand this.David TaurielloKeymasterLarry –
An instance document is a collection of facts that together make up a business report. At a technical level an instance document is an XML document with a root element of <xbrli:xbrl … >. See https://specifications.xbrl.org/xbrl-essentials.html
Please post a URL where the second reference exists; I’m not entirely clear about the context for usage.
Larry OkongoParticipantThanks a lot David for the clarification.
Here is a link where I found the second scenario as stated in my post.
https://www.sec.gov/Archives/edgar/data/1280263/000156459019010114/amba-20190131.xmlDavid TaurielloKeymasterLarry – thanks for the clarification as I misunderstood and thought there was a single instance where these two declarations were made (I read too fast and missed your ‘Here are two separate scenarios.’)
In this second example, the <xbrl> element is used instead of <xbrli:xbrl> – as far as I know, it provides the same necessary function as a container element for the instance and location that allows declaration of namespaces necessary to the file. See http://www.xbrl.org/Specification/XBRL-2.1/REC-2003-12-31/XBRL-2.1-REC-2003-12-31+corrected-errata-2013-02-20.html#_4.1
See also https://www.w3.org/TR/REC-xml-names/#scoping-defaulting
David TaurielloKeymasterPeter – a quick note to confirm we’ve resolved the issue for this CIK (and a few others), and updated our load process to prevent future anomalies of this sort. My earlier reply was mistaken, however – the lower entity.id was retained.
David TaurielloKeymasterTo use this massive amount of data, one will need to use some database for sorting and screening. Microsoft Excel or Access cannot handle this much of data. Maybe we all can put in a request to XBRL US to allow members to contribute to this standardization efforts by creating a depository area on XBRL US pgAdmin.
I’ve raised this idea internally; another possibility might be creating some sort of common Google Sheet that holds these standardized terms (taking off from Peter Guldberg’s template for balance sheet)
Larry OkongoParticipantThanks David,
this is quite clearer. Since both <xbrli:xbrl> and <xbrl> provide a container within which declaration of namespaces is done, what does the prefix in the first case “xbrli” mean? Just like:
xbrl – Extensible Business Reporting Language, what does the “i” in “xbrli” represent sir? That’s if it is also an acronym anyway.David TaurielloKeymasterxbrli = instance, which is the collection of facts in a report.
Larry OkongoParticipantThanks alot David, I really appreciate your help sir.
- This reply was modified 5 years, 1 month ago by Larry Okongo.
Rod MorleyParticipantI’m receiving a ‘no information returned’ error when running the query below (cut and paste from page 48 of the XBRL API guide) in google sheets – has anyone experienced the same error?
=showData(“https://api.xbrl.us/api/v1/report/search?report.entrytype=inline&fields=report.base-taxonomy,report.entity-name,report.filingdate.sort(DESC),report.accession”)
David TaurielloKeymasterHi Rod – thanks for posting this; it looks like there’s an issue with copying from PDF: when the last character on the line is a hyphen – it is removed.
As a result, your paste is
report.entrytype
when it should bereport.entry-type
=showData(“https://api.xbrl.us/api/v1/report/search?report.entry-type=inline&fields=report.base-taxonomy,report.entity-name,report.filingdate.sort(DESC),report.accession”)
Monday, June 17, 2019 at 11:20 PM in reply to: Getting started with the XBRL Google Sheet and add-on #143246Benjamin FenigsohnParticipantGetting an invalid request re-inserting URLs to Config sheet B2 and B3 “expired token.”
Monday, June 17, 2019 at 11:21 PM in reply to: Getting started with the XBRL Google Sheet and add-on #143247Benjamin FenigsohnParticipantHere is the correct image:
Tuesday, June 18, 2019 at 6:47 AM in reply to: Getting started with the XBRL Google Sheet and add-on #143279David TaurielloKeymasterElmhurst – thanks for writing; open a ‘private’ or ‘incognito’ window and login to your copy of the XBRL API Spreadsheet. You’ll also need to login to the XBRL API add on under the tools menu.
Change at least one of the tickers from the default – this will trigger queries.
Tuesday, June 18, 2019 at 12:19 PM in reply to: Getting started with the XBRL Google Sheet and add-on #143303Benjamin FenigsohnParticipantIt worked. Thanks!
-
AuthorPosts