Python script to scrape One Account data and convert it to QIF format
Python
Switch branches/tags
Nothing to show
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
README
categories.py.in
oneaccount.py
settings.py.in

README

Use Royal Bank of Scotland (RBS)'s "One Account"?  Need to access the data through something other than it's stupid web interface?

This is a script to scrape your one account data and convert it to QIF format, so you can actually do useful things with it.  And not have to wrestle with the crappy One Account web interface.

I've not bothered making it nice yet.

Right now, to get started:

 * install pyquery and mechanise

 * Copy settings.py.in to settings.py and edit.

 * Copy categories.py.in to categories.py and edit.

 * Run ./oneaccount.py to parse dates from settings.DEFAULT_START_DATE to today

   * Subseqently, just running ./oneaccount.py should only download
     subsequent transactions, though there may be some overlap that
     you should merge during QIF import

 * The HTML scraped from the One Account is cached in the current directory

 * Have a look at ./oneaccount.py --help for some options


TODO:

 * Store historical data in a SQLLite database and ensure subsequent
   scrapes only return new data
 
 * HTML dumps to go in a temporary location and the software shouldn't
   rely on them