Anyone have a script to download bank statements?

Forums › IT Pro and developers › Anyone have a script to download bank statements?

andrewinwlg

20 posts

Geek

#54583 18-Dec-2009 15:54

Anyone tried to write a script to download bank statements, or scrape data from online banking sites? In particular I'd be looking for ANZ or BNZ, most likely in PERL but any language would do. If not, that is going to be my xmas software project, but I don't want to have to re-invent the wheel if someone has it.

Cheers,
Andrew

nate

6473 posts

Uber Geek
+1 received by user: 458

Retired Mod

Trusted

Lifetime subscriber

#283873 18-Dec-2009 19:13

I use Wesabe, I'm sure it's compatible with your bank.

andrewinwlg

20 posts

Geek

#284019 19-Dec-2009 15:00

Looks interesting but I was looking for a DIY script. Surely somebody has written one?

I wonder how they do the firefox uploader that remembers how to manually dowload statements? That might be another option if there is a decent tool that can record and repeat keystrokes/mouseclicks. Has anyone played around with these?

kontonnz

137 posts

Master Geek
+1 received by user: 20

#284052 19-Dec-2009 17:31

the big question is why?
why would you want to automate something that has access to your bank accts; this just screams as a questionable thing to do;
the bnz uses two factor authentication any hows (not sure bout their business acts however??)

richms

29097 posts

Uber Geek
+1 received by user: 10206

Trusted

Lifetime subscriber

#284080 19-Dec-2009 21:36

In my case it was to get a .csv file to run against an online store/trademe script to mark payments as recived if they were recieved.

In the end it was too much effort so just pull a .csv daily and upload it to the server.

Richard rich.ms

Filterer

489 posts

Ultimate Geek
+1 received by user: 6

#284355 21-Dec-2009 12:58

I **had** one for ASB until they re-branded recently :(

pɐǝɥ sıɥ uo ƃuıpuɐʇs

andrewinwlg

20 posts

Geek

#284562 22-Dec-2009 11:06

kontonnz: the big question is why?
why would you want to automate something that has access to your bank accts; this just screams as a questionable thing to do;
the bnz uses two factor authentication any hows (not sure bout their business acts however??)

1) so I don't waste half an hour downloading csv/qif files, and
2) so I don't lose any electronic data if I forget to download the transaction data every 90 days

I assume that if someone is clever enough to figure out how to write the script to do the download (no easy task for ANZ as it always runs in a separate window), adding in encryption of the password in a file should be no biggie.

Mighty Ape

Shop now at Mighty Ape (affiliate link).

nate

6473 posts

Uber Geek
+1 received by user: 458

Retired Mod

Trusted

Lifetime subscriber

#284696 22-Dec-2009 20:20

andrewinwlg: I assume that if someone is clever enough to figure out how to write the script to do the download (no easy task for ANZ as it always runs in a separate window), adding in encryption of the password in a file should be no biggie.

Doesn't matter if the banking opens in a new window, as long as the two factor authentication isn't one of those security passes, it wouldn't be that hard to duplicate a "legitimate" session, and download the data you require.

Ragnor

8279 posts

Uber Geek
+1 received by user: 585

Trusted

#284867 23-Dec-2009 16:57

Wonder how Xero Personal is coming along, they have deals with all the major banks for their bank feeds.

andrewinwlg

20 posts

Geek

#286286 31-Dec-2009 15:55

nate:

Doesn't matter if the banking opens in a new window, as long as the two factor authentication isn't one of those security passes, it wouldn't be that hard to duplicate a "legitimate" session, and download the data you require.

Correct, it wasn't that hard to write the script in the end.