EXCEL stock market calculations

From a row of performance numbers(see attached), I need to get three graphs and a table of performance results. Therefor the input numbers need to be transfered to a monthly and yearly percentage-change output in a table - relativ to the month before. (Example: Input = 100.00; 102.65 / Output = January 2.65) We then use these monthly outputs to create three graphs. The graphs should look like the ones in the example: - a perfromance line starting at 100% (see example) - a "monthly distiribution" chart (see example) - a "rolling 12 months/monthly return" chart (see example). Then two stock market numbers are to be calculated: Sharpe Ratio and Standard Deviation. Formulas are attached. I need this for the attached row of numbers and as an executable EXCEL sheet.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows EXCEL, Win 2000, Win NT

PHP

Project ID: #3763683

About the project