Last
updated: 08-08-2024
Time:
23:06:51
Date:08/17/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_13.xlsx
## OK: residuals appear as normally distributed (p = 0.141).
## OK: Residuals appear to be independent and not autocorrelated (p = 0.840).
## OK: Error variance appears to be homoscedastic (p = 0.172).
##
## 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.5029, p-value = 0.0003528
## 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.88 [ 6.19, 10.12] 2.81 0.13 [0.10, 0.16]
## L(TCI_R, 3) 9.44 [ 7.39, 12.14] 3.07 0.11 [0.08, 0.14]
##
## High Correlation
##
## Term VIF VIF 95% CI Increased SE Tolerance
## L(SP500, 1) 231.01 [ 177.78, 300.27] 15.20 4.33e-03
## L(SP500, 2) 235.69 [ 181.38, 306.36] 15.35 4.24e-03
## L(SP500, 3) 182.19 [ 140.23, 236.78] 13.50 5.49e-03
## sc 30.86 [ 23.87, 40.01] 5.56 0.03
## L(sc, 1) 35.29 [ 27.27, 45.76] 5.94 0.03
## L(sc, 2) 24.44 [ 18.93, 31.65] 4.94 0.04
## L(sc, 3) 19.09 [ 14.81, 24.69] 4.37 0.05
## L(sc, 4) 12.24 [ 9.54, 15.78] 3.50 0.08
## L(TCI_R, 1) 18.85 [ 14.63, 24.39] 4.34 0.05
## L(TCI_R, 2) 20.47 [ 15.87, 26.49] 4.52 0.05
## m1 239.97 [ 184.67, 311.92] 15.49 4.17e-03
## L(m1, 1) 318.01 [ 244.68, 413.40] 17.83 3.14e-03
## indpro 15.35 [ 11.93, 19.83] 3.92 0.07
## L(indpro, 1) 15.98 [ 12.42, 20.65] 4.00 0.06
## L(indpro, 2) 15.84 [ 12.31, 20.47] 3.98 0.06
## L(indpro, 3) 12.74 [ 9.93, 16.44] 3.57 0.08
## x_ff 69.12 [ 53.28, 89.75] 8.31 0.01
## L(x_ff, 1) 154.44 [ 118.89, 200.70] 12.43 6.48e-03
## L(x_ff, 2) 160.05 [ 123.21, 208.00] 12.65 6.25e-03
## L(x_ff, 3) 71.40 [ 55.04, 92.72] 8.45 0.01
## x10_3 31.04 [ 24.00, 40.24] 5.57 0.03
## L(x10_3, 1) 41.79 [ 32.27, 54.22] 6.46 0.02
## L(x10_3, 2) 37.12 [ 28.67, 48.14] 6.09 0.03
## PF 763.99 [ 587.64, 993.35] 27.64 1.31e-03
## L(PF, 1) 1325.71 [1019.61, 1723.81] 36.41 7.54e-04
## L(PF, 2) 1226.80 [ 943.54, 1595.18] 35.03 8.15e-04
## L(PF, 3) 587.78 [ 452.13, 764.21] 24.24 1.70e-03
## cpium 31.60 [ 24.43, 40.97] 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.04]
## [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.00, 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.27762, p-value = 1
## [1] 0.0009722816
## [1] 0.001299736
Spot Market Close:4274.04
Spot Market Close (ex ante):4116.35
Spot Market Close (spread in %):3.69
Forecast (4 weeks):4253.26
Forecast (spread in % | From Spot Market Close to Forcast[4 weeks]):0.49