Closed

Monthly Dow30 Returns

We need an interactive interface whereby you can select a stock symbol by typing it into an input field. Additional Input fields include date range. (i.e. Number of years to display, starting from the current and going back).

It then generates a table and calculates a change in stock price based on the previous month's close and displays it in the table grid as a percent change. (Color coded with Green for positive %, and Red for negative %).

In the attached files is a sql database file containing all the facts needed for the calculation. In addition there is an image of a sample format to get an idea of what needs to be contained in the table.

The script written preferably in PHP should check the data for the presence of the Symbol and return applicable errors or results. For example, Symbol not found. The entire project also needs to scale with the data-set. If more, or different symbols are added then the script should not break down.

If the date range (in years) is greater than the available data for that particular symbol it should return all available data.

Using the Adjusted Close as the values in the equation.

The monthly return = (CurrentMonth - PreviousMonth)/PreviousMonth

Skills: MySQL, PHP, Software Architecture

See more: sql get date, scale price, architecture idea, symbol of red, php symbol, it symbols, Monthly, table month php, date calculation, field addition, stock added, stock symbol, interactive table, data typing project sample, sql script data set, image sample typing, sql stock project, stock image needed, interface sql sample, image interactive, generates monthly, check stock php script, sample image typing, stock using php script, interactive table using php

About the Employer:
( 2 reviews ) Riverside, United States

Project ID: #1264412

7 freelancers are bidding on average $164 for this job

umernaseer

hello please check pm. thanks umer

$250 USD in 5 days
(23 Reviews)
6.2
froiden07

Hey this is froiden i have already worked with you..and would like to work on this project too

$150 USD in 2 days
(62 Reviews)
5.6
nuprogramer

Hi,I am php/mysql expert, check your pm. thanks

$250 USD in 10 days
(10 Reviews)
4.8
marcuslewis

Swapinfutures, I have attached a demo of my proposed solution. Please check your PM. Thank you for considering my services on this project. -Marcus

$150 USD in 1 day
(1 Review)
3.8
albertgalo

i understand the work you give and i have a work relevant that work.. i am a programmer... and i am good in that field and i do my best to do that work promise..

$150 USD in 3 days
(0 Reviews)
0.0
expertbehind

Hi, Contact me to start.

$100 USD in 7 days
(2 Reviews)
1.8
MaxVandervelde

I've worked on many projects involving metrics analysis for project data. This is a similar type of project and I am excited to get a chance to work on it. I have a lot of experience in PHP/MySQL and can produce a high More

$100 USD in 2 days
(0 Reviews)
0.0