
There is a very quick and simple way to pull crypto prices without the need for a paid or free cryptocurrency price API.
The basic formula goes like this =IMPORTDATA("https://cryptoprices.cc/BTC")
You can be a little more advanced by dynamically setting the crypto ticket based on another column: