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
7 freelancers are bidding on average $164 for this job
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..