Excel Formula

Excel Formula

Closed - This job posting has been filled and work has been completed.

Job Description

Hi

I need someone to create a point and figure chart in excel for me, using formulas NOT VBA

I dont need the actual chart, just the figures in colums as they would appear on the chart. so in the colums where there would be an "x" on the chart there is a +1 and where there would be a "o" there would be a -1

Here is the logic. (google point and figure charts)

http://stockcharts.com/school/doku.php?id=chart_school:chart_analysis:pnf_charts:pnf_basics

I also need you to overlay a 2 period moving average indicator on this data.

example

http://stockcharts.com/help/doku.php?id=chart_school:chart_analysis:pnf_charts:pnf_indicators

Thanks

*please read and look at the pages first

Other open jobs by this client