首页 | 本学科首页   官方微博 | 高级检索  
     


Tracking a benchmark index – using a spreadsheet‐based decision support system as the driver
Authors:Liang‐Chuan Wu  Liang‐Hong Wu
Affiliation:1. Institute of Technology Management, National Chung Hsing University, , Taichung, Taiwan, R.O.C.;2. Department of Business Administration, National Central University, , Chung‐Li, Taiwan, R.O.C.
Abstract: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.
Keywords:decision support system  enhanced index investing  goal programming  information ratio
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号