Simple way to harness the power of XBRL tagging
There's no need to leave the comfort of Excel in order to download reams of XBRL data. Using Excel web queries, the X Sheet provides instant access to the latest filings in a tagged as reported format for an unlimited number of companies. You can download an X Sheet from here.
Our premium version, standiZd provides additional standardized XBRL tags to make modelling even easier.
The X Sheet is the base for all our products. When you purchase standiZd, you get all the value added additional fields, add on totaliZd and you have a framework to completely control the integrity of your dataset.
So simple to use. Want to change company in an X Sheet, just specify a different ticker in the Search tab. Want to load up an older filing, just change the dates there too. It will even download the last five filings for the same company automatically.
The X Sheet is completely customisable allowing you to leverage the power of Excel to create whatever model you want. You can even create your own X Sheet from scratch by downloading a web query (file) to seed an entirely new sheet.
Each version of the X Sheet uses the same Model/Standard/XBRL arrangement that allows you to hack the data without disturbing your model (or trash the model without effecting your ability to populate a new one - see the blog entry Looking up XBRL in Excel).
Want to add more than five companies/years to your model, no problem, just copy an existing Filing sheet to create more sheets & queries. See the FAQ's for more information on how to do this. Or watch the "How To" video here.
Using web queries, you can ensure that the model is always up to date. Set the external data range option to refresh on opening and with the latest date parameter set in the Search tab, it will always download the latest filings on opening.
Of course being Excel, web queries can be quickly incorporated into a VBA macro so say you wanted to home in on a particular value or ratio for 100 companies, you could write a VBA Macro in a X Sheet to do just that.
So there's no complicated setup, no need for an application or a website. Just download the X Sheet from here and off you go. Remember to login and take a token with you.
To find out more about web queries, try visiting this site.