Error in calling crypto prices in Google Sheets

0
votes

This command:

=VALUE(REGEXEXTRACT(IMPORTDATA("https://min-api.cryptocompare.com/data/price?fsym=ETH&tsyms=USD"), "{.+:(.+)}"))

used to work just fine for ETH and BTC, but it is giving me this error now:

Error
Function REGEXEXTRACT parameter 2 value "{.+:(.+)}" does not match text of
Function REGEXEXTRACT parameter 1 value "{"Response":"Error"".

What's the reason?

2
regexgoogle-sheetsgoogle-sheets-formulacryptocurrency

2 Answers

1
votes

Consider using =IMPORTDATA("https://cryptoprices.cc/BTC/")

There's no parsing required, no limitations, no authentication.

0
votes

try it perhaps tomorrow (you probably reached the max limit of free API calls for the day)

enter image description here