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. I created this sample portfolio tracker in Excel that draws live data from the CoinMarketCap API and refreshes on demand.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |