Find Jobs
Hire Freelancers

256238 Simple database script

N/A

処理中
投稿日: 15年以上前

N/A

完了時にお支払い
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
プロジェクト ID: 2002504

プロジェクトについて

リモートプロジェクト
アクティブ 12年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です

クライアントについて

UNITED STATESのフラグ
Buda, United States
4.9
47
メンバー登録日:7月 18, 2007

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。