PHP script edit and reporting system

Closed Posted Jun 16, 2009 Paid on delivery
Closed Paid on delivery

This project is for an edit to a php script and a reporting system for the data. I didn't post the zip containing the script and DB sample, but if you post a comment I'll send it to you as soon as I get your message. The script edit should not take more than an hour or so for php programmer, but the reporting system, I'm not too sure about. The current script basically goes through a list of trades and pretends to trade them again but mulitplies the size of the trade depending on certain criteria. It then counts # of trades, total profit/loss, etc... The new calculations that are needed are listed below. I'm not very good with math, so I won't try to give equations for these or how to calculate them. The fields need to be added into the results table of the database that's included. The calcs needed are in the deliverables section. The php reporting system should be as simple as possible. I am open to about any suggestion for achieving the goal so I will just describe what would need to be produced. I would need to be able to define what fields would be shown and define criteria. I would picture maybe checkboxes to select what fields will be displayed, then a way to select and give a few fields criteria (ie. profitFactor >1, or tradeCount >100). What should be displayed first is a normal table that would be generated if the sql command were sent. In addition to the normal fields should be a column for a graph. A small line graph should show the value of accountBalace after every trade. This is calculated within the attached script. After selecting a row (clicking a button), a full report should be generated showing all available figures, and graphs for accountBalance, percentage gain/loss months/weeks. I realize all this may not be very clear, so feel free to ask any questions.

## Deliverables

This project is for an edit to a php script and a reporting system for the data. I didn't post the zip containing the script and DB sample, but if you post a comment I'll send it to you as soon as I get your message. The script edit should not take more than an hour or so for php programmer, but the reporting system, I'm not too sure about. The current script basically goes through a list of trades and pretends to trade them again but mulitplies the size of the trade depending on certain criteria. It then counts # of trades, total profit/loss, etc... The new calculations that are needed are listed below. I'm not very good with math, so I won't try to give equations for these or how to calculate them. The fields need to be added into the results table of the database that's included. Percentage positive trades Percentage negative trades Perentage breakeven trades Number of negative months Number of positive months Highest number of consecutive negative months Highest number of consecutive positive months Percentage of positive months Percentage of negative months Average percentage gain/loss every month (float)Sum of differences in percentage gains/losses for weeks (week1 = +1 week2 = -1, difference =2) (float)Sum of differences in percentage gains/losses for months netProfit/above calculation The php reporting system should be as simple as possible. I am open to about any suggestion for achieving the goal so I will just describe what would need to be produced. I would need to be able to define what fields would be shown and define criteria. I would picture maybe checkboxes to select what fields will be displayed, then a way to select and give a few fields criteria (ie. profitFactor >1, or tradeCount >100). What should be displayed first is a normal table that would be generated if the sql command were sent. In addition to the normal fields should be a column for a graph. A small line graph should show the value of accountBalace after every trade. This is calculated within the attached script. After selecting a row (clicking a button), a full report should be generated showing all available figures, and graphs for accountBalance, percentage gain/loss months/weeks. I realize all this may not be very clear, so feel free to ask any questions. 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):

a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Ubuntu Server PHP/MySQL

PHP

Project ID: #2685380

About the project

Remote project Active Jun 16, 2009