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 :**
[url removed, login to view]
**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.