Last
updated: 08-08-2024
Time:
22:28:51
Date:08/10/2022
Period:5
Specification:SP500=f(SC, TCI_R, m1, indpro, x_ff, x10_3, PF, cpium)
Sources:Bureau/StocksForecast/BacktestSP500/Backtest2/Data/macro_22_08_8.xlsx
## OK: residuals appear as normally distributed (p = 0.171).
## OK: Residuals appear to be independent and not autocorrelated (p = 0.926).
## OK: Error variance appears to be homoscedastic (p = 0.260).
##
## Bounds F-test (Wald) for no cointegration
##
## data: d(SP500) ~ L(SP500, 1) + L(sc, 1) + L(TCI_R, 1) + L(m1, 1) + L(indpro, 1) + L(x_ff, 1) + L(x10_3, 1) + L(PF, 1) + cpium + d(L(SP500, 1)) + d(L(SP500, 2)) + d(sc) + d(L(sc, 1)) + d(L(sc, 2)) + d(L(sc, 3)) + d(TCI_R) + d(L(TCI_R, 1)) + d(L(TCI_R, 2)) + d(m1) + d(indpro) + d(L(indpro, 1)) + d(L(indpro, 2)) + d(x_ff) + d(L(x_ff, 1)) + d(L(x_ff, 2)) + d(x10_3) + d(L(x10_3, 1)) + d(PF) + d(L(PF, 1)) + d(L(PF, 2))
## F = 5.5672, p-value = 0.0003116
## alternative hypothesis: Possible cointegration
## null values:
## k T
## 8 1000
## # Check for Multicollinearity
##
## Moderate Correlation
##
## Term VIF VIF 95% CI Increased SE Tolerance Tolerance 95% CI
## TCI_R 8.08 [ 6.35, 10.38] 2.84 0.12 [0.10, 0.16]
## L(TCI_R, 3) 9.48 [ 7.42, 12.20] 3.08 0.11 [0.08, 0.13]
##
## High Correlation
##
## Term VIF VIF 95% CI Increased SE Tolerance
## L(SP500, 1) 207.25 [ 159.50, 269.37] 14.40 4.83e-03
## L(SP500, 2) 236.44 [ 181.96, 307.34] 15.38 4.23e-03
## L(SP500, 3) 182.48 [ 140.46, 237.17] 13.51 5.48e-03
## sc 31.69 [ 24.50, 41.08] 5.63 0.03
## L(sc, 1) 37.12 [ 28.68, 48.14] 6.09 0.03
## L(sc, 2) 23.99 [ 18.58, 31.07] 4.90 0.04
## L(sc, 3) 19.02 [ 14.76, 24.61] 4.36 0.05
## L(sc, 4) 12.46 [ 9.71, 16.08] 3.53 0.08
## L(TCI_R, 1) 19.04 [ 14.77, 24.63] 4.36 0.05
## L(TCI_R, 2) 20.41 [ 15.83, 26.42] 4.52 0.05
## m1 225.12 [ 173.24, 292.61] 15.00 4.44e-03
## L(m1, 1) 293.09 [ 225.52, 381.00] 17.12 3.41e-03
## indpro 15.51 [ 12.05, 20.03] 3.94 0.06
## L(indpro, 1) 15.91 [ 12.37, 20.56] 3.99 0.06
## L(indpro, 2) 15.98 [ 12.42, 20.65] 4.00 0.06
## L(indpro, 3) 12.72 [ 9.91, 16.41] 3.57 0.08
## x_ff 70.21 [ 54.12, 91.17] 8.38 0.01
## L(x_ff, 1) 145.93 [ 112.35, 189.64] 12.08 6.85e-03
## L(x_ff, 2) 159.70 [ 122.94, 207.54] 12.64 6.26e-03
## L(x_ff, 3) 72.05 [ 55.54, 93.57] 8.49 0.01
## x10_3 36.76 [ 28.40, 47.67] 6.06 0.03
## L(x10_3, 1) 46.90 [ 36.20, 60.86] 6.85 0.02
## L(x10_3, 2) 37.27 [ 28.79, 48.33] 6.10 0.03
## PF 731.05 [ 562.31, 950.51] 27.04 1.37e-03
## L(PF, 1) 1339.45 [1030.17, 1741.66] 36.60 7.47e-04
## L(PF, 2) 1220.74 [ 938.88, 1587.30] 34.94 8.19e-04
## L(PF, 3) 586.79 [ 451.37, 762.92] 24.22 1.70e-03
## cpium 31.64 [ 24.46, 41.01] 5.62 0.03
## Tolerance 95% CI
## [0.00, 0.01]
## [0.00, 0.01]
## [0.00, 0.01]
## [0.02, 0.04]
## [0.02, 0.03]
## [0.03, 0.05]
## [0.04, 0.07]
## [0.06, 0.10]
## [0.04, 0.07]
## [0.04, 0.06]
## [0.00, 0.01]
## [0.00, 0.00]
## [0.05, 0.08]
## [0.05, 0.08]
## [0.05, 0.08]
## [0.06, 0.10]
## [0.01, 0.02]
## [0.01, 0.01]
## [0.00, 0.01]
## [0.01, 0.02]
## [0.02, 0.04]
## [0.02, 0.03]
## [0.02, 0.03]
## [0.00, 0.00]
## [0.00, 0.00]
## [0.00, 0.00]
## [0.00, 0.00]
## [0.02, 0.04]
##
## OLS-based CUSUM test
##
## data: ocus
## S0 = 0.26971, p-value = 1
## [1] 0.001034887
## [1] 0.001491983
Spot Market Close:4210.24
Spot Market Close (ex ante):3869.71
Spot Market Close (spread in %):8.09
Forecast (4 weeks):4237.06
Forecast (spread in % | From Spot Market Close to Forcast[4 weeks]):-0.64