We need a script, written in Perl or preferably PHP and probably using a MySQL database for a new stock recommendation website. The essence of the system we will be selling consists of the following: Each month, we recommend purchasing a seven stock portfolio. For model portfolio purposes, each portfolio will start with $3500 and put about $500 into each recommendation. Each portfolio is held for 13 months (for long term capital gains tax purposes.) Each portfolio then sells all seven of the stocks and rolls the proceeds into a new recommendation of 7 stocks. Thus, there are 13 separate portfolios, each with 7 stocks and each with some cash. Needed are tables that will allow each of the 13 portfolios to be displayed separately. We need the ability to buy and sell the stocks and enter purchase price, purchase date, sell date (when applicable), commission amount, name of the company and ticker symbols. Each stock's data should be updated using Yahoo data (once an hour is adequate) and show gain/loss in dollars and percentages. Each portfolio should have a summary line showing gain/loss in dollars and percentages both for the current recommendations and another line for the gain/loss in dollars and percentages for the portfolio since beginning (using $3500 as the starting point.). To start with, we need to be able to enter back-tested trades for all thirteen portfolios. We need a summary table that shows the aggregate of all the portfolios open positions and total return (some portfolios will have overlapping recommendations, so there will not be 7 times 13 stocks total - the summary must combine the results for the same stocks into one line). The summary table should be automatically generated. The summary table needs to be produced in two versions – one with the names and ticker symbols, and the other without the names and ticker symbols. The latter table will be used for marketing purposes – prospective purchasers can follow along the exact results but not see what stocks have been or are being recommended. A final table is needed that shows the past trade history – closed trades only. This must be an aggregated table – there may also be but it is not absolutely necessary for there to be 13 separate trade history tables. For speed in loading on the web, the 13 portfolios may be separated into several pages – hopefully at least three or four per page. The summary table may be displayed on a separate page. We need to be able to enter stock split and dividend data into the portfolios tables. Hopefully, this could be automated using Yahoo data but we could do it manually if this is not easily done.