I have a stock trading website and need to track and display historical trade data to visitors in a useful and flexible way. I found a number of scripts that perform most of what I need but not all so I am posting this project for a fast programmer.
[login to view URL] script will have an admin function that provides the ability to upload a csv file for stock trade information to a Mysql database.
Fields for upload file will include:
c. Symbol: (Alphanumeric. Formatted to always be upper case)
d. Type: (Text: Long or Short)
e. EntryDate: (Date mm/dd/yy format)
f. EntryPrice: (Currency)
g. ExitDate: (Date mm/dd/yy format)
h. ExitPrice: (Currency)
i. %Gain/Loss: (Calculated percent field based on entry price, exit price and type of trade)
j. Exit Type: (Text)
k. % Cumulative Gain/Loss: (Calculated percentage [login to view URL] the per trade Gain/loss%)
[login to view URL] function performs a dup check during data import (by unique entry date and stock symbol combination) to make sure double entries are not uploaded. (It shouldn't be possible to have a stock entry on the same date)
[login to view URL] a front-end user interface that allows users to view the database in table form and sort or filter table headings.
[login to view URL] end user will allow users to select a data range for the table view. Date range selections should be for either entry or exit dates.
[login to view URL] generates a chronological line chart based on cumulative gains/losses field.
[login to view URL] end automatically calculates the following statistics based on the date range selected by user:
a. Days in date range: (Count Monday – Friday only)
b. Total Gain/Loss%: (Percent)
c. Winning trade percentage (Percent)
d. Total number of trades (Numeric)
e. Number of Short trades (Numeric)
f. Number of Long trades (Numeric)
g. Total profitable trades (Numeric)
h. Total losing trades (Numeric)
[login to view URL] front end should display data for the last three calendar months by default but admin should be able to change to YTD or last 6 calendar months etc. if needed.
[login to view URL] front end should display requested data within 1-3 seconds so performance is key.
[login to view URL] the admin or front end code, I need the ability to apply formatting to the front-end table as well as the line chart. (color, font size/color etc.)
[login to view URL] the admin, I need the ability to export the entire database to a csv file
[login to view URL] script needs to be compatible with Wordpress which I use as my CMS