Using the new API for CoinMarketCap in Excel-Portfolio : CryptoCurrency
I hope listed below are some folks extra Excel-savvy than I’m. For my crypto portfolio I exploit an Excel sheet with API. It was quite simple by simply utilizing an URL and that is it.
Now, CMC has a new API entry. I created an account and every little thing, however I’m not acquainted with URL-building and CMC_PRO_API_KEY-stuff.
What I attempted is that this URL: https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest/CMC_PRO_API_KEY=MYKEYHERE&items?id=1720/
It returns an error 404.
What ought to the API URL appear to be for a particular coin for Excel? I determine I am not the just one utilizing Excel for this. If you’ve gotten easy options with different apps, let me know!
Thanks for any assist.