Stock Selection Using Ward Clustering and Mean Absolute Deviation Portfolio Construction on the IDX Quality30 Index

Author's Information:

Fairuz Dwi Najla

Department of Statistics, Faculty of Science and Mathematics, Universitas Diponegoro, Semarang, Indonesia

Triastuti Wuryandari

Department of Statistics, Faculty of Science and Mathematics, Universitas Diponegoro, Semarang, Indonesia

Rahmila Dapa

Department of Statistics, Faculty of Science and Mathematics, Universitas Diponegoro, Semarang, Indonesia

Vol 02 No 06 (2025):Volume 02 Issue 06 June 2025

Page No.: 183-191

Abstract:

Investment in stocks offers high potential returns but also involves risks that need to be managed through diversification. This study aims to find the best stocks for constructing a Mean Absolute Deviation (MAD) portfolio by using Ward Clustering to select stocks from the IDX Quality30 index. The data includes stocks listed continuously from November 2023 to October 2024. Stocks were grouped based on financial ratios: Earnings Per Share, Price to Earnings Ratio, Debt to Equity Ratio, and Return on Equity. Ward Clustering was applied to create clusters with low internal variation by merging groups that minimize the increase in Sum of Squared Error. The Silhouette Coefficient was used to determine that five clusters were optimal. From each cluster, stocks with the highest positive expected return were chosen. The MAD model then calculated the best portfolio weights by minimizing risk measured by absolute deviation, with limits on minimum return and stock weights. The final portfolio contains four stocks: ADRO (30%), BBCA (30%), MIKA (10%), and UNTR (30%), while ACES was excluded due to its insignificant contribution to portfolio performance . The portfolio achieved an expected return of 0.00090 and risk of 0.01018. A Sharpe Ratio of 0.07224 indicates the portfolio outperforms risk-free investments, making it a suitable option for investors looking for a balanced risk-return portfolio within the IDX Quality30 index.

KeyWords:

IDX Quality30 Index, Ward Clustering, Mean Absolute Deviation Portfolio, Sharpe Index

References:

Adnyana, I. M. (2020). Manajemen investasi dan portofolio. Jakarta: Lembaga Penerbitan Universitas Nasional (LPU-UNAS).

Anugrahayu, M. R., & Azmi, U. (2023). Stock portfolio optimization using mean-variance and mean absolute deviation model based on K-medoids clustering by dynamic time warping. Jurnal Matematika, Statistika dan Komputasi, 20(1), 164–183.

Bower, B., & Wentz, P. (2005). Portfolio optimization: MAD vs. Markowitz. Rose-Hulman Undergraduate Mathematics Journal, 6(2), Article 3. https://scholar.rose-hulman.edu/rhumj/vol6/iss2/3

Gubu, L., Rosadi, D., & Abdurakhman. (2020). Robust mean-variance portfolio selection with Ward and complete linkage clustering algorithm. Economic Computation and Economic Cybernetics Studies and Research, 54(3), 111–127.

Hair, J. F., Jr., Black, W. C., Babin, B. J., & Anderson, R. E. (2019). Multivariate data analysis (8th ed.). Andover: Cengage Learning EMEA.

Hartono, J. (2022). Portofolio dan analisis investasi pendekatan modul (2nd ed.). Yogyakarta: ANDI.

Kaufman, L., & Rousseeuw, P. J. (1989). Finding groups in data: An introduction to cluster analysis. John Wiley & Sons, Inc.

Konno, H., & Yamazaki, H. (1991). Mean-absolute deviation portfolio optimization model and its applications to Tokyo stock market. Management Science, 37(5), 519–531. https://doi.org/10.1287/mnsc.37.5.519

Markowitz, H. M. (1952). Portfolio selection. The Journal of Finance, 7(1), 77–91. https://doi.org/10.2307/2975974

Maruddani, D. A. I. (2019). Value at risk untuk pengukuran risiko investasi saham: Aplikasi dengan program R. Ponorogo: WADE GROUP.

Mitran, S. (2019). Hierarchical clustering techniques. University of North Carolina. http://mitran-lab.amath.unc.edu/courses/MATH590/biblio/Clustering.ch7.HierarchicalClustering.pdf

Murtagh, F., & Legendre, P. (2014). Ward’s hierarchical agglomerative clustering method: Which algorithms implement Ward’s criterion? Journal of Classification, 31, 274–295. https://doi.org/10.1007/s00357-014-9161-z

Ratih, D., Prihatini, A. E., & Saryadi, S. (2013). Pengaruh EPS, PER, DER, ROE terhadap harga saham pada perusahaan sektor pertambangan yang terdaftar di Bursa Efek Indonesia (BEI) tahun 2010-2012. Jurnal Ilmu Administrasi Bisnis, 3(1), 83–94.

Tsay, R. S. (2005). Analysis of financial time series (2nd ed.). John Wiley & Sons, Inc.

Wirdasari, D. (2009). Metode Simpleks dalam Program Linier. Jurnal SAINTIKOM, 6(1), 276–285.