I need help with a project. I want to grab the current price of a specific cryptocurrency token and have it display in my spreadsheet automatically. I’m aiming to set it up so that the price refreshes every few minutes, or even more frequently if possible. I attempted to use built-in functions such as IMPORTXML and IMPORTHTML, but they haven’t worked as expected. Has anyone managed to implement live updates for crypto prices in a spreadsheet? Any suggestions or insights would be much appreciated. Thanks!
hey TomDream42, i’ve used the cryptowatch API for this. it’s pretty easy to set up and gives real-time data. you’ll need to make an account and get an API key, but then you can use their google sheets add-on. it updates automatically and you can customize the refresh rate. give it a shot!
I’ve been working with cryptocurrency data in spreadsheets for some time and found that the CoinMarketCap API is incredibly reliable. You need to get an API key, but the free tier is more than enough for most personal projects. I use Google Apps Script to create a custom function that fetches data and updates the spreadsheet, setting up time-based triggers to run the script at regular intervals. This method gives me full control over the data updates and has worked flawlessly as long as I stick to the API rate limits.
I’ve tackled the issue by using Google Apps Script as an alternative to functions like IMPORTXML. My solution involved writing a custom script that pulls data from a reliable API, such as CoinGecko, which provides the necessary cryptocurrency information. I then integrated the code into the spreadsheet by creating a custom function and set up a time-driven trigger to refresh the data at regular intervals. Although this method involves coding, it offers greater flexibility and reliability compared to built-in spreadsheet functions, and there are plenty of online tutorials available to help you get started.