Today I’ve tried to write a script to extract some useful information from my bank and credit card statements.
Current account provider: not a problem. Here’s the last year of transactions as a csv file.
Credit card provider A: not a problem. Here’s the last year of transactions as a csv file. You’ll have to provide your own column headers, though, and I’m gonna quote and comma-separate any values >£1000, because I’m sure those are too big to store as regular numbers.
Credit card provider B, santander: you can have 12 months of transaction history, but only if you do 12 separate one month queries, twiddling a form by hand each time. I’m gonna claim that you’re downloading XLS files, but actually it’s some kinda XHTML that excel (and open office calc) can parse, because it’s very important to me that your spreadsheets have my corporate branding.
Wtf, santander. It could have been so much simpler for us both.


