Newbie question:
I’m pulling in crypto current prices from CoinGecko into cells, eg
=WEBSERVICE(“https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=gbp”)&T(TODAY())
=WEBSERVICE(“https://api.coingecko.com/api/v3/simple/price?ids=ethereum&vs_currencies=gbp”)&T(TODAY())
These return results such as
{“bitcoin”:{“gbp”:41900}}
I want to display only 41900.
How please? I tried this “REFIND” solution
but not luck. thanks.
My workaround was the following. In an adjacent cell I put in:
=REGEX((O5),"-?\d+(.\d{1,5})?")
Where O5 is the cell importing the API.
For some reason this REGEX… was not recognized as a digit, so in a THIRD adjacent cell:
=VALUE(P5)
Where P5 is the REGEX… cell. This now accepts number-formats (currency, etc.)
Inelegant I’m sure, but it works!
You can involve the REGEX with VALUE, =VALUE(REGEX((O5),"-?\d+(.\d{1,5})?")) to avoid another cell.