X12ACOMP - X12-ARIMA Output Time Series

Returns the value of an X-12-ARIMA model output component (e.g. trend, seasonal or irregular).


X12ACOMP(model, step, component)
is a unique identifier that designates an X-12-ARIMA model (created using the NumXL X12 Wizard).
is the offset (i.e. index) from the beginning of the original time series sample data. If missing, the step is assumed to be 1.
is an identifier of the output component (1=SA (default), 2=trend cycle, 3=irregular, 4=seasonal factor, etc.). See the help file for a complete list of the supported components.
Type Desc
1 Final seasonally adjusted series (d11) (default)
2 Final trend-cycle (d12)
3 Final irregular component (d13)
4 Final seasonal factors (d10)
5 Combined holiday and trading day factors (d18)
6 Combined seasonal and trading day factors (d16)


X12ACOMP() function is deprecated as of version 1.67: use X13ASCOMP function instead.


  1. The underlying model is described here.
  2. If the model identifier is invalid, X12ACOMP returns "#VALUE!"
  3. If the step value is greater than the input data set size, X12COMP returns "#N/A!"
  4. If the step value is negative, X12ACOMP returns "#VALUE!"
  5. If the component argument value is not supported, X12ACOMP returns "#VALUE!"


Files Examples



Article is closed for comments.

Was this article helpful?
0 out of 0 found this helpful