My bank provides OFX format files for download from their Internet banking website. This short perl script ofx2txt converts these into tab delimited text files suitable to be opened in Excel.
My bank provides OFX format files for download from their Internet banking website. This short perl script ofx2txt converts these into tab delimited text files suitable to be opened in Excel.
Wow — sounds like exactly what I need. …. but…..
I clicked on the link for the word ofx2txt and it returned an error stating that there was no such file on the server.
Where would I find the script?
Do I need anything installed on my PC in order to run a perl script? (sorry — don’t know anything about perl, other than it is a programming language)
Thanks!
Oops. I forgot to upload the file. I have now fixed the problem.
To use a perl script, you need to install perl. The easiest way is to run http://www.cygwin.com/setup.exe and select it from there.
Thank you so much!
Do you use Google Finance? I downloaded my portfolio in OFX and used your script, only I got this error message:
mismatched tag at line 7, column 2, byte 65 at /usr/lib/perl5/vendor_perl/XML/Parser.pm line 187
I’ll work on it this week to see if I can get it to work.
If you require a desktop program to convert banking and credit card OFX and QIF to CSV or to convert banking and credit card CSV and QIF to OFX try iCreateOFX Basic from:
http://icreateofx.co.uk/basic.php