Excel - add traders pivot points to existing work book xxxx

This project was successfully completed by buyaspreadsheet for $30 USD in a day.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
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 :**

[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.

Completed by:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online