A Comparative Study of the Markowitz and Index Models Under Various Constraints: An Empirical Analysis Based on 20 Years of Data for 21 Stocks
- DOI
- 10.2991/978-94-6239-672-2_15How to use a DOI?
- Keywords
- Portfolio Optimization; Markowitz Model; Index Model; Efficient Frontier; Risk-Return Trade-off
- Abstract
This paper examines portfolio optimization using both the Markowitz Model (MM) and the Index Model (IM), with a focus on the S&P 500 Index and 21 of its OEX constituent stocks over a 20-year sample period. Daily prices were converted into monthly returns, resulting in over 200 months of data. Using Excel Solver and SolverTable, we estimated expected returns, variances, and covariance matrices, and then applied quadratic optimization under multiple constraints. Specifically, we analyzed five cases: (1) Regulation T constraint, (2) box constraint, (3) no constraint, (4) no short-selling, and (5) exclusion of the index. The results highlight differences between MM, which captures full pairwise correlations among assets, and IM, which simplifies by linking returns to the market index. Empirical findings suggest that while unconstrained portfolios offer the highest potential returns, they produce extreme weights and higher risks. In contrast, IM portfolios demonstrate more stability and improved efficiency under conservative conditions, making them more suitable for investors with regulatory or practical limitations.
- Copyright
- © 2026 The Author(s)
- Open Access
- Open Access This chapter is licensed under the terms of the Creative Commons Attribution-NonCommercial 4.0 International License (http://creativecommons.org/licenses/by-nc/4.0/), which permits any noncommercial use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license and indicate if changes were made.
Cite this article
TY - CONF AU - Jianuo Li AU - Mingyue Tian AU - Yanxin Zhang AU - Yimin Nie PY - 2026 DA - 2026/05/12 TI - A Comparative Study of the Markowitz and Index Models Under Various Constraints: An Empirical Analysis Based on 20 Years of Data for 21 Stocks BT - Proceedings of the 2026 3rd International Conference on Applied Economics, Management Science and Social Development (AEMSS 2026) PB - Atlantis Press SP - 147 EP - 162 SN - 2352-5428 UR - https://doi.org/10.2991/978-94-6239-672-2_15 DO - 10.2991/978-94-6239-672-2_15 ID - Li2026 ER -