This post is from a low-reputation account and contains an unverified outbound link. Be cautious before clicking external links.
A quick heads up if you use the =GOOGLEFINANCE("CURRENCY:BTCUSD")function in Google Sheets
Words
22
Reading
1 min
Listen
Play
8y
=GOOGLEFINANCE("CURRENCY:BTCUSD") stopped working as of 7/10/2018
You can use a call to the crypto compare api with this command instead:
=SUM(SUBSTITUTE(SUBSTITUTE(IMPORTDATA("https://min-api.cryptocompare.com/data/price?fsym="&"BTC"&"&tsyms=USD"), "{"&CHAR(34)&"USD"&CHAR(34)&":",""),"}","")+0)