![]() ![]() In my example file, I've only added the price feed for a few popular coins, but you can get live data for any coin on CMP by doing this: This is why its often better to value your portfolio using the prices on CoinMarketCap, which derives prices by "taking the volume weighted average of all prices reported at each market." In many altcoins there can be quite a large spread in price between your exchange and the market average, and it generally always tends to move towards the average as arbitrage removes the difference. In addition to often not showing you the dollar price per coin, they also show the spot price at their exchange rather than the average across all exchanges. One of the things that the exchanges generally get terribly wrong is portfolio valuation and tracking. ![]() Its also much quicker than logging into a site and allows for the full capability of Excel to analyze, you can run all the functions, graphs.etc that you want. If you have holdings across various exchanges (XRB at Bitgrail, BTC at GDAX, REQ at Binance.etc) this allows you to consolidate your entire portfolio, and also to value it more accurately in Satoshis and US dollars. Navigate to the "Data" tab in the ribbon and open the "From Web" option in "Get & Transform Data".I created this sample portfolio tracker in Excel that draws live data from the CoinMarketCap API and refreshes on demand. How to create the connection in ExcelFor the CMC API call, we need to create an advanced web connection through the Excel data connection. NOTE: Depending on the version of Excel you're using, it might look slightly different, or be located at slightly different places. The example I'll be using, is the example from the "Quick start guide" in the documentation. Please read the API documentation carefully, to find the call for your specific use case. This short guide is only to show the ropes a bit to instruct on what to enter where in Excel, to establish the connection to the API call you desire. The flip side of this, is the increased complexity. The CMC API is a lot more robust, and allows for a lot more tinkering, than the CoinGecko API. You can sign up at and - after verifying your account - you can retrieve your API key. If any details are missing here and in the linked post, feel free to ask any questions in the comments :)īefore you can use the CMC API, you need to sign up for a (free) developer account, to receive an API key. Following my previous post about using the CoinGecko API in Excel here, I will now give a short guide on using the CoinMarketCap API in Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |