Banking stock price movement and macroeconomic indicators: K-means clustering approach

Zuhroh, Idah; Rofik, Mochamad; Abdelghani Echchabi Article Banking stock price movement and macroeconomic indicators: K-means clustering approach Cogent Business & Management Provided in Cooperation with: Taylor & Francis Group Suggested Citation: Zuhroh, Idah; Rofik, Mochamad; Abdelghani Echchabi (2021) : Banking stock price movement and macroeconomic indicators: K-means clustering approach, Cogent Business & Management, ISSN 2331-1975, Taylor & Francis, Abingdon, Vol. 8, Iss. 1, pp. 1-10, https://doi.org/10.1080/23311975.2021.1980247 This Version is available at: https://hdl.handle.net/10419/245134 Standard-Nutzungsbedingungen: Die Dokumente auf EconStor dürfen zu eigenen wissenschaftlichen Zwecken und zum Privatgebrauch gespeichert und kopiert werden. Sie dürfen die Dokumente nicht für öffentliche oder kommerzielle Zwecke vervielfältigen, öffentlich ausstellen, öffentlich zugänglich machen, vertreiben oder anderweitig nutzen. Sofern die Verfasser die Dokumente unter Open-Content-Lizenzen (insbesondere CC-Lizenzen) zur Verfügung gestellt haben sollten, gelten abweichend von diesen Nutzungsbedingungen die in der dort genannten Lizenz gewährten Nutzungsrechte. Terms of use: Documents in EconStor may be saved and copied for your personal and scholarly purposes. You are not to copy documents for public or commercial purposes, to exhibit the documents publicly, to make them publicly available on the internet, or to distribute or otherwise use the documents in public. If the documents have been made available under an Open Content Licence (especially Creative Commons Licences), you may exercise further usage rights as specified in the indicated licence. https://creativecommons.org/licenses/by/4.0/ Full Terms & Conditions of access and use can be found at https://www.tandfonline.com/action/journalInformation?journalCode=oabm20 Cogent Business & Management ISSN: (Print) (Online) Journal homepage: https://www.tandfonline.com/loi/oabm20 Banking stock price movement and macroeconomic indicators: k-means clustering approach Idah Zuhroh, Mochamad Rofik & Abdelghani Echchabi | To cite this article: Idah Zuhroh, Mochamad Rofik & Abdelghani Echchabi | (2021) Banking stock price movement and macroeconomic indicators: k-means clustering approach, Cogent Business & Management, 8:1, 1980247, DOI: 10.1080/23311975.2021.1980247 To link to this article: https://doi.org/10.1080/23311975.2021.1980247 © 2021 The Author(s). This open access article is distributed under a Creative Commons Attribution (CC-BY) 4.0 license. Published online: 02 Oct 2021. Submit your article to this journal Article views: 263 View related articles View Crossmark data BANKING & FINANCE | LETTER Banking stock price movement and macroeconomic indicators: k-means clustering approach Idah Zuhroh 1 *, Mochamad Rofik 2 and Abdelghani Echchabi 3 Abstract: This study investigates the price movement characteristics of banking issuers listed on the Indonesia Stock Exchange with macroeconomic indicators as an exogenous variable. By using the k-means clustering based on the monthly rate of return, banks are classified into three clusters, lower, middle, and upper clusters, with a cluster rank directly proportional to the average rate of return. Furthermore, each cluster formed is estimated using dynamic panel data regression with the generalized method of moment. This study shows that the price of banking issuers in the middle cluster is more reactive in dealing with interest rates and exchange rates. At the same time, the highest inflation coefficient exists in the upper cluster. The higher beta coefficient creates abnormal returns that allow for higher gains and line with the risk level. Meanwhile, the price effect in the previous period proved to be in line with the cluster level, indicating that higher clusters are more resilient. Therefore, referring to the possibility of abnormal returns and resilience to uncertainty, this study concludes that issuers in the middle cluster are more suitable for a short-term investment, while issuers in the upper cluster are for the long-term. Subjects: Economics; Finance; Investment & Securities Keywords: Banking stock price; macroeconomic; stock return; k-means clustering ABOUT THE AUTHOR Idah Zuhroh has research interests in finance, banking, and Islamic economics. Currently, Idah Zuhroh works at the Faculty of Economics and Business, Universitas Muhammadiyah Malang as an Associate Professor. Mochamad Rofik is a research fellow at the Center for Economics, Business and Entrepreneurship Development, Faculty of Economics and Business, Universitas Muhammadiyah Malang, with concern in Macroeconomics, Finance, and Labor Economics. Abdelghani Echchabi is Assistant Professor of Finance, Higher Colleges of Technology, Dubai Men’s Campus, United Arab Emirates. His research scope covers banking, finance, and financial technology. PUBLIC INTEREST STATEMENT This study performs clustering of banking issuers on the Indonesian Stock Exchange based on the monthly rate of return. Bank issuers are divided into three cluster levels directly proportional to their average monthly returns, namely lower, middle and upper. This finding definitely shows that the higher the cluster level tends to be more resilient in challenging economic shocks. Furthermore, this study shows that the price of bank issuers in the middle cluster is more reactive in responding to changes in the interest rate and exchange rate—meanwhile, the upper cluster dealing with the highest inflation variable. Higher coefficient of macroeconomic variables cause volatility and provide a chance for high returns in the short term; however, it tends to be vulnerable to economic shocks. Therefore, this study recommends that issuers in the middle cluster are more suitable for short-term investment and issuers in the upper cluster for the long term. Zuhroh et al., Cogent Business & Management (2021), 8: 1980247 https://doi.org/10.1080/23311975.2021.1980247 Page 1 of 10 Received: 27 January 2021 Accepted: 17 August 2021 *Corresponding author: Idah Zuhroh, Economics Department, Faculty of Economics and Business, Universitas Muhammadiyah Malang, Malang 65144, Indonesia E-mail: [email protected] Reviewing editor: David McMillan, University of Stirling, Stirling, UK Additional information is available at the end of the article © 2021 The Author(s). This open access article is distributed under a Creative Commons Attribution (CC-BY) 4.0 license. Subjects: E44; G00; G11; G12 1. Introduction Hardouvelis (1987) analyzed the response of financial stock prices on the New York Stock Exchange to macroeconomic information. Share prices respond sensitively to early monetary policy announcements. The result can implicitly state that the stock price reacts to the policies issued by the Central Bank. Similar research by Paul and Mallik (2003) took the object of financial and banking stocks on the Australian Stock Exchange for the period 1980–1999; this study found that banking and financial stocks are cointegrated with macroeconomic variables, particularly GDP, inflation, and interest rates. GDP responded positively by share prices; meanwhile, interest rates and inflation are responded negatively significant. Furthermore, Talla (2013) uses monthly data from 1993 to 2012 to look at the impact of macroeconomic variables on the Stockholm stock exchange. The Granger Causality test and the ordinary least square regression estimate findings demonstrate that interest rates and exchange rates affect share price; positive inflation and share price are insignificant. Also, in the Singapore stock market, a small open economy with controlled exchange rate targeting, the asymmetric asset-price movements, exchange rates, and stock prices are analyzed using a monetary approach. The exchange rates of the Singapore dollar to developed countries’ currencies are negatively linked to stock prices. In contrast, the relationship between the exchange rate of the Singapore dollar and the Malaysian ringgit and stock prices is positive instead (Wu, 2001). A lot of studies on the relationship between the macroeconomic and stock price movements have also been carried out in Indonesia. Utami et al. (2015), through panel data analysis, found that inflation and interest rates had a significant negative effect on stock returns in the construction subsector, while the exchange rate had a significant positive effect. Other studies also show that only the GDP has a significant effect on the stock price index of the plantation sector, and variables such as interest rates, inflation rates, and the Rupiah exchange rate against the Dollar do not have a significant effect on the stock price index of the plantation sector (Safitri & Kumar, 2014). Recent literature on the impact of macroeconomics on the stock market in Indonesia can also be tracked through research by Augustpaosa Nariman (2019), Bassar et al. (2021), Lusiana (2020), and Maharditya et al. (2018) However, specific studies on the relationship between macroeconomic variables and banking stocks in Indonesia are limited. One of the studies in the Indonesian banking issuers through the monthly price index for the period 2010–2015 show that inflation and exchange rates positively affect the stock price index while interest rates negatively affect it. Lower interest rates stimulate higher investment and better economic activity, which increases stock prices (Laduna & Sun’an, 2018). Meanwhile, the partial research on Indonesia’s banking share prices with large capitalization for the 2016–2018 period using the dynamic panel data regression found that gross domestic product and appreciation of the domestic currency against the US Dollar significantly positively affected the banking share price. At the same time, inflation has a negative effect (Zuhroh, 2020). Several previous studies that discuss the effect of macroeconomic variables in stock prices are generally separate from the discussion of firm characteristics. In addition, research on the firm characteristics generally uses classical approaches such as capitalization, transaction volume, and firm size (Diantimala et al., 2021; Lim & Hooy, 2011; Widiatmoko et al., 2020; Yang & Pangastuti, 2016). Therefore, this study specifically applies a clustering approach to understand the pattern of stock price movements in response to changes in macroeconomic indicators. Furthermore, this study will provide a new perspective that optimizing investment returns can also be done by understanding the issuer’s characteristics, especially through k-means clustering based on the monthly rate of return. In general, this study contributes as alternative literature on investment Zuhroh et al., Cogent Business & Management (2021), 8: 1980247 https://doi.org/10.1080/23311975.2021.1980247 Page 2 of 10 portfolio management, specifically for in the investment time frame base on macroeconomic indicators. In particular, this study also expands the literature on Indonesian banking stocks that are exceedingly lacking. The rest of this paper is organized in the following manner; Section 2 describes data, variable measurements, and research method; Section 3 presents results and a short discussion. Section 4 concludes the paper. 2. Data and methodology 2.1. Data Adapting empirical studies by Hardouvelis (1987), Laduna and Sun’an (2018), Paul and Mallik (2003), and Utami et al. (2015), and Wu (2001) and considering the availability of monthly data, this study takes four secondary data: a) monthly prices of 28 issuers listed on IDX in the 2016– 2019 period (sp); b) the central bank reference rate of the Republic of Indonesia for the period 2016–2019 (ir); c) the USD exchange rate against the rupiah by exchange rate in December 2015 as the baseline (er); d) the inflation rate (inf) measured by the consumer price index (CPI). The CPI is a weighted average of prices for a basket of goods and services, such as transportation, food, and medical care. It’s calculated by average price changes across all items in a predetermined basket of goods. Meanwhile, monthly banking stock’s rate of return calculated by Equation (1) while ri;t represent rate of return of banking share i in t month, spi;t is the share price of Banki, in t month. 2.2. k-means clustering Clustering is one of the most common unsupervised learning methods for exploratory data analysis to gain insight into the data structure. The role of identifying subgroups in the data can be described in such a way that the data points in the same subgroup (cluster) are very similar, whereas the data points are different in each cluster. In other words, we try to find homogeneous subgroups within the data such that data points are as close as possible in each cluster according to a similarity measure (Guojun et al., 2007). The research uses the k-means clustering method. Formally, assuming a set of observations, where each observation is a real vector with d-dimension, k-means clustering aims to divide observations into kclusters for every k�n where n is total data of observation. The set S¼ S1;S2;S3;...;Sk f g thus minimizing the within-cluster sum of square-like variants. The purpose of minimizing this variant can be stated in Equation (2) and equivalent to minimizing the paired square deviations of points in the same cluster (3). Also, the equivalence can be deduced from identity in Equation (4). Where μi is the mean of points inSi. When the total variance is constant, it is equivalent to maximizing the sum of the squared deviations between points in different clusters following the law of total variance (Guojun et al., 2007; Kriegel et al., 2017). In this study, we divided banking issuers into three clusters based on the average monthly rate of return. ri;t¼spi;tspi;t1 spi;t1 (1) arg min s∑ k i¼1 ∑ x2Si xμi2¼arg min s∑ k i¼1 Si j j Var Si(2) arg min s∑k i¼1 1 2Si j j∑x;y2Sixy2 (3) ∑ x2Si xμi2¼∑ x�y2SiðxμiÞμiyð Þ (4) Zuhroh et al., Cogent Business & Management (2021), 8: 1980247 https://doi.org/10.1080/23311975.2021.1980247 Page 3 of 10 2.3. Panel data regression Arellano & Bover (1995) and Blundell & Bond (1998) introduced the Generalized Method of Moment (GMM) as one of the dynamic panel data processes. This approach is superior to alternative panel data estimators (e.g., pooled ordinary least squares, fixed effects, and GMM differences). It solves econometric issues in lagged dependent variable models induced by unobserved group-specific effects and endogeneity of explanatory variables. Also, the GMM’s estimators proved consistent in parameter estimation and unbiased (Hasan & Gan, 2009). Technically, dynamic panel data through GMM also avoids the singularity matrix in the regression process because the explanatory data in this study do not completely panel in nature. Because of this limitation, this study also provides a robustness test to increase the validity and reliability of the regression results. The two-step GMM approach was chosen over the one-step procedure in this study cause, asymptotically, it looked to be more efficient (Blundell & Bond, 1998; Hasan & Gan, 2009). Furthermore, as Laporte and Windmeijer (2005) indicated, the strong standard error is derived using sample correction down to the two-step covariance matrix. This study applies Arellano–Bond AR(2) test to identify autocorrelation and to check the validity of overidentifying is a clear application of the J-statistic; the J-statistic would be zero if the equation outside suspect instruments is precisely defined and this study utilizes an appropriate probability lower than 0.1 (Benchimol, 2020). The baseline equation was thus set as follows equation (5) Where j represents of the cluster, irepresent the cross-section unit ofK, while t represents the time of the number of T and there are p independent variables onxi;t. By clustering and adjusting for each variable, we propose corresponding equations as follows equations (6). yj it ¼δyj i;t1þ∑ n i¼1 βj ixi;tþεj i;t(5) log spð Þj i;t¼δjlog spð Þj i;t1þβj 1log irð Þtþβj 2log erð Þtþβj 3log infð Þtþεj i;t(6) spj i;t is the share price of Bank i, in t period, in cluster j; irt is interest rate in t period; ert is domestic exchange rates converted in USD in t period; inft is an inflation in t period measured from the consumer price index; spj i;t1 is the share price of Bank i, in cluster j, in the previous period. δj;βj 1,βj 2, βj 3 are successive variable coefficients for banking share prices in the previous period, interest rate, exchange rates and inflation in j cluster; εj i;t is the error term or residual term indicates the error of the assessment. 2.4. Robustness test Robustness is an attribute of resilience that measures the behavior of the system under nonstandard conditions. Robustness is characterized as the degree to which a system operates correctly in exceptional inputs or stressful environmental conditions. Since it might also crash the system in the worst-case scenario to cause robustness faults, detecting this form of fault is of utmost importance (Micskei et al., 2012). The uncertainty about the expected effect size increase of the robustness test model’s baseline model obtains various point estimates and/or gets larger standard errors. Robustness tests will improve the validity of inferences either way. Robustness has been defined in various ways in the literature: a) as the same sign and meaning (Leamer); b) as the weighted average effect (Bayesian and Frequently Model Averaging); c) as stability of the effect (Neumayer & Plumper, 2017). This research assuming robustness as affecting stability and uses model variance tests to modify and replace model specifications with an alternative assumption. Specifically, change in the set of regressors through controlling variable is applied follows the combination rule. This rule can be modeled as well as formula (5) with the number of models as much as n n1 � �for each cluster, and finally, the Equation (7) is obtained. Zuhroh et al., Cogent Business & Management (2021), 8: 1980247 https://doi.org/10.1080/23311975.2021.1980247 Page 4 of 10 yj it ¼δyj i;t1þ∑ n1 i¼1 βj ixi;tþεj i;t(7) 3. Results and discussion The clustering results reveal that the lower, middle, and upper clusters, respectively, have a cluster center at 0.010, 0.014, and 0.178, as seen in Table 1 and directly proportional to the average return. Meanwhile, the highest return variance is in the middle cluster, followed by the lower cluster, and lastly, the upper cluster. Furthermore, the matrix correlation is presented in Table 2. Accordingly, no pairs of exogenous variables have a higher value of 0.5 so that the model built is free from multicollinearity (Gujarati, 2011). The dynamic panel data regression results show that the model in each cluster show a probability value greater than 0.05 for the Arellano-Bond AR (2) test. These results indicate that the model obtained is free from autocorrelation symptoms. Besides, the J-statistic value in each cluster also shows the probability value carried 0.1. The low probability of the J-statistic indicates that the model is free from overidentifying. Based on the AR (2) and J-statistic tests, the model obtained in each cluster is declared valid and reliable. 3.1. Interest rate Theoretically, lower interest rates are believed to be the trigger for growth. Consumers will spend more income so that consumption and production increase. Lower interest rates will allow the business to have a wide fiscal space of finance operations, acquisitions, and expansion at a cheaper cost, thereby increasing potential future income. Furthermore, the condition will encourage penetration of financing demand to banks and, in turn, lead to higher profit in the future. Conversely, when the Central Bank announces an increase in interest rates, both businesses and households will reduce spending, which leads to lower productivity and demand for financing. This condition is considered a negative sentiment by the market, which in turn pushes the share price. Table 3 shows the interest rate in each cluster has a negative and significant coefficient. Previous research conducted on banking issuers in Indonesia also showed the same result, an Table 1. Final cluster center Cluster (j) Total amount Cluster Member Center of Cluster (return) Varian return Max return Min return Average of return Lower (1) 9 BABP, BACA, BEKS, BKSW, BNBA, BNII, BVIC, INPC, MCOR 0.0104 0.015893 1.015 −0.490 0.0103 Middle (2) 11 BBKP, BJBR, BJTM, BMAS, BNGA, BNLI, BSIM, AGRO, NISP, NOBU, PNBN 0.0146 0.021141 1.187 −0.435 0.0146 Upper (3) 8 BBCA, BBNI, BBRI, BBTN, BDMN, BMRI, BTPN, MAYA 0.0178 0.008108 0.459 −0.476 0.0170 Zuhroh et al., Cogent Business & Management (2021), 8: 1980247 https://doi.org/10.1080/23311975.2021.1980247 Page 5 of 10 increase in interest rates negatively affected stock prices (Safitri & Kumar, 2014). In addition, Paul and Mallik (2003) also reveals that interest rates negatively affect banking and finance stock prices in the Australian stock exchange. This result brings solid consensus that increasing interest rates negatively affect banking stocks, especially in the Indonesian stock market. 3.2. Exchange rate In general, the results of data analysis can be concluded that the strengthening of the USD will increase the price of banking stocks in the middle-upper cluster (See Table 3). This is in line with Wu (2001), which show that the Singapore dollar’s weakening tends to be responded to positively by investors in the Singapore stock exchange. Meanwhile, investors in the lower clusters did not consider exchange rate movements to be valuable information. In contrast, research in Stockholm stock exchange shows that domestic currency depreciation has a significant negative effect on stock prices (Talla, 2013). The existence of clusters that do not respond significantly to the exchange rate also strengthens the argument, which states that Table 2. Correlation matrix Cluster (j) sp ir er inf Lower (1) sp 1 ir −0.127007969 1 er 0.028093053 −0.302102352 1 inf 0.026984798 −0.135922652 0.064883316 1 Middle (2) sp 1 ir −0.21825 1 er 0.034953 −0.3021 1 inf 0.10525 −0.13592 0.064883 1 Upper (3) sp 1 ir −0.03145 1 er 0.004909 −0.3021 1 inf 0.241222 −0.13592 0.064883 1 Table 3. GMM model’s estimation results Cluster (j) Variable Coefficient Prob AR(2) Prob J-stat Lower (1) log spt10.277760*** 0.0913 0.000 log ir −0.249568*** log er −0.220178 log inf −0.193627*** Middle (2) log spt10.381548*** 0.2919 0.000 log ir −0.49962*** log er −1.45192*** log inf 0.031915 Upper (3) log spt10.439511*** 0.7593 0.000 log ir −0.08181*** log er −0.80225*** log inf 0.73758* ***, **, * indicate significance at 1%, 5% and 10%, respectively. Zuhroh et al., Cogent Business & Management (2021), 8: 1980247 https://doi.org/10.1080/23311975.2021.1980247 Page 6 of 10 macroeconomic variables such as exchange rates are not very significant for the capital market for developing countries (Lim & Hooy, 2011; Wu, 2001). In terms of financing, when the local currency weakens, financing in foreign currency is certainly less attractive due to high-interest expenses and the cost of margin. Therefore, it is understandable that investors will tend to seek domestic financing. Likewise, if it is associated with global supply chains, when the local currency strengthens, producers can get a more competitive price for raw material through export, but this is not the case when the local currency weakens. There are many possibilities; one of them is looking for substitute local raw materials. The rotation of domestic businesses, in the end, provided local banks the opportunity to expand their financing. The increase in credit growth indicates increasing net profit, which is a positive sentiment for banking issuers. However, share prices’ negative response to the domestic currency’s strengthening may only occur under normal conditions when the depreciation in extreme pressure, the domestic currency’s weakening makes production costs more expensive due to high economic integration. It will ultimately affect the aggregate supply and demand. High production costs tend to reduce purchasing power; companies will eventually tighten their finances and delay expansion. This will put pressure on the market and investment climate, and the banking industry is no exception. By diversifying their assets through sales, stock market investors reacted to this signal, resulting in a decline in stock prices. Based on the 2016–2019 observation range can see that the strengthening of the USD against the rupiah still has a positive impact in a middle-upper cluster; this is a strong indication that during that period, the weakening and strengthening of the rupiah were still within normal limits. 3.3. Inflation Table 3 shows the inflation negatively impacts the lower cluster, insignificant in the middle cluster, and positive significance in the upper cluster. The lower cluster results are in line with Hsing et al. (2011) and Paul and Mallik (2003), which indicate that inflation hurts stock prices. When inflation increases, there is a possibility that the interest rate will also increase and cause demand for bonds to increase; a higher rate of inflation reduces the ability of the government or company to issue debt securities. Therefore, it is more attractive for the private sector to raise funds by selling equity than to issue debt securities; this condition results in increased availability of the stock supply. An increase in stock supply and demand for bonds will ultimately lower stock prices (Quayes & Jamal, 2008). On the other hand, a price increase is a positive signal for economic actors because it includes a profit incentive. A positive response from stock prices to inflation can also occur if the source of inflation is driven by stronger demand for the real sector; strengthening demand is a positive signal for economic growth, which an increase will follow in bank financing disbursements, so, naturally, rising inflation is considered a positive sentiment for investors in upper clusters. These findings in the upper cluster are in line with the finding by Talla (2013), which states that inflation positively affects stock prices in the Stockholm Stock Exchange. Recent research from India also shows that inflation positively correlates with stock prices (Giri & Joshi, 2017). The difference in the direction of the coefficients and the significance level indicates that banking investors in the Indonesian stock market still do not have a strong consensus. Therefore, investors need to understand the direction of inflation in drawing up the investment portfolio, especially in the banking issuers. 3.4. Cluster characteristics The highest coefficient for the interest rate and exchange rate variables is definitely in the middle cluster, while the inflation variable, in the upper cluster. These imply that banking issuers in the middle cluster are more reactive in responding to the interest rate and exchange rate; meanwhile, Zuhroh et al., Cogent Business & Management (2021), 8: 1980247 https://doi.org/10.1080/23311975.2021.1980247 Page 7 of 10