Comparison of the Accuracy of Brown's and Holt's Double Exponential Smoothing in LQ45 Stock Price Forecasting

Raden Gunawan Santosa; Antonius Rachmat Chrismanto; Willy Sudiarto Raharjo

doi:10.58776/ijitcsa.v2i1.112

Authors

Raden Gunawan Santosa Prodi Informatika, Universitas Kristen Duta Wacana Yogyakarta, Indonesia
Antonius Rachmat Chrismanto Universitas Kristen Duta Wacana
Willy Sudiarto Raharjo Prodi Informatika, Universitas Kristen Duta Wacana Yogyakarta, Indonesia

DOI:

https://doi.org/10.58776/ijitcsa.v2i1.112

Keywords:

double exponential smoothing, holt's method, brown's method, LQ45 stock forecasting

Abstract

As of May 2022, 787 stocks are listed on the Indonesia Stock Exchange (IDX), and the number of stock indices in Indonesia to date is 38. One interesting and important stock index is the LQ45 index. Because this index is a very important reference index for investors, this research data focuses on stocks in the LQ45 index. There are two essential things in the forecasting process: the data and the right forecasting method. Two forecasting methods that can be used are Brown and Holt's Double Exponential Smoothing (DES). This study examines two methods with the lowest accuracy error in forecasting the LQ45 stock price data. Mean Absolute Percentage Error (MAPE) is used to measure the accuracy of the error. The analysis methods used to compare the MAPE of the two methods are the F test for variance similarity, Boxplot, t-test to test paired means with different cases of variance, and Wilcoxon signed rank test to test paired means nonparametric statistics. The result is that the MAPE average with Holt's DES method is smaller than the average MAPE with Brown's DES method. This is supported by the t-test for paired means with different cases of variance and also supported by the Wilcoxon signed exact rank test. Meanwhile, the MAPE standard deviation with Holt's DES method is smaller than the MAPE standard deviation with Brown's DES method. This is supported by the F test to test the variance similarity and is visually supported by a Boxplot diagram. From this study, LQ45 stocks with the smallest MAPE value accuracy are ICBP stocks. In general, based on the MAPE value, Holt's DES method is better than Brown's DES method in predicting the prices of stocks in the LQ45 index.

References

Dahlan A. A. et al, 1996, Ensiklopedia Hukum Islam, Cetakan pertama, Jakarta: PT Ichtiar Baru Van Hoeve.

Brealey A. R., Myers C.and Alan J. M., 2007, Fundamentals of Coorporate Finance 5th ed, McGraw-Hill.

Permata C. P. and Ghoni M. A. , 2009, Peranan Pasar Modal dalam Perekonomian Negara Indonesia, Jurnal AkunStie 5 (2), pp. 56-58 .

Aden and Supriyanti A. , 2020, Prediksi Jumlah Calon Peserta Didik Baru Menggunakan Metode Double Exponential Smoothing dari Brown (Study Kasus : SD Islam Al-Musyarrofah Jakarta), Jurnal Lebesgue : Jurnal Ilmiah Pendidikan Matematika, Matematika dan Statistika Volume 1, No. 1, April, 2020, pp. 56-62.

Ferdiansyah T., Zainal R. F. and Arizal A., 2019, Honda Motorcycle Stock Forecasting System Using Double Exponential Smoothing Method (Case Study of Honda Dealer PT Delta Sari Agung Sidoarjo), Journal of Electrical Engineering and Computer Sciences Vol. 4 Issue 1, June 2019, pp. 603-610 .

Jahring and Pradani A. P., 2016, Forecasting With Double Exponential Smoothing Brown Method, Journal of Math Sciences - JMS Vol. 1 No. 2 October 2016, pp. 35-39.

Farida Y., Sulistiani D. A.and Ulinnuha N., 2021, Peramalan Indeks Pembangunan Manusia (IPM) Kabupaten Bojonegoro Menggunakan Metode Double Exponential Smoothing Brown, Teorema : Teori dan Riset Matematika 6(2) , September 2021, pp. 173-183.

Purwanti D.and Purwadi J., 2019,Brown's Double Exponential Smoothing in Forecasting The Inflation Rate in Indonesia, Jurnal Ilmiah MATEMATIKA 6(2) 2019, pp. 54-61.

Marlim Y. N. and Hajjah A., 2021, Sistem Peramalan Persediaan Barang Menggunakan Metode Brown Exponential Smoothing, JOISIE Journal of Information And Informatics Engineering Vol. 5, No. 2, Desember 2021, pp. 146-152.

Dharmawan P. A. S. and Indradewi I. G. A. A. D. ,2021, Double Exponential Smoothing Brown Method Toward Sales Forecasting System With a Linear and Non-Stationary Data, IConVET 2020 Journal of Physics : Conference Series 1810 (2021), pp. 1-9.

Syahdan S.and Aisyah S. , 2020, Forecasting of Consumer Price Index (CPI) Tarakan City With Double Exponential Smoothing Method From Brown, Jurnal Matematika dan Pendidikan Matematika Vol. 5 No. 1, Maret 2020, pp. 54-64.

Susanto A. F., Subanti S.and Slamet I., 2020,Perbandingan Exponential Smoothing Holt's Method dan Double Moving Average terhadap Peramalan IHSG, in Lomba dan SEminar Matematika XXVIII , Prosiding Pendidikan Matematika dan Matematika Volume 2 (2020),.

Marlianah S., Meilani C., Lina Q.and Widodo E., 2019, Analisis Double Exponential Smoothing untuk Meramalkan Utang Pemerintah Indonesia ke Luar Negeri (Studi Kasus : Data Utang Pemerintah Indonesia ke Luar Negeri dari Bulan Januari 2010 sd April 2019), in Prosiding Seminar Nasional MIPA UNIBA 2019.

Muchayan A., 2019,Comparison of Holt and Brown's Double Exponential Smoothing Methods in The Forecast of Moving Price for Mutual Funds, Journal of Applied Science, Engineering, Technology and Education Vol. 1 No. 2 (2019), pp. 183-192 .

Rahmawati A., Ramadhanti C. N., Ismia F. H. and Nurcahyo R., 2021,Comparing The Accuracy of Holt's and Brown's Double Exponential Smoothing Method in Forecasting The Coal Demand of Company X, in Proceedings of The International Conference on Industrial Engineering and Operations Management, Bangalore, India, August 16-18, 2021, Bangalore.

[`16] Bidangan J., Purnamasari I.and Hayati M. N., 2016, Perbandingan Peramalan Metode Double Exponential Smoothing Satu Parameter Brown dan Metode Double Exponential Smoothing Dua Parameter Holt,Statistika Vol. 4 No. 1 , Tahun 2016, pp. 14-19.

Montgomery D. C., Jennings C. L. and Kulahci M., 2008, Introduction Time Series Analysis & Forecasting, A John Wiley & Sons, Inc. Publication.

Hyndman R. J. and Athanasopoulos G.,2018, Forecasting: Principles and Practice 2nd Edition, 2018. [Online]. Available: otexts.com/fpp2/. [Accessed 8 May 2018].

Habsari H. D. P., Purnamasari I.and Yuniarti D., 2020, Forecasting Uses Double Exponential Smoothing Method and Forecasting Verification Uses Tracking Signal Control Chart (Case Study : IHK Data of East Kalimantan Province), Barekeng : Jurnal Ilmu Matematika dan Terapan , Vol. 14 , No. 1 , March 2020, pp. 13-22.