Free stocks software for linux

eeStock project is a Web application for managing an inventory.
eeStock is a free software which allows you to manage your stocks (items).
Its written in PHP4 and uses a PostgreSQL or MySQL database to store data.
Its divided in 2 sections:
- a user section
- an administration section
In the Stock managing section, users can:
.browse items by manufacturer, category, owner or location
.search items using a keyword
.borrow an item if this one is free
.return their items
.access to their profile
In the Administration section you can (if you have administrator or superuser rights):
.create, modify, duplicate, delete items
.browse all items (list)
.create, modify, delete categories (each category can have a parent category)
.create, modify, delete locations (each location can have a parent location)
.create, modify, delete manufacturers
.create, modify, delete users who will be owners of item(s) (only superusers)
System requirements:
- Apache (required)
- PHP (required)
- MySQL (optional)
- PostgreSQL (optional)
Install database
Create the eestock database (MySQL root user password required)
$ mysqladmin -h localhost -u root -p create eestock
Create the user "eestock" (MySQL root user password required)
$ mysql -h localhost -u root -D mysql -p < admin/utils/mysql/create_user.mysql
Create tables (MySQL root user password required)
$ mysql -h localhost -u root -D eestock -p < admin/utils/mysql/init_db.mysql
Edit file admin/config.inc to change the eestock user password.

Stock Quote is a Firefox extension that allows you to get stock quote of selected ticker from any financial site that you define in the setting page.

Advanced Stock Tracking System (AST) is a Web-based application for keeping track of stocks.

Advance Stock Tracker features a portfolio with dividend tracking, a worksheet to keep track of prospects, a stock comparison utility, and a search engine for the stock market based heavily on technical analysis.

Fastilo project is a freeware shopping cart script based on PHP and Flat Files. Extremely easy to run and use. Our product work on Quick.Cart engine with some modifications.
Main features:
- full administration of the products, categories and delivery companies (delivery cost)
- full administration of the orders
- system for managing the content of additional pages and (subpages) in the web shop, as the company information, regulations etc.
- printing products and order cards
- system of additions, which helps to make your web shop even more functional
- inventory stock control
- WYSIWYG editor
- bestsellers panel
- email customer with his order
- friendly links

Qtstalker project is a user friendly Technical Analysis package for GNU/Linux. Similar to commercial wares such as Metastock, Supercharts and Tradestation. Keeps to a lean, simple design for speed, portability, and low resource usage. Because it uses a plugin model, Qtstalker can easily be extended.
Qtstalker is 100% free software, distributed under the terms of the GNU GPL. An active development community is continually adding new features. We appreciate your input towards creating a world-class GNU/Linux TA package.
Main features:
- A point-and-click object-oriented graphical user interface.
- Chart plugins include line, bar, candlestick, point and figure, and swing.
- Customizable colors. Logarithmic and linear arithmetic scaling. Scale to screen.
- Indicators plugins include MACD, MAs, Bollinger Bands, RSI, and dozens more.
- Chart drawing objects: trendlines, buy/sell arrows, horizontal and vertical lines, fibonacci retracement lines, text.
- Quote plugins download data from online sources such as Yahoo, CME, NYBOT.
- Data import plugins for plain-text CSV files and MySQL database.
- The "Plugin" architecture for quotes and indicators enables easy future extensibility.
- Daily, weekly and monthly chart compression (intra-day in development)
- Various data classes to support for investment types such as stocks, futures, indices, ratios and spreads.
- A back testing function allowing indicator performance tests using actual trading data.
- A very basic portfolio manager. Good for tracking open positions. (Suggestions welcome.)
- A Scanner that can scan the qtstalker database for charts that meet a user defined criteria.
Enhancements:
- Installing TA-Lib is now a pre-requisite.
- A single-click is now used to select charts.
- The user can run external scripts that can pass data back to ExScript to be plotted.
- "Indicator Summary" shows a table of all values of active indicators for each item in a Group.
- An XML export can be used by other programs and by the ExScript indicator.
- See misc/CUS_examples to get a quick start with custom CUS indicators.
- Automated help documents were added for indicators.
- All the installation paths were changed from /usr/* to /usr/local/*.
- This now runs very reliably on Mac OS X systems.

mysqlrowcopy is a tool that generates insert statements from result sets. It produces output similar to what might result from running mysqldump on a single SELECT query.

This project helps eliminate some of the tedium of moving data between QA and production MySQL databases.

Build:

To build mysqlrowcopy, you should run:

./configure
make

A mysqlrowcopy and mysqlrowcopy.debug file are created. They have identical functionality, the .debug version simply has debugging symbols built in (for gdb).

Since mysqlrowcopy is probably going to be I/O bound with modest CPU and RAM usage, the only reason to even build a 64-bit version is to work around potential issues in dynamic linking 32-bit binaries against 64-bit libraries.

RECIPES

1. Migrating a MySQL user account reaper from QA server to a production server.

e.g. MySQL database server qa3.example.com to prod1.example.com:

$ mysqlrowcopy -h qa3.example.com
SELECT * FROM db WHERE User = "reaper" mysql db > reaper.sql
$ mysql -h prod1.example.com mysql < reaper.sql

You could of course simply pipe the output of mysqlrowcopy into mysql and skip the intermediate file.

(Dont forget to RELOAD PRIVILEGES afterwards)

2. Keep your test environment up to date. Populate it with production data every 24 hours. You could run this sequence from cron once a day:

$ mysqlrowcopy -h finance-db.example.com
SELECT * FROM stocks WHERE modified > DATE_SUB(NOW(),INTERVAL 24 HOUR)
finance stocks > day-stocks.sql

$ cat day-stocks.sql | mysql -h finance-test.example.com finance

3. Copy data between tables on different servers that have some similar fields.

Youve got common data in table Zip on a production database:

mysql> desc Zip;
+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| ZIPCode | varchar(5) | | PRI | | |
| ZIPCodeType | char(1) | YES | | NULL | |
| City | varchar(32) | YES | | NULL | |
| CityType | char(1) | YES | | NULL | |
| State | varchar(32) | YES | | NULL | |
| StateCode | char(3) | YES | | NULL | |
| AreaCode | char(3) | YES | | NULL | |
| Latitude | varchar(12) | YES | | NULL | |
| Longitude | varchar(12) | YES | | NULL | |
+-------------+-------------+------+-----+---------+-------+
9 rows in set (0.00 sec)

And youve got table ZipPosition in a research database:

mysql> desc ZipPosition;
+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| ZIPCode | varchar(5) | | | | |
| Latitude | varchar(12) | YES | | NULL | |
| Longitude | varchar(12) | YES | | NULL | |
+-------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

You want to load data from production Zip into research ZipPosition.

$ mysqlrowcopy -h production SELECT ZIPCode,Latitude,Longitude common ZipPosition > pos.sql
$ cat pos.sql | mysql -h qa research

Note how we specify ZipPosition on the first line to tell mysqlrowcopy what the destination table is going to be.