Do any banks offer data feeds of personal accounts via any form of API? I'm essentially looking to check balances on accounts without logging into their website.
I remember reading about a universal banking protocol at some point... and maybe mint.com uses it to access accounts? Does mint.com have a special relationship with each bank, or can I leverage their method?
Edit: For my requirements, I'm only interested in accessing my own financial data.
Look up the Open Financial Exchange (OFX) format on the web. That (I believe) is a generic format for the banking industry.
API access
You will need to check with each institution if they provide an API for direct access. Some will provide access over a dial-up line, others have more modern IP based service. Each will likely require you to register and pay a fee.
Easier is to require the user to download their statement from the bank and import it into your application. Most online banking systems provide this functionality.
Formats
Either way, there are several formats supported by banks (taken from here).
You might see OFX referred to as Quickbooks, Microsoft Money 2005 or Sage Line 50. QIF is sometimes called Quicken 98 or 2000, or Microsoft Money 2003.
CSV formats will be proprietary per institution and require parsing logic developed for each instance.
Who uses what format
The UK banks that support OFX or QIF formats are:
It is possible to write a basic screen scraper to pull account transactions from your Mint.com account. Of course, this means you'll have to have an account set up there and let them to the dirty work for you.
CasperJS is a great tool that makes this fairly trivial, you will need to install both Casper and PhantomJS, the framework it is built on.
var casper = require('casper').create();
casper.start('https://wwws.mint.com/login.event', function() {
this.fill('form#form-login', {
username: 'mintusername',
password: 'mintpassword'
}, true);
}).then(function() {
this.echo('Downloading transaction history...')
this.download('https://wwws.mint.com/transactionDownload.event', '/path/to/save/transactions.csv');
});
casper.run(function() {
this.echo('Done.').exit();
});
This script logs into your Mint account, and downloads your transaction history (as a CSV file) to wherever you specify. From there, you can do what you like with the data. Of course, this script could be expanded significantly to do more advanced things, or to filter the transactions it pulls down, but as a matter of best practice I would advise keeping the screen scraping as simple as possible and add the logic on your program's end.
You can have this script run periodically using launchd for Mac OS X or cron for most Linux flavors.
Intuit are lauching new data services with access to over 18000 financial institutions via secure apis. I am not privy as to whether they will include UK banksand financial institutions, but here is the link:
You could try Swift (see message types), its not the kind of thing you can just set up though, you'd have to speak to each institution you wanted to work with.
There is a standard protocol known as OFX (ofx.net) that might meet your needs. Microsoft Money and Quicken both use it to update data.
For those not overtly concerned about paying a fiver for an OFX converter, designed to handle Nationwide FlexAccount, e-Savings and Creditcards try the Nationwide OFX Converter.
For other banks and creditcards try iCreateOFX Basic and for Investment files try iCreateOFX Investment.
