Hi Luke - do you ever get a VALUE error in your spreadsheet? I keep getting this error every couple of days, but then if I go back in version history a day it's ok. But then it randomly reoccurs. I haven't changed anything in this part of the sheet you built. I'm wondering if just happens because it's making a call to look up the prices and maybe the API on cryptocompare.com is overwhelmed?
Thanks
Unfortunately the IP for Google spreadsheets gets rate limited by the API provider. I've been in dialogue with them hoping they'll implement a token-based solution so that each user's requests could be attributed to them directly instead of Google's IPs, but that hasn't happened yet.