The Quantified Wallet

I've been trying to get a bit more of a handle on my finances lately, so I figured I'd try to get all the data into the time-series database I've been messing with. Actually getting data out of the various banks turned out to be a nightmare of badly formatted pseudo-CSV and export systems that give you slightly less than 6 months of data at a time.

Still, I've got it going now. I've written scripts to clean the CSV up and other scripts to load it into my database. I've got scripts up to my ears. And it kind of occurs to me that I still don't necessarily have all the information I need. The pictured graph is how much I spend each week. Ideally I'd be able to break that down by what kind of things I'm spending it on and filter things out and so on, but that's still a ways off.

I'm pretty surprised that none of the banks seem to be working on analytical tools like this given how useful they are. Plus they'd easily be able to beat any third-party offerings because the crappiness or straight up nonexistence of their APIs and export tools would make competition impossible.