S&P 500 INDEX: MODEL SPECIFICATIONS & FORECASTS

Last updated: 08-08-2024
Time: 22:51:28

1. Model Specification

Date:08/15/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_11.xlsx

## OK: residuals appear as normally distributed (p = 0.146).
## OK: Residuals appear to be independent and not autocorrelated (p = 0.856).
## OK: Error variance appears to be homoscedastic (p = 0.158).
## 
##  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.5133, p-value = 0.0003461
## 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.43 [   7.38,   12.13]         3.07      0.11     [0.08, 0.14]
## 
## High Correlation
## 
##          Term     VIF         VIF 95% CI Increased SE Tolerance
##   L(SP500, 1)  230.85 [ 177.66,  300.07]        15.19  4.33e-03
##   L(SP500, 2)  235.36 [ 181.12,  305.93]        15.34  4.25e-03
##   L(SP500, 3)  182.33 [ 140.34,  236.96]        13.50  5.48e-03
##            sc   30.84 [  23.85,   39.98]         5.55      0.03
##      L(sc, 1)   35.39 [  27.34,   45.88]         5.95      0.03
##      L(sc, 2)   24.34 [  18.85,   31.52]         4.93      0.04
##      L(sc, 3)   19.09 [  14.81,   24.69]         4.37      0.05
##      L(sc, 4)   12.26 [   9.56,   15.82]         3.50      0.08
##   L(TCI_R, 1)   18.86 [  14.64,   24.40]         4.34      0.05
##   L(TCI_R, 2)   20.47 [  15.87,   26.49]         4.52      0.05
##            m1  239.55 [ 184.35,  311.38]        15.48  4.17e-03
##      L(m1, 1)  316.75 [ 243.72,  411.77]        17.80  3.16e-03
##        indpro   15.07 [  11.72,   19.47]         3.88      0.07
##  L(indpro, 1)   15.97 [  12.41,   20.63]         4.00      0.06
##  L(indpro, 2)   15.82 [  12.30,   20.45]         3.98      0.06
##  L(indpro, 3)   12.72 [   9.92,   16.42]         3.57      0.08
##          x_ff   68.79 [  53.03,   89.33]         8.29      0.01
##    L(x_ff, 1)  153.66 [ 118.29,  199.68]        12.40  6.51e-03
##    L(x_ff, 2)  160.06 [ 123.22,  208.02]        12.65  6.25e-03
##    L(x_ff, 3)   71.57 [  55.17,   92.93]         8.46      0.01
##         x10_3   30.99 [  23.96,   40.17]         5.57      0.03
##   L(x10_3, 1)   41.90 [  32.35,   54.36]         6.47      0.02
##   L(x10_3, 2)   37.06 [  28.63,   48.07]         6.09      0.03
##            PF  763.74 [ 587.45,  993.02]        27.64  1.31e-03
##      L(PF, 1) 1325.14 [1019.16, 1723.06]        36.40  7.55e-04
##      L(PF, 2) 1227.14 [ 943.80, 1595.62]        35.03  8.15e-04
##      L(PF, 3)  587.71 [ 452.08,  764.12]        24.24  1.70e-03
##         cpium   31.59 [  24.42,   40.95]         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.10]
##      [0.04, 0.07]
##      [0.04, 0.06]
##      [0.00, 0.01]
##      [0.00, 0.00]
##      [0.05, 0.09]
##      [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.27733, p-value = 1

2. Forecasts

## [1] 0.000977087
## [1] 0.001309018

Spot Market Close:4297.14

Spot Market Close (ex ante):4128.13

Spot Market Close (spread in %):3.93

Forecast (4 weeks):4250.26

Forecast (spread in % | From Spot Market Close to Forcast[4 weeks]):1.09