Find Jobs
Hire Freelancers

Write MySQL application

$1500-3000 USD

Cancelled
Posted over 6 years ago

$1500-3000 USD

Paid on delivery
We have an excel spreadsheet with data and formulas. As we keep making changes to the formulas, excel is no longer functioning well due to large file size. We want to convert this into an app (would run on our server and mySQL) with a web-facing interface. The app would allow us to import the data (same as spreadsheet) and be able to edit formulas and get results as well as charts. Please take a look at the excel file with the data, then review the requirements below: REQUIREMENTS: 1. Need to generate charts from a) value data b) drawdown data Charts need to be able to compare data from different "runs" (i.e each time a formula or setting gets changed and the calculations are re-run) 2. Need to be able to calculate a) value at each data change (for each row) using a formula. The formula needs to be fully editable with a query (that can reference any piece of data or any other calculated field) and use any mathematical terms as well as IF/THEN operators b) max drawdown (i.e % difference between CURRENT value and HIGHEST value to date) other fields that add in to calculating a) such as i. position size (column G) 3. Need to generate a report each time the formula gets changed and a new set of Values/Drawdowns is run Report should have an unlimited number of time periods For example: 2/2/2014 begin 2/10/2016 end Each time period will have beginning value, end value, % change and annualized % change and maximum drawdown during that time period 4. Have a set of settings that are modifiable, that are referenced by the the calculation, AND have the ability to add NEW settings (parameters) that can then be referenced by the calculation steps QUESTIONS AND ANSWERS (FAQ) Here are some questions other developers have asked: 1) Q- What is a "run"? Is a run when new data is uploaded? Is a run when parameters are changed that require a chart refresh? Does that mean chart data should be generated at run time and not dynamic generated per request? A: Either. Run can be upon change in parameters, adding new parameters, changing the query (formulas), or uploading new data. Chart and results (remember we should be able to see value change over any given time period) should be generated when any of those happens and the "run" is initiated 2) Q- Changing calculations. How flexible should this be? Is he okay with having a list of calculations in a dropdown? Does he need the ability to generate custom calculations on the Fly? A: Yes we need to be able to generate calculations custom so we can develop more formulas for testing. I gave you a sample formula but it can be much more complex than that. Should be able to reference any of the settings, use any calculation (multiply, divide) and if/then statements with operators such as >, < etc 3) Q-Settings. For the settings that are modifiable, are they listed in the settings tab? Does he want to create custom setting sets/group or just add new settings by name and value? A: Yes those are the settings, however need to be able to add new settings that can then be added to the formulas 4) Q: Security. Will this be hosted internally? Should there be authentication? A: Hired internally if it's easy to run on a windows system. Otherwise hosted somewhere else (preferably something simple like GoDaddy since we don't need that much speed or bandwidth and don't have a big budget for this)
Project ID: 15474526

About the project

20 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello..I have read your project details and i am expert working on MYSQL applications. Relevant Skills and Experience I have in-depth knowledge of php, mysql, javascript , jquery, paypal integrations, API's, css, html, html5, wordpress. I will look forward to discuss with you. Thank you. Proposed Milestones $1588 USD - milestone
$1,588 USD in 30 days
4.6 (329 reviews)
8.4
8.4
20 freelancers are bidding on average $2,161 USD for this job
User Avatar
hi sir, we have experience in such database oriented developments , as we have done similar type jobs and we believe that we can make you happy with our work . I passed the link to the recruiter Relevant Skills and Experience MYSQL PHP HTML5 CSS Jquery Javascript Proposed Milestones $500 USD - HTML $500 USD - Stage 1 $500 USD - Stage 2
$1,500 USD in 30 days
4.9 (171 reviews)
8.7
8.7
User Avatar
Hi There, Thank you for the opportunity. We have reviewed the attached excel file and we have some gap in terms of understanding the date flow, Can we please discuss in detail on this project via Chat Relevant Skills and Experience We have 10+ Yrs of experience Proposed Milestones $1600 USD - On discussion with the client Looking forward to discussing this [project specification in detail via Chat
$1,600 USD in 30 days
4.9 (299 reviews)
8.8
8.8
User Avatar
Hello there! I'm available to work on your project. Thanks Relevant Skills and Experience PHP Proposed Milestones $2647 USD - To be discussed
$2,647 USD in 30 days
5.0 (1028 reviews)
8.8
8.8
User Avatar
I have read all requirements and It's certainly something I can turn around in the time frame required, However, I'd like to know a few more details. I can start your project immediately Relevant Skills and Experience Thank you for sharing the detailed overview of the site, I am pretty confident to assist you in this. Please check my profile I am a top rated developer and can do about anything with websites. Proposed Milestones $1500 USD - Project Milestone
$1,500 USD in 25 days
4.9 (129 reviews)
8.3
8.3
User Avatar
Hello Sir I can design & develop high quality website to fulfill all of your requirements. Our developed cross-browser website would be highly secure from HACKING and spamming. Relevant Skills and Experience I am Faisal having 8 years of experience with more than 600 successful projects. Please come in private chat to discuss in detail about your website and I am ready to start your project right now. Proposed Milestones $1705 USD - we can discuss
$1,705 USD in 30 days
5.0 (288 reviews)
8.1
8.1
User Avatar
MySql Experts! We have studied your project and we think we can surely do it. you can rely on us as you can see our profile have best reviews and our project completion rate is 100%. Relevant Skills and Experience we are a leading website app development company, we specialize in WordPress, PHP, Laravel, Codeigniter, Joomla, AngularJS, NodeJS & MYSQL. Proposed Milestones $2941 USD - Estimated Cost Please reply us with your message so that we can discuss more. Thank you, Kim
$2,941 USD in 30 days
5.0 (67 reviews)
7.5
7.5
User Avatar
I will build MySql Application based on your requirement. Relevant Skills and Experience php, mysql Proposed Milestones $2647 USD - milestone
$2,647 USD in 30 days
4.8 (89 reviews)
7.4
7.4
User Avatar
Have gone through your requirements and question answers and all seems fine we can have Windows and web both version of this app whatever you prefer, we will be quite easy to access from anywhere for speed we can suggest you VPS with GoDaddy and can host this app on that server. please let me know when we can discuss further.
$1,764 USD in 30 days
4.9 (225 reviews)
7.1
7.1
User Avatar
Hi! I have 10+ years of web developing experience. I can promise quality and responsibility. We can start IMMEDIATELY. Stay tuned, I'm still working on this proposal.
$2,000 USD in 10 days
5.0 (85 reviews)
6.9
6.9
User Avatar
Sr. Software Professional having 8+ years experience. Relevant Skills and Experience Angular CLI, Angular 4, Angular 2, Angular Js, C# .Net, MVC , PHP, HTML, CSS, Bootstrap, Typescript, Javascript, Jquery, ASPBOILERPLATE, Twilio, Kendo UI,Google API,WPF, WCF,WEBAPI,MSSQL, Oracle, Proposed Milestones $4117 USD - Milestone
$4,117 USD in 60 days
5.0 (48 reviews)
6.0
6.0
User Avatar
Hello there, I can create web app for showing calculations with Chart using given algorithm. I love this type of job due to logical aspects needs to derived. Relevant Skills and Experience Excel, Chart, Calculations, PHP, MySQL Proposed Milestones $1764 USD - Milestone Payment Stay tuned, I'm still working on this proposal.
$1,764 USD in 30 days
5.0 (19 reviews)
5.1
5.1

About the client

Flag of UNITED STATES
West Palm Beach, United States
5.0
35
Payment method verified
Member since Jan 16, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.