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!

Experiments with Google Maps

In my current job, I need to plot various lat/lng's and find distances and routes between them. I was using Google Earth, but it really drains the resources on my comp (it runs Weblogic, Oracle and Eclipse), so I wrote made this page that would help me out. If you want to use it, click here