Monday, February 19, 2007

kexi and beancounter

I was looking for applications to track investments on linux, with a good level of usability and configuration. But was no able to find any good ones.

So I was trying to integrate beancounter and kexi into a more usable application.

I converted the beancounter database to kexi (Filename: PowerInvest.kexi).

I was able to have beancounter updating and adding stocks to kexi database, using mysql and sqllite3. I decided to use Kexi 1.1.1 and sqlite to allow me to move the file from machine to machine. I implemented the lsportfolio option in kexi using a simple query in a few minutes.

You can find the PowerInvest.kexi in kde-files.org web site on kexi templates, or using the kexi and selecting "Download example databases" from the file menu. http://kde-files.org/?xcontentmode=614

I would be glade to know about more linux user friendly software for stocks/etf/funds statistics, and portfolio tracking tools (KDE/GNome based).

I'll post more about this test I'm doing with kexi/beancounter in the near future.