X13ASFORE - Forecasting for X13ARIMA-SEATS Model

Returns the forecast value and/or confidence interval limits for the X13ARIMA-SEATS model.


X13ASFORE(model, type,dt)
is a unique identifier that designates an X13-ARIMA model created earlier with the X13 Wizard.
is a number that determines the type of return value: 0 (or missing)=forecast value, 1=C.I. lower limit, 2=C.I. upper limit.
TYPE Description
0 or omitted Forecast mean value
1 Lower limit of the confidence interval
2 Upper limit of the confidence interval
is the date of the datapoint for the desired forecast. If missing, NumXL assumes a value equal to the date of the first data point after the end of the dataset.


The X13ASFORE(.) function is available starting with version 1.67 MARTHA.


  1. The underlying model is described here.
  2. If the model's identifier is not recognized, X13ASFORE returns #VALUE!.
  3. If the requested return type argument is negative or greater than 2, X13ASFORE(.) returns #VALUE!.
  4. If the date argument falls later than the end of the specified forecast horizon, X13ASFORE(.) return #N/A.
  5. If the component argument value is not supported, X13ASCOMP returns #VALUE!.
  6. If the date argument is earlier than the date of the last data point (i.e., in-sample), X13ASFORE(.) returns the value of the corresponding data point.

Files Examples



Please sign in to leave a comment.

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