XBRLAnalyst takes Excel deeper into XBRL!Excel cells with a single XBRL value, formula or even user-defined metric are fully linked to XBRL financial statements. You wonder what it means? - Cell annotation shows what XBRL tags were used to return the value in the cell, whether it is a single tag value, a formula or even a user defined metric that combines multiple XBRL tags. You will also find there the list of labels for all the tags.
- If you select the cell and click “View Statements“, Excel opens the financial statement viewer (see the screenshot above) where the corresponding XBRL accession, the financial statement and the XBRL values have already been selected and highlighted. It tremendouslysimplifies the audit/verification of XBRL financial data in Excel.
- If you select the cell and click “Search Tags/Data“, Excel opens another viewer of all XBRL tags present in the corresponding accession. Double click the tag and you will see all it’s values for different periods reported in the accession and also the dimensional information associated with the tag in that accession.
- When defining your own metrics using our tool “Edit My Definitions“, you can add a plus sign at the end of the metric name and XBRLAnalyst will add together all values of the tags from your definition list found in the specified accession. See the example [Other Non-current Assets+] on the screenshot below or download our example of Valuation Modelwhere the screenshot was made.
|
XBRLFact function in Excel got more powerful!Now, you can find values using XBRL tag pattern with percent sign % as a wildcard. Try for example XBRLFact(“GE”,”%sales%”,”2013-Q2″)
It will find SalesRevenueGoodsNet XBRL tag and return its value in Excel. |
|
|
No Comments