How to import CoinMarketCap Professional API (Ex: Excel, PHP)
After its latest update (API v2) CoinMarketCap has released the Professional API as a high performance suite designed specifically to meet the demands of mission critical. They have alerted the API publisher to migrate to the new on December 4th, 2018 (documentacion) . This new version requires authentication by query string parameter or http headers, to make requests you must use an APIKey provided by https://pro.coinmarketcap.com once you have registered and selected the plan. To connect from excel we will use the query string parameter authentication (CMC_PRO_API_KEY), we are going to build list all cryptocurrencies https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest ? CMC_PRO_API_KEY= YOU-API-KEY by default it will return 100 results, to request more you must go through method get start-limit: https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest ? CMC_PRO_API_KEY= YOU-API-KEY &start=1&limit=...