Rate of change

Overview

The Rate of change analysis is used to calculate the change in value or in percentage over periods of time (COP). These changes can also be annualized. The analysis will help you visualize and compare how series are changing over time and is commonly used to calculate differences before applying regressions or correlations

Settings

Method

Change over period value

Calculates the difference in value over the time. This can also be called “momentum”.

y t = z t - z t - h

Change over period %

Calculates the percentage change over the time.

y t = 1 0 0 z t - z t - h z t - h

Annual rate value

Calculates the sum of the values over the time and then scales the result to a yearly level.

y ( t ) = c h i = 0 h 1 z ( t i )

where c is the typical number of observations for one year.

Annual rate %

Calculates the percentage change over the time and then annualizes.

y t = 100 · z t z t - h c h - 1

where c is the typical number of observations for one year.

Logarithmic change over period %

Calculates the logarithmic percentage change over the time.

y t = 100 ln z t z t - h

Length

Specify the length of the period, or horizon, over which the change will be calculated.

Mode

The mode determines how the period length is measured.

Fixed period

The period length will be a constant number of observations that is determined based on the frequency of the series. Select this option if it is important to use a constant period length and that each value of the past is used only once.

Calendar date

The period length is determined for each observation based on the calendar date so that an observation with a corresponding date in the past is selected. Select this option when it’s important to compare values of corresponding dates even if it means that some values might be used twice and some not at all. A common use case for this mode is when you have converted a series from a lower frequency. The calendar date mode uses the ISDA standard of Actual/Actual day count fraction.

Force

The application recognizes if a series is already expressed as a rate of change and will return an error if you attempt to calculate a rate of change twice. You can bypass this check by selecting the force option.

Example

Change over period value

In this example, we calculated by how many persons the jobless claims have increased or decreased compared to a year ago. We did this by selecting change over period value for a length of 1 year.

Annual rate (value or percentage)

Here, we compared two different growth rates of the German GDP. The line displays year on year growth rates and the columns represent annualized quarterly growth rates.