CODEWITHSUNDEEP
bankingonlinebankingofx
Naftuli Kay
Naftuli Kay

Reputation: 91830

How to pull bank statements from websites?

I need to pull bank account statements from a number of different sources. I'd love to be able to get this data in some sort of standardized fashion, be it CSV or OFX or XML or whatever. I just need to be able to get this data. I'll be using my own account to grab transactions from, so there shouldn't be too many 'legal' problems there. How do sites like Mint.com get bank statements? They simply ask for your account information, the URL, and then they're off and running. How can I do this?

Upvotes: 19

Views: 33439

Answers (5)

John von No Man
John von No Man

Reputation: 3030

If you're interested in a simple, personal solution, one easy way would have Mint aggregate all your purchases and use an existing scraper to download them. Something like this: https://github.com/mrooney/mintapi.

Upvotes: 6

JustGage
JustGage

Reputation: 1662

The other main things you may consider is Plaid (more commercial product but looks really good) And https://www.buxfer.com which has a free api. Mint as of late has made it harder for scrapers to scrape it.

Upvotes: 2

Nepaluz
Nepaluz

Reputation: 707

Grab your transactions and save them to CSV of XLS to convert to OFX and / QIF using iCreateOFX Basic v4 or try the v5 beta.

Upvotes: 0

eggie5
eggie5

Reputation: 1960

I read a comprehensive technical article on this awhile ago, however, I can't find it. From my memory this is what mint does to get data from your bank:

  1. Query API from this company: http://www.finappstore.com/
  2. If bank isn't in above API they fallback to screen scraping

Upvotes: -1

holygeek
holygeek

Reputation: 16195

Write a screen scraper in your favorite language to do it. Automate it away.

Normally banks give you access up to three months of transactions via their online services.

Don't forget to make it push the panic button when the screen scraping fails.

The main point here is to automate it so that the pain (of running it manually) goes away so that all you see are "constantly" updated transactions of your accounts.

Upvotes: 8

Related Questions