How to Import Cryptocurrency prices from CoinMarketCap Data to Google Sheets
This video is a tutorial on, in my opinion, the simplest way to import cryptocurrency data from CoinMarketCap to Google sheet.
Add-on: API Connector
Link for scripts:
I can't believe how elegant this solution was compared to the half dozen other portfolio tracker videos I watched. Brilliant. And damn youtube's algorithm for not showing me this one weeks ago.
The best of the videos after seeing 10 videos! Thank you very much!
nice presentation, thank you.
the feature where you put the data line by line is now a pro one
How do I refresh the prices?
Very good, I like and subscribe, I will wait for new videos on this topic.
The coins are arranged alphabetically, which affects the price of each coin when adding a new one in the API URL. Example if I have ETH and BTC in row 1 and 2 and add ADA, ada would take row number one as well as the value of ADA in row number one which was BTC before. Do you know how to solve this detail?
Larry, Did you see that you can no longer enter "data.values (@)", because now the "JMESPath filtering" is only for PRO users, so you have everything in horizontal is very inconvenient, how can we solve it?
Is the data live does it update? If so how often?
Hey thanks. If I want to follow the 5 top cryptocurrencies, and they keep changing order. New ones get in and old ones disappear, will this new information get updated when refreshing the sheet? And to make the matter worse, I want additional information about this new crypto-currencies coming in from other pages when updating.
Thank you for the wonderful video Dr. Larry. If I want to add more coins to the tracker after a few days, how can I do so?
Thank you very much for the Vedio…it is really nice and easy to track without confusing google sheet command
I’ve been trying to figure it out how to put sell and buy in the same sheet that can calculate loss or profit.
If I gradually sell or buy (not all at once). Hope you can help.. looking forward to seeing another Vedio
tnx so much!
Do these prices continuously update?
Thank you! very helpful