Minimum, Maximum, and Average Implementation of Patterned Datasets in Mapping Cryptocurrency Fluctuation Patterns

Rizky Parlika - Diponegoro University, Tembalang, Semarang, 50275, Indonesi
Mustafid Mustafid - Diponegoro University, Tembalang, Semarang, 50275, Indonesi
Basuki Rahmat - University of Pembangunan Nasional “Veteran” Jawa Timur, , Surabaya, 60294, Indonesia

Citation Format:



Cryptocurrency price fluctuations are increasingly interesting and are of concern to researchers around the world. Many ways have been proposed to predict the next price, whether it will go up or down. This research shows how to create a patterned dataset from an API connection shared by Indonesia's leading digital currency market, Indodax. From the data on the movement of all cryptocurrencies, the lowest price variable is taken for 24 hours, the latest price, the highest price for 24 hours, and the time of price movement, which is then programmed into a pattern dataset. This patterned dataset is then mined and stored continuously on the MySQL Server DBMS on the hosting service. The patterned dataset is then separated per month, and the data per day is calculated. The minimum, maximum, and average functions are then applied to form a graph that displays paired lines of the movement of the patterned dataset in Crash and Moon conditions. From the observations, the Patterned Graphical Pair dataset using the Average function provides the best potential for predicting future cryptocurrency price fluctuations with the Bitcoin case study. The novelty of this research is the development of patterned datasets for predicting cryptocurrency fluctuations based on the influence of bitcoin price movements on all currencies in the cryptocurrency trading market. This research also proved the truth of hypotheses a and b related to the start and end of fluctuations.


patterned datasets; cryptocurrencies; predictions; hypotheses

Full Text:



Coinmarketcap, “Indodax trade volume and market listings | CoinMarketCap.” 2019, [Online]. Available:

CoinMarketCap, “Cryptocurrency Prices, Charts And Market Capitalizations | CoinMarketCap,” CoinMarketCap. 2022, [Online]. Available:

Coinmarketcap, “Top Cryptocurrency Exchanges Ranked By Volume | CoinMarketCap,” 2022, [Online]. Available:


R. Parlika and P. W. Atmaja, “Rizubot Version 1.0 algorithm: How to read the price movements of Crypto Currency Using the API to find a good purchase price,” Proceedings of the International Conference on Science and Technology (ICST 2018), 2018, doi: 10.2991/icst-18.2018.211.

R. Parlika and P. W. Atmaja, “Realtime monitoring of Bitcoin prices on several Cryptocurrency markets using Web API, Telegram Bot, MySQL Database, and PHP-Cronjob,” 2020 6th Information Technology International Seminar (ITIS), Oct. 2020, doi: 10.1109/itis50118.2020.9321109.

S. A. Basher and P. Sadorsky, “Forecasting Bitcoin price direction with random forests: How important are interest rates, inflation, and market volatility?,” Machine Learning with Applications, vol. 9, p. 100355, Sep. 2022, doi: 10.1016/j.mlwa.2022.100355.

S. Nakamoto, “Bitcoin : A Peer-to-Peer Electronic Cash System,” pp. 1–9, 2009, bitcoin.pdf.

S. Tapia and W. Kristjanpoller, “Framework based on multiplicative error and residual analysis to forecast bitcoin intraday-volatility,” Physica A: Statistical Mechanics and its Applications, vol. 589, p. 126613, Mar. 2022, doi: 10.1016/j.physa.2021.126613.

Y. Liu, Z. Li, R. Nekhili, and J. Sultan, “Forecasting cryptocurrency returns with machine learning,” Research in International Business and Finance, vol. 64, p. 101905, Jan. 2023, doi: 10.1016/j.ribaf.2023.101905.

Y. Qiu, Y. Wang, and T. Xie, “Forecasting Bitcoin realized volatility by measuring the spillover effect among cryptocurrencies,” Economics Letters, vol. 208, p. 110092, Nov. 2021, doi: 10.1016/j.econlet.2021.110092.

A. Bouteska, S. Mefteh-Wali, and T. Dang, “Predictive power of investor sentiment for Bitcoin returns: Evidence from COVID-19 pandemic,” Technological Forecasting and Social Change, vol. 184, p. 121999, Nov. 2022, doi: 10.1016/j.techfore.2022.121999.

D. C. A. Mallqui and R. A. S. Fernandes, “Predicting the direction, maximum, minimum and closing prices of daily Bitcoin exchange rate using machine learning techniques,” Applied Soft Computing, vol. 75, pp. 596–606, Feb. 2019, doi: 10.1016/j.asoc.2018.11.038.

G. S. Atsalakis, I. G. Atsalaki, F. Pasiouras, and C. Zopounidis, “Bitcoin price forecasting with neuro-fuzzy techniques,” European Journal of Operational Research, vol. 276, no. 2, pp. 770–780, Jul. 2019, doi: 10.1016/j.ejor.2019.01.040.

J. Bleher and T. Dimpfl, “Today I got a million, tomorrow, I don’t know: On the predictability of cryptocurrencies by means of Google search volume,” International Review of Financial Analysis, vol. 63, pp. 147–159, May 2019, doi: 10.1016/j.irfa.2019.03.003.

J. Cheng, S. Tiwari, D. Khaled, M. Mahendru, and U. Shahzad, “Forecasting Bitcoin prices using artificial intelligence: Combination of ML, SARIMA, and Facebook Prophet models,” Technological Forecasting and Social Change, vol. 198, p. 122938, Jan. 2024, doi: 10.1016/j.techfore.2023.122938.

K. Murray, A. Rossi, D. Carraro, and A. Visentin, “On Forecasting Cryptocurrency Prices: A Comparison of Machine Learning, Deep Learning, and Ensembles,” Forecasting, vol. 5, no. 1, pp. 196–209, Jan. 2023, doi: 10.3390/forecast5010010.

L. Maciel, R. Ballini, F. Gomide, and R. Yager, “Forecasting cryptocurrencies prices using data driven level set fuzzy models,” Expert Systems with Applications, vol. 210, p. 118387, Dec. 2022, doi: 10.1016/j.eswa.2022.118387.

M. M. Patel, S. Tanwar, R. Gupta, and N. Kumar, “A Deep Learning-based Cryptocurrency Price Prediction Scheme for Financial Institutions,” Journal of Information Security and Applications, vol. 55, p. 102583, Dec. 2020, doi: 10.1016/j.jisa.2020.102583.

N. Aslam, F. Rustam, E. Lee, P. B. Washington, and I. Ashraf, “Sentiment Analysis and Emotion Detection on Cryptocurrency Related Tweets Using Ensemble LSTM-GRU Model,” IEEE Access, vol. 10, pp. 39313–39324, 2022, doi: 10.1109/access.2022.3165621.

N. Gradojevic, D. Kukolj, R. Adcock, and V. Djakovic, “Forecasting Bitcoin with technical analysis: A not-so-random forest?,” International Journal of Forecasting, vol. 39, no. 1, pp. 1–17, Jan. 2023, doi: 10.1016/j.ijforecast.2021.08.001.

N. Parvini, M. Abdollahi, S. Seifollahi, and D. Ahmadian, “Forecasting Bitcoin returns with long short-term memory networks and wavelet decomposition: A comparison of several market determinants,” Applied Soft Computing, vol. 121, p. 108707, May 2022, doi: 10.1016/j.asoc.2022.108707.

O. Kraaijeveld and J. De Smedt, “The predictive power of public Twitter sentiment for forecasting cryptocurrency prices,” Journal of International Financial Markets, Institutions and Money, vol. 65, p. 101188, Mar. 2020, doi: 10.1016/j.intfin.2020.101188.

P. Jay, V. Kalariya, P. Parmar, S. Tanwar, N. Kumar, and M. Alazab, “Stochastic Neural Networks for Cryptocurrency Price Prediction,” IEEE Access, vol. 8, pp. 82804–82818, 2020, doi: 10.1109/access.2020.2990659.

R. Parlika, Mustafid, and B. Rahmat, “Use of Patterned Datasets (Minimum and Maximum) to predict Bitcoin and Ethereum price movements”, Technium, vol. 16, no. 1, pp. 137–142, Oct. 2023.

S. G. Quek, G. Selvachandran, J. H. Tan, H. Y. A. Thiang, N. T. Tuan, and L. H. Son, “A New Hybrid Model of Fuzzy Time Series and Genetic Algorithm Based Machine Learning Algorithm: A Case Study of Forecasting Prices of Nine Types of Major Cryptocurrencies,” Big Data Research, vol. 28, p. 100315, May 2022, doi: 10.1016/j.bdr.2022.100315.

S. K. Nayak, S. C. Nayak, and S. Das, “Modeling and Forecasting Cryptocurrency Closing Prices with Rao Algorithm-Based Artificial Neural Networks: A Machine Learning Approach,” FinTech, vol. 1, no. 1, pp. 47–62, Dec. 2021, doi: 10.3390/fintech1010004.

V. D’Amato, S. Levantesi, and G. Piscopo, “Deep learning in predicting cryptocurrency volatility,” Physica A: Statistical Mechanics and its Applications, vol. 596, p. 127158, Jun. 2022, doi: 10.1016/j.physa.2022.127158.

Y. Liu, Z. Li, R. Nekhili, and J. Sultan, “Forecasting cryptocurrency returns with machine learning,” Research in International Business and Finance, vol. 64, p. 101905, Jan. 2023, doi: 10.1016/j.ribaf.2023.101905.

Z. H. Munim, M. H. Shakil, and I. Alon, “Next-Day Bitcoin Price Forecast,” Journal of Risk and Financial Management, vol. 12, no. 2, p. 103, Jun. 2019, doi: 10.3390/jrfm12020103.