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...
P.S. There is no visible change in the url website:https://coinmarketcap.com/all/views/all/ Liam Bastick
NameTickerLast price%24 high24 lowPrice Charts 7d24 volume# CoinsMarket cap 0 bitcoin BTC $ 8,008.027 +1.83% $ 8,056.630 $ 7,812.784 NaN $ 12.04B 17.71M $ 141.89B 1 ethereum ETH $ 251.72335 +2.68% $ 253.84721 $ 242.95687 NaN $ 6.93B 106.20M $ 26.73B 2 litecoin LTC $ 98.633851...
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...
NameTickerLast price%24 high24 lowPrice Charts 7d24 volume# CoinsMarket cap 0 bitcoin BTC $ 8,008.027 +1.83% $ 8,056.630 $ 7,812.784 NaN $ 12.04B 17.71M $ 141.89B 1 ethereum ETH $ 251.72335 +2.68% $ 253.84721 $ 242.95687 NaN $ 6.93B 106.20M $ 26.73B 2 litecoin LTC $ 98.633851...