Premium
Tracking a benchmark index – using a spreadsheet‐based decision support system as the driver
Author(s) -
Wu LiangChuan,
Wu LiangHong
Publication year - 2013
Publication title -
expert systems
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.365
H-Index - 38
eISSN - 1468-0394
pISSN - 0266-4720
DOI - 10.1111/j.1468-0394.2012.00624.x
Subject(s) - computer science , index (typography) , variance (accounting) , benchmark (surveying) , decision support system , tracking error , stock market index , operations research , stock market , data mining , artificial intelligence , accounting , control (management) , business , paleontology , geodesy , horse , biology , world wide web , engineering , geography
This paper presents a two‐phase quantitative approach for enhanced index investing based on the mean‐variance model and the goal programming method. In the first stage, we use the mean‐variance theory to select better performing stocks for an investment pool. Then, in the second stage, we use a goal programming method to weight the selected stocks by balancing both the tracking error and the rate of return. In addition to the theoretical formulation, we construct a spreadsheet‐based decision support system (DSS) based on the transaction data to help resolve the index tracking problem. The paper contributes to the literature in two ways. For academics, we present original discussions on combining an interdisciplinary mean‐variance model and a goal programming method. Unlike the conventional approach used for enhanced index investing that requires a fund manager to actively buy and sell stocks to improve returns, our approach is based on historical data and deduces subjective judgments. Meanwhile, for practitioners, we present an original discussion on using a DSS to support index investing. The results of an empirical survey of the Taiwan stock market are also presented.