You have chosen to sponsor your bid up to a maximum amount of .
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 :**
**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
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.