One day ahead risk forecasts for a range of assets and models. The forecasts are updated daily as the closing prices become available. VaR and ES of a portfolio worth 1000 in the native currency.
The models are estimated with code from Financial Risk Forecasting. The two risk measures that are estimated are Value-at-Risk (VaR) and expected shortfall (ES), both at the 99% probability, described here, while the statistical models used in the forecasting can be seen here.
There are several tables, first two showing VaR and ES, along with model risk calculated by the risk ratio method. The last show the implied probability of a 5% and 20% drop and the expected worst drop in 5 and 25 years. We cannot calculate the probability for HS and it is not relevant to calculate model risk in this case.
| name | date | HS | MA | EWMA | GARCH | tGARCH | EVT | mean | ModelRisk | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | AAPL | 2021-04-09 | 65.60 | 110.50 | 42.50 | 88.00 | 81.80 | 66.90 | 75.90 | 2.60 |
| 2 | AEX | 2021-04-09 | 34.60 | 26.00 | 19.40 | 17.80 | 25.10 | 34.60 | 26.30 | 1.90 |
| 3 | AMZN | 2021-04-09 | 55.30 | 45.50 | 36.70 | 37.20 | 53.20 | 54.00 | 47.00 | 1.50 |
| 4 | AORD | 2021-04-09 | 34.10 | 25.60 | 16.30 | 16.90 | 22.20 | 34.90 | 25.00 | 2.10 |
| 5 | ASX200 | 2020-07-15 | 33.10 | 25.20 | 31.20 | 21.80 | 29.20 | 34.50 | 29.20 | 1.60 |
| 6 | BIST100 | 2021-04-09 | 42.10 | 33.00 | 49.30 | 34.30 | 52.70 | 43.10 | 42.40 | 1.60 |
| 7 | BITCOIN | 2021-04-11 | 130.30 | 106.60 | 87.70 | 91.30 | 260.40 | 133.00 | 134.90 | 3.00 |
| 8 | BOVESPA | 2021-04-09 | 53.60 | 42.00 | 33.10 | 28.40 | 36.90 | 52.00 | 41.00 | 1.90 |
| 9 | CAC40 | 2021-04-09 | 40.20 | 29.10 | 15.90 | 16.20 | 24.40 | 40.40 | 27.70 | 2.50 |
| 10 | CHFEUR | 2021-04-09 | 7.40 | 6.50 | 6.40 | 6.00 | 8.30 | 7.00 | 6.90 | 1.40 |
| 11 | DAX | 2021-04-09 | 40.20 | 30.20 | 18.70 | 18.30 | 30.40 | 40.60 | 29.70 | 2.20 |
| 12 | DAXMIDCAP | 2021-04-09 | 34.90 | 26.80 | 20.80 | 19.80 | 24.60 | 33.80 | 26.80 | 1.80 |
| 13 | FTSE100 | 2021-04-09 | 35.60 | 26.30 | 18.30 | 19.70 | 26.70 | 36.00 | 27.10 | 2.00 |
| 14 | FTSE100TR | 2020-07-15 | 35.50 | 24.70 | 34.40 | 25.80 | 39.30 | 34.80 | 32.40 | 1.60 |
| 15 | FTSE250 | 2021-04-09 | 37.40 | 26.60 | 18.30 | 18.60 | 23.90 | 33.80 | 26.40 | 2.00 |
| 16 | FTSE350 | 2021-04-09 | 36.10 | 25.80 | 17.90 | 19.10 | 25.10 | 36.10 | 26.70 | 2.00 |
| 17 | FTSEAS | 2021-04-09 | 35.90 | 25.50 | 17.70 | 18.90 | 25.10 | 36.00 | 26.50 | 2.00 |
| 18 | FTSEMIB | 2021-04-09 | 37.70 | 33.10 | 16.90 | 17.40 | 25.60 | 39.40 | 28.30 | 2.30 |
| 19 | GBPEUR | 2021-04-09 | 12.50 | 10.90 | 8.50 | 10.70 | 13.80 | 11.60 | 11.30 | 1.60 |
| 20 | HSI | 2021-04-09 | 36.00 | 27.50 | 32.40 | 30.80 | 41.10 | 32.90 | 33.50 | 1.50 |
| 21 | IBEX | 2021-04-09 | 36.00 | 30.40 | 20.00 | 18.40 | 25.80 | 37.30 | 28.00 | 2.00 |
| 22 | ICEX | 2021-04-09 | 29.30 | 23.30 | 20.70 | 20.80 | 28.70 | 27.50 | 25.00 | 1.40 |
| 23 | ISEQ | 2021-04-09 | 39.20 | 29.50 | 22.70 | 19.40 | 23.60 | 37.20 | 28.60 | 2.00 |
| 24 | JKSE | 2021-04-09 | 32.30 | 25.50 | 21.40 | 20.60 | 29.30 | 32.80 | 27.00 | 1.60 |
| 25 | JPYEUR | 2021-04-09 | 12.50 | 10.70 | 7.10 | 9.30 | 11.10 | 12.00 | 10.50 | 1.80 |
| 26 | JSE40 | 2021-04-09 | 33.40 | 29.70 | 28.60 | 28.10 | 36.30 | 35.50 | 31.90 | 1.30 |
| 27 | KFX | 2021-04-09 | 28.80 | 24.60 | 27.60 | 25.50 | 32.30 | 28.70 | 27.90 | 1.30 |
| 28 | KOSPI | 2021-04-09 | 37.30 | 27.10 | 23.30 | 17.10 | 24.40 | 34.80 | 27.30 | 2.20 |
| 29 | MERVAL | 2021-04-09 | 76.40 | 69.70 | 43.20 | 47.30 | 69.80 | 77.90 | 64.00 | 1.80 |
| 30 | MOEX | 2021-04-09 | 34.10 | 26.30 | 22.40 | 20.60 | 26.50 | 30.60 | 26.70 | 1.70 |
| 31 | MXX | 2021-04-09 | 34.30 | 25.40 | 23.30 | 22.80 | 28.30 | 32.00 | 27.70 | 1.50 |
| 32 | N225 | 2021-04-09 | 39.70 | 27.40 | 27.00 | 23.60 | 35.70 | 35.30 | 31.40 | 1.70 |
| 33 | OMX | 2021-04-09 | 35.70 | 27.20 | 19.70 | 19.70 | 25.50 | 35.10 | 27.20 | 1.80 |
| 34 | OMXH25 | 2021-04-09 | 34.80 | 27.30 | 17.70 | 17.50 | 22.00 | 34.20 | 25.60 | 2.00 |
| 35 | SENSEX | 2021-04-09 | 37.10 | 29.10 | 31.00 | 27.20 | 34.20 | 35.10 | 32.30 | 1.40 |
| 36 | SHCOMP | 2021-04-09 | 37.80 | 26.10 | 24.50 | 22.00 | 40.80 | 33.60 | 30.80 | 1.90 |
| 37 | SP500 | 2021-04-09 | 41.80 | 30.80 | 21.80 | 18.40 | 34.60 | 40.90 | 31.40 | 2.30 |
| 38 | SP500TR | 2021-04-09 | 41.80 | 30.80 | 21.80 | 18.40 | 34.70 | 40.90 | 31.40 | 2.30 |
| 39 | SPTSX | 2021-04-09 | 31.60 | 27.00 | 15.60 | 14.60 | 17.70 | 33.20 | 23.30 | 2.30 |
| 40 | STI | 2021-04-09 | 27.20 | 22.40 | 14.50 | 14.50 | 20.00 | 27.70 | 21.10 | 1.90 |
| 41 | SX5E | 2021-04-09 | 39.00 | 28.70 | 16.90 | 16.70 | 25.90 | 39.30 | 27.80 | 2.40 |
| 42 | TASI | 2021-04-08 | 31.80 | 24.50 | 20.60 | 20.90 | 31.40 | 32.60 | 27.00 | 1.60 |
| 43 | TELAVIV100 | 2021-04-08 | 34.40 | 24.80 | 21.50 | 20.00 | 25.40 | 34.20 | 26.70 | 1.70 |
| 44 | TOPIX | 2021-04-09 | 33.90 | 24.60 | 23.10 | 20.20 | 29.80 | 30.80 | 27.10 | 1.70 |
| 45 | TOPXDV | 2021-04-09 | 33.90 | 24.60 | 24.70 | 22.90 | 34.00 | 30.70 | 28.50 | 1.50 |
| 46 | TWSE | 2021-04-09 | 30.80 | 22.50 | 24.00 | 20.10 | 27.50 | 28.90 | 25.60 | 1.50 |
| 47 | USDEUR | 2021-04-09 | 10.60 | 9.90 | 8.60 | 8.80 | 8.80 | 10.00 | 9.40 | 1.20 |
| 48 | VIX | 2021-04-09 | 185.50 | 201.50 | 171.50 | 159.90 | 262.30 | 178.90 | 193.20 | 1.60 |
| name | date | HS | MA | EWMA | GARCH | tGARCH | EVT | mean | ModelRisk | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | AAPL | 2021-04-09 | 213.70 | 126.60 | 48.70 | 100.80 | 121.70 | 132.50 | 124.00 | 4.40 |
| 2 | AEX | 2021-04-09 | 50.70 | 29.80 | 22.30 | 20.40 | 32.60 | 53.80 | 34.90 | 2.60 |
| 3 | AMZN | 2021-04-09 | 66.30 | 52.20 | 42.10 | 42.60 | 70.80 | 71.40 | 57.60 | 1.70 |
| 4 | AORD | 2021-04-09 | 58.80 | 29.30 | 18.70 | 19.30 | 28.10 | 69.20 | 37.20 | 3.70 |
| 5 | ASX200 | 2020-07-15 | 58.90 | 28.80 | 35.80 | 24.90 | 37.10 | 66.60 | 42.00 | 2.70 |
| 6 | BIST100 | 2021-04-09 | 62.60 | 37.80 | 56.50 | 39.30 | 69.20 | 64.00 | 54.90 | 1.80 |
| 7 | BITCOIN | 2021-04-11 | 181.30 | 122.10 | 100.40 | 104.60 | 439.10 | 190.50 | 189.70 | 4.40 |
| 8 | BOVESPA | 2021-04-09 | 95.90 | 48.20 | 37.90 | 32.60 | 46.50 | 130.40 | 65.30 | 4.00 |
| 9 | CAC40 | 2021-04-09 | 60.00 | 33.30 | 18.20 | 18.60 | 32.80 | 62.20 | 37.50 | 3.40 |
| 10 | CHFEUR | 2021-04-09 | 9.80 | 7.40 | 7.40 | 6.90 | 10.70 | 10.40 | 8.80 | 1.60 |
| 11 | DAX | 2021-04-09 | 58.00 | 34.60 | 21.50 | 21.00 | 41.70 | 60.10 | 39.50 | 2.90 |
| 12 | DAXMIDCAP | 2021-04-09 | 51.60 | 30.70 | 23.80 | 22.70 | 30.30 | 53.20 | 35.40 | 2.30 |
| 13 | FTSE100 | 2021-04-09 | 52.20 | 30.20 | 21.00 | 22.60 | 34.50 | 56.60 | 36.20 | 2.70 |
| 14 | FTSE100TR | 2020-07-15 | 52.10 | 28.30 | 39.40 | 29.50 | 51.10 | 58.20 | 43.10 | 2.10 |
| 15 | FTSE250 | 2021-04-09 | 55.90 | 30.50 | 21.00 | 21.30 | 30.20 | 74.70 | 38.90 | 3.60 |
| 16 | FTSE350 | 2021-04-09 | 52.50 | 29.50 | 20.50 | 21.80 | 32.00 | 55.60 | 35.30 | 2.70 |
| 17 | FTSEAS | 2021-04-09 | 52.30 | 29.20 | 20.30 | 21.70 | 32.10 | 54.70 | 35.00 | 2.70 |
| 18 | FTSEMIB | 2021-04-09 | 67.60 | 37.90 | 19.30 | 20.00 | 33.20 | 70.10 | 41.40 | 3.60 |
| 19 | GBPEUR | 2021-04-09 | 16.50 | 12.50 | 9.80 | 12.30 | 17.40 | 17.50 | 14.30 | 1.80 |
| 20 | HSI | 2021-04-09 | 44.00 | 31.50 | 37.10 | 35.20 | 52.60 | 47.50 | 41.30 | 1.70 |
| 21 | IBEX | 2021-04-09 | 59.40 | 34.80 | 22.90 | 21.10 | 33.20 | 57.60 | 38.20 | 2.80 |
| 22 | ICEX | 2021-04-09 | 41.80 | 26.70 | 23.70 | 23.80 | 37.00 | 48.30 | 33.50 | 2.00 |
| 23 | ISEQ | 2021-04-09 | 59.70 | 33.80 | 26.00 | 22.20 | 29.30 | 66.20 | 39.50 | 3.00 |
| 24 | JKSE | 2021-04-09 | 47.80 | 29.20 | 24.60 | 23.60 | 38.20 | 53.50 | 36.10 | 2.30 |
| 25 | JPYEUR | 2021-04-09 | 14.30 | 12.30 | 8.10 | 10.70 | 13.40 | 14.80 | 12.30 | 1.80 |
| 26 | JSE40 | 2021-04-09 | 58.70 | 34.00 | 32.80 | 32.20 | 45.70 | 62.90 | 44.40 | 2.00 |
| 27 | KFX | 2021-04-09 | 39.80 | 28.20 | 31.60 | 29.20 | 40.00 | 39.80 | 34.80 | 1.40 |
| 28 | KOSPI | 2021-04-09 | 48.60 | 31.00 | 26.60 | 19.60 | 31.50 | 54.10 | 35.20 | 2.80 |
| 29 | MERVAL | 2021-04-09 | 147.90 | 79.80 | 49.50 | 54.10 | 93.10 | 141.00 | 94.20 | 3.00 |
| 30 | MOEX | 2021-04-09 | 54.70 | 30.10 | 25.60 | 23.70 | 33.60 | 69.10 | 39.50 | 2.90 |
| 31 | MXX | 2021-04-09 | 46.90 | 29.20 | 26.70 | 26.10 | 35.10 | 50.70 | 35.80 | 1.90 |
| 32 | N225 | 2021-04-09 | 47.80 | 31.40 | 30.90 | 27.00 | 48.20 | 54.90 | 40.10 | 2.00 |
| 33 | OMX | 2021-04-09 | 50.30 | 31.10 | 22.50 | 22.60 | 32.10 | 53.10 | 35.30 | 2.40 |
| 34 | OMXH25 | 2021-04-09 | 51.50 | 31.30 | 20.20 | 20.00 | 27.20 | 57.90 | 34.70 | 2.90 |
| 35 | SENSEX | 2021-04-09 | 64.60 | 33.30 | 35.50 | 31.20 | 43.00 | 81.30 | 48.20 | 2.60 |
| 36 | SHCOMP | 2021-04-09 | 47.70 | 29.90 | 28.10 | 25.30 | 56.40 | 55.60 | 40.50 | 2.20 |
| 37 | SP500 | 2021-04-09 | 64.70 | 35.20 | 25.00 | 21.00 | 48.50 | 67.50 | 43.70 | 3.20 |
| 38 | SP500TR | 2021-04-09 | 64.60 | 35.20 | 25.00 | 21.10 | 48.50 | 67.30 | 43.60 | 3.20 |
| 39 | SPTSX | 2021-04-09 | 68.90 | 31.00 | 17.90 | 16.70 | 22.20 | 93.20 | 41.60 | 5.60 |
| 40 | STI | 2021-04-09 | 45.00 | 25.70 | 16.60 | 16.60 | 25.80 | 50.50 | 30.00 | 3.00 |
| 41 | SX5E | 2021-04-09 | 58.40 | 32.90 | 19.40 | 19.10 | 35.00 | 63.00 | 38.00 | 3.30 |
| 42 | TASI | 2021-04-08 | 52.10 | 28.00 | 23.60 | 23.90 | 42.60 | 57.90 | 38.00 | 2.40 |
| 43 | TELAVIV100 | 2021-04-08 | 50.70 | 28.40 | 24.60 | 22.90 | 31.80 | 59.00 | 36.30 | 2.60 |
| 44 | TOPIX | 2021-04-09 | 42.70 | 28.20 | 26.50 | 23.20 | 39.50 | 48.50 | 34.80 | 2.10 |
| 45 | TOPXDV | 2021-04-09 | 42.70 | 28.20 | 28.30 | 26.30 | 45.10 | 48.90 | 36.60 | 1.90 |
| 46 | TWSE | 2021-04-09 | 45.40 | 25.80 | 27.50 | 23.00 | 35.80 | 60.10 | 36.30 | 2.60 |
| 47 | USDEUR | 2021-04-09 | 12.00 | 11.30 | 9.80 | 10.10 | 10.10 | 12.50 | 11.00 | 1.30 |
| 48 | VIX | 2021-04-09 | 214.90 | 230.80 | 196.50 | 183.10 | 377.20 | 239.20 | 240.30 | 2.10 |
| name | date | p5 | p20 | d5 | d20 | |
|---|---|---|---|---|---|---|
| 1 | AAPL | 2021-04-09 | 0.20 | 3.70 | -233.67 | -518.72 |
| 2 | AEX | 2021-04-09 | 1.10 | 54.80 | -85.14 | -151.19 |
| 3 | AMZN | 2021-04-09 | 0.30 | 86.60 | -99.90 | -147.82 |
| 4 | AORD | 2021-04-09 | 0.80 | 13.60 | -121.94 | -270.58 |
| 5 | ASX200 | 2020-07-15 | 0.90 | 15.40 | -116.50 | -252.86 |
| 6 | BIST100 | 2021-04-09 | 0.60 | 44.10 | -98.27 | -166.17 |
| 7 | BITCOIN | 2021-04-11 | 0.00 | 1.50 | -285.06 | -463.31 |
| 8 | BOVESPA | 2021-04-09 | 0.40 | 3.80 | -237.49 | -625.21 |
| 9 | CAC40 | 2021-04-09 | 0.70 | 38.60 | -97.83 | -171.77 |
| 10 | CHFEUR | 2021-04-09 | 155.10 | 10285.90 | -16.07 | -27.35 |
| 11 | DAX | 2021-04-09 | 0.80 | 54.60 | -92.09 | -155.22 |
| 12 | DAXMIDCAP | 2021-04-09 | 1.20 | 52.60 | -84.89 | -152.57 |
| 13 | FTSE100 | 2021-04-09 | 1.00 | 44.00 | -90.44 | -162.76 |
| 14 | FTSE100TR | 2020-07-15 | 1.00 | 31.30 | -95.91 | -182.87 |
| 15 | FTSE250 | 2021-04-09 | 0.80 | 10.30 | -134.66 | -324.86 |
| 16 | FTSE350 | 2021-04-09 | 1.00 | 52.80 | -87.52 | -153.91 |
| 17 | FTSEAS | 2021-04-09 | 1.00 | 59.90 | -85.41 | -148.24 |
| 18 | FTSEMIB | 2021-04-09 | 0.70 | 16.30 | -119.13 | -240.94 |
| 19 | GBPEUR | 2021-04-09 | 30.90 | 1909.80 | -27.10 | -46.55 |
| 20 | HSI | 2021-04-09 | 1.60 | 141.30 | -71.51 | -117.35 |
| 21 | IBEX | 2021-04-09 | 0.90 | 46.70 | -90.91 | -160.41 |
| 22 | ICEX | 2021-04-09 | 1.60 | 39.90 | -81.65 | -163.49 |
| 23 | ISEQ | 2021-04-09 | 0.80 | 18.50 | -112.60 | -228.11 |
| 24 | JKSE | 2021-04-09 | 1.20 | 42.80 | -87.13 | -162.43 |
| 25 | JPYEUR | 2021-04-09 | 718.00 | 1050575.80 | -19.44 | -26.40 |
| 26 | JSE40 | 2021-04-09 | 0.90 | 21.10 | -106.78 | -215.57 |
| 27 | KFX | 2021-04-09 | 2.90 | 405.50 | -58.23 | -91.49 |
| 28 | KOSPI | 2021-04-09 | 1.10 | 53.50 | -85.76 | -152.38 |
| 29 | MERVAL | 2021-04-09 | 0.10 | 3.30 | -241.32 | -495.96 |
| 30 | MOEX | 2021-04-09 | 1.00 | 11.60 | -124.93 | -306.36 |
| 31 | MXX | 2021-04-09 | 1.30 | 56.80 | -81.37 | -147.62 |
| 32 | N225 | 2021-04-09 | 1.10 | 51.00 | -87.12 | -154.94 |
| 33 | OMX | 2021-04-09 | 1.10 | 68.50 | -82.53 | -142.23 |
| 34 | OMXH25 | 2021-04-09 | 1.00 | 30.00 | -96.10 | -185.73 |
| 35 | SENSEX | 2021-04-09 | 0.70 | 8.50 | -147.54 | -368.35 |
| 36 | SHCOMP | 2021-04-09 | 1.10 | 36.60 | -91.14 | -172.10 |
| 37 | SP500 | 2021-04-09 | 0.70 | 22.50 | -110.61 | -208.41 |
| 38 | SP500TR | 2021-04-09 | 0.70 | 22.90 | -110.13 | -207.14 |
| 39 | SPTSX | 2021-04-09 | 0.80 | 6.50 | -168.74 | -475.48 |
| 40 | STI | 2021-04-09 | 1.50 | 32.00 | -86.55 | -178.95 |
| 41 | SX5E | 2021-04-09 | 0.80 | 30.10 | -101.74 | -186.49 |
| 42 | TASI | 2021-04-08 | 1.10 | 25.50 | -98.20 | -198.19 |
| 43 | TELAVIV100 | 2021-04-08 | 1.00 | 26.60 | -98.97 | -194.77 |
| 44 | TOPIX | 2021-04-09 | 1.50 | 66.80 | -77.50 | -139.63 |
| 45 | TOPXDV | 2021-04-09 | 1.50 | 61.00 | -78.70 | -143.41 |
| 46 | TWSE | 2021-04-09 | 1.10 | 16.60 | -107.30 | -247.53 |
| 47 | USDEUR | 2021-04-09 | 1395.40 | 1584927.90 | -16.48 | -22.63 |
| 48 | VIX | 2021-04-09 | 0.00 | 0.60 | -338.11 | -507.21 |
© All rights reserved, Jon Danielsson, 2021