Excel XBRL functions library
Description
Starting on release 2.6.12 of Reporting Standard S.L. products suite, XBRLizer and XBRLviewer can export the view of an XBRL report to an Excel sheet as formulas pointing to the information stored into the XBRL Database.
The function that retrieves the data from the database is called XBRLFactFiltered.
XBRLFactFilteted
Description
Search for a fact on the XBRL Database using parameters that describe different aspects of the fact item.
Syntax
=XBRLFactFiltered("","","", ...) Up to 20 arguments (filters) are allowed. Normally only 3 or 4 are needed.
Filters
Each filter contains a filter prefix and a filter argument. The filter prefix is a 1 to 3 letters token followed by a colon sign.
The Company Filter
Prefix: c:
Argument: The company name, this is the name of the company as stored into the XBRL Database. The XBRL Database contains a table that links a company name with a pair of entity - identifier strings as defined in the XBRL 2.1 specification and used in XBRL reports.
Reporting Standard S.L. software will automatically obtain the company name if it is available in the report and there is a specific element name in the taxonomy where companies will put their company name. Implemented algorithms include the UG-GAAP taxonomy (dei taxonomy) and the IFRS 2010.
Example: c:ADVANCE AUTO PARTS INC
The Concept Name filter
Prefix: fn:
Argument: The concept name for which the fact is reported. This is the XML element name as defined in a table that links the element name with the pair prefix and element name in a taxonomy. Users don't need to remember element names from the XBRL Taxonomy as the software allows them to change the assigned element name if this is required.
By default, Reporting Standard S.L. software automatically build element names using an algorithm that considers the taxonomy prefix and the element name. If the taxonomy prefix has already been used by another taxonomy, then a number is added to the taxonomy prefix in order to remove duplicates.
Example: fn:us-gaap_CashAndCashEquivalentsAtCarryingValue
The Time filter
Prefix: t:
Argument: This is always two dates defining a period (even for instant values) separated by a semicolon and followed by a letter that is
Examples
=XBRLFactFiltered("c:ADVANCE AUTO PARTS INC", "fn:us-gaap_CashAndCashEquivalentsAtCarryingValue", "t:2010-01-02;2010-01-02i", "rp:http://www.sec.gov/Archives/edgar/data/1158449/000115844910000101/aap-20101009.xml")
