Moving Average

Description

The Moving Average function uses a moving average over a determinable number of periods to calculate business figures.

Using this Function

Syntax

In the Control File, the Moving Average function is called up as follows:

[account] = Moving average over k periods

Parameters

[account]

Business figure for which the value should be calculated.
This must be contained in the following input data: Input Files | Financial-Data

{over} k {periods}

Number of periods to be used to calculate the moving average.
The value of this parameter is entered directly in the Control File.

Examples

The examples below are based on the following historical data of the business figure [20001]:

• 31/12/2019: 26,000.00

• 31/12/2020: 28,000.00

• 31/12/2021: 27,000.00

• 31/12/2022: 27,500.00

• 31/12/2023: 27,600.00

Example 1

[20001] = Moving average over 3 periods 

• calculation for 31/12/2024:

  • new value of the business figure [20001]:
    (27,000.00 + 27,500.00 + 27,600.00) / 3 = 27,366.67

• calculation for 31/12/2025:

  • new value of the business figure [20001]:
    (27,500.00 + 27,600.00 + 27,366.67 ) / 3 = 27,488.89

• calculation for 31/12/2026:

  • new value of the business figure [20001]:
    (27,600.00 + 27,366.67 + 27,488.89) / 3 = 27,485.19

Example 2

[20001] = Moving average over 5 periods

• calculation for 31/12/2024:

  • new value of the business figure [20001]:
    (26,000.00 + 28,000.00 + 27,000.00 + 27,500.00 + 27,600.00) / 5 = 27,220.00

• calculation for 31/12/2025:

  • new value of the business figure [20001]:
    (28,000.00 + 27,000.00 + 27,500.00 + 27,600.00 + 27,220.00) / 5 = 27,464.00

• calculation for 31/12/2026:

  • new value of the business figure [20001]:
    (27,000.00 + 27,500.00 + 27,600.00 + 27,220.00 + 27,464.00) / 5 = 27,356.80

Example 3

[20001] = Moving average over 6 periods

• calculation for 31/12/2024:

  • new value of the business figure [20001]:
    (26,000.00 + 28,000.00 + 27,000.00 + 27,500.00 + 27,600.00) / 5 = 27,220.00

• calculation for 31/12/2025:

  • new value of the business figure [20001]:
    (26,000.00 + 28,000.00 + 27,000.00 + 27,500.00 + 27,600.00 + 27,220.00) / 6 = 27,220.00

• calculation for 31/12/2026:

  • new value of the business figure [20001]:
    (28,000.00 + 27,000.00 + 27,500.00 + 27,600.00 + 27,220.00 + 27,220.00) / 6 = 27,423.33