2 ms·
The best option I found (for read-only access) was chromedriver > download CSV statement > process that into your own database. Using minimal standard screen
by viraptor 9y ago
The best option I found (for read-only access) was chromedriver > download CSV statement > process that into your own database.
Using minimal standard screen scraping will be hard because most bank apps are a complicated mess of client and server side processing using ancient tech. After many tries, I just used python+chromedriver and that's doable in ~100 loc per bank.
CSV statements because OFX and others are a complete mess in most cases. I haven't seen a single compliant and correct file so far. (This may be AU specific)
Own database / spreadsheet so you have a local copy you can easily filter on. Obtaining specific date range from a bank may be an interesting challenge. I default to importing last 30 days every day with duplicates detected using a hash(date-description-amount-idx) where idx increases for every date-desc-amount duplicate.
So far I'm happy. Actually I'm in the process of writing a post about it - will submit sometime next week most likely.
- mkurz 9y agoLooking forward to that blog post since we need to solve something similar.