Tag Archives: Query

Introducing iQ

I’m working on a new language. It’s called iQ.

iQ stands for “iXBRL Query”, where “iXBRL” stands for “inline XBRL”, and “XBRL” stands for “eXtensible Business Reporting Language”

It’s Javascript. It’s inspired by jQuery, and the concepts of Domain-Specific Languages (DSL) and Literate Programming.

Check it out the iQ source code by clicking here:

With iQ, you can easily locate values and identify patterns in financial data. The goal: freely enable anyone with an interest in finance to make meaningful stories out of financial data… Continue reading

Tagged , , , , , , , , , ,

Part Two: The Query

In my previous post, I described the business problem:

Finding filers who made “backwards calculations”. “Backwards” in the sense that they’ve said that us-gaap_ProfitLoss is a calculation parent of the element of us-gaap_NetIncomeLoss. Remember, the former includes income attributable to the noncontrolling interest, and the latter does not. This is backwards because accountants typically subtract us-gaap_NetIncomeLossAttributableToNoncontrollingInterest from us-gaap_ProfitLoss to arrive at a total of us-gaap_NetIncomeLoss. But the above calculation relationship suggests that us-gaap_ProfitLoss is the total. Wrong element.

Confused? I’ll cover that in Part Four. For now, bear with me. Assume it’s “backwards” to go from us-gaap_ProfitLoss to us-gaap_NetIncomeLoss. So, how do we find who’s backwards?

Enter the XBRL-US Database!
To find these filings, I ran this query. I’ve bolded the important parts. Continue reading

Tagged , , , , , , , , , , , , , ,

Backwards Calculations, Part One: The Setup

XBRL US has made a great database available It’s in PostgreSQL  and they made it available as part of their Open Source XBRL competition (aka the XBRL Challenge) I’ve experimented a bit, and found that I can use their database with easy SQL queries, to answer some important XBRL questions, about all SEC-filed XBRL, and it’s lightning-fast! Today I wanted to post about one scenario in particular, called the “Backwards Calculation

My friend Phil Mennona (creator of great GAE apps like this ISO8601 converter or this report name checker) posed an interesting question about two us-gaap elements. Continue reading

Tagged , , , , , , , , , , , , , ,