Tag Archives: xbrl

XBRL Zoo: Anaconda + Arelle + Pandas + Python

  • Anaconda is called a “completely free Python distribution… It includes over 195 … packages for science, math, engineering, data analysis.” Anaconda lets us make rapid and visual financial-prototypes. You write code, execute it, see and share results all in the same place.
  • Arelle is called a “a project to provide the XBRL community with an easy to use open source platform for XBRL. “ Arelle makes XBRL easy to handle.
  • Pandas is called a “an open source, BSD-licensed library providing high-performance, easy-to-use data structures and data analysis tools”. Pandas lets us manipulate data like Excel wizards.
  • Python is an open-source and free programming language, called ” easy to pick up whether you’re a first time programmer or you’re experienced with other languages.” All of the above are built on Python.

Together these animals will make XBRL easy, visual and fun.

Watch how I go from 4+ quarters of SEC XBRL filing…

to a printed line-chart in 5 lines of code.

And then I do it for more companies in just another few lines.

Continue reading

Tagged , , , , ,

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 , , , , , , , , , ,

Don’t Be So Negative: XBRL Values (1/3)

Paul Warren recently revisited the popular discussion of negative values in XBRL . Many experts consider negative values the biggest quality/comparability issue in XBRL. If it’s that important, I want to chime in! This post is hopefully the first of a few on the subject. This post will focus on my experience in creating XBRL and the rationale I apply to the problem of “negative values”. Continue reading

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