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
|
Seasonal Adjustment
SASA |
- Seasonal Adjustment
Two Parameters:
- 1. Seasonal Width (Default: 7)
- 2. Time Series is robust (Default: False)
|
SATR |
- Trend Component
Two Parameters:
- 1. Seasonal Width (Default: 7)
- 2. Time Series is robust (Default: False)
|
SASC |
- Seasonal Component
Two Parameters:
- 1. Seasonal Width (Default: 7)
- 2. Time Series is robust (Default: False)
|
SARC |
- Residual Component
Two Parameters:
- 1. Seasonal Width (Default: 7)
- 2. Time Series is robust (Default: False)
|
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
Three Parameters:
- 1. Target Currency (Euro, US$ or LC as Local Currency)
- 2. Unit (Self, Unit, Thd, MN, BN ,TR)
- 3. Reference (AVG as Average Value oder End as End Value)
|
EXTEND |
- Extend Time Series
One Parameter:
- 1. End Date in the Data Manager Date Format (see Date Formats Documentation)
|
RESIZE |
- Resize Time Series
Two 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)
|