Prediction of Banking Sectors Financial Data of Dhaka Stock Exchange Using Autoregressive Integrated Moving Average (ARIMA) Approach

This paper investigates the predictability with the banking sector data of the Dhaka Stock Exchange (DSE) by using the Autoregressive Integrated Moving Average (ARIMA) process. Through different formal tests on the data set, the best-fitted model selected was ARIMA (0, 2, 1) for the data series. This study was select five banks from DSE such as Al-Arafah bank limited, EXIM bank limited, Islami bank limited, National bank limited, and one bank limited and use these data to train the model and checks the predictive power of the model. Only analyzed results of Al-Arafah bank limited are presented in this paper because the same results have been produced for other remaining companies. The obtained results show that all the companies closing stock prices are non-stationary. It is also found that the original value curve and the predicted value curve are very much identical. So, the fitted model is performed better. For the validity of the model, the root means squared error (RMSE), mean absolute error (MAE) and mean absolute percentage error (MAPE) were checked.


INTRODUCTION:
Stock prices and their volatility have been a hot issue; the stock market in an economy plays a vital rule in accessing its economic condition. The random walk is usually established in the developed country's stock markets (Kendall, 1953;Granger & Morgenstern, 1963;Solnik, 1973). Stock market forecasters focus on developing a successful approach for close prices. The frugality and the stock market are interrelated as claimed by Moffatt (2010). Ultimate aiming to earn a high profit using well-defined trading strategies. The cardinal conception to successful stock market prediction is achieving the best results also lessen the inaccurate prognosis of the close price. Among the two stock exchanges of Bangladesh, DSE was the first and began trading in 1976 with a paid-up capital of Tk. 0.138 billion and market capitalization of Tk. 0.147 billion which was 0.138% of the GDP (Bepari and Mollik, 2008).
According to Wayne A. Fuller (1995), the stock market forecast is important for both the timing of stock investment and the relative investment desirability among the various sectors in the market. Many people observe the stock market to assess the performance of the economy and it is a common presumption that if the share market is declining, the economy is also about to decline (Moffatt, 2010).
On the other hand, the condition of the economy also affects investments and this is based on the idea that changes in the economy have a significant effect on interest rates and inflation, which in turn have a direct influence on the stock and bond markets (Faerber, 2000). The financial sector is a vital part of our economy because it plays an important role in intermediating savings of the private and public sectors to productive activities including investment. During the economic downturn, the earnings of the average companies decline to result in the stock market index to fall (Duca, 2007). The banking sector has evolved to become the dominant financial intermediary in Bangladeshi financial system due to the underdeveloped money and capital markets, limited availability of financial instruments, and lack of confidence in the financial system as a whole (Chu et al., 2011).
In analyzing closing price index data, the series should be identically and independently distributed with zero mean and constant variance (Akgiray, 1989). Bangladesh has a stock market, with its known difficulties. Most of the Asian stock markets except few have experienced a rapid growth in gross national product through contributing to a significant rise in savings and, hence, in the supply of lendable funds (Chiang and Doong, 2012). A couple of studies have been found to deal with prediction of stock prices in several countries including Bangladesh (Sohail et al., 2012;Kumar, 2006;and Al-Zeaud, 2011). But no such study has been performed yet that prediction of closing stock prices in DSE. Hence, this research context was chosen. This study will start with a general overview of the current composition of the monetary system in Bangladesh in terms of the share market as well as the close price of five banking sectors of DSE.

MATERIAL AND METHODS:
This study considers daily stock exchange data (general index) for building time series modeling and forecast (Dickey and Fuller, 1979). To fulfill this purpose we collect data from the databank of the Dhaka Stock Exchange website. The data series is from January 01, 2013, to January 30, 2015, and the length is 499 realizations. The objective of this study is to fit a model for forecasting the closing stock price of the banking sector of DSE by the ARIMA process (Peter and Davis, 2020). The methods used in this research for producing prediction based on trend and stationary of the DSE closing price index dataset. Box-Jenkins (ARIMA) approach is used to pick the piloted model and used to predict the DSE index series. The Box Jenkins procedure has been applied to the dataset using "STATA 13".

ARIMA Process
A very popular process in econometric time series is the ARIMA process. Time series models are based on the assumption that it is stationary. But many of the econometric time series are non-stationary that are integrated. If a time sequence is integrated of order one i.e. (1), its first difference is (0), i.e. stationary. Similarly, if a time series is (2), its second difference is (0). In general, if a time orders are ( ), then after differencing it times we get an (0) series. Therefore, if we take difference a time orders d times and then apply the ( , ) model to it, then the time series model is ( , , ) where is the number of autoregressive terms, the number of time orders has to difference and q the number of moving average terms. The (1, 1, 1) process can be written as, are the first difference between .

RESULTS AND DISCUSSION:
This study collects data on the closing price index from the Dhaka Stock Exchange, Bangladesh from January 01, 2013, to January 30, 2015, and the interval is 499 realizations. This study divided the sample into two parts such as the first 450 and last 49 samples for training and test sample, respectively to permit a more efficient model. The most popular programming software R and STATA used to whole analysis according to the objective of the present research.
This study use ARIMA model in time series forecasting and collects the daily closing price of some selected bank of DSE such as Al-Arafah Islami bank limited, EXIM bank limited, Islami bank limited, National bank limited and One bank limited. Only analyzed results of Al-Arafah Islami Bank Limited are presented in this paper because the same results have been produced for other remaining banks.
A visual plot of the observation is usually the first step in any time series analysis. Therefore the series is stationary after taking the second difference. It has displayed from Table 1 the calculated measure of the test statistic in the absolute term is larger than the critical value in an absolute term at a 1% level of the significance, at a 10% level of the significance and 5% level of significance. So, the study decides that the data is stationary for these three cases.
This study recognizes the sample autocorrelation functions of this non-stationary time series data is declined very slowly as shown in Fig 3, ACFs at all lags are individually statistically significantly different from zero i.e. for they all are outside of the 95% confidence bounds except the first four lags, the PACF drops dramatically all PACFs except this three lags are statistically insignificant. Since this time series is non-stationary, after integrating it move to stationary.
The ACF and PACF suggest that the model is between (0, 2, 3). After combining the different model between the (0, 2, 3) model this study will get an appropriate model. Table 2 suggests the appropriate model forecast for the closing price index of Al-Arafah Islami Bank Limited. According to minimum AIC (Akaike Information Criteria), the appropriate model is (0, 2, 1).
The actual, forecast and average values for the outsample are presented as Fig 4 and indicates the difference between actual and forecast values are very small. Also, the original value curve and the predicted value curve are very much identical. Therefore, the chosen model is acceptable. From Table 3 it is evident that all the value for root means a square error, mean absolute error, mean absolute percent error and MSD are smaller for out-sample forecast than in-sample forecast.
Therefore, the chosen model is adequate. Also from Fig 5, it is evident that the residual plot follows IID (0,1) which indicates our fitted model is best. So the fitted model is acceptable. Policymakers or investors should use this model for better prediction of the share prices of the banking sector of DSE.

CONCLUSION:
The closing price index of the stock market is a very important index for the analysis and predicting investment. The index of Dhaka Stock Market over the time January 01, 2013, to 01 January 2015 with sample size is 499 were used in this study. The modeling and predictions of the closing stock price index were done by the ARIMA process (Islam et al., 2020). Care of different diagnostic testing, the best-fitted model for the closing price of DSE (from January 01, 2013, to January 30, 2015) was found to be (0, 2, 1). Based on the models, Prediction can be done for the index. This study use ARIMA model in time series forecasting and collects the daily closing price of some selected bank of DSE such as Al-Arafah Islami bank limited, EXIM bank limited, Islami bank limited, National bank limited and One bank limited. The study shows that the predicted value curve is identical to the actual value curve. Therefore the ARIMA model predicts the actual value very well. This result will provide an informative guideline for the researchers and policymakers. As the diagnostic tests (lower RMSE, low MAE, low MAPE and low MSD) also suggest a good fit of the model, it can be concluded that the predictions are reliable and they can help to figure out the future market condition and minimize the risk of investment in the banking sectors.