Beancounter
Beancounter enables stock market data analysis and performance evaluation. The software is open source software and released under GNU General Public License (GPL).
Beancounter is written in Perl and SQL. The software runs independently on any operating system. Beancounter has two main modes.
The first mode is gathering data, i.e., both current data and the historical price data can be retrieved efficiently using multiple securities per requests, and stored in an SQL database via easy command line operations. Beancounter is compatible with PostgreSQL, MySQL and SQLite databases.
The second mode is data analysis, based on previously stored data. This mode of Beancounter comprises various performance reports, as well as a Value-at-Risk analysis. Beancounter is implemented as a Perl module along with a Perl command-line front-end to the module.
Beancounter supports different stock markets from around the globe, foreign exchange rates, US mutual funds and US options. The recent modified version of the software is Beancounter_0.8.1. SQLite 2 is the default database that can be used or can be created as two new options have been added to Beancounter and setup_beancounter. Beancounter queries stock prices from Yahoo! Finance server(s) around the globe and stores them in a relational database (using PostgreSQL), so that the data can be used for further analysis.