How can I retrieve only the price from this API in a Google spreadsheet? This is the API ticker - https://api.crypto-bridge.org/api/v1/ticker

For example, if I use this function

=INDEX(IMPORTDATA("https://api.crypto-bridge.org/api/v1/ticker"), 1,7)

then in response I will get following response.


Which is the price of PRTX_BTC currency pair which is second in list.

How can I get only price and remove everything except for the price like last, semi column, and double quotes? In response I only want this. How can I get this?


  • If you've lost the cookie that gives you access to your account, please use the Contact Us link below to regain access. – jonsca May 25 '18 at 22:48

Just use importjson function with the specific ticker (https://api.crypto-bridge.org/api/v1/ticker/PRTX_BTC)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.