How To Track Cryptocurrencies In Google Sheets

Опубликовано: 01 Январь 2021
на канале: Think Stocks

51,552

1.3k

How To Track Cryptocurrencies In Google Sheets

📈 Link to download all my Portfolio Trackers: / thinkstocks
🌎 Follow me on Twitter: / keithfrislid
🎥 Here is the camera I use for my videos: https://amzn.to/2PB865Q

🔶Get 50% off Seeking Alpha Premium with my Promo Link!!!🔶
https://www.sahg6dtr.com/28KL61/R74QP/

In this video, I will show you have to pull Cryptocurrency data into Google Sheets. This data will include prices, market cap, and circulating supply. As you will see in the video you can pull data for a bunch of different cryptos including all the big ones. If you like this video don't forget to smash the like button and subscribe!

🔷Google Sheets Functions:

🔸Price: =IF(ISBLANK(A3),"",INDEX(IMPORTHTML(CONCATENATE("https://finance.yahoo.com/quote/",A3),"table",1),1,2))
🔸Market Cap: =IF(ISBLANK(A3),"",INDEX(IMPORTHTML(CONCATENATE("https://finance.yahoo.com/quote/",A3),"table",2),1,2))
🔸Circulating Supply: =IF(ISBLANK(A3),"",INDEX(IMPORTHTML(CONCATENATE("https://finance.yahoo.com/quote/",A3),"table",2),2,2))

AFFILIATE DISCLOSURE: Some of the links on this channel and in video descriptions are affiliate links. At no additional cost to you, we receive a commission if a purchase is made after clicking the link.

#googlesheets #cryptocurrencies #cryptotrackers