Weekly, Monthly and Yearly Range Calculator !!! Programmer Needed !!!

Anyone know how to create Average Weekly, Monthly and Yearly Range Calculator ??

Take a 25 period average for Weekly, Monthly and Yearly Range.

Then show how much pips has moved for the week, month and the year.

This would helps alot... anyone can help ??


Make it something like this indicator..

The range are between the period High and Low range.

Output can be like :
=================


Average 25 weeks range: 200
Pips range for the week: 180

Average 25 months range: 800
Pips range for the month: 700

Average 25 years range: 2000
Pips range for the year: 1800

Output on top left corner can be like :
=================

Average 25 weeks range: 200
Last week Pips Range: 190
This week Pips Range: 180

Average 25 months range: 800
Last month Pips Range: 750
This month Pips Range: 700

Average 25 years range: 2000
Last year Pips Range: 1900
This year Pips Range: 1800

Anyone know how to create Average Yearly Range Calculator ?? Range is based on High/Low of the year. I would like to put this on weekly chart.

Make it something like this indicator..

Output can be like :
=================

Average 20 years range: 2000
Previous year range: 1500
Current year range: 1100

???

All of these things can be done in Excel quite easily with little effort using exported data from MT4.. Sorry can't help with the indicator you're looking for.

Can someone help me with the excel on the yearly range ?

Open a monthly chart and note the high and low for the year. if for example the high is 1.5555 and the low is 1.2222 we subtract 1.2222 from 1.5555, and that is your yearly range... (0.3333)

If you want an average range for the whole year do this for every week in the year then use the average() function in excel using highs and lows of each week from the 52 weeks in the year.

press F1 in excel for help specific to excel, it actually has everything you will ever want to know about excel.

hi,

i want any avg year range for past 20 yrs.

Last year range and this year range.

Can i make it automatically count in excel ?

Output can be like :
=================

Average 20 years range: 2000
Previous year range: 1500
Current year range: 1100

yeah do it


just bring in historical data and work on your excel skills from there.

Still i would like to request help for MQ4 programmer on this calculator...

THanks bobblong for yr reply..