I'm sure you could keep your version in dropbox/drive/onedrive, but I'd be curious about the trigger updates and mobile compatibility. I wanted the ability to view it from anywhere. Please post any questions to /r/cryptosheets I've been answering questions for 24 hours and need a break (⊙.☉)7
How to understand delta crypto tracker full#
I can also post the full excel file if someone is interested. Having it all in Excel makes it easy to chart and analyze now. You can also make a quick macro to Refresh All and assign it to a button to add to the spreadsheet to make it even faster. You can also manually refresh at any time by clicking Refresh All under the Data tab. The data will automatically refresh every time you open the file. Click on Convert Into Table on top.ĥ) This will make a nice table for you to import into a new spreadsheet, you can name it by changing the Name field on the right side.Ħ) Click save to import and this will make a new sheet with the name entered in the Name field. Simply click on the Record field in the table and it should expand to look like this.
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. 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/CryptoCurrencyMemes r/CryptoTechnology r/CryptoMarkets r/CryptoRecruiting r/Best_of_Crypto r/BitcoinMarkets r/BitcoinMining r/CryptoTrade r/Ethfinance r/EthTrader r/Jobs4Crypto r/Liberland r/NFT r/OpenBazaar r/GPUmining Mastering Ethereum (Open Source book) Exchanges IBM's ZeroToBlockchain (Free learning resources)
0 kommentar(er)
