A Mathematical Approach to a Stocks Portfolio Selection: The Case of Uganda Securities Exchange (USE)
Loading...
Date
2013
Journal Title
Journal ISSN
Volume Title
Publisher
Scientific Research
Abstract
In this paper, we present the problem of portfolio optimization under investment. This area of investment is traced with
works of Professor Markowitz way back in 1952. First, we determine the probability distribution of the Uganda Securities
Exchange (USE) stocks returns. Secondly, we develop unrestricted portfolio optimization model based on the classical
Modern Portfolio Optimization (MPT) model, and then we incorporate certain restrictions typical of the USE trading
or investment environment and hence, develop the modified restricted model. Thirdly, we explore the possibility of
diversification under a portfolio of averagely correlated assets. Determination of the model parameters and model development
is all done using Excel spreadsheets. We explicitly go through the mathematics of the solution methods for
both models. Validation of the models is done using the USE stocks daily trading data, in which case we use a random
sample of 6 stocks out of the 13 stocks listed at the USE. To start with, we prove that USE stocks log returns are normally
distributed. Data analysis results and the frontier curves show that our modified (restricted) model is valid as the
solutions are all consistent with the theoretical foundations of the classical MPT-model but inferior to the unrestricted
model. To make the model more useful, accurate and easy to apply and robust, we programme the model using Visual
Basic for Applications (VBA). We therefore recommend that before applying investment models such as the MPT,
model modifications must be made so as to adapt them to particular investment environments. Moreover, to make them
useful so as to serve the intended purpose, the models should be programmed so as to make implementation less cumbersome.
Description
Keywords
Portfolio Optimisation, Uganda Securities Exchange (USE), Stocks, Modern Portfolio Theory (MPT), Markowitz, Portfolio diversification, Frontier, Efficient frontier
Citation
Mayanja, F., Mataramvura, S. and Charles, W.M., 2013. A Mathematical Approach to a Stocks Portfolio Selection: The Case of Uganda Securities Exchange (USE). Journal of Mathematical Finance, 3(04), p.487.