**Technology and Investment**

Vol.06 No.04(2015), Article ID:60876,10 pages

10.4236/ti.2015.64016

Portfolio Management: Stock Ranking by Multiple Attribute Decision Making Methods

Haresh V. Dedania^{1}, Vipul R. Shah^{2*}, Rajesh C. Sanghvi^{2}

^{1}Department of Mathematics, Sardar Patel University, Vallabh Vidyanagar, India

^{2}G H Patel College of Engineering & Technology, Vallabh Vidyanagar, India

Copyright © 2015 by authors and Scientific Research Publishing Inc.

This work is licensed under the Creative Commons Attribution International License (CC BY).

Received 13 August 2015; accepted 1 November 2015; published 4 November 2015

ABSTRACT

An investor would like to build a balanced portfolio with stocks representing different sectors. Several researchers have attempted the portfolio selection problem by different methods. Many of these methods consider companies of different sectors together. However, it can be argued that the attributes affecting the company’s growth vary for different sectors. Therefore, it is advisable to compare a company with the companies of the same sector. There are many options for the selection of a stock from a particular sector. A stock ranking method is proposed by using MADM methods based on overall performance under a stochastic environment. Of many MADM methods, SAW, AHP, TOPSIS, and VIKOR are applied. Usually, Euclidean distances (2-norm) are considered in the implementation of TOPSIS and VIKOR methods. In this work, this norm is generalized to p-norm, where p > 1. The model is tested for 13 companies in the field of Information Technology sector (IT) listed on National Stock Exchange in India and 13 criteria as performance indicators of a company. A MATLAB GUI system is developed and the results are obtained for several values of p in case of TOPSIS and VIKOR methods besides other methods. As the result indicates, the ordering is not much affected by different values of p in certain range. Moreover, higher values of p have adverse effect on the ordering. The proposed model is able to provide better information on the overall performance of a particular stock in comparison with its peers. The results obtained by various methods clearly separate good companies from inferior companies though the exact ordering slightly differs.

**Keywords:**

Ranking of Stocks, MADM methods, Financial ratios, p-TOPSIS Method, p-VIKOR Method

1. Introduction

Nowadays, due to the complexity and diversity involved in investments, the evaluation and ranking of companies is an important issue. It is necessary to promote a method for identifying efficient and superior firms. Ranking of stocks differentiates efficient companies from non-efficient ones. In order to optimize the return, effective selection process of stocks for portfolio investments is one of the most important decision making processes in competitive capital markets. Several researchers have investigated the problem with different perspectives.

Quah (2008) presented methodologies to select equities based on soft-computing models which focus on applying fundamental analysis for equities screening and compared the performance of three soft-computing models [1] . The methods used were multi-layer perceptions (MLP), adaptive neuro-fuzzy inference systems (ANFIS) and general growing and pruning radial basis function (GGAP-RBF).

Fatma Tiryaki and Beyza Ahlatcioglu (2009) used the fuzzy AHP for the portfolio selection problem [2] . The authors considered a hierarchy of factors with extrinsic, intrinsic and investor’s objectives at the top level. Extrinsic factors consist of economic, political and technological factors. Profitability, size and technology are the intrinsic factors. Profitability, security, excitement and control are generally the investor’s objectives. Naser Jamshidi and Mahmood Ramshini (2014) have made ranking of automotive and petrochemical companies by using combined approaches of FAHP-TOPSIS and FAHP-DEA method [3] . Hasan Dincer (2015) proposed a profit based stock selection model by Fuzzy AHP and MOORA (the Multi-Objective Optimization by Ratio Analysis) methods and applied it on banking stocks listed at Borsa, Istanbul Stock Exchange [4] . Majid Moradi and Hossein Janatifar (2014) have proposed a framework based on the Fuzzy Multiple Criteria Decision Making (FMCDM) approach for ranking firms of automobile companies listed in Tehran Stock Exchange by using financial ratios [5] . The approach relies on TOPSIS method.

Sevastjanov Pavel and Dymova Ludmila (2009) suggested a new method for stock screening with the use of multiple criteria decision making and optimization [6] . The method considers financial indices and market success of a firm. It selects the stocks with a great correlation between the two. However, the complexity can be reduced if stock price is also considered as one of the attributes with higher weight compared to other attributes. Kao-Yi Shen, Min-Ren Yan and Gwo-Hshiung Tzeng (2014) have proposed an MADM method for solving glamor stocks (value investing and growth stocks) selection problem based on fundamental analysis [7] . The method is a blending of VIKOR method and DANP (Decision Analytical Network Process).

Ricardo Giglio and Sergio Da Silva (2009) have proposed ranking of the stocks listed on Bovespa Stock Exchange according to their relative efficiency based on the algorithmic complexity theory [8] . It does not consider any of the financial ratios in ranking the stocks. Pinporn Maikaew and Patcharaporn Yanpirat (2012) have proposed a multiple criteria stock ranking model and tested it on the stocks listed at the Stock Exchange of Thailand (SET 100) by using TOPSIS method [9] .

The efficient portfolio can only be built when the stocks in the portfolio constitute a right mix. Therefore, selection of the best stock among the existing ones in the same industry becomes crucial. Accordingly, there is a need for a study to provide a mechanism for performance evaluation. This paper intends to develop a decision making method to assign ranks to the companies (alternatives) on the basis of several financial and non-financial (quantitative and qualitative) parameters (attributes) which affect the performance of the company. Owing to the regulator SEBI (Securities and Exchange Board of India) investors can access all the information and data of the listed companies. All the data considered in this paper is available at www.nseindia.com.

Three kinds of analyses, namely, technical analysis, bottom-up analysis, and social analysis help us understand where the company ranks among its peers. Stock price is a good indicator of a company’s financial health, if not driven by rumors or speculation. Speculation in the prices of a stock is measured by the value of beta. It is an indicator of a stock’s standard deviation, or volatility. For a technical analyst, this volatility is of worth as traders prefer stocks with high beta. But for investment purposes, fundamentals of a company, i.e. bottom-up and social analysis, should be taken into account. The present work deals with the selection of stocks for investment purpose. So, in this work, higher values of beta are discouraged by giving it smaller weightage. Basically, earnings drive stock prices. Several financial ratios, such as total income, net profit, operating profit margin, net profit margin, are useful to measure the earnings. Investors can compare these financial ratios of a company with those of other companies in the same sector. Dividends and bonus are the rewards by the companies to their shareholders for holding their stocks. Warren Buffett prefers to buy or sell a company’s stock based on its intrinsic value. Net worth and return on net worth are the indicators of the intrinsic value of a company. Promoter holding and FII + DII holding reflect the confidence of promoters and of high net worth investors respectively. Reliability is a qualitative attribute, to some extent, subjective also, in the selection process. It is based on the brand value of the products and/or services offered by the company as well as quality of the management. The effects of some of the attributes such as book value of a stock, earnings per share are reflected in the attributes, namely, net worth and net profit respectively. So, they need not to be considered separately as attributes.

The proposed method is validated by considering the data for 13 Indian IT companies for last five years [NSE]. The companies considered are TCS, HCL Tech, Wipro, Persistent Systems, Mphasis, Hexaware, Vakrangee, Infosys, KPIT Tech, Zensar Tech, NIIT Tech, Sonata Software, Mastek, in this order. The results obtained are matched with the general opinions of informed investors. As the fluctuations of currency affect every company of the IT sector and its effect will appear in net profit numbers, it is not considered as a separate attribute. The data used for promoter holding and FII + DII holding as well as bonus must be recent. However, the fluctuations in rest of the data are smoothed by taking average of five years of these data. Reliability is assigned a value in the scale of 1 to 9, the smaller the number, the lesser the reliability.

MADM is an approach employed to solve problems involving selection from among a finite number of alternatives. There are numerous applications of these methods in management science, economics, psychometrics, marketing research, applied statistics, decision theory, and many more to name a few. Of the many MADM methods, the following four commonly used methods are considered in this work.

1) Simple Additive Weight method (SAW);

2) Analytic Hierarchy Process method (AHP);

3) Technique for Order Preference by Similarity to Ideal Solution (TOPSIS);

4) Compromise Ranking method (or VIsekriterijumskoKOmpromisnoRangiranje―VIKOR).

In TOPSIS method, the distances are generalized as p-norms. In VIKOR method also, generally researchers fix the value of p as 1. In both these cases, several values of p are tested in the range [1, ∞] and their effects are examined. Critic method is used to find weight vector in TOPSIS method and eigenvalue method is used in AHP method. The GUI system developed incorporates all the above methods and assigns ranks to the companies as per the user’s choice of method.

To the best of our knowledge the present is the first report on employing MADM methods for ranking of Indian stocks.

2. MADM Methods

In 1947, a book “Theory of Games and Economic Bahavior” published by von Neumann and Morgenstern opened the door to Multiple Attribute Decision-making Methods (MADM) [10] . In 1957 it was Churchman, Ackoff and Arnoff who first treated a MADM for selecting business investment policy using simple additive weighting (SAW) method [11] . MADM methods are generally discrete, with a limited number of predetermined alternatives. An MADM method specifies how attribute information is to be processed in order to arrive at a choice. Each decision table (also called decision matrix) in MADM methods has four main parts, namely: 1) alternatives, 2) attributes, 3) weight or relative importance of each attribute, and 4) measures of performance of alternatives with respect to the attributes. The decision matrix is shown in Table 1.

2.1. The SAW Method

The Simple Additive Weighting (SAW) method is probably the best known and widely used method for MADM. Here each attribute is given a weight, and the sum of all weights must be equal to 1. Each alternative is assessed with regard to every attribute. The composite performance score which determines the ranking is given by

Table 1. decision matrix.

where is the normalized preferred ratings of the alternative with respect to the criterion, given by, for beneficial and for non-beneficial, for.

2.2. The AHP Method

The analytic hierarchy process (AHP) is a structured technique for organizing and analyzing complex decisions, based on mathematics and psychology. It was developed by Thomas L. Saaty in the 1970s [12] [13] . The method first compares the attributes pair wise by assigning intensity of importance in the scale of 1 (equal importance) to 9 (extreme importance). Denoting n elements to be compared as and the relative priority of with respect to by, a matrix of order n can be formed, called reciprocal matrix, where

The n elements need to be assigned a set of numerical weights which allows diverse elements to be compared to one another in a rational way. In the ideal case, the relation between weights

and is given by.

The matrix is called consistent if its elements are transitive i.e. for all i, j, k. For a reciprocal matrix,; with equality if and only if is consistent, where is the maximum ei-

genvalue of. The consistency index (CI) is the value. The random index (RI) is defined as the av-

erage CI calculated from a large number of randomly generated reciprocal matrices. The consistency ratio (CR)

of a reciprocal matrix is defined as by T. Satty in 1990. Usually, a CR of 0.1 or less is considered as

acceptable, and it reflects an informed judgment attributable to the knowledge of the analyst regarding the problem under study. J. Alonso and M. Lamata derived the equation where, as an alternative criterion to verify the condition by taking the average of 500000 randomly generated reciprocal matrices [14] .

2.3. p-TOPSIS Method

The Technique for Order of Preference by Similarity to Ideal Solution (TOPSIS) is a multi-criteria decision analysis method, which was originally developed by Hwang and Yoon in 1981 with further developments by Yoon in 1987, and Hwang, Lai and Liu in 1993 [15] [16] . The basic concept of this method is that the selected alternative should have the shortest distance from the ideal solution and the farthest distance from the negative- ideal (anti-ideal) solution in some geometrical sense.

As an illustration, Figure 1 shows five alternatives, A, B, C, D and E, with two criteria; it also shows the ideal and anti-ideal points. Obviously, in case of the usual Euclidean distance (p = 2) with equal weights, point C is the closest to the ideal and D is the longest. The method can be outlined as follows.

1) Let be the decision matrix and be its normalization.

2) Construct the weighted normalized decision matrix.

3) Determine ideal and negative-ideal solutions.

Let and

Figure 1. Ideal and anti-ideal points.

Determine the worst alternative and the best alternative as under:

4) The TOPSIS method evaluates the separation measures by considering l^{2}-norm. One of the contributions in this paper is to define generalized separation measures using l^{p}-norm with real
as distance metrics and study its effect on ranking.

(1)

(2)

Also, for, the separation measures with L_{¥}-norm is defined as

(3)

(4)

5) The relative closeness to the ideal solution, which will be used for the ranking of options, is calculated as in formula

(5)

Clearly,. Rank the alternatives according to the value of. In this paper, the method proposed is referred to as p-TOPSIS.

An attempt has also been made to modify this method by using weighted Euclidean distances, rather than creating a weighted decision matrix, referred to as modified TOPSIS method, by Deng et al. (2000) [17] . In this paper, all three methods, namely, TOPSIS, modified TOPSIS and p-TOPSIS, are implemented.

2.4. p-VIKOR Method

VIKOR method was developed for multicriteria optimization of complex systems. It was originally developed by Serafim Opricovic to solve decision problems with conflicting and non-commensurable (different units) criteria in his Ph.D. dissertation in 1979 [18] , and an application was published in 1980. The idea of compromise solution was introduced in MCDM by Po-Lung Yu in 1973 and by Milan Zeleny [19] [20] . Let and if the function is benefit and and if the function is cost. The compromise ranking algorithm VIKOR consists of the following steps:

1) The first step is to determine the objective, and to identify the pertinent evaluation attributes. Determine the best and worst values of all criterion functions,.

2) Compute the values and, by the relation

(6)

(7)

3) Compute the value by the relation

where. Here v is introduced as weight of the strategy of the majority of attributes. Usually, the value of v is taken as 0.5. However, it can take any value from 0 to 1.

4) Rank the alternatives. Sort the values of S, R and Q in decreasing order. The results are three ranking lists. The compromise ranking list for a given v is obtained by ranking with measures. The best alternative is the one with the minimum value of.

5) For given attribute weights, propose a compromise solution, alternative, which is the best ranked by measure Q, if the following two conditions are satisfied:

a) Acceptable advantage:, where is the second best alternative in the ranking by Q.

b) Acceptable stability in decision making: Alternative must also be the best ranked by S or/and R.

This compromise solution is stable within a decision making process, which could be: voting by majority rule (when is needed) or by consensus (when) or with veto (when).

Usually, researchers take the value of p as 1. In this paper, other values of p have also been tried.

2.5. Estimation of Weights

If the criteria are assigned weights as per the choice of decision maker, the subjectivity enters into the picture. This may result into misleading conclusions. One of the ways to remove this subjectivity is to assign data-de- pendent weights. In the present implementation, a method, called critic method, suggested by H. Kazan has been used in the TOPSIS method. Similarly, one of the several methods discussed for assigning objective weights, namely eigenvalue method, is used in AHP method by S. Gao [21] .

In critic method [22] , both standard deviation of the criterion and its correlation among other criteria are included in the weighting process. Let be the standard deviation of the criteria and be the correlation coefficient between the and criteria.

The weight of the criteria is obtained by

where is defined as

(8)

3. Results

The GUI software, incorporating some of the known methods and modifications suggested in this paper, makes it possible to select a small group of “good” stocks (and to reject a small group of “inferior” stocks) on the basis of different types of meaningful financial ratios considered. The results are presented in the following Table 2. Note that the results for only two values of p are displayed in the Table 2, but other values of p can also be tried for in case of p-TOPSIS and VIKOR method. Though the actual ordering of the better performing companies and inferior performing companies differ for different methods, it can be observed that they remain same with some exceptions. As an example, 2^{nd} company is selected by all the methods. Similarly, 6^{th} company is not selected by only one method, namely, AHP. 4^{th} company is selected as an exception by VIKOR method that can be neglected. Similar comments apply to the rejection of inferior companies. For example, 13^{th }and 5^{th} companies are declared as inferior companies by all the methods.

As far as effects of varying p are considered, the p-TOPSIS method exhibits the uniform ranking for p in the range [1] [16] , exhibiting stability of ranking over considerably large value of p. However, larger values of p results into absurdity. Similarly, VIKOR method also gives satisfactory result for p in [1] [2] only. To arrive at some general conclusion, further experimentation with other companies of different sectors may be performed. Of course, in that case, one may have to rethink about the attributes considered.

Selected screen shots as in Figures 2-4 show the actual execution process. The upper table titled “Company Information” contains the collected data which remains fixed. The column titles indicate the attributes. The attributes considered along with their abbreviations are: Total Income (TI), Net Profit (NP), Net Worth (NW), Return on Net worth (RON), Stock Price (SP), Promoter Holding (PH), FII + DII Holding (FII), Operating Profit Margin (OPM), Net Profit Margin (NPM), Dividend Payout Ratio (DPR). The user has to just select the

Table 2. Final ranking.

Figure 2. Ranking by p-TOPSIS method (p = 4.5).

Figure 3. Ranking by AHP method.

Figure 4. Ranking by p-VIKOR method (p = 2).

method among the methods listed in the table “Select the Method”. If the method requires the value of p, then a separate box will be displayed asking the user to enter the value. After this, when the user clicks the button “Decision Maker”, the results are displayed in the table titled “Output” and the four good and four inferior companies are displayed at proper place.

4. Conclusion

Collective performance assessment of n entities in the context of chosen n attributes is an important aspect in decision making in finance, engineering, social sciences, management, etc. There are several methods, called multiple attribute decision making methods, developed for this purpose. In the present note by replacing Euclidean norm by the p-norms, 1< p < ∞ in R^{n}, we have modified two of these methods: TOPSIS method and VIKOR method into p-TOPSIS and p-VIKOR methods respectively. We analyze performance of 13 companies of IT sector listed on Indian Stock Exchanges considering 13 financial and non-financial attributes using each of the MADM methods, namely, SAW, AHP, p-TOPSIS, p-VIKOR (with different values of p).

We concentrate on ranking of the first four best performing companies and the last four worst performing companies to assess stability of these methods for different values of p. It is found that for values of p in the interval [1] [16] , this ranking by and large remains the same in p-TOPSIS method. In p-VIKOR method, more or less same conclusion is obtained for values of p in the interval [1] [2] . This exhibits stability of these methods with respect to p. We have also considered comparative ranking of these companies with other MADM methods. By and large, comparison shows that the first four ranks (as well as last four ranks) are just the permutations of the same numbers.

As a way forward, other MADM methods such as ELECTRE, PROMETHEE, COPRAS will be tried for. Similarly, to delve into the ranking of entities of other asset classes is also an interesting idea. To devise a completely new method for the purpose may be considered as an excellent contribution to the theory of MADM methods.

Acknowledgements

The authors are thankful to Prof. S. J. Bhatt for suggesting p-TOPSIS method and for reading the manuscript. The work is supported by UGC-SAP-DRS-F.510/1/DRS-III/2015 (SAP), to the Department of Mathematics, S P University.

Cite this paper

Haresh V.Dedania,Vipul R.Shah,RajeshC. Sanghvi, (2015) Portfolio Management: Stock Ranking by Multiple Attribute Decision Making Methods. *Technology and Investment*,**06**,141-150. doi: 10.4236/ti.2015.64016

References

- 1. Quah, T.-S. (2008) DJIA Stock Selection Assisted by Neutral Network. Expert Systems with Applications, 35, 50-58.

http://dx.doi.org/10.1016/j.eswa.2007.06.039

http://www.sciencedirect.com/science/article/pii/S0957417407002096 - 2. Tiryaki, F. and Ahlatcioglu, B. (2009) Fuzzy Portfolio Selection Using Fuzzy Analytic Hierarchy Process. Information Sciences, 179, 53-69.

http://dx.doi.org/10.1016/j.ins.2008.07.023

http://www.cse.ust.hk/~leichen/courses/comp630p/collection/reference-7-6.pdf - 3. Jamshidi, N. and Ramshini, M. (2014) The Survey on Combined Approaches FAHP-TOPSIS and FAHP-DEA in Ranking and Efficiency Survey Accepted Companies in Tehran Stock Exchange. International Journal of Social Science and Management, 1, 27-36.

http://oaji.net/articles/2014/1022-1405876046.pdf - 4. Dincer, H. (2015) Profit-Based Selection Approach in Banking Sector Using Fuzzy AHP and MOORA Method. Global Business and Economics Research Journal, 4, 1-26.

journal.globejournal.org/index.php/GBERJ/article/download/173/116 - 5. Moradi, M., and Janatifar, H. (2014) Performance Evaluation of Automobile Companies Based on Multi-Criteria Decision Making Techniques. Global Journal of Management Studies and Researches, 1, 77-84. academicjournalscenter.org/index.php/GJMSR/article/download/.../pdf_8
- 6. Sevastjanov, P. and Dymova, L. (2009) Stock Screening with Use of Multiple Criteria Decision Making and Optimization. Omega, 37, 659-671.

http://www.sciencedirect.com/science/article/pii/S0305048308000467 - 7. Shen, K.-Y., Yan, M.-R. and Tzeng, G.-H. (2014) Combining VIKOR-DANP Model for Glamor Stock Selection and Stock Performance Improvement. Knowledge-Based Systems, 58, 86-97.

http://dx.doi.org/10.1016/j.knosys.2013.07.023

http://www.researchgate.net/publication/260315003_Combining_VIKOR-DANP_model_for_glamor_stock_selection_and_stock_performance_improvement

- 8. Giglio, R. and Da Silva, S. (2009) Ranking the Stocks Listed on Bovespa According to Their Relative Efficiency. Applied Mathematical Sciences, 43, 2133-2142.

http://www.m-hikari.com/ams/ams-password-2009/ams-password41-44-2009/dasilvaAMS41-44-2009.pdf - 9. Maikaew, P. and Yanpirat, P. (2012) Stochastic TOPSIS Employment in Stock Ranking for the Stock Exchange of Thailand. Proceedings of International Conference on Business and Management, Phuket, 6-7 September 2012, 57-72.
- 10. Tzeng, G. and Huang, J. (2011) Multiple Attribute Decision Making Methods and Applications. CRC Press, Taylor and Francis Group, A Chapman & Hall Book, Boca Raton.
- 11. Churchman, C., Ackoff, R. and Arnoff, E. (1957) Introduction to Operations Research. John Wiley and Sons Inc., New York.
- 12. Saaty, T. (1980) The Analytic Hierarchy Process. McGraw-Hill, New York.
- 13. Saaty, T. (1990) How to Make a Decision: The Analytic Hierarchy Process. European Journal of Operational Research, 48, 9-26.

http://dx.doi.org/10.1016/0377-2217(90)90057-I

https://www.ida.liu.se/~TDDD06/literature/saaty.pdf - 14. Alonso, J. and Lamata, M. (2006) Consistency in the Analytic Hierarchy Process: A New Approach. International Journal of Uncertainty, Fuzziness and Knowledge-Based Systems, 14, 445-459.

http://dx.doi.org/10.1142/S0218488506004114

http://www.researchgate.net/publication/220354940_Consistency_in_the_Analytic_Hierarchy_Process_a_New_Approach

- 15. Hwang, C.L. and Yoon, K. (1981) Multiple Attribute Decision Making: Methods and Applications. Springer-Verlag, New York.

http://dx.doi.org/10.1007/978-3-642-48318-9 - 16. Yoon, K. (1987) A Reconciliation among Discrete Compromise Situations. Journal of Operational Research Society, 38, 277-286.

http://dx.doi.org/10.1057/jors.1987.44 - 17. Deng, H., Yeh, C. and Willis, R. (2000) Inter-Company Comparison Using Modified TOPSIS with Objective Weights. Computers & Operations Research, 27, 963-973.

http://dx.doi.org/10.1016/S0305-0548(99)00069-6

http://www.sciencedirect.com/science/article/pii/S0305054899000696 - 18. Opricovic, S. (1998) Multicriteria Optimization of Civil Engineering Systems. PhD Thesis, Faculty of Civil Engineering, Belgrade, 302 p.
- 19. Yu, P. (1973) A Class of Solutions for Group Decision Problems. Management Science, 19, 936-946.

http://dx.doi.org/10.1287/mnsc.19.8.936 - 20. Zeleny, M. (1982) Multiple Criteria Decision Making. McGraw Hill, New York.
- 21. Gao, S., Zhang, Z. and Cao, C. (2009) New Methods of Estimating Weights in AHP. Proceedings of the International Symposium on Information Processing (ISIP 09), Jiaxing, 21-23 August 2009, 201-204.

http://academypublisher.com/proc/isip09/papers/isip09p201.pdf - 22. Kazan, H. and Ozdemir, O. (2014) Financial Performance Assessment of Large Scale Conglomerates via Topsis and Critic Methods. International Journal of Management and Sustainability, 3, 203-224.

http://www.pakinsight.com/pdf-files/ijms-3(4)-203-224.pdf

NOTES

^{*}Corresponding author.