So I suggest using a different crypto API for this: CoinGecko, CryptoCompare and CoinMarketCap all provide that type of multi-coin endpoint. Reply Is it possible at all? Reply Ana November 26, 2021 at 4:05 am Sure, you can do the following: 1. Use a URL like this to get daily dat...
Public Sub exceljson_bcn() Dim http As Object, JSON As Object, i As Integer Set http = CreateObject("MSXML2.XMLHTTP") Set Url = "https://api.coinmarketcap.com/v1/ticker/?limit=2" Url = Url & "?rand=" & Int((300 - 100 + 1) * Rnd + 100) http.Open "GET", Url, False...