Excel XBRL functions library - Revision history

Ihr: /* XBRLFactFilteted */

2010-12-09T17:30:10Z

XBRLFactFilteted

← Older revision		Revision as of 17:30, 9 December 2010
Line 5:		Line 5:
	The function that retrieves the data from the database is called '''XBRLFactFiltered'''.		The function that retrieves the data from the database is called '''XBRLFactFiltered'''.

	==~~XBRLFactFilteted~~==		==XBRLFactFiltered==

	===Description===		===Description===

Ihr at 11:25, 9 December 2010

2010-12-09T11:25:50Z

@@ Line 43: / Line 43: @@
 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
+Argument: This is always two dates defining a period (even for instant values) separated by a semicolon and followed by a letter that identifies the period type (instant '''i''', duration '''d''')
 ===Examples===

Ihr: Created page with '==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…'

2010-12-09T10:52:05Z

Created page with '==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…'

New page

==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:<nowiki>http://www.sec.gov/Archives/edgar/data/1158449/000115844910000101/aap-20101009.xml</nowiki>")

==Navigation==
[[Main Page]]