In Progress

Excel - add traders pivot points to existing work book xxxx

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.

Skills: Microsoft, Software Architecture, Visual Basic, Windows Desktop

See more: excel contracting, points, pivot table excel, excel pivot, excel pivot table, excel formula, excel add in, workbook html, add stock, excel stock chart, excel monthly daily, stock chart excel, related book, support level, daily stock excel, point excel, stock excel, add years, excel formula description, range html table, excel html table, html excel project, daily monthly excel, excel daily data monthly, pivot table excel read

About the Employer:
( 14 reviews ) Clearwater, United States

Project ID: #4010674

Awarded to:


I would welcome the opportunity to get off the mark in terms of my freelancer career - hence the minimum bid, the sponsored bid and minimum milestone. Why should you pick me? Firstly, I have more than 7 years experienc More

$30 USD in 1 day
(1 Review)

9 freelancers are bidding on average $62 for this job


Hi toddao, that is really simple with some adpated formulaes

$50 USD in 3 days
(7 Reviews)

Consider it done. Check your PM for my bid details.

$150 USD in 2 days
(13 Reviews)

Please send us the workbook and any additional details. We will make a sample and show you as soon as you contact us.Thanks

$30 USD in 3 days
(7 Reviews)

we r excel macro expert would like to place our bid for ur project and complete the work to ur complete satisfaction

$50 USD in 1 day
(5 Reviews)

Hello toddao, I can complete your Excel - add traders pivot points to existing work book xxxx project. Thank you.

$30 USD in 5 days
(9 Reviews)

Hi, I specialise in financial and trading applications using VBA. Please see PM for further details.

$30 USD in 3 days
(1 Review)

Greetings Client I have read your project request and will be able to help you with this project. I have over 7 years of experience in Excel,Access and VBA tools,automation and database management and development More

$100 USD in 2 days
(1 Review)

Got a team of 4 programmers, can make it complete in less than 5 days, will deliver best gui and best quality with reasonable cost..

$90 USD in 5 days
(0 Reviews)