Import API Data from web to EXCEL (with automatic refresh)

hello everybody

after an hour don't find a solution i wonder if someone can help me..

i'd like to import the following API Data (orderbook) from bitstamp to Excel. if i try it with DATA/retrieve external data/from the web i got an error, do you have another idea how to import this data into EXCEL.

here the data i'd like to import to excel and refresh
https://www.bitstamp.net/api/v2/order_book/BTCUSD

i also need to refresh this data automatic in excel, any idea how that could work?

thank you very much

Kevin

maybe this helps, bitstamp write this on the website: Passing any GET parameters, will result in your request being rejected.

also every second time i refresh https://www.bitstamp.net/api/v2/order_book/BTCUSD there's an error... no idea why?

the person who can solve this can get a following payed order.

i want the orderbook (bid and ask) from www.bitstamp.net for the following currency into an excel and that it refresh at least every 30 seconds.

BTC/USD
BTC/EUR
XRP/USD
XRP/EUR
XRP/BTC
LTC/USD
LTC/EUR
LTC/BTC
ETH/USD
ETH/EUR
ETH/BTC

the API Data to import BTC/USD is the following:

https://www.bitstamp.net/api/v2/order_book/BTCUSD

for BTC/EUR the following and so on...
https://www.bitstamp.net/api/v2/order_book/BTCEUR

i'm maybe in the wrong forum here, so if you know someone who can help, please write me at k.maloney AT gmx.ch THAANK YOU