An Empirical Study of the Markowitz Mean-Variance Model and the CAPM Model in the Stock Market

This paper focuses on the practical application of Markowitz's mean-variance model and Capital Asset Pricing Model (CAPM) in the stock market.Stock data was obtained using the Tushare interface, data preprocessing and visualization were performed by using Python.Multiple stocks from the Shanghai and Shenzhen markets were analyzed using the mean-variance model, and an efficient frontier chart was created.Through empirical research, the optimal investment portfolio with the highest Sharpe ratio and lowest variance was identified, and their expected returns and volatility were compared.Finally, the CAPM model was fitted using the least square methods to evaluate the returns and volatility of individual stocks in relation to the market.Besides, the Fama-French three-factor model, which is a developmental model based on CAPM, was also used for the analysis.This study provides valuable investment strategy references for investors.It addresses the concerns of investors regarding the evaluation of portfolio returns and risks, achieving optimal asset allocation.Furthermore, it deepens the understanding of the significance of Markowitz's mean-variance model and the CAPM model in financial risk management.