QlikView VB Scripting For Newbies

I like documentation — thanks for finding the “golden egg” of Qlikview VBA API, denvercoder9


I’ve been working with QlikView for a few weeks now, and I’ve finally run into the need for a script. (yay!) I’ve never used Visual Basic before, and have no familiarity with the QlikView API, but I’m pretty decent at picking up new languages. How hard could this possibly be?

… 3 hours later …

QLIKVIEW, WHAT HAPPENED TO YOUR DOCUMENTATION?!!!!! Am I supposed to magically know what all these strange Document and Sheet objects are and what functions they contain? Why does every google query pass me off to your help forums THAT DON’T ACTUALLY HAVE ANY HELP! Okay, maybe they would be helpful if I could open the sample code people keep attaching to their cryptic forum replies. But, oh wait — I can’t. Because I have the free version, and these people actually paid for theirs. So basically, no help for the newbies around here. Gotta work…

View original post 491 more words


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

RankAndFiled.com is like the SEC’s EDGAR database, but for humans

Rank and Filed remains a wonderfully crafted set of API’s and UI’s 🙂

E Pluribus Unum

A new website, Rank and Filed, gathers data from the Security and Exchange Commission’s EDGAR database, indexes it, and publishes it online in open formats that  investors can use to research and discover companies. I’ve included a screenshot of Tesla’s SEC filings below.


The site currently has over 25 million files indexed.

I heard about the new website directly from its creator, Maris Jensen, a former SEC analyst who built the site independently. According to Maris, she proposed the project internally in March 2013 but was immediately turned down.

A month later, after she was terminated for threatening the Commission’s mission with a “lack of respect for senior management” — an issue she holds was unrelated to the proposal — Maris decided to make the idea become real independently and started building. She has since offered to give the site and its code to the SEC but has not heard…

View original post 1,179 more words

Arelle + Google Apps Script = Recent Filings Viewer

I discovered a few exciting things about 1) arelle 2) Google App Scripts– over the course of the week. But I’ll save the boring-stuff for the bottom of the post. Log in to your Google account and open up this Google Spreadsheet.

Warning to XBRL Gurus; this is nothing miraculous. Indeed, the code mainly parsed the SEC’s RSS feed.

Warning to Excel-ophiles; Google Spreadsheet is fantastic, and can create Excel outputs. Try it, you’ll like it.


Here are the three steps:


Continue reading

Flask: What the doctor ordered

Just watched first 10 minutes of Miguel’s Flask talk. It’s fantastic. He’s addressed so many of the bugbears  I’ve encountered while developing Python web-apps… Read on to learn more. Continue reading

Tagged , ,

What is Pickle in python ?

A nice summary of Pickling

Python Tips

Hi there fellas. In this post i am going to tell you about pickle. It is used for serializing and de-serializing a Python object structure. Any object in python can be pickled so that it can be saved on disk. What pickle does is that

View original post 500 more words

d3 and me

So I want to learn d3. I daresay it’s the Javascript standard for data visualization.

My d3 process goes like this: raw data -> d3 processing (grouping, reducing) -> d3 makes data points as SVGs  (rendering, animating)

A web-developer like me will try to apply habits and mental models from different* web technologies. I’ve encountered two big mental hurdles so far;

  1. API: d3 vs jQuery
  2. Elements/styling: SVG vs HTML

Below I describe the differences that I struggle with. Hopefully they help you learn d3!

Continue reading

Promises in iQ

The new HTML5/ECMA6 Promise API is now available! In reading about it here, I knew I had to apply it. Check it out…

Continue reading

Tagged , , ,

Google Datastore Entity Review

I’m working on TTB Tamer. One of my tasks requires that every Entry made by a Brewer (i.e. moving beer out of the cellar) must have a reference to the Brewery to which it applies

I’m forced to reconsider my options for modeling this relationship. Reviewing the Google Datastore gave me fresh perspective…

Continue reading