How to convert live json api data from url to excel sheet


#1

I have a URL - https://bitbns.com/order/getTickerWithVolume

Which gives live prices of different cryptocurrencies.

Now if I feed this url in excel, I can easily get the live data. But is there any function by which I can specifically get the price of a single currency, for example if I just want to get a price of bitcoin than what can I do?


#2

I think this is a question for any community this service may provide, or perhaps stackoverflow.com. This board is to discuss the {json:api} standard. Good luck!