Optimasi Prediksi Harga Saham BBNI melalui Integrasi Proses ETL dan Algoritma Long Short-Term Memory
DOI:
https://doi.org/10.62951/repeater.v4i1.795Keywords:
Data Engineering, ETL Process, LSTM, Stock Price Prediction, Time Series AnalysisAbstract
Stock price prediction remains a complex challenge due to the dynamic and non-linear nature of financial markets, especially for banking stocks like PT Bank Negara Indonesia (Persero) Tbk (BBNI). This study aims to optimize BBNI stock price forecasting by integrating an automated Extract, Transform, Load (ETL) pipeline with the Long Short-Term Memory (LSTM) algorithm within a data engineering framework. Historical data from 2019 to 2025 were processed through a structured ETL sequence—including data cleaning, feature engineering, and MinMaxScaler normalization—to ensure high data quality. The dataset was partitioned into 80% for model training and 20% for testing to ensure rigorous evaluation. The results demonstrate that the systematic ETL approach significantly enhances model stability and predictive accuracy compared to conventional methods. The LSTM model effectively captured long-term temporal dependencies, providing reliable trend forecasts with an impressive test accuracy, achieving a Root Mean Squared Error (RMSE) of 0.0354. This research underscores that integrating robust data engineering practices with deep learning is essential for building resilient financial decision-support systems.
Downloads
References
Adebiyi, A. A., Adewumi, A. O., & Ayo, C. K. (2014). Comparison of ARIMA and artificial neural networks models for stock price prediction. Journal of Applied Mathematics, 2014, 1–7. https://doi.org/10.1155/2014/614342
AEMPS. (2025). Stock price prediction based on machine learning. Advances in Economics, Management and Political Sciences, 224, 119–127.
Bao, W., Yue, J., & Rao, Y. (2017). A deep learning framework for financial time series using stacked autoencoders and long short-term memory. PLOS ONE, 12(7), e0180944. https://doi.org/10.1371/journal.pone.0180944
Jiang, Y. (2025). Stock price prediction based on machine learning. Advances in Economics, Management and Political Sciences, 224, 119–127.
Li, T. (2024). Stock prediction and analysis based on machine learning algorithms. Applied and Computational Engineering, 50, 15–22.
Liu, L. (2023). A comparative examination of stock market prediction: Evaluating traditional time series analysis against deep learning approaches. Advances in Economics, Management and Political Sciences, 55, 196–204.
Mario, C. (2021). Bank Negara Indonesia stock historical price [Data set]. Kaggle. https://www.kaggle.com/datasets/caesarmario/bank-negara-indonesia-stock-historical-price
Meisenbacher, S., Ratz, M., Turowski, M., Phipps, K., Müller, D., Hagenmeyer, V., & Mikut, R. (2022). Review of automated time series forecasting pipelines. WIREs Data Mining and Knowledge Discovery, 12(6), e1475.
Moghar, A., & Hamiche, M. (2020). Stock market prediction using LSTM recurrent neural network. Procedia Computer Science, 170, 1168–1173.
Qiu, M., & Song, Y. (2016). Predicting the direction of stock market index movement using an optimized artificial neural network model. PLOS ONE, 11(5), e0155133.
Ravi, C. (2025). ETL (extract, transform & load) automation. International Journal of Emerging Trends in Computer Science and Information Technology, 6(1), 51–54.
Sen, J., Mehtab, S., & Nath, G. (2020). Stock price prediction using deep learning models. arXiv. https://arxiv.org/abs/2010.12456
Shi, Y. (2023). Research on the stock price prediction using machine learning. Advances in Economics, Management and Political Sciences, 22, 174–179.
Siami-Namini, S., Tavakoli, N., & Namin, A. S. (2018). A comparison of ARIMA and LSTM in forecasting time series. In Proceedings of the 17th IEEE International Conference on Machine Learning and Applications (ICMLA) (pp. 1394–1401). IEEE.
Smith, N., Varadharajan, V., Kalla, D., Kumar, G. R., & Samaah, F. (2024). Stock closing price and trend prediction with LSTM-RNN. Journal of Artificial Intelligence and Big Data, 4(1), 1–13.
Soni, P., Tewari, Y., & Krishnan, D. (2022). Machine learning approaches in stock price prediction: A systematic review. Journal of Physics: Conference Series, 2161(1), 012065.
Vassiliadis, P., Simitsis, A., & Skiadopoulos, S. (2002). Conceptual modeling for ETL processes. In Proceedings of the 5th ACM International Workshop on Data Warehousing and OLAP (pp. 14–21). Association for Computing Machinery.
Wang, W. (2024). Machine learning in financial time-series data. Advances in Economics, Management and Political Sciences, 92, 1–12.
Wijaya, R., & Pudjoatmodjo, B. (2015). An overview and implementation of extraction-transformation-loading (ETL) process in data warehouse (Case study: Department of agriculture). In Proceedings of the 3rd International Conference on Information and Communication Technology (ICoICT) (pp. 70–74). IEEE.
Zhan, Z., & Kim, S. K. (2024). Versatile time-window sliding machine learning techniques for stock market forecasting. Artificial Intelligence Review, 57(209), 1–25.
Zhang, D., Tang, N., Dong, W., & Zhao, L. (2025). Machine learning-based financial big data analysis and forecasting: From preprocessing to deep learning models. Applied and Computational Engineering, 116, 1–11.
Zhang, J. (2024). Analysis of stock forecasting based on LSTM. Applied and Computational Engineering, 51, 1–9.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Repeater : Publikasi Teknik Informatika dan Jaringan
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
