ridertiger
ridertiger

Reputation: 33

Error in calling crypto prices in Google Sheets

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?

Upvotes: 0

Views: 1225

Answers (2)

Pedro
Pedro

Reputation: 489

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

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

Upvotes: 2

player0
player0

Reputation: 1

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

enter image description here

Upvotes: 0

Related Questions