Last
updated: 08-08-2024
Time:
23:51:54
Date:08/26/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_20.xlsx
## OK: residuals appear as normally distributed (p = 0.246).
## OK: Residuals appear to be independent and not autocorrelated (p = 0.834).
## OK: Error variance appears to be homoscedastic (p = 0.336).
##
## 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.588, p-value = 0.0002983
## 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 7.94 [ 6.24, 10.20] 2.82 0.13 [0.10, 0.16]
## L(TCI_R, 3) 9.45 [ 7.40, 12.16] 3.07 0.11 [0.08, 0.14]
##
## High Correlation
##
## Term VIF VIF 95% CI Increased SE Tolerance
## L(SP500, 1) 234.86 [ 180.74, 305.28] 15.33 4.26e-03
## L(SP500, 2) 234.41 [ 180.39, 304.69] 15.31 4.27e-03
## L(SP500, 3) 182.26 [ 140.29, 236.88] 13.50 5.49e-03
## sc 29.48 [ 22.80, 38.21] 5.43 0.03
## L(sc, 1) 34.55 [ 26.70, 44.80] 5.88 0.03
## L(sc, 2) 24.57 [ 19.02, 31.82] 4.96 0.04
## L(sc, 3) 19.08 [ 14.80, 24.68] 4.37 0.05
## L(sc, 4) 12.18 [ 9.50, 15.71] 3.49 0.08
## L(TCI_R, 1) 19.00 [ 14.74, 24.57] 4.36 0.05
## L(TCI_R, 2) 20.42 [ 15.83, 26.42] 4.52 0.05
## m1 240.18 [ 184.83, 312.19] 15.50 4.16e-03
## L(m1, 1) 319.05 [ 245.48, 414.76] 17.86 3.13e-03
## indpro 15.34 [ 11.93, 19.82] 3.92 0.07
## L(indpro, 1) 15.98 [ 12.42, 20.65] 4.00 0.06
## L(indpro, 2) 15.77 [ 12.25, 20.37] 3.97 0.06
## L(indpro, 3) 12.79 [ 9.97, 16.51] 3.58 0.08
## x_ff 69.06 [ 53.23, 89.67] 8.31 0.01
## L(x_ff, 1) 156.49 [ 120.47, 203.36] 12.51 6.39e-03
## L(x_ff, 2) 160.05 [ 123.21, 208.00] 12.65 6.25e-03
## L(x_ff, 3) 71.35 [ 55.00, 92.65] 8.45 0.01
## x10_3 30.09 [ 23.27, 39.00] 5.49 0.03
## L(x10_3, 1) 41.87 [ 32.33, 54.32] 6.47 0.02
## L(x10_3, 2) 37.08 [ 28.64, 48.09] 6.09 0.03
## PF 761.82 [ 585.97, 990.53] 27.60 1.31e-03
## L(PF, 1) 1323.26 [1017.72, 1720.61] 36.38 7.56e-04
## L(PF, 2) 1226.42 [ 943.25, 1594.69] 35.02 8.15e-04
## L(PF, 3) 587.53 [ 451.95, 763.89] 24.24 1.70e-03
## cpium 31.53 [ 24.38, 40.87] 5.62 0.03
## Tolerance 95% CI
## [0.00, 0.01]
## [0.00, 0.01]
## [0.00, 0.01]
## [0.03, 0.04]
## [0.02, 0.04]
## [0.03, 0.05]
## [0.04, 0.07]
## [0.06, 0.11]
## [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.00, 0.01]
## [0.00, 0.01]
## [0.01, 0.02]
## [0.03, 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.2811, p-value = 1
## [1] 0.0009497931
## [1] 0.001265465
Spot Market Close:4057.66
Spot Market Close (ex ante):4101.79
Spot Market Close (spread in %):-1.09
Forecast (4 weeks):3989.5
Forecast (spread in % | From Spot Market Close to Forcast[4 weeks]):1.68