Monday, November 27, 2006

401(k) woes .. Believe me, this has to do with code!

My 401(k) wasn't doing really good the last few months and I wanted to pry into the details of my investments and see how each one is growing and performing. To my dismay, the financial providers website was of little use to me as the tools they provided hardly helped me perform any analysis. I needed the data on my machine to analyze it better. They provided only QIF files for download and my need was a CSV file that could be easily imported into Excel. Thats when I wrote developed a webpage with this nifty little script to convert and QIF file to CSV.

The best part is that you don't need to upload/download any files, simply open your QIF file in your favourite text editor, Select All, copy and paste into the left panel. Press Convert at the bottom of the page and the CSV is ready on the right. Click anywhere in the right pane, Select All, Copy and then paste where you require the data!

No comments: