Query Tool Prototype
Saturday, May 5, 2012 at 10:13AM
Charlie in Demonstrations of Using XBRL

This is a little taxonomy query tool prototype that I was fiddling with.  I created it in Excel.  The query tool works against easy to use XML infosets, generated from 1480 SEC XBRL financial filing taxonomies.

Using the tool you can query across the set of 1480 filings to get: [Text Block]s used; [Table]s used; [Axis] used; or query on a specific concept such as 'us-gaap:Assets'.  Clearly this is not a be-all, end-all solution to any specific problem, but it does show that you can create such queries. Also, it gives you an idea of how to use XPath to query an XML file.

Fiddle around with the VBA and if you come up with some interesting or useful query, let me know about it.

Article originally appeared on XBRL-based structured digital financial reporting (http://xbrl.squarespace.com/).
See website for complete article licensing information.