Excel - add traders pivot points to existing work book xxxx

IN PROGRESS
Bids
9
Avg Bid (USD)
$62
Project Budget (USD)
$30 - $250

Project Description:
project is to add traders pivot point price levels with a chart to an existing workbook. Workbook already finds and loads stock data from C:/data. I need this data read and the levels put in a table and then a chart made with weekly, monthly and yearly pivot points. Plot On/off switches would be nice if possible. Plot of your chart should have similar range to the chart in workbook provided

data provided is daily, you must find last weeks high low close, last months high low close, last years high low close within that data.


**description of what a trader pivot point is :**

http://www.onlinetradingconcepts.com/TechnicalAnalysis/FloorTraderPivots.html

**formula to be used:**

PP = (H + L + C)/3
The first resistance level(R1)=(PPx2)-L
The second resistance level (R2)=PP+H-L
The fist support level (s1)=(PPx2)-H
The second support level (S2)=PP-H+L

(H)igh (L)ow (C)lose




note: workbook provided here has some pages removed that are not related to what you will need. I will provide you with full workbook upon contracting.

Additional Project Description:
12/07/2012 at 20:33 GMT
addendum
sorry I thought I attached workbook when I posted project and now in edit mode cannot find where to add attachment if allowed at all.

Skills required:
Microsoft, Software Architecture, Visual Basic, Windows Desktop
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 50
in 3 days
$ 150
in 2 days
$ 30
in 3 days
$ 50
in 1 days
$ 30
in 5 days
$ 30
in 3 days
$ 30
in 1 days
$ 100
in 2 days
Hire neel13191
$ 90
in 5 days