Overall, it’s quite a simple spreadsheet. By putting the ticker of a coin in the column A, the rest of the data points will populate themselves. The first column is the only column that requires an input from the user. The goal of this spreadsheet is to be able to collect and compare multiple data points from many cryptocurrencies all at once within one Google spreadsheet that will look like this: It has been the base of numerous of my other work and is continuing to inspire my other projects such as this one. The main paradigm of this article is based on this article that I wrote a while back that explains how you can scrape websites with Google Sheets. If you just want the spreadsheet, I also included a link to the file down in this article. In this article, I am going to show you how you can create a spreadsheet in Google Sheets that will retrieve the price of up to 49 coins and their 24h, 7d and 30d variations. If you’ve ever wanted to track the price and variation of your favourite coins in Google Sheets, you came to the right place. Video How to get Bitcoin or Cryptocurrency Prices in Google Sheets
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |