=IMPORTJSON(CONCATENATE("https://coinsmarkets.com/apicoin.php"), CONCATENATE("/BTC_POLY"), CONCATENATE("noHeaders,",$D$1))
it actually worked pretty straight forward, I had been trying to reference ID instead of /BTC_POLY, so it was giving me REFERENCE errors.
It's working perfectly, Basically i made a last field which would get BTC price in USD from coinmarketcap and just multiply by the BTC_POLY's last price, so it would give me last price in USD.
My sheet's designed to update every hour, so we will see if cloudflare actually gets in the way of retrieving data hourly, but doing manual update does grab data every time.
Thanks for the heads up on the API !
The API on CoinMarkets doesn't show volume details compared to CoinMarketCap or Yobit data, but all i wanted was the price ticker so it's good :)