Indicator needed for calculating number of UP/DOWN daily candles for past 24 months.

 

Indicator needed for calculating number of UP/DOWN daily candles for past 24 months.

1) Highest number of consecutive UP or DOWN days in past 24 months.

2) Lowest number of consecutive UP or DOWN days in past 24 months.

3) Average number of consecutive UP or DOWN days in past 24 months.

Is there such a indicator available here ? Anyone please.

 
compro99:
Indicator needed for calculating number of UP/DOWN daily candles for past 24 months. 1) Highest number of consecutive UP or DOWN days in past 24 months. 2) Lowest number of consecutive UP or DOWN days in past 24 months. 3) Average number of consecutive UP or DOWN days in past 24 months. Is there such a indicator available here ? Anyone please.

As an option, if nothing better becomes available - a .csv file of history loaded into Excel spreadsheet. Once made, it will require only a daily update for every currency. I know nothing about coding and no expert in Excel, but still could do it within like 20 or 30 minutes max, real easy.

Reason: