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

in #googlefinance • 7 years ago

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

#google #finance
7 years ago in #googlefinance by
$0.00
    1 vote
    Reply 0

    Coin Marketplace

    STEEM 0.17
    TRX 0.24
    JST 0.034
    BTC 95957.89
    ETH 2786.70
    SBD 0.67