- 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
Highest value in each year and after x business days
Find all-time highs in each year. Compare how many all-time-highs was in each year at the same moment current year is ('after x business days').
Highest value in each year and after x business days
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