I am trying to fetch the latest price of BTC/INR from a JSON HTTP URL of a exchange. https://api.wazirx.com/api/v2/trades?market=btcinr

I am using the following formula in Google Sheet to Fetch the Latest Price of the URL:


But this is displaying all the Price. I only wanted to fetch the Latest Price. Can you please help me with this how to filter the query of /price to fetch only the latest price.

I am using this ImportJSON Script: https://github.com/bradjasper/ImportJSON

Thank you

  • Welcome. If you want the "latest price", then why are you looking at "trades" - trades?market=btcinr. Your problem appears to understanding the wazirx api than anything to do with Google Sheets. – Tedinoz Mar 31 at 9:25

Your Answer

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

Browse other questions tagged or ask your own question.