A quick heads up if you use the =GOOGLEFINANCE(“CURRENCY:BTCUSD”)function in Google Sheets

=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) 

submitted by /u/tookdrums
[link] [comments]
Bitcoin – The Currency of the Internet

Bitcoin falls back below $9000 after Google says it will ban cryptocurrency ads

Bitcoin fell roughly 6 percent following news that Google, the world's largest ad provider, is cracking down on cryptocurrency. Facebook, which is the second largest online ad provider behind Google, took similar action in January by banning ads on "binary options, initial coin offerings and …
Google Alert – bitcoin