JFRM  Vol.6 No.4 , December 2017
Portfolio Optimization Modelling with R for Enhancing Decision Making and Prediction in Case of Uganda Securities Exchange
Abstract: Portfolio Optimization involves choosing proportions of assets to be held in a portfolio, so as to make the portfolio better than any other. In this research, we use a software for statistical computing R to analyse the performance of portfolio optimization models which include; Markowitz’s Mean-Variance (MV) model, the VaR model, and Konno and Yamazaki’s Mean-Absolute Deviation (MAD) model. We start by analysing multi-asset data for the major indexes in the world followed by historical data of 16 constituent shares listed on the Uganda Securities Exchange (USE) covering 6.5 years. The paper then tests the stock performance of the models using R. We found that GREXP bonds dominated the world market as they accounted for more than 60% of the Maximum Diversified Portfolio (MDP). For the USE, we generated more risk measures like volatility, Sharpe Ratio (SR), Risk Parity (RP), Expected Shortfall (ES) or CVaR which we used to assess stock performance. UMEME, NVL, BATU, JHL, DFCU, EBL, EABL, KCB, SBU and CENT were the best-performing stocks. By understanding the performance of portfolio optimization models in R, Ugandan investors will develop a better view of the latest performance of the stocks listed on the USE. This will help them to decide on which stocks to include in their investment portfolios, thus prevent wrong investment decisions.
Cite this paper: Baganzi, R. , Kim, B. and Shin, G. (2017) Portfolio Optimization Modelling with R for Enhancing Decision Making and Prediction in Case of Uganda Securities Exchange. Journal of Financial Risk Management, 6, 325-351. doi: 10.4236/jfrm.2017.64024.

[1]   ACCA (2016). ACCA P4, Advanced Financial Management (9th ed.). London: BPP Learning Media Ltd.

[2]   ACCA (2017). ACCA P1, Governance, Risk and Ethics.

[3]   Amundi (2014). Amundi Asset Management: Investment Strategy Collected Research Papers.

[4]   BATU (2017). BATU Full Year Results 31 December 2016. Kampala.

[5]   Bodie, Z., Kane, A., & Marcus, A. J. (2011). Investments (9th ed.). New York, NY: McGraw-Hill.

[6]   Busuulwa, B. (2016). Commodities Exchange Launched in Kampala. The East African.

[7]   Bwiso, P. (2017). An Interview with Paul Bwiso: The Future of USE; Which Are the Top four Listed Companies in Terms of Turnover and Why (pp. 1-37)? Summit Business Review.

[8]   Chen, G., Liao, X., & Wang, S. (2009). A Cutting Plane Algorithm for MV Portfolio Selection Model. Applied Mathematics and Computation, 215, 1456-1462.

[9]   Chouinard, E., & D’Souza, C. (2004). The Rationale for Cross-Border Listings. Bank of Canada Review, 1, 1-23.

[10]   CMA (2017). Who We Are.

[11]   Danielsson, J. (2011). Financial Risk Forecasting, the Theory and Practice of Forecasting Market Risk, with Implementation in R and Matlab. John Wiley & Sons Ltd.

[12]   De Landsheere, J. (2012). Cross-Listing in the 21st Century “Benefits of ADR-Listings: An Ending Story?” Tilburg University.

[13]   DFCU (2017). DFCU Bank Full Year Results 31 December 2016. Kampala.

[14]   Haimes, Y. (2009) On the Complex Definition of Risk: A Systems-Based Approach. Risk Analysis. An International Journal, 29, 1647-1654.

[15]   Hansson, S. O. (1996). What Is Philosophy of Risk? Theoria, 29, 1647-1654.

[16]   JHL (2017). JHL Announcement 2016 Audited Consolidated Results. Kampala.

[17]   Kasekende, L. (2017a). At the 4th Edition of the Uganda National Journalism Awards; African Centre for Media Excellence (ACME). Kampala.

[18]   Kasekende, L. (2017b). Launch of the 10-Year Capital Markets Development Master Plan. Kampala.

[19]   KCB (2017). KCB-Group-Financial-Results-FY16. Nairobi.

[20]   Konno, H., & Yamazaki, H. (1991). Mean-Absolute Deviation Portfolio Optimization Model and Its Applications to Tokyo Stock Market. Management Science, 37, 519-531.

[21]   Krause, T., Ehsani, S., & Lien, D. (2014). Exchange-Traded Funds, Liquidity and Volatility. Applied Financial Economics, 24, 1617-1630.

[22]   Lee, W. (2014). Constraints and Innovations for Pension Investment: The Cases of Risk Parity and Risk Premia Investing. The Journal of Portfolio Management, 40, 12-20.

[23]   Li, W. C., Wu, Y., & Ojiako, U. (2014). Using Portfolio Optimisation Models to Enhance Decision Making and Prediction. Journal of Modelling in Management, 9, 36-57.

[24]   Liu, M., & Gao, Y. (2006). An Algorithm for Portfolio Selection in a Frictional Market. Applied Mathematics and Computation, 182, 1629-1638.

[25]   Luenberger, D. G. (1998). Investment Science. New York, NY: Oxford University Press.

[26]   Markowitz, H. (1952). Portfolio Selection. The Journal of Finance, 7, 77-91.

[27]   Mayanja, F., Mataramvura, S., & Mahera, C. W. (2013). A Mathematical Approach to a Stocks Portfolio Selection: The Case of Uganda Securities Exchange (USE). Journal of Mathematical Finance, 2, 487-501.

[28]   Mutebile, E. T. (2017). Investing in Government Securities Now Easier and More Accessible to the Public.

[29]   Namugaya, J., Weke, P. G. O., & Charles, W. M. (2014). Modelling Stock Returns Volatility on Uganda Securities Exchange. Applied Mathematical Sciences, 8, 5173-5184.

[30]   Naslund, B., & Whinston, A. (1964). Model of Decision Making under Risk. Metroeconomica, 16, 81-94.

[31]   NIC (2017). National Insurance Corporation Full Year 31 December 2016. Kampala.

[32]   Njanike, K., Katsuro, P., & Mudzura, M. (2009). Factors Influencing the Zimbabwe Stock Exchange Performance (2002-2007). Annals of the University of Petrosani, Economics, 9, 161-172.

[33]   NSE (2017). About NSE.

[34]   NVL (2017). New Vision Limited Full Year Results 31 December 2016. Kampala. 31

[35]   Pfaff, B. (2016). Financial Risk Modelling and Portfolio Optimization with R (2nd ed.). Wiley.

[36]   Polak, G. G., Rogers, D. F., & Sweeney, D. J. (2010). Risk Management Strategies via Minimax Portfolio Optimization. European Journal of Operational Research, 207, 409-419.

[37]   Quaye, I., Mu, Y., Abudu, B., & Agyare, R. (2016). Review of Stock Markets’ Reaction to New Events: Evidence from Brexit. Journal of Financial Risk Management, 5, 281-314.

[38]   Rana, M. E., & Akhter, W. (2015). Performance of Islamic and Conventional Stock Indices: Empirical Evidence from an Emerging Economy. Financial Innovation, 1, 1-17.

[39]   R Project (2016). The R Project for Statistical Computing.

[40]   Reuters (2016). ALTX Africa Targets Small Investors with New Uganda Exchange. Reuters.

[41]   SBU (2017). Stanbic Bank Uganda Limited Annual Report 2016. Kampala.

[42]   Semakula, J. (2017). Kasekende Challenges Journalists on Integrity. New Vision Uganda. Kampala.

[43]   Simaan, Y. (1997). Estimation Risk in Portfolio Selection: The Mean Variance Model versus the Mean Absolute Deviation Model. Management Science, 43, 1437-1446.

[44]   Simon, H. (1959). Theories of Decision-Making in Economics and Behavioral Science. American Economic Review, 49, 253-283.

[45]   Sitkin, S., & Pablo, A. (1992). Reconceptualizing the Determinants of Risk Behavior. Academy of Management Review, 17, 9-38.

[46]   UMEME (2017). UMEME Full Year Results 31 December 2016. Kampala.

[47]   USE (2017a). Role of USE.

[48]   USE (2017b). USE Background.

[49]   Wang, D., Song, J., & Lin, Y. (2017). Does the VaR Measurement using Monte-Carlo Simulation Work in China?—Evidence from Chinese Listed Banks. Journal of Financial Risk Management, 6, 66-78.

[50]   Ward, S. (2003). Linked References Are Available on JSTOR for This Article: Approaches to Integrated Risk Management: A Multi-Dimensional Framework. Risk Management: An International Journal, 5, 7-23.

[51]   Watson, S., & Brown, R. (1978). The Valuation of Decision Analysis. Journal of the Royal Statistical Society, 141, 69-78.

[52]   Würtz, D., Setz, T., Chalabi, Y., Chen, W., & Ellis, A. (2015). Portfolio Optimization with Rmetrics. Rmetrics Association & Finance Online Publishing.

[53]   Xu, Q., Zhou, Y., Jiang, C., Yu, K., & Niu, X. (2016). A Large CVaR-Based Portfolio Selection Model with Weight Constraints. Economic Modelling, 59, 436-447.