Note: If your version of Excel doesn't have Query Editor installed by default, you can get it from the Microsoft site.Ĥ) This will load the Query Editor like in this screenshot. Copy paste the API link into the box, click OK. Select New Query -> From Other Sources -> From Web, here is a screenshot. The API tracker link can be seen on the tools page and is: ģ) Go into the Excel spreadsheet and click the Data tab. 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:ġ) Go to and select the coin you are interested in.Ģ) Click the Tools tab and copy paste the link under API Tracker. 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.
#SPREADSHEET CONVERTER STOCK PRICE FULL#
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. R/Altcoin r/Best_of_Crypto r/BitcoinMarkets r/Blockchain r/BitcoinMining r/CryptoMarkets r/CryptoRecruiting r/CryptoTechnology r/CryptoTrade r/Ethfinance r/EthTrader r/Jobs4Crypto r/Liberland r/LitecoinMarkets r/LitecoinMining r/NFT r/OpenBazaar r/XMRtrader r/GPUmining Mastering Ethereum (Open Source book) Exchanges IBM's ZeroToBlockchain (Free learning resources) See our Expanded Rules page for more detailsĬoinMarketCap (Cryptocurrency market cap info)ġ0k.pizza (Portfolio tracking.See our Expanded Rules page for more details about this rule.This includes "PM for referral", asking for referral codes or links, and linking to sites used solely for referral links. Rule #2.9 - Posting referral, promo links, or codes of any kind is strictly prohibited and will be met with a long-term or permanent ban.See our Expanded Rules wiki page for more details about this rule.If you meet our requirements and want custom flair, click here.
Please make quality contributions and follow the rules for posting. This subreddit is intended for open discussions on all subjects related to emerging crypto-currencies or crypto-assets. R/Bitcoin r/Ethereum r/Binance r/Tether r/Solana r/Cardano r/Coinbase r/Ripple r/TerraLuna r/AVAX Welcome If this feature doesn't work, please message the modmail.īe nice to each other! r/CryptoCurrency is a welcoming place for all people and all cryptocurrencies. Requires 100 comment karma and 1-month account age.
You can correct innacurate link-flair assignments by typing the name of a flair label in a top-level comment and in full caps, e.g.