FORECASTING BITCOIN PRICES WITH TIME SERIES ANALYSIS IN PYTHON AND EXCEL

Authors

  • JayKrishna Joshi Mukesh Patel School of Technology Management & Engineering, SVKM's NMIMS Mumbai, India, Research Scholar Chhatrapati Shivaji Maharaj University Navi Mumbai, India
  • Anish Gharat Department of Data Science, Mukesh Patel School of Technology Management & Engineering, SVKM's NMIMS Mumbai, India
  • Snehee Chheda Department of Data Science, Mukesh Patel School of Technology Management & Engineering, SVKM's NMIMS Mumbai, India
  • Dr. R.P. Sharma Chhatrapati Shivaji Maharaj University, Navi Mumbai, India

DOI:

https://doi.org/10.29121/shodhkosh.v5.i5.2024.3457

Keywords:

Bitcoin Price Prediction, Time Series Analysis, Python, Excel, ARIMA, AR, MA

Abstract [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

2024-05-31

How to Cite

Joshi, J., Gharat, A., Chheda, S., & Sharma, R. (2024). FORECASTING BITCOIN PRICES WITH TIME SERIES ANALYSIS IN PYTHON AND EXCEL. ShodhKosh: Journal of Visual and Performing Arts, 5(5), 1551–1559. https://doi.org/10.29121/shodhkosh.v5.i5.2024.3457