Decision Support System for Mongolian Portfolio Selection

Enkhtuul Bukhsuren , Uyanga Sambuu , Oyun-Erdene Namsrai , Batnasan Namsrai and Keun Ho Ryu

Abstract

Abstract: Investors aim to increase their profitability by investing in the stock market. An adroit strategy for minimizing related risk lies through diversifying portfolio operationalization. In this paper, we propose a six-step stocks portfolio selection model. This model is based on data mining clustering techniques that reflect the ensuing impact of the political, economic, legal, and corporate governance in Mongolia. As a dataset, we have selected stock exchange trading price, financial statements, and operational reports of top-20 highly capitalized stocks that were traded at the Mongolian Stock Exchange from 2013 to 2017. In order to cluster the stock returns and risks, we have used k-means clustering techniques. We have combined both k-means clustering with Markowitz's portfolio theory to create an optimal and efficient portfolio. We constructed an efficient frontier, creating 15 portfolios, and computed the weight of stocks in each portfolio. From these portfolio options, the investor is given a choice to choose any one option.

Keywords: Data Mining , Decision Support System , K-Means Clustering

1. Introduction

The rapidly increasing volume, velocity, variety, and complexity of data are due to the dynamic development of information technology and IoT devices, such as the day-in-day-out operational growth of all sectors, including research institutions, businesses, trade, and industry. It is becoming increasingly challenging to use traditional data analysis techniques to accurately and efficiently process large amounts of data that are being generated in each sector today. Traditional data analysis methods that rely heavily on workforce can no longer effectively process, analyze extensive data, and help take decisions [1,2]. Data mining, artificial intelligence, and cloud computing technology [3-5] are gradually becoming the key techniques for analyzing large amounts of data.

Since the dawn of human history, financial markets have played a crucial role in economic and social activities of organizations [6,7]. Financial activities play central role in the current economic development of many countries worldwide, and they contribute to the growth of the world economy. Financial markets depend on many factors [8]. Researchers working in such areas as data mining, finance, and mathematics have in the past essentially focused on investing in financial markets. Accordingly, some data mining algorithms have been proposed to support investors in different financial markets [9]. Financial markets are risky and sensitive, and so it is critical to base your long-term investment decisions on research. It is becoming increasingly challenging in dealing with complex financial data using statistical methods only. Which is why, researchers use data mining methods and machine learning methods to process complex financial data [10].

The banking sector accounts for 95% of the financial market in Mongolia. Although companies can use long-term financing from the stock market at a lower rate than the lending from the banks, companies in Mongolia derive the majority of their investments from high-interest bank loans given the development status-quo of this market. Owing to the weak stock market development, long-term, low-cost financing channels to support real economic growth are limited, economic growth is inaccessible, and asset valuation is underdeveloped. As a result, there is insufficient capital circulation in the economy, foreign investment in non-mining sectors is relatively low, and foreign exchange inflows are small. The World Bank publishes an annual Competitiveness Index report for 137 countries. In this report, Mongolia was ranked at 82 in terms of public decision-making, 123 in corporate ethics, 128 in audit and reporting standards, 132 in board efficiency, 131 in protection of small shareholders' rights, 6.8 in terms of investor protection (maximum score of 10), 114 in consumer awareness and information, and 131 in securities trading regulation as of 2017–2018. These indicators bear evidence to the dearth of corporate governance, corporate ethics, board efficiency-related information in Mongolia, which are needed by the investors. Moreover, majority of the stocks of listed companies are held by a few shareholders. As a result, corporate governance is underdeveloped, and investors are reluctant to invest in the company.

We do not have enough systematic software or decision support systems to process information on listed and stock companies, provide investors with valuable and accurate information through qualitative and technical analysis, and assist them in their investment decisions. Therefore, it is imperative to develop an integrated approach to diversify stock market products, process large stock market data, and augment decision-making systems for stock portfolio selection methodology.

Markowitz's model offers solution based on the correlation of stock. Our proposed method is much more accurate than the existing methodologies; we have used data mining techniques to support decision-makers. Investors can select a portfolio based on stocks. We evaluated the financial, corporate gov¬ernance, and bankruptcy indicators to identify the stock ranking applying the TOPSIS method of the multicriteria decision-making method.

2. Related Work

Global stock exchange development trends have changed owing to global economic crisis and other negative factors. Until the 1980s, stock trading was traditional, and thereafter electronic commerce made strong headway with the progressive improvement of computer technology. With the advent of computer systems, data were stored in databases, and large amounts of data were generated. The concept of "big data" emerged in the1990s and research by scientists is focused on how this large amount of data can be processed efficiently to meet human needs and also help people make informed decisions.

Hsu [11] implemented a hybrid of self-organizing map (SOM) and genetic programming to predict stock prices on the Taiwan Stock Exchange and artificial neural network for stock market prediction [12- 14] was likewise applied. Nanda et al. [15] used k-means, SOM, and fuzzy C-means to cluster stocks listed on the Bombay Stock Exchange (BSE). Using genetic algorithm (GA), a study of Oh et al. [16] in 2015 suggests a portfolio optimization scheme for index fund management. Topaloglou et al. [17] worked on a dynamic stochastic programming model for global portfolio management. Ghosh and Mahanti [18] studied mathematical and econometric models used in 63 research papers and studies were conducted between 2009 and 2014 under securities portfolio management. More than 30 algorithms were used in these works, with mathematical modelling algorithms accounting for almost 24% of the research. Sharp ratios were used in the most, constitution 39.68%, to measure portfolio performance.

Recent financial theories have also shown that it is important to consider investor behavior in portfolio selection. Researchers have proposed a financial risk indicator system based on similarity measurement and item clustering. They constructed a financial risk model [19] on the clustering algorithm to classify and optimize financial risks [20,21]. In the past decade, data mining and machine learning algorithms have been used to analyze financial activities [22-25]. Recent financial theories have also revealed the quintessence of considering investor behavior in portfolio selection.

3. Proposed Methodology

Based on the comparative analysis of optimal risky portfolio selection research papers, and by taking into consideration Mongolia's political, economic, legal, and corporate governance indicators, we have developed the following six-step methodology.

The overall structure of the Decision Support System (DDS) developed for stock portfolio selection in the Mongolian Stock Exchange is shown in Fig. 1.

Fig. 1.
The process of the DSS.

The steps and stages in the decision support system are as follows:

STEP-1. Data collection, cleaning, and portfolio creation

STEP-2. Stock clustering

STEP-3. Stock ranking

STEP-4. Stock weighting

STEP-5. Portfolio ranking

STEP-6. Selection of optimal portfolio

The main steps of our proposed methodology are described in detail as follows.

3.1 STEP-1. Data Collection, Cleaning, and Portfolio Creation

We have selected records from stock exchange information, financial statements, and activity report information of top-20 highly capitalized stocks traded at the Mongolian Stock Exchange from 2013 to 2017. Following which, we refined the data for further analysis, and some records were duplicated and regenerated for preprocessing. On the whole, 16,018 records were used in our experiment. Furthermore, we manually selected the required information from the company's financial statements and corporate governance reports and used around 100 data records with 15 indicators.

3.2 STEP-2. Stock Clustering

Numerous researches have revealed that k-means are appropriate for investors to make investment decisions based on stock returns and risks. Proceeding from this premise, we clustered the stocks according to their return and risk, using the k-means clustering analysis [26].

Algorithm basic k-means algorithm

1. Select k points as initial centroids.

2. repeat

3. Form k clusters by assigning each point to its closest centroid.

4. Recompute the centroid of each cluster

5. until centroids do not change.

3.3 STEP-3. Stock Ranking

We calculated financial, corporate governance, and bankruptcy indicators to identify the stock ranking. We identified the stock rankings by the TOPSIS method of multicriteria decision-making method.

Company Financial Indicators: One of the most critical factors that investors must consider before investing in a company's stock is the company's financial performance. A company's financial statements show the company's financial position over time, future profits and dividends, and they contain the right information needed to assess the company's prospects. As a result of our research, the following financial ratios are considered in determining the ranking of stocks: return on equity (ROE), return on assets (ROA), earnings per share (EPS), price-earnings ratio (P/E ratio), and Debt ratio.

Financial ratios that affect a company's bankruptcy: Private and corporate investors take investment decisions by forecasting the company's financial difficulties and bankruptcy. In other words, it is essential for a company to trade before the stock price falls and to predict changes in the value of stocks and additional stocks in the portfolio. Tsolmon [27] developed a bankruptcy prediction model and identified four independent variables that significantly impact on company's bankruptcy. These include: interest and pre-tax profit/total assets or EBITDA, equity/total assets or ETA, liabilities/equity or LE, logarithm of total assets or LOGTA.

Corporate governance and its indicators: In Mongolia, there is no clear understanding of what corporate governance means, but in our research, we have selected essential factors in corporate governance by considering the following: the size of the board, independent board of directors, institutional shareholder(s), audit committee, percentage of shareholders (more than 5%) and firm size, which means that there are no more devices to be discovered in the partition. Go to the next partition.

The weight of the criteria influencing decision-making is highly dependent on the subjective judgment of the decision-maker. The emotional weight of the indicators consists of the decision-makers' experience, knowledge, and understanding of the issue. For this reason, a variety of subjective weighting methods have been developed. The results of these methods are not reliable, however. The critical method, which does not have an emotional nature, was proposed by Diakoulaki et al. [28]. The technique uses a standard deviation of the criteria and a correlation between the indicators.

Hwang and Yoon [29] developed the technique for order preference by similarity to ideal solution (after this TOPSIS) based on choosing a decision option close to the positive solution of the criterion and far from the negative ideal solution.

The stocks were prioritized based on the TOPSIS method of the multicriteria decision-making method. TOPSIS sketches are as follows:

Step 1. Develop a decision matrix and the standard decision matrix (R);

Step 2. Calculate the weighted (R) matrix;

Step 3. Determine the best and the worst solutions;

Step 4. Compute the distance of each alternative from the positive ideal solution and the distance of each alternative from the negative ideal solution; and,

Step 5. Calculate the similarity to the worst condition.

3.4 STEP-4. Stock Weighting

Markowitz [30,31] developed the portfolio selection theory in uncertain conditions, identified the difference between risks of particular assets and portfolios in the math equation, and proved that the risk of a portfolio depends on the covariance of assets in that portfolio. The Markowitz model suggests maximizing expected return and minimizing the portfolio's risk for risk and return.

The key formula for maximization of the expected rate of return of the portfolio is:

(1)
[TeX:] $$E\left(R_p\right)=\sum_{i=1}^n \omega_i E\left(R_i\right)$$

where [TeX:] $$\omega_i$$ must satisfy the following constraint.

(2)
[TeX:] $$\left\{\begin{array}{c} \operatorname{var}\left(R_p\right)=\sum_{i=1}^n \omega_i^2 \operatorname{var}\left(R_i\right)+\sum_{i=1}^n \sum_{\substack{j=1 \\ i \neq j}}^n \omega_i \omega_j \operatorname{cov}\left(R_i, R_j\right) \leq \sigma_p^2 \\ \omega_1+\omega_2+\cdots+\omega_n=1 \\ \omega_i \geq 0 \end{array}\right.$$

where [TeX:] $$\omega_i-i$$ is the weight of an asset in the portfolio, [TeX:] $$E\left(R_i\right)-i$$ is the expected return of asset in the portfolio, and [TeX:] $$\operatorname{cov}\left(R_i, R_j\right)$$ is the covariance between asset i and j.

3.5 STEP-5. Portfolio Ranking

The portfolio's ranking considers the weight of the stock in the portfolio, its return and risk, the portfolio beta, the Sharpe ratio, and the Treynor ratio.

A web-based decision support system automatically helps to by-pass the creation of an optimal risky portfolio. The software module shows the ranked portfolio to the user.

3.6 STEP-6. Selection of Optimal Portfolio

We resolved the risk minimization problem at the desired return level and established a threshold for the stock return curve. An investor can select any one of the appropriate portfolios in accordance with their sentiment, decide on how to handle portfolio management, and react to market conditions.

4. Experimental Results

We developed a web-based decision support system called “Decision support system for stock investment” using PHP. We wrote 650 lines of code with a total of nine modules. As a database manage¬ment system, we used MySQL. Our database contains nine tables with 16,018 records.

According to industry classification, we have classified the Mongolian Stock Exchange listed companies into five sectors: production, construction and transportation, mining, agriculture, trade and services, and 14 sub-sectors.

Fig. 2 shows the system settings window with the following tabs: sector, sub-sectors, companies, financial indicators, and market index. Each tab is available to update, delete, insert, and select operations. We calculated the financial ratio from the company's financial statements, and governance indicators are taken from the company's operational report. The system allows users to manually enter, import, and enter data into a database.

Fig. 2.
System settings window.

Results of stock ranking processing using the TOPSIS method of multivariate decision-making

The stability of a joint-stock company and its sound financial performance are indicators of a company's suitable governance mechanism. The weight of the factors influencing the stocks' ranking was calculated using the critical method.

The weight decision-making indicators for each sector are shown in Table 1. Of course, the most significant ratio for decision-making is the P/E ratio. Financial and governance indicators for 2013–2017 are considered for each sector. The stock was ranked by the TOPSIS method. The following results were obtained for the companies ranking based on each sector's 2013–2017 financial and governance indicators of each sector.

Table 2 shows the following information: based on the 2017 financial ratios and governance indicators, Arig Gal JSC was ranked highest among production companies. Hermes JSC was ranked highest among construction companies, Baganuur JSC was highest among mining companies, and BDSec JSC was highest among the trade and service companies.

Clustering by the k-means method

An investor creating a portfolio by the highest rank stocks of that clustering is the most accurate decision-making. Based on companies' historical stock trading data with the top-20 listed companies from January 1, 2013, to December 31, 2017, we have created six clusters using the k-means method by considering the expected return on a stock and expected average risk.

Fig. 3 shows a screenshot of K-means clustering. The cluster includes stocks of companies with similar financial characteristics. The number of clusters created by the investor should be less than the number of companies registered in the web system. The stocks are placed in one cluster in a descending order. The optimal portfolio can be created by selecting one stock from each cluster of investors. The system allows investors to create the most optimal portfolio by selecting one stock from each cluster according to their sentiment.

Table 1.
Weight of decision-making indicators for each sector in 2016–2017
Table 2.
Stock ranking calculated by the TOPSIS method
Fig. 3.
Clustering by the k-means method.

Markowitz's basic model calculates a portfolio's expected average return and risk when the investor chooses the same weight of stocks to be included in the portfolio. The highest-ranked stocks will appear at the beginning of the clustering, for example, from Cluster 2 BDSec and Baganuur from Cluster 4 Makhimpex, Cluster 5 Darkhan Nekhii, and Cluster 6 APU.

The following results were obtained by calculating the expected average return and risk of a portfolio with the same weight or 20% of the stocks in the portfolio using the Markowitz model:

Expected return: - 0.00015

Expected risk: 0.00043

At a next step, we solved stock return maximization for these five stocks at the risk level of 0.00043 to estimate the optimal stock weights of each stock, as shown in Fig. 4.

Fig. 4.
Weights of stocks in optimal portfolio k-means clustering.

Table 3 shows the expected average return, risk, and weight of shares in a portfolio's efficiency margin curve.

An investor can select the appropriate portfolio in accordance with his/her sentiment, decide on portfolio management behavior and react to market conditions.

Table 3.
Portfolio options offered by the system

5. Conclusion

In our study, we proposed a six-step decision support system for an optimal portfolio of stocks suitable in the conditions of Mongolia. This model is based on data mining clustering techniques that reflect the impact of political, economic, legal, and corporate governance in Mongolia. We have developed a web-based decision support information system for financial intermediaries and investors, which offers optimal risky portfolio options.

As a dataset, we have selected stock exchange information, financial statements, and activity report information of top-20 highly capitalized stocks traded at the Mongolian Stock Exchange from 2013 to 2017. Based on the stuides conducted, 15 financial and non-financial indicators were identified that have the most significant impact on the ranking of Mongolian joint-stock companies. The weight of decision-making factors is calculated using a critical method, which is advantageous as it allows the individual to avoid subjective judgments. K-means clustering method is used to cluster stock returns and risks. The stock weight within the optimal portfolio and portfolio return and risks were estimated using the Markowitz method. In addition to offering investors a portfolio of stocks issued by the system, investors can choose a portfolio that suits their behavior. The system is crucial because it allows investors to build the most profitable portfolio according to their economic situation, behavior, and risk tolerance. With the support of the system that we have developed, investors will make non-intuitive decisions based on factual information and calculations.

As a result of the research, we have come to the conclusion that the creation of a portfolio by clustering the stocks is the most efficient method yet.

In the future, we plan to conduct research into the following: (1) Discover association rules on stock sales by applying the association analysis method; (2) Predict stock selection based on investor's behavior; (3) Identify the association between investors' decisions and joint-stock company information posted on social networks; and (4) Predict future stock prices from historical trading data.

Acknowledgement

The research has received funding from the National University of Mongolia (Grant No. P2019-3739).

Biography

Enkhtuul Bukhsuren
https://orcid.org/0000-0002-2961-997X

She received a B.Sc. degree in computer science from the School of Mathematics and Computer Science, National University of Mongolia, in 2001. She obtained here Ph.D. in Business Administration from the University of Finance & Economics, Mongolia, in 2018. She is currently an associate professor in the Department of Information and Computer Sciences, School of Engineering and Applied Sciences, National University of Mongolia. Her research interests include Databases, Data Mining.

Biography

Uyanga Sambuu
https://orcid.org/0000-0003-0867-6948

She is a Professor at the National University of Mongolia. She holds a bachelor’s and master’s degree in Computer Science from the Novosibirsk State Technical University, Russia, and a Ph.D. in Education and Information Technology from the National University of Mongolia. She conducted her post-doctoral research at the University of Minho in Portugal, Korea University, Republic of Korea, and the International Institute for Software Technology of the United Nations University (UNU/IIST), Macau.

Biography

Oyun-Erdene Namsrai
https://orcid.org/0000-0001-6895-6904

She received her Ph.D. from Chungbuk National University, Cheongju, South Korea, in 2008. She is currently working as a professor at the Department of Information and Computer Science, School of Engineering and Applied Sciences, National University of Mongolia. Her research interests include temporal databases, data mining, data warehousing, advanced algorithm issues, and advanced database applications. She has also worked on the BIT project of the Chungbuk National University of Korea from the National Research Foundation of Korea (NRF), funded by the Ministry of Science, ICT Future Planning as a researcher/software developer.

Biography

Batnasan Namsrai
https://orcid.org/0000-0001-9431-506X

He is a Professor at the Business School, National University of Mongolia. Prior to joining his present position, he served as the Dean of Business School at the National University of Mongolia from 2013 to 2016. Between 2012 and 2013, he was the Aca-demic Secretary of the Academic Council, National University of Mongolia. Professor Batnasan serves as a Member of the Economic Advisory Council, Government of Mongolia. He has also been a Member of the Economic Advisory Council, Govern-ment of Mongolia (2016-2016) and Member of the Customs Tariff Council, Govern-ment of Mongolia (2015-2016), and an ex-officio adviser to the Parliamentary Standing Committee (2011-2012) and Cabinet Minister (2018-2020). He also served as a Member of the Advisory Council, CAREC Institute (2017-2020) and worked as an Adviser and Consultant to various international organizations, including UNICEF and UNDP. He holds an MA degree in international economics and received his Ph.D. in Business Administration from the National University of Mongolia in 2000. From 2007 to 2008, Batnasan held a post-doctoral fellowship at the Department of Economics, Sogang University, South Korea.

Biography

Keun Ho Ryu
https://orcid.org/0000-0003-0394-9054

He is a professor Emeritus, Endowed Chair Researcher, and Director of Database and Bioinformatics Laboratory at Chungbuk National University, and a professor and Director of Data Science Laboratory at Ton Duc Thang University, and also a visiting professor at Chiang Mai University. He was also the Vice President of the Personalized Tumor Engineering Research Center. He received his Ph.D. in Computer Science/ Engineering from Yonsei University, Korea, in 1988. He was a captain in the Korean Army for four years as ROTC. He worked at the University of Arizona a post-doc and a research scientist in the USA. He has also worked as a senior researcher at Electronics Telecommunications Research Institute in Korea. He has served in numerous program committees including demonstration co-chair of the VLDB, panel and tutorial co-chair of the APWeb, general co-chair of the FITAT/ISPM. He has published more than 1,000 referred technical articles in various journals, international conferences, and books. His research interests include temporal databases, spatiotemporal databases, temporal GIS, ubiquitous computing and stream data processing, knowledge-base information retrieval, database security, data mining, bioinformatics, and biomedical science. He is a member of the IEEE as well as a member of the ACM since 1983.

References

  • 1 H. V . Jagadish, J. Gehrke, A. Labrinidis, Y . Papakonstantinou, J. M. Patel, R. Ramakrishnan, and C. Shahabi, "Big data and its technical challenges," Communications of the ACM, vol. 57, no. 7, pp. 86-94, 2014.doi:[[[10.1145/2611567]]]
  • 2 A. Oussous, F. Z. Benjelloun, A. A. Lahcen, and S. Belfkih, "Big data technologies: a survey," Journal of King Saud University-Computer and Information Sciences, vol. 30, no. 4, pp. 431-448, 2018.doi:[[[10.1016/j.jksuci.2017.06.001]]]
  • 3 I. Lee, "Big data: dimensions, evolution, impacts, and challenges," Business Horizons, vol. 60, no. 3, pp. 293303, 2017.doi:[[[10.1016/j.bushor.2017.01.004]]]
  • 4 W. Liu, J. Zhao, and D. Wang, "Data mining for energy systems: review and prospect," Wiley Interdisciplinary Reviews: Data Mining and Knowledge Discovery, vol. 11, no. 4, article no. e1406, 2021. https://doi.org/10.1002/widm.1406doi:[[[10.1002/widm.1406]]]
  • 5 K. P . Sinaga and M. S. Yang, "Unsupervised K-means clustering algorithm," IEEE Access, vol. 8, pp. 8071680727, 2020.doi:[[[10.1109/access.2020.2988796]]]
  • 6 D. Fields, "Constructing a new asset class: property-led financial accumulation after the crisis," Economic Geography, vol. 94, no. 2, pp. 118-140, 2018.doi:[[[10.1080/00130095.2017.1397492]]]
  • 7 D. Daugaard, "Emerging new themes in environmental, social and governance investing: a systematic literature review," Accounting & Finance, vol. 60, no. 2, pp. 1501-1530, 2020.doi:[[[10.1111/acfi.12479]]]
  • 8 B. Braun, "Central banking and the infrastructural power of finance: the case of ECB support for repo and securitization markets," Socio-economic Review, vol. 18, no. 2, pp. 395-418, 2020.doi:[[[10.1093/ser/mwy008]]]
  • 9 S. Carta, A. Ferreira, A. S. Podda, D. R. Recupero, and A. Sanna, "Multi-DQN: an ensemble of deep Qlearning agents for stock market forecasting," Expert Systems with Applications, vol. 164, article no. 113820, 2021. https://doi.org/10.1016/j.eswa.2020.113820doi:[[[10.1016/j.eswa..113820]]]
  • 10 S. Roychowdhury, N. Shroff, and R. S. V erdi, "The effects of financial reporting and disclosure on corporate investment: a review," Journal of Accounting and Economics, vol. 68, no. 2-3, article no. 101246, 2019. https://doi.org/10.1016/j.jacceco.2019.101246doi:[[[10.1016/j.jacceco..101246]]]
  • 11 C. M. Hsu, "A hybrid procedure for stock price prediction by integrating self-organizing map and genetic programming," Expert Systems with Applications, vol. 38, no. 11, pp. 14026-14036, 2011.doi:[[[10.1016/j.eswa.2011.04.210]]]
  • 12 K. Kohara, T. Ishikawa, Y . Fukuhara, and Y . Nakamura, "Stock price prediction using prior knowledge and neural networks," Intelligent Systems in Accounting, Finance & Management, vol. 6, no. 1, pp. 11-22, 1997.doi:[[[10.1002/(sici)1099-1174(199703)6:1<11::aid-isaf115>3.0.co;2-3]]]
  • 13 Y . Yoon and G. Swales, "Predicting stock price performance: a neural network approach," in Proceedings of the 24th Annual Hawaii International Conference on System Sciences, Kauai, HI, 1991, pp. 156-162.doi:[[[10.1109/hicss.1991.184055]]]
  • 14 Y . Zhang and L. Wu, "Stock market prediction of S&P 500 via combination of improved BCO approach and BP neural network," Expert Systems with Applications, vol. 36, no. 5, pp. 8849-8854, 2009.custom:[[[-]]]
  • 15 S. R. Nanda, B. Mahanty, and M. K. Tiwari, "Clustering Indian stock market data for portfolio management," Expert Systems with Applications, vol. 37, no. 12, pp. 8793-8798, 2010.doi:[[[10.1016/j.eswa.2010.06.026]]]
  • 16 K. J. Oh, T. Y . Kim, and S. Min, "Using genetic algorithm to support portfolio optimization for index fund management," Expert Systems with Applications, vol. 28, no. 2, pp. 371-379, 2005.doi:[[[10.1016/j.eswa.2004.10.014]]]
  • 17 N. Topaloglou, H. Vladimirou, and S. A. Zenios, "A dynamic stochastic programming model for international portfolio management," European Journal of Operational Research, vol. 185, no. 3, pp. 1501-1524, 2008.doi:[[[10.1016/j.ejor.2005.07.035]]]
  • 18 A. Ghosh and A. Mahanti, "Investment portfolio management: a review from 2009 to 2014," in Proceedings of 10th Global Business and Social Science Research Conference, Beijing, China, 2014.custom:[[[-]]]
  • 19 Z. Zhu and N. Liu, "Early warning of financial risk based on k-means clustering algorithm," Complexity, vol. 2021, article no. 5571683, 2021. https://doi.org/10.1155/2021/5571683doi:[[[10.1155//5571683]]]
  • 20 L. Li, J. Wang, and X. Li, "Efficiency analysis of machine learning intelligent investment based on K-means algorithm," IEEE Access, vol. 8, pp. 147463-147470, 2020.doi:[[[10.1109/ACCESS.2020.3011366]]]
  • 21 W. Dai, "Development and supervision of robo-advisors under digital financial inclusion in complex systems," Complexity, vol. 2021, article no. 6666089, 2021. https://doi.org/10.1155/2021/6666089doi:[[[10.1155//6666089]]]
  • 22 S. Sankhwar, D. Gupta, K. C. Ramya, S. Sheeba Rani, K. Shankar, and S. K. Lakshmanaprabu, "Improved grey wolf optimization-based feature subset selection with fuzzy neural classifier for financial crisis prediction," Soft Computing, vol. 24, no. 1, pp. 101-110, 2020.doi:[[[10.1007/s00500-019-04323-6]]]
  • 23 S. Guo, H. He, and X. Huang, "A multi-stage self-adaptive classifier ensemble model with application in credit scoring," IEEE Access, vol. 7, pp. 78549-78559, 2019.doi:[[[10.1109/access.2019.2922676]]]
  • 24 R. Rosati, L. Romeo, C. A. Goday, T. Menga, and E. Frontoni, "Machine learning in capital markets: decision support system for outcome analysis," IEEE Access, vol. 8, pp. 109080-109091, 2020.doi:[[[10.1109/access.2020.3001455]]]
  • 25 D. Fengqian and L. Chao, "An adaptive financial trading system using deep reinforcement learning with candlestick decomposing features," IEEE Access, vol. 8, pp. 63666-63678, 2020.doi:[[[10.1109/access.2020.2982662]]]
  • 26 P . N. Tan, M. Steinbach, and V . Kumar, Introduction to Data Mining. Boston, MA: Pearson, 2005.doi:[[[10.1017/9781108231954.004]]]
  • 27 S. Tsolmon, "Bankruptcy prediction model and methodological issues," Ph.D. dissertation, National University of Mongolia, UB City, Mongolia, 2016.custom:[[[-]]]
  • 28 D. Diakoulaki, G. Mavrotas, and L. Papayannakis, "Determining objective weights in multiple criteria problems: the critic method," Computers & Operations Research, vol. 22, no. 7, pp. 763-770, 1995.doi:[[[10.1016/0305-0548(94)00059-h]]]
  • 29 C. L. Hwang and K. Yoon, Multiple Attribute Decision Making. Heidelberg, Germany: Springer, 1981.doi:[[[10.4135/9781412985161]]]
  • 30 H. Markowitz, "Portfolio Selection," Journal of Finance, vol. 7, no. 1, pp. 77-91, 1952.custom:[[[-]]]
  • 31 H. Markowitz, Portfolio Selection: Efficient Diversification of Investments. London, UK: Yale University Press, 1959.doi:[[[10.2307/3006625]]]

Table 1.

Weight of decision-making indicators for each sector in 2016–2017
Indicator Production sector Mining sector Trade and service sector
2016 2017 2016 2017 2016 2017
ROA 0.00092 0.00032 0.01085 0.01232 0.00004 0.00002
ROE 0.00293 0.00088 0.01919 0.0197 0.00015 0.00011
P/E 0.73074 0.85507 0.43549 0.61025 0.99094 0.98984
D/Equity 0.00528 0.01094 0.01275 0.05078 0.00031 0.00033
LOGTA 0.01743 0.00305 0.04456 0.01096 0.00031 0.00031
EBITDA 0.00107 0.00038 0.01360 0.0166 0.00004 0.00002
ETA 0.00498 0.00263 0.02934 0.02209 0.00024 0.00023
LE 0.02960 0.01718 0.19225 0.04056 0.00165 0.00217
BS 0.03863 0.02061 0.04387 0.04878 0.00091 0.00102
IS 0.02645 0.01414 0.03329 0.03694 0.00078 0.00083
OS 0.01330 0.00696 0.08927 0.07706 0.00094 0.00103
Audit 0.01067 0.00460 0.02484 0.02056 0.00028 0.00026
T5 0.00184 0.00092 0.00167 0.00174 0.00007 0.00007
Life 0.11617 0.06232 0.04903 0.05223 0.00334 0.00374

Table 2.

Stock ranking calculated by the TOPSIS method
2013 2014 2015 2016 2017
CV Rank CV Rank CV Rank CV Rank CV Rank
Production sector
Arig gal 0.102 4 0.587 2 0.395 7 0.753 3 0.986 1
APU 0.225 2 0.112 8 0.798 2 0.891 2 0.784 4
Govi 0.092 6 0.418 6 0.477 5 0.167 7 0.705 7
Darkhan Nekhii 0.091 7 0.495 4 0.548 4 0.223 5 0.767 6
Makhimpex 0.088 8 0.904 1 0.558 3 0.184 6 0.788 3
Remicon 0.990 1 0.124 7 0.321 8 0.101 8 0.678 8
Suu 0.106 3 0.509 3 0.981 1 0.976 1 0.813 2
Talkh-Chikher 0.092 5 0.466 5 0.463 6 0.254 4 0.768 5
Khukh Gan 0.012 9 0.105 9 0.031 9 0.037 9 0.010 9
Construction and transportation sector
Hermes centre 1 1 1 1 1
Mining sector
Aduunchuluun 0.258 2 0.877 1 0.299 2 0.484 2 0.488 2
Baganuur 0.012 4 0.379 2 0.155 3 0.685 1 0.841 1
Tavantolgoi 0.182 3 0.189 4 0.989 1 0.392 3 0.090 4
Sharyn Gol 0.982 1 0.202 3 0.040 4 0.287 4 0.287 3
Trade and service sector
Bayangol Hotel 0.468 3 0.107 4 0.339 4 0.008 4 0.001 6
BDSec 0.903 1 0.004 6 0.994 1 0.998 1 0.997 1
Genco Tour Bureau 0.032 6 0.586 2 0.398 3 0.004 5 0.009 3
Materialimpex 0.369 4 0.089 5 0.002 6 0.009 3 0.006 5
Telecom Mongolia 0.814 2 0.165 3 0.322 5 0.091 2 0.585 2
Ulsyn Ikh Delguur 0.169 5 0.995 1 0.433 2 0.002 6 0.009 4

CV-calculated value.

Table 3.

Portfolio options offered by the system
Expected return Expected risk BDSec (%) Makhimpex (%) Darkhan Nekhii (%) APU (%) Baganuur (%)
min -0.00015 0.00043 25.10 29.53 12.32 15.59 17.47
1 -0.00011 0.00040 23.94 30.05 14.15 14.52 17.34
2 -0.00006 0.00039 22.79 30.57 15.99 13.45 17.21
3 -0.00001 0.00039 21.63 31.09 17.82 12.38 17.08
4 0.00004 0.00039 20.47 31.61 19.66 11.31 16.95
5 0.00009 0.00039 19.31 32.13 21.50 10.24 16.82
6 0.00014 0.00039 18.15 32.65 23.33 9.17 16.69
7 0.00019 0.00040 17.00 33.17 25.17 8.11 16.56
8 0.00024 0.00040 15.84 33.69 27.00 7.04 16.43
9 0.00029 0.00041 14.68 34.21 28.84 5.97 16.30
10 0.00034 0.00042 13.52 34.73 30.67 4.90 16.17
11 0.00039 0.00043 12.37 35.25 32.51 3.83 16.04
12 0.00044 0.00046 11.21 35.77 34.35 2.76 15.91
13 0.00049 0.00048 10.05 36.29 36.18 1.69 15.78
14 0.00054 0.00050 8.89 36.81 38.02 0.63 15.65
The process of the DSS.
System settings window.
Clustering by the k-means method.
Weights of stocks in optimal portfolio k-means clustering.