DiscoverWavesDecks

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

Published in

Words

0

Reading

0 min

Listen

Play

2018-07-13 21:31

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

2018-07-13 21:31

This post was published via steemit. Ecency is not the originator or editor of this content and displays it for discovery purposes only.

$ 0.000

1

A quick heads up if you use the =GOOGLEFINANCE("CURRENCY:BTCUSD")fu...