FERI Economics Portal

Available Transformations


To use a Transformation, please always specify the Code on the left Side to the Table, possibly with required Parameters.
If you want to apply several Transformations, please separate them with a Space (using the Space Key).

Examples:
1. Applying an Interpolation with Linear Calculation of the missing Values: IPOL(LIN)
2. First Moving Average over 3 Periods, then Percentage Change against previous Year: MAVG(3) PYOY
3. Basing on January 2015: INDX(1'2015)


Percentage Change

PYOY
Percentage Change against previous Year
No Parameters
PPOP
Percentage Change against previous Period
No Parameters
PPON
Percentage Change over n Periods
One Parameter:
n = Number of Periods
PYOE
Percentage Change over Year End
No Parameters
PPOA
Percentage Change (Annualized)
No Parameters
PPAN
Percentage Change (Annualized) over n Periods
One Parameter:
n = Number of Periods


Absolute Change

DYOY
Absolute Change against previous Year
No Parameters
DPOP
Absolute Change against previous Period
No Parameters
DPON
Absolute Change over n Periods
One Parameter:
n = Number of Periods
DYOE
Absolute Change over Year End
No Parameters
DPOA
Absolute Change (Annualized)
No Parameters


Indexing and Smoothing

INDA
Index based on Year Average
One Parameter:
Year in YYYY Format
INDX
Index based on Period
One Parameter:
Period in the Data Manager Date Format (see Date Formats Documentation)
MAVG
Moving Average over n Periods
One Parameter:
n = Number of Periods
MSUM
Moving Sum over n Periods
One Parameter:
n = Number of Periods


Cumulation

RTAV
Year to Date (Average)
No Parameters
RTSM
Year to Date (Sum)
No Parameters
CUGR
Year to Date (Percentage Change)
No Parameters
CGRA
Year to Date (Percentage Change over Y)
No Parameters
CGAA
Year to Date (Annualized Percentage Change over Year Average)
No Parameters


Date Operations

LEAD
Shift by n Periods into the Past
One Parameter:
n = Number of Periods
LAGS
Shift by n Periods into the Future
One Parameter:
n = Number of Periods
CUTP
Start Time Series with specified Period
One Parameter:
Period in the Data Manager Date Format (see Date Formats Documentation)
IPOL
Interpolation
One Parameter:
Method of Interpolation (LINEAR = Linear, EVEN = Last Value before Gap, GROW = Growth Rate)


Trend Functions

LITR
Linear Trend
Three Parameters:
1. Start Date in the Data Manager Date Format (see Date Formats Documentation)
2. End Date in the Data Manager Date Format (see Date Formats Documentation)
3. End Date of Forecast in the Data Manager Date Format (see Date Formats Documentation)
LOTR
Logarithmic Trend
Three Parameters:
1. Start Date in the Data Manager Date Format (see Date Formats Documentation)
2. End Date in the Data Manager Date Format (see Date Formats Documentation)
3. End Date of Forecast in the Data Manager Date Format (see Date Formats Documentation)
SPTR
Spline Trend
Three Parameters:
1. Start Date in the Data Manager Date Format (see Date Formats Documentation)
2. End Date in the Data Manager Date Format (see Date Formats Documentation)
3. End Date of Forecast in the Data Manager Date Format (see Date Formats Documentation)
ARFO
Autoregression
Three Parameters:
1. Start Date in the Data Manager Date Format (see Date Formats Documentation)
2. End Date in the Data Manager Date Format (see Date Formats Documentation)
3. End Date of Forecast in the Data Manager Date Format (see Date Formats Documentation)


Other Functions

FACTOR
Multiplication with a Constant
One Parameter:
Constant as numeric Value
CURRENCY
Currency Conversion
One Parameter:
Target Currency (Euro, US$ or LC as Local Currency)