FORECASTING BITCOIN PRICES WITH TIME SERIES ANALYSIS IN PYTHON AND EXCEL
DOI:
https://doi.org/10.29121/shodhkosh.v5.i5.2024.3457Keywords:
Bitcoin Price Prediction, Time Series Analysis, Python, Excel, ARIMA, AR, MAAbstract [English]
Over the past few years the interest in trading with a decentralized or virtual form of currency has significantly increased. This has led to the rise of the cryptocurrency market in the early 2000’s. Bitcoin, the pioneer in the field, has managed to dominate this volatile and cutthroat market till this day. Cryptocurrency is based on multiple technological frameworks and success stories of high returns in a short time frame have garnered the interest of young investors as well.
Similar to the traditional stock market, multiple machine learning, Artificial Intelligence, Time Series Analysis models have come up to help investors, understand trends, patterns, and derive a deeper understanding of the asset as well as the market they are investing in.
Our research aims to deal with this problem using time series methods such as Auto-Regressive (AR), Moving Average (MA) and Auto-Regressive Integrated Moving Average (ARIMA) models. In our analysis, we have implemented the models using both Excel method and Python. Our metric of evaluation is Mean Absolute Percentage Error (MAPE). In our work, data was taken from a website called ‘Yahoo finance’ [1] for Bitcoin cryptocurrency for a five-year time period i.e. from 1st June, 2017 to 31st May, 2024.
Our Python methodology has resulted in a MAPE of 0.16 for AR model, 0.14 for MA model and 0.11 for ARIMA model. The same has been verified using Excel and the score has been validated.
References
“Yahoo is part of the Yahoo family of brands.” https://finance.yahoo.com/quote/BTC-USD/history/?guccounter=1&guce_referrer=aHR0cHM6Ly93d3cuZ29vZ2xlLmNvbS8&guce_referrer_sig=AQAAACf8tC51NXB7TvNjDH3ij6imZ5Tw3Qg1PL6PLK5sNSUbw-grUCCVsINURkGcu2rnAzSywAf0cfNLTc8VeeEi4C426irNlbEESiVqsgKIuLTmj3glh5fiEe52DftkX7Maeuj_rs2UICbuST1CvZ0wruHNPzxMa904SRF0dHYQQlBJ
“8.3 Autoregressive models | Forecasting: Principles and Practice (2nd ed).” https://otexts.com/fpp2/AR.html
“8.4 Moving average models | Forecasting: Principles and Practice (2nd ed).” https://otexts.com/fpp2/MA.html
“8.5 Non-seasonal ARIMA models | Forecasting: Principles and Practice (2nd ed).” https://otexts.com/fpp2/non-seasonal-arima.html
“IPM Insights metrics include MAPE (Mean Absolute Percentage Error),” Oracle Help Center, Sep. 03, 2024. https://docs.oracle.com/en/cloud/saas/planning-budgeting-cloud/pfusu/insights_metrics_MAPE.html
M. Khedmati, F. Seifi, and M. J. Azizi, “Time Series forecasting of Bitcoin price based on autoregressive integrated moving average and machine learning approaches,” International Journal of Engineering, vol. 33, no. 7, Jul. 2020, doi: 10.5829/ije.2020.33.07a.16. DOI: https://doi.org/10.5829/ije.2020.33.07a.16
Ijraset, “Cryptocurrency Price Prediction and Forecasting Market momentum Using Machine Learning Techniques,” IJRASET. https://www.ijraset.com/research-paper/cryptocurrency-price-prediction-and-forecasting-market-momentum
“Cryptocurrency price prediction using supervised machine learning algorithms.” https://revistas.usal.es/cinco/index.php/2255-2863/article/download/31490/30390?inline=1
G. Serafini et al., “Sentiment-Driven Price Prediction of the Bitcoin based on Statistical and Deep Learning Approaches,” 2020. https://www.semanticscholar.org/paper/Sentiment-Driven-Price-Prediction-of-the-Bitcoin-on-Serafini-Yi/ff388671b7038383e721d3d0e8b2f03766bb0ba7
K. Struga and O. Qirici, “Bitcoin Price Prediction with Neural Networks,” 2018. https://www.semanticscholar.org/paper/Bitcoin-Price-Prediction-with-Neural-Networks-Struga-Qirici/78227a1267464c132236b0bf25a0db812788b864
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2024 JayKrishna Joshi, Anish Gharat, Snehee Chheda, Dr. R.P. Sharma

This work is licensed under a Creative Commons Attribution 4.0 International License.
With the licence CC-BY, authors retain the copyright, allowing anyone to download, reuse, re-print, modify, distribute, and/or copy their contribution. The work must be properly attributed to its author.
It is not necessary to ask for further permission from the author or journal board.
This journal provides immediate open access to its content on the principle that making research freely available to the public supports a greater global exchange of knowledge.