Quantitative Methods for Finance
Assigned Index: MSCI Switzerland Index
Table of Contents
Sr. No |
Title |
Page No. |
1 |
Introduction |
2 |
2 |
Task 1 & 2 |
2 |
3 |
Task 3 |
4 |
4 |
Task 4 |
5 |
5 |
Task 5 |
5 |
6 |
Task 6 |
7 |
7 |
Task 7 |
8 |
8 |
Appendix |
11 |
9 |
Bibliography |
12 |
Introduction
The aim of this report is to examine if a profitable trading strategy can be formulated by using the historical returns of a given asset. The asset in question is the MSCI Switzerland index for the period between 1st January 2000 and 31st December 2017. We will begin by presenting key summary statistics, testing for normality, and testing for seasonality. In addition, we will continue by exhibiting the results of multiple regressions through which we can not only propose our trading strategies, but also examine if they are statistically significant. We will conclude this report by commenting on possible sources of the returns, and how the strategies performed during periods of growth or decline in the market.
Task 1 and 2
We obtained the required data through the Bloomberg platform (2018) for the period stated in the introduction. We initially imported the data into EViews and began to calculate the returns, volatility, skewness, and kurtosis for our data. Using the log return formula:
(1)
We calculated the monthly returns of the index and named the variable LogR. We then found the mean, standard deviation, skewness, kurtosis, and Jarque-Beta (a.k.a JB) statistic by using the “Quick>Series Statistics>Histogram and Stats” command. Moreover, we chose to annualize the mean and standard deviation in order to make the comparison with the results of Georgopoulou and Wang (2017) easier. To achieve this, we used the following formulas respectively:
(2)
(3)
In the following Table 1, we exhibit our findings and also the results of Georgopoulou and Wang (2017):
Table 1
Author |
Period |
Annualized Mean |
Annualized Volatility |
Skewness |
Kurtosis |
Group 21 |
Jan 2000 – Dec 2017 |
1.98% |
13.44% |
-0.68 |
3.73 |
Georgopoulou and Wang |
Dec 1969 – Dec 2015 |
7.17% |
18.13% |
-0.39 |
1.36 |
Source: The results in the above table have been sourced through personal research and the study published in 2017 by Georgopoulou and Wang.
From Table 1 it is apparent that the results obtained by our research are significantly different to the ones obtained in the earlier study. The annualized mean differs by 5.19% which can be explained due to the difference in volatility and length between the two periods. Furthermore, our results show higher skewness and kurtosis meaning that the distribution of our observations is more asymmetric and high-tailed than that of the 2017 study. The higher skewness and kurtosis indicate that our observations are not normally distributed since a normal distribution has a skewness of zero and a kurtosis of 3 (Brown, 2017). Moreover, in order to confirm if our observations are normally distributed, we utilized the JB statistic and conducted an empirical distribution analysis. We tested the null hypothesis of normal distribution existing against the alternative, that the data is not derived from a normal distribution. From our earlier calculations we had found the JB coefficient to be 21.29054 with a p-value of 0.000024. Since our variable JB coefficient is above three and significant at the level of 5%, we were able to reject the null hypothesis and conclude that our returns were not normally distributed. Furthermore, by using the “View>Descriptive Statistics> Empirical Distribution Analysis” command on the LogR variable, we were able to confirm that the JB test result is consistent with results to the Lilliefors, Cramer-von Mises, Watson, and Anderson-Darling tests for normality. Thus, we can conclude with certainty that our distribution is not normally distributed.
We were also asked to test our data against the presence of seasonality. Seasonality is defined as a characteristic of a time series in which the data is exposed to a systematic, although not always regular, event or action that causes predictable movements on a yearly basis (Hylleberg, 1986, p. 241). Furthermore, it is important to state that seasonality differs from cyclical effects since the latter can span long periods of time, whereas seasonal effects are observed in periods spanning no more than one calendar year (1. Investopedia, 2018). Moreover, we initially examined our series against the January effect. This effect was first observed in the monthly returns of the New York stock exchange by Rozeff and Kinney (1976). They reported statistically significant results proving that the returns in the period from 1904 until 1974 are higher in January than any other month. Our data, however, did not show significant results confirming the existence of this seasonal effect as is noticeable in Table 2 below.
Table 2
Variable |
Coefficient |
Probability |
January_dummy |
-1.489895 |
0.1467 |
Halloween |
0.814431 |
0.1416 |
In order to determine the existence of the January effect, a dummy variable was created that took the value of 1 in the months of January included in our data set. We then regressed the dummy with the LogR variable in order to determine if there was a seasonal effect. Since the probability of the variable is 0.146 it is not significant to the level of 5% and we cannot confirm the presence or absence of seasonality in the data.
We also conducted a similar test in order to determine if there was a significant Halloween effect. The effect was observed by Jacobsen and Visaltanachoti (2009) in their paper “The Halloween Effect in US Sectors”. They report significant findings that prove that stock market returns are significantly higher in the period of October until May, in specific sectors, when compared to the rest of the year. In order to test our data set against this effect, we created a dummy variable called Halloween, which took the value of 1 in the months from October until May in our data set. We then regressed this variable against our LogR variable and found that again the results were not significant at the 5% level. Thus, we concluded that there is no evidence of the January or Halloween effect in our index.
Task 3
As mentioned in the introduction, the aim of this report is to propose profitable trading strategies based on the results of a regression between the returns of our index a constant and the 1-month lagged returns of the index. We used the following formula in order to run the regression:
(4)
The regression results were as follows:
Table 3
Variable |
Coefficient |
Std. Error |
t-Statistic |
Probability |
C |
0.139056 |
0.261742 |
0.531271 |
0.5958 |
LogR(-1) |
0.190424 |
0.067415 |
2.824669 |
0.0052 |
The p-value of the regressor ‘LogR(-1)’ is 0.0052. It is known that the p-value for statistical significance is p < 0.05. Therefore, in this regression, the 1-month-lagged return is statistically significant at the 5% level. This means that the 1-month-lagged return has significant explanatory power for the variability of the current returns of the MSCI Switzerland Index. This result is economically relevant as well because it suggests that the previous month’s return has some predictive power on the current month’s returns, and investors can use these returns in a bid to gain in the following month. Moreover, in this regression, the = 0.139 and the = 0.1904. These estimate values can be used to construct a trading strategy. In this case, since the sign and coefficient of the slope parameter is positive, a profitable trading strategy would be to hold a long position for the following month. The direction of the slope suggests that in the next month, the returns are likely to be increasing, thus a long position would be a profitable position to be in.
Task 4
Using a similar method as the one used for the completion of task 3, we obtained the following results from the regression of the current returns with the 2nd– until 12th-lagged-month returns:
Table 4
Month |
Constant Coefficient |
Constant p-value |
Regressor Coefficient |
Regressor p-value |
2 |
0.123948 |
0.6403 |
0.077512 |
0.2561 |
3 |
0.119894 |
0.6516 |
0.114630 |
0.0933 |
4 |
0.121739 |
0.6496 |
0.008319 |
0.9035 |
5 |
0.107784 |
0.6874 |
0.102331 |
0.1359 |
6 |
0.106459 |
0.6935 |
0.026066 |
0.7052 |
7 |
0.100835 |
0.7102 |
0.003508 |
0.9595 |
8 |
0.122122 |
0.6509 |
0.080650 |
0.2401 |
9 |
0.116787 |
0.6664 |
-0.042182 |
0.5393 |
10 |
0.118916 |
0.6615 |
-0.076599 |
0.2658 |
11 |
0.104577 |
0.7021 |
-0.035501 |
0.6076 |
12 |
0.103288 |
0.7071 |
0.012051 |
0.8620 |
Regressing the current returns against the 2nd– until 12th-month-lagged returns gives a Regressor p-value, as can be seen in the table above. None of them are statistically significant at the 5% level and suggest that the monthly lagged returns do not have significant explanatory power for the variability of the current returns. However, the 9, 10 & 11 month lagged variables show that the have negative values, and this suggests that if an investor were to consider these variables and take on a short position, he would be profitable. For the remaining months, taking a long position would be profitable to the investor.
Task 5
In this part of the report, we will be testing the 11 different strategies in order to determine if the mean returns are significant and also to determine if there is evidence of autocorrelation in our data set.
Below are the key summary statistics for each strategy:
Table 5
Month |
Mean |
Standard Deviation |
Probability (F-statistic) |
2 |
0.1365 |
3.8654 |
0.2561 |
3 |
0.1378 |
3.8745 |
0.0933 |
4 |
0.1205 |
3.8755 |
0.9035 |
5 |
0.1233 |
3.8845 |
0.1359 |
6 |
0.1102 |
3.8892 |
0.7052 |
7 |
0.1014 |
3.8966 |
0.9595 |
8 |
0.1336 |
3.8781 |
0.2401 |
9 |
0.1112 |
3.8742 |
0.5393 |
10 |
0.1093 |
3.8836 |
0.2656 |
11 |
0.1006 |
3.8912 |
0.6076 |
12 |
0.1046 |
3.9004 |
0.8620 |
Each trading strategy gives a p-value that is higher than our significance level of 5% (0.05). As a result, we conclude that none of the average returns from the 11 trading strategies are statistically significant.
Moreover, in order to test for autocorrelation using the following regression formula:
(5)
We used the Durbin Watson test for autocorrelation and the Breusch Godfrey test in order to determine serial correlation. In the table below, we have analyzed the Durbin Watson Test statistic and the p-value of the F-test and Chi-Square.
Table 6
Month |
Durbin-Watson stat |
Prob F-statistic |
Prob. Chi-Square |
2 |
1.618860 |
0.1810 |
0.1816 |
3 |
1.618963 |
0.1870 |
0.1873 |
4 |
1.617324 |
0.1818 |
0.1823 |
5 |
1.615768 |
0.1731 |
0.1739 |
6 |
1.614365 |
0.1795 |
0.1801 |
7 |
1.611968 |
0.1835 |
0.1840 |
8 |
1.613801 |
0.1954 |
0.1954 |
9 |
1.615619 |
0.2033 |
0.2030 |
10 |
1.615994 |
0.2107 |
0.2101 |
The Durbin Watson test for each of the returns lagged by 2-12 months gives us a value between 0 DW 4 which is closer to 2. Hence, there is little evidence of autocorrelation.
We further our research by conducting the Breusch Godfrey test using the following hypothesis:
H0 = no serial correlation at up to 12 lags
We observed that the p-values of both the F-test and the Chi-Square are higher than our significance level of 0.05. As a result, we do not reject the null hypothesis for all 11 trading strategies. To conclude, since the residuals of our trading strategies lack evidence of autocorrelation, the parameter estimates and the standard errors are unbiased and accurate.
Task 6
In this part of our report, we will present the key statistics of two subsamples created from our original data. The two subsamples range from January 2000 until December 2008 and January 2009 until December 2017 respectively. The aim of this division is to compare the returns between the two subsamples in order to compare our trading strategies over time. The summary statistics for the two samples are as follows:
Table 7
Subsample |
Period |
Annualised Mean |
Annualised Volatility |
Skewness |
Kurtosis |
Jarque – Bera |
1 |
01/2000 – 12/2008 |
-2.21% |
14.83% |
-0.69 |
3.25 |
8.72 |
2 |
01/2009 – 12/2017 |
6.61% |
11.85% |
-0.48 |
3.98 |
8.47 |
As is visible in the above table, the mean returns of the two subsamples are significantly different. However, we formally tested the following hypothesis, in order to determine if the average returns are significantly different.
Hypothesis: Ho: mean of subsample 2 = -0.183871 against the alternative.
(The value of -0.183871 is the monthly mean of subsample 1)
The single t-test we conducted returned a t-statistic of 2.113606 with a probability of 0.0369, meaning the results are significant. The test we conducted is a two-tailed test at the 5% significance level and therefore we consider a t-statistic against the value of
derived from the T-table of critical values of the t distribution. The condition we use to determine if we will accept or reject the null hypothesis is the following:
Accept Ho if
Reject Ho if
Therefore, we reject the null hypothesis and conclude that the average returns of our two subsamples are significantly different at the 5% level.
This observed difference in returns can easily be attributed to the significant political and economic events that took place within the two subperiods. For example, the first period includes key events that shook the Swiss and world economy such as the banking crisis of 2008, which caused markets around the world to collapse and changed the financial climate of the world (Mathiason, 2008). Another example is the bankruptcy of Swiss Air in 2001, due to a risky expansionary policy and the events of 9/11 in the USA (Kirby, 2001). Furthermore, there was a small correction of prices in the Swiss stock market around February 2003 that caused prices to plummet. However, after 2009, the Swiss economy recovered from the effects of the 2008 crisis and began to experience steady growth. Therefore, the difference between our two subsamples mean can be explained due to these events.
Task 7
In the closing part of this report, we will attempt to give a possible source for our returns, examine the relationship between our strategies and the buy and hold strategy, and determine how our strategies performed during periods of boom and bust.
The returns predicted through our trading strategies can be attributed to a number of factors. However, the main source of returns arising from our suggested trading strategies is the correlation between the returns and the lagged returns. The notion of returns from time series momentum trading strategies, being driven by correlation between the returns of an asset today and the lagged returns of the same asset, is heavily reinforced in relevant literature, as Moskowitz, Ooi, and Pedersen explain in their journal article “Time Series Momentum” (2011).
In our data set, in order to examine the relationship between our strategies and the buy and hold strategy, we decided to construct a correlation matrix in order to determine if multicollinearity existed within our data set. Multicollinearity is present when there is high intercorrelation between independent variables in models of multiple regressions. Furthermore, its existence can raise issues such as unreliable p-values and wider confidence intervals (2. Investopedia, 2018). As is visible in Table 8 below, the variables we used to obtain our trading strategies are not highly correlated since the highest value in the table is 0.22, which is low enough to be considered as non-existent. Without the existence of multicollinearity, we are able to trust the results of our research and safely recommend the trading strategies in task 3 and 4 above.
Table 8: Correlation Matrix
LOGR1 |
LAGRETURNS1 |
LAGRETURNS2 |
LAGRETURNS3 |
LAGRETURNS4 |
LAGRETURNS5 |
LAGRETURNS6 |
LAGRETURNS7 |
LAGRETURNS8 |
LAGRETURNS9 |
LAGRETURNS10 |
LAGRETURNS11 |
LAGRETURNS12 |
|
LOGR1 |
1 |
0.22 |
0.07 |
0.12 |
-0.01 |
0.09 |
0.04 |
-0.01 |
0.08 |
-0.04 |
-0.07 |
-0.03 |
0.01 |
LAGRETURNS1 |
0.22 |
1 |
0.21 |
0.07 |
0.12 |
-0.01 |
0.09 |
0.04 |
-0.01 |
0.08 |
-0.04 |
-0.07 |
-0.03 |
LAGRETURNS2 |
0.07 |
0.21 |
1 |
0.21 |
0.07 |
0.11 |
-0.01 |
0.09 |
0.04 |
-0.01 |
0.08 |
-0.04 |
-0.07 |
LAGRETURNS3 |
0.12 |
0.07 |
0.21 |
1 |
0.21 |
0.07 |
0.11 |
-0.01 |
0.09 |
0.04 |
-0.01 |
0.08 |
-0.04 |
LAGRETURNS4 |
-0.01 |
0.12 |
0.07 |
0.21 |
1 |
0.20 |
0.07 |
0.12 |
-0.01 |
0.10 |
0.04 |
-0.001 |
0.08 |
LAGRETURNS5 |
0.09 |
-0.01 |
0.11 |
0.07 |
0.20 |
1 |
0.20 |
0.06 |
0.12 |
-0.01 |
0.10 |
0.02 |
0.0004 |
LAGRETURNS6 |
0.04 |
0.09 |
-0.01 |
0.11 |
0.07 |
0.20 |
1 |
0.20 |
0.06 |
0.12 |
-0.01 |
0.10 |
0.02 |
LAGRETURNS7 |
-0.01 |
0.04 |
0.09 |
-0.01 |
0.12 |
0.06 |
0.20 |
1 |
0.20 |
0.07 |
0.12 |
-0.01 |
0.10 |
LAGRETURNS8 |
0.08 |
-0.01 |
0.04 |
0.09 |
-0.01 |
0.12 |
0.06 |
0.20 |
1 |
0.20 |
0.07 |
0.12 |
-0.01 |
LAGRETURNS9 |
-0.04 |
0.08 |
-0.01 |
0.04 |
0.10 |
-0.01 |
0.12 |
0.07 |
0.20 |
1 |
0.20 |
0.07 |
0.12 |
LAGRETURNS10 |
-0.07 |
-0.04 |
0.08 |
-0.01 |
0.04 |
0.10 |
-0.01 |
0.12 |
0.07 |
0.20 |
1 |
0.20 |
0.07 |
LAGRETURNS11 |
-0.03 |
-0.07 |
-0.04 |
0.08 |
-0.001 |
0.02 |
0.10 |
-0.01 |
0.12 |
0.07 |
0.20 |
1 |
0.20 |
LAGRETURNS12 |
0.01 |
-0.03 |
-0.07 |
-0.04 |
0.08 |
0.0004 |
0.02 |
0.10 |
-0.01 |
0.12 |
0.07 |
0.20 |
1 |
Finally, we would like to conclude this report by presenting some results concerning the performance of our strategies against historic periods of boom and bust. Graph 1 below shows the movements of our assigned MSCI index in the period beginning in January 2000 until February 2017. By visually inspecting the graph and taking into account the financial events presented in the last paragraph of task 6, we identified periods of boom and bust.
Graph 1
Source: Thomson Reuters, 2018
We then created dummy variables in EViews, in order to find out how our trading strategy performed. We only included the trading strategy derived from the one month lagged returns since this is the only statistically significant strategy we obtained and is the one most investors would follow. Table 9 below includes the results we obtained.
Table 9
Period |
Boom or Bust |
Buy and Hold |
Prob |
1-month lagged |
Prob |
5/2001-9/2001 |
Bust |
-4.07 |
0.0121 |
-1.20 |
0.3406 |
5/2002 – 5/2007 |
Bust |
-4.44 |
0.0001 |
-4.46 |
0.0001 |
4/2003 – 5/2007 |
Boom |
1.34 |
0.0312 |
1.31 |
0.0379 |
10/2007 – 3/2009 |
Bust |
-3.70 |
0.0001 |
-3.96 |
0.0000 |
8/2011 – 12/2014 |
Boom |
0.70 |
0.2904 |
0.57 |
0.3967 |
From the data in table 9, we are able to deduce that the trading strategy was unable to outperform the buy and hold strategy. This is intuitive since in the periods where we derived significant results the buy and hold strategy either earned more during a boom or lost less during a bust. This result is not a surprise, since we explained earlier that results in trading strategies derived from time series momentum, serial correlation is one of the main drives behind results. Our data set was not highly correlated and therefore could not produce a trading strategy yielding high returns.
Conclusion
To conclude, in this report we examined the trading strategies that could be derived by analyzing the returns of an MSCI index, specifically that of Switzerland. We began by comparing the results to those of an earlier research, examining if they were normally distributed, and testing if the January or Halloween seasonal effects were present in the set. Moreover, we proposed trading strategies derived from multiple regressions between the indexes returns and its lagged returns, of various time scales. Furthermore, we tested the returns for autocorrelation, compared the performance of the strategies, and concluded by commenting on the possible sources of our returns.
Appendix
Sr. No. |
Table/Chart No. |
Pg. No. |
1 |
Table 1 |
2 |
2 |
Table 2 |
3 |
3 |
Table 3 |
4 |
4 |
Table 4 |
5 |
5 |
Table 5 |
5 |
6 |
Table 6 |
6 |
7 |
Table 7 |
7 |
8 |
Table 8 |
9 |
9 |
Graph 1 |
10 |
10 |
Table 9 |
10 |
Bibliography
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more