volatility is high, and the uncertainty is large.
Therefore, this portfolio is more suitable for risk-
averse investors, with lower investment risks and
stable returns.
3.3 Limitations and Prospects
The five-year data period used in this paper includes
the COVID-19 epidemic period. During this period,
there is a significant increase in the volatility of
different financial assets, and even anomalies such as
plummeting. The cryptocurrencies and futures in this
portfolio are less liquid, especially during times of
high market volatility or even liquidity depletion (Liu
& Tsyvinski, 2021). Therefore, extreme changes in
asset prices during an epidemic may affect the market
performance of the assets, while model results that
include this period may not be applicable to other
periods. The construction of portfolio in this paper is
based on the underlying mean-variance model, which
assumes that the expected returns of the assets follow
a normal distribution. However, new asset
cryptocurrencies are highly volatile in price, and the
distribution of returns does not always show a normal
distribution, but may be skewed and thick tailed, so
that a normal distribution tends to underestimate the
risks associated with extreme variations. (Klein et al.,
2018). Plus, the mean-variance model assumes that
the covariance matrix between assets is stable. In the
real market, covariances always change constantly,
especially during the epidemic period, so using a
simple covariance matrix to construct the portfolio is
not an accurate assessment of market performance. In
addition, the model building tool used in this paper is
Excel, not Python. large-scale data models are more
accurately and efficiently constructed in Python. And
the effective frontier graph which is showed does not
show in detail the changes in the Sharpe ratio of the
weights of the various assets, which is the limit of
Excel. As for the future research, it is a good attempt
to expand the data range to improve model accuracy
and explore the use of machine learning, artificial
intelligence, or tail risk management algorithms for
optimizing portfolios with new assets to address
market volatility.
4 CONCLUSIONS
To sum up, this study evaluates portfolio construction
using Markowitz's mean-variance theory, applying
two optimization objectives: maximizing the Sharpee
ratio and minimizing variance. The results indicate
that the portfolio optimized for maximizing the
Sharpee ratio can achieve the highest returns,
demonstrating its effectiveness in enhancing return
potential. In contrast, the minimum variance portfolio
provided greater stability, highlighting its advantage
in risk management. However, the study's limitations
include reliance on historical data and the omission of
new asset market impact, which may affect real-
world applicability. This research not only
demonstrates optimization methods for traditional
assets but also provides empirical support for
including new asset cryptocurrency in the portfolio. It
reveals how mean-variance theory can be applied to
diverse asset allocations to achieve higher risk-
adjusted returns, offering valuable insights for
investors navigating complex financial markets.
REFERENCES
Chen, J., Liu, Y., 2022. The Role of Cryptocurrencies in
Modern Portfolio Theory. Journal of Financial
Innovation, 9(3), 89-105.
Corbet, S., Meegan, A., Larkin, C., Lucey, B., Yarovaya, L.,
2018. Cryptocurrencies as a financial asset: A
systematic analysis. Journal of International Financial
Markets, Institutions & Money, 56, 1-22.
Fama, E. F., 1970. Efficient capital markets: A review of
theory and empirical work. Journal of Finance, 25*2,
383-417.
Fama, E. F., French, K. R., 1993. Common risk factors in
the returns on stocks and bonds. Journal of Financial
Economics, 33(1), 3-56.
Gorton, G., Rouwenhorst, K., 2021. Facts and Fantasies
about Commodity Futures. Financial Analysts Journal,
77(4), 40-54.
Guo, S., Lin, T., 2022. Big Data and Sentiment Analysis in
Portfolio Management. Financial Analysts Journal,
78(4), 102-118.
He, X., Liao, J., 2021. Machine learning for portfolio
optimization: An empirical study. Journal of Financial
Data Science, 3(1), 16-28.
Kahneman, D., Tversky, A., 1979. Prospect theory: An
analysis of decision under risk. Econometrica, 47(2),
263-292.
Klein, T., Thu, H. P., Walther, T., 2018. Bitcoin is not the
new gold – A comparison of volatility, correlation, and
portfolio performance. International Review of
Financial Analysis, 59, 105-116.
Liu, Y., Tsyvinski, A., 2021. Risks and returns of
cryptocurrency. The Review of Financial Studies, 113.
Markowitz, H. M., 1952. Portfolio selection. Journal of
Finance, 71, 77-91.
Sharpee, W. F., 1964. Capital asset prices: A theory of
market equilibrium under conditions of risk. Journal of
Finance, 19(3), 425-442.
Sullivan, R., Mackenzie, C., 2021. Sustainable Investing:
ESG Factors in Portfolio Construction. Global Finance
Journal, 50, 100-115.