- Aggregate all declining values
- Count(), Count valid, Counter()
- Calculation based on a condition
- Countdown till 0
- Find local peaks, count/aggregate observations
- How many series go up/down/no change

# Aggregate all declining values

Aggregate all consecutive declines of the series.

**Aggregate all declining values**

# Count(), Count valid, Counter()

See how those basic formulas work and how they differ.

**Count, Count valid, Counter - see comparison**

# Calculation based on a condition

## Do calculation when series fall below its average

When series falls below its 200-day average for more than 5 days subtract average from main series.

**Subtract when series fall below 200d average for more than 5d**

## Number of series which have risen

See how to count number of series which have risen for 3 months or more.

**Number of series which have risen**

# Countdown till 0

Count number of forecasted observations from 'now' till the end of forecast - from highest number till 0.

# Find local peaks, count/aggregate observations

## All-time highest value and aggregated number of days above/below certain value

Find all-time highest value(s) and when there is a 10% decline or more. Aggregate number of those values.

**All-time highest value and aggregated number of days above/below certain value**

## All-time highest value and number of days between

Find all-time highest value(s) and count number of observations between them. Also, count number of days since higher value than 'current'.

**All-time highest value and number of days between**

# How many series go up/down/no change

## How many stocks go up or down?(Advance/Decline line)

See the difference between the number of advancing and declining stocks on a daily basis with calculated A/D line.

**How many stocks go up or down - (Advance/Decline line)**

## How many series from list went up (in %)?

Calculate how many banks hiked their policy rates in each point in time. Also, based on that show series when percentage of hiking banks is below or above 50%.

**How many series from list went up (in %)**

## How many series from list went up, down or remained in place?

See how Policy rates series from various banks behaved - how many rates were hiked, cut or had 'no change' - in numbers and percentage.

**How many series from list went up, down or remained in place**