Advances in Economics, Management and Political Sciences
- The Open Access Proceedings Series for Conferences
Series Vol. 53 , 01 December 2023
* Author to whom correspondence should be addressed.
This article is mainly about finding the most efficient portfolio for some chosen stocks in the S&P 500. It is an application of portfolio management. The article introduced data collection and processing for 10 important S&P 500 companies’ stock data. These companies are chosen as representatives of different industries. The data processing will give sufficient material for the following calculation, such as the covariance matrix for those stocks, average return, monthly return, etc. Markowitz’s model is a model for portfolio optimization. Using this model to first minimize the standard deviation, in other words, the risk, and then, the most efficient portfolio weighting for those companies can be chosen. Solver in Excel is also used based on previous data to test the accuracy of the result calculated based on the model. Then, the article introduces possible errors during the calculation and corresponding reflection and improvement.
portfolio management, stocks, Markowitz’s model
1. Wang Lei, Bao Xinzhong. Research on patent portfolio value assessment based on fuzzy hierarchical analysis and real option method[J]. China Invention and Patent, 2022, 19(8):10.
2. Yuenan Wang, Amalia Di Iorio, The cross section of expected stock returns in the Chinese A-share market, Global Finance Journal, Volume 17, Issue 3, 2007, Pages 335-349, ISSN 1044-0283.
3. Hua, R., & Chen, B. International linkages of the Chinese futures markets[J]. Applied Financial Economics, 2007, 17(16), 1275-1287.
4. Cassimon D , Engelen P J , Thomassen L ,et al. The valuation of a NDA using a 6-fold compound option[J].Research Policy, 2004, 33(1):41-51.DOI:10.1016 /s0048-7333(03)00089-1.
5. Zhu B. A comparative study of gains and losses of European-style portfolio options[J]. Enterprise Economics, 2006(7):3. DOI:10.3969/j.issn.1006-5024.2006.07.031.
6. Y. Xu. Portfolio option pricing with information influence based on fractional Brownian motion[J]. Practice and Understanding of Mathematics, 2014(19):6. DOI:CNKI:SUN:SSJS.0.2014-19-021.
7. TANG Mingkun, FENG Zhenhua, ZHAO Zhenyu. Research on option portfolio arbitrage under Bayesian game framework; Theoretical model and market data validation[J]. Southern Economy, 2023(4):79-97.
8. Whaley, R. E. Valuation of American futures options: Theory and empirical tests[J]. The Journal of Finance, 1986, 41(1), 127-150.
9. Thomassen L , Van W M .The n-fold compound option[J]. martine van wouwe, 2001.DOI:http://dx.doi.org/.
10. Zhao P , Wang T , Xiang K ,et al. N-Fold Compound Option Fuzzy Pricing Based on the Fractional Brownian Motion[J]. Systems, 2022.DOI:10.1007/s40815-022-01283-2.
The datasets used and/or analyzed during the current study will be available from the authors upon reasonable request.
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Authors who publish this series agree to the following terms:
1. Authors retain copyright and grant the series right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this series.
2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the series's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this series.
3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See Open Access Instruction).