« Prototype Set of "Disclosure Templates", Think Visio or PowerPoint | Main | IASB Chairman: "XBRL has the potential to improve effectiveness of financial reporting" »

Query Tool Prototype

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.

Posted on Saturday, May 5, 2012 at 10:13AM by Registered CommenterCharlie in | CommentsPost a Comment

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Hyperlinks will be created for URLs automatically.