Right now crypto currencies stand at about 0.8% in my portfolio and I'm looking to increase it to about 5% by the end of 2017. Do you mean the timestamp sent back from CoinMarketCap, or the timestamp set by API Connector (info)? Franais. It should do the vlookup, but somehow it is not successful. what are you waiting for? Now on the CMC Android app, you can see the prices of your top coins follow you around our site. I'm the senior product manager at CoinMarketCap. so i have done everything perfectly but i wanna add an extra something. Historically, its role has been to understand the institution's aggregate credit risk, improve returns on those riskssometimes by trading loans in the secondary market, and . If you'd like, please feel free to message support and I can run some tests with you directly in your sheet. Wahrscheinlich weit du, dass wir nicht nur unser Portfolio-Feature zur Verfgung stellen, sondern auch eine andere Funktion namens Watchlist. Hey David, you'd make a request like https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?id=1,1027,825, where you include whatever IDs you need in the id parameter. I've updated the template as well. We will demonstrate this in this article using Python. I dont think theres an endpoint for that specifically but you can request a coin list from Binance and then compare it to a coin list from CoinMarketCap to see the difference. Sheet1, cell A1) and then reference that cell like this: https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=+++Sheet1!A1+++ You can check this article for more info on referencing cells in your requests: https://mixedanalytics.com/knowledge-base/api-connector-create-api-request-based-on-cell/. Try again later, or contact the app or website owner. Wenn du Kryptowhrungsinvestitionen besitzt, hast du diese wahrscheinlich aus verschiedenen Quellen gekauft: Vielleicht hast du BTC bei Coinbase gekauft, BNB bei Binance und dann vielleicht noch viele andere Coins oder Tokens an verschiedenen Brsen. Quite a lot of people are reporting this error right now, you can see some more reports in our user forum here. dusk network , enjin coin, energy web token for these coins telling resource at url not found. Example: https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=BTC,ETH,SOL,FTM,RAY,SRM,SHIB,RUNE,ATOM,BNB,USDT,CRP. . Join the thousands already learning crypto! What is the good syntax ? Please check this comment for info on using the ID instead of symbol. CoinMarketCap API and Google Sheets | by Craigory Sparks | Geek Culture | Medium 500 Apologies, but something went wrong on our end. CryptoCompare Pros: With 13 user ratings, the app has earned 2.9 out of 5 stars at the App Store and generated 4 stars out of 191 ratings at the Play Store. I just need coin symbol, USD price, 24h % and 7d % I think it's in JMESpath but i don't know the syntax Hi there, you can try this: data.*[].{symbol:symbol,quote:quote}. If a symbol on CMC is duplicated, how do we pull in the Symbol by ID instead? If I understand correctly, you have a list of coins in one sheet, and want to keep all the data lined up? Here, we show you the total profit/loss of your crypto assets along with the P&L % (profit and loss percentage) from inception of your purchase. Hey there, yeah, there's an example in the article of pulling in specific coins. Any workaround?.. Crypto Portfolio Tracker Keep track of your profits, losses and portfolio valuation with our easy to use platform. We'll first get an API key from CoinMarketCap, and then set up a request to pull in crypto data to your spreadsheet. Here, youll see the balance of Bitcoin based on the current price, 24h % change and the total P&L, or you can see a list of transactions youve inputted for Bitcoin. You need to specify IDs in a comma separated list, like this: https://pro-api.coinmarketcap.com/v1/cryptocurrency/info?id=300,1,2, Alternately, you can list the slugs or symbols as described here: https://coinmarketcap.com/api/documentation/v1/#operation/getV1CryptocurrencyInfo. I just tested and those IDs seemed to work fine on this side. Basically what I do is purchase USDT via P2P, transfer to spot, then trade for whatever coin I want. Are you still having an issue? Managed to get it work with the coingecko's, thanks Ana! Hey Marco, we haven't updated anything recently. Weakness in the yen also contributed heavily to rising import costs, as a widening gap between local and U.S. interest rates saw investors dump the Japanese currency. 2. Hier kannst du den aktuellen Preis dieses Vermgenswerts, die 24-Stunden-Preisnderung in %, den aktuellen Gesamtbetrag deiner Bestnde in deiner Whrung und in der Originalwhrung sowie den Gewinn und Verlust jedes Vermgenswertes mit P&L % sehen. Update: you can now set a starting cell to avoid overwriting your formulas. I wonder if it's gone over some limit, how many coins are you pulling data for? I was able to set this up in my spreadsheet in no time at all. Portfolios let you track your Crypto purchases, by sharing their performance, gains, and losses over time. Auf der Desktop-Seite von CoinMarketCap kannst du mehrere Portfolios erstellen (bald auch mobil!). Launch the Crypto Pro app; Go to the portfolio you'd like to import trades to; Tap on the '+' in the top . If that isn't clear, feel free to share your sheet with edit access, I can then help you in your sheet directly. Lebanon's first official devaluation in a quarter century has already made the pound this year's worst-performing currency in the world. You can check CoinMarketCap's docs for specifics, but their faq says "Most endpoints update every 1 minute". there are 2+ different MIST coins). I did this and it is working! Es ist immer schwer, alle Coins oder Tokens, die man besitzt, im Auge zu behalten, wenn sie berall verstreut sind. Here's a copy of the whole string. It doesn't work. Portfolios let you track your Crypto purchases, by sharing. A moment later you'll receive an email. Shibcat. The section called "Fast Cell-Based Refresh" shows how you'd hook up your API call to a checkbox. I'm using the exact same url than the one shared by Anonymous, so that's really strange. My data does not update. Here are other things I've done on Binance: Converted USDT to XRP and transferred that to a wallet in which I cashed it out, Transferred USDT from Binance to Mandela Exchange wallet, then traded it with MDX. great article, i just wanted to know can we create forecast report using live price which will automatically update ? To import coin data follow the steps as described below: 2.1. Not a lot of people know that CoinMarketCap also offers a crypto portfolio tracking feature. Only pulls the first hundred. Auf der rechten Seite dieser Webpage findest du eine Liste aller Coins/Tokens, die du in dieses Portfolio aufgenommen hast, mit einigen Daten. Please check that section for how to resolve it with JMESPath, or use a different endpoint. Hi Ana and thanks a lot for your article! I can only get it to work when I use the ID instead like this: https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?id=15439. 1 Reply This tutorial will show you how to use the CoinMarketCap API to import bitcoin prices and cryptocurrency data into Google Sheets.. Have been using the paid version. Our multi-query request function can help automate that by letting you cycle through a list of currencies or dates. CoinGecko has a /coins/{id}/history endpoint. If you have purchased crypto investments from multiple sources, you can now see them all in one place, right on CoinMarketCap. Can you please share the exact request URL you're using so I can test it? Hello, first of all, congratulations on your website. Suggest adding it to the guide. Thank you. How do you add trade history to your coinmarket portfolio? Many crypto investors and traders rely on Coinmarketcap's API to get accurate, real time data for thousands of cryptocurrencies and cryptocurrency exchanges.. With Coinmarketcap's API, you can pull information on . Join us in showcasing the cryptocurrency revolution, one newsletter at a time. For more info, please check my JMESPath guide. Advanced Portfolios offer all the functionality of Quick Portfolios plus you can track transaction fees, dates, and P&L. And don't forget there's no reason you have to choose just one! Please check the documentation link as it describes their requirements for access (you'll need a paid CMC plan). If you can't get it from the API maybe you can try a site like this: https://bitcoincharts.com/markets/. I'm not sure what you mean by the example works, but not in your sheet. When you click again on the icon, it unlocks the privacy mode and shows you all the data available. Wir pflegen den Preis automatisch ein, zu dem Zeitpunkt, zu dem du den Modalwert eingegeben hast, aber du kannst den Preis noch entsprechend ndern. All rights reserved, We use cookies to offer you a better browsing experience, analyze site traffic, personalize content, and serve targeted advertisements. You can add new transactions from the + icon on the right, or click on the to view transaction details or remove the whole asset from your portfolio. Which URL are you using? You can import your data from a CSV file using the iPhone app. Under Authorization, enter your CoinMarketCap API key from the earlier step. Reddit and its partners use cookies and similar technologies to provide you with a better experience. Therefore, a good tool to help you tidy up this mess is very important. CoinTracker is the most complete portfolio tracker on the market. This article contains links to third-party websites or other content for information purposes only (Third-Party Sites). Importing portfolios from markets Both Binance/Kraken etc. I hope that you can help me about API. If so, you can just use Google Sheets functions for this, for example put all your coins in one column and then use VLOOKUP to pull associated data into associated columns. You can click on the Scheduling tab to set that up, and see this article for more info: https://mixedanalytics.com/knowledge-base/api-connector-scheduling/ As another option, you can look into API Connector's feature IMPORTAPI. Hi Ana, could you maybe elaborate on this solution. Thanks Ana for your quick response. Thanks Ana. Sorry, I'm completely new to this! It is in the guide, here. Copy and paste the content of CRYPTOFINANCE.gs into the page. Cheers! Fortunately, CoinMarketCap has an excellent way to view historical data. I'm not sure why the second one didn't work. sorry my technical english isn't so good Hey Florian! Dieser Artikel ist nicht als Finanzberatung gedacht und darf auch nicht als solche ausgelegt werden. Jan. Hey there, great article, very helpful thanks a lot ! Your current balance, charts and summary. How do you update the coins list? Hey Cris, please check this article. This article is not intended as, and shall not be construed as, financial advice. Hi, I tried you URL as above and the result is displayed horizontally. I will need your help on another one though, it's the last thing missing to completely set up my excel. You can also check the summary stats of your investment from the Statistics tab. Read about how we use cookies and how you can control them on our. CoinMarketCap created the Portfolio tool that allows you to input your crypto investment records, similar to providing you a nice bookkeeping tool to keep all your investments in one place but better, as we use only CMC data and methodology to help you analyze your investment value, profit and loss! is there a way to export all coins in order to filter on market cap, circulating supply, volume? I am having trouble with part 5 (to get more than just the top 100). I know a lot of people have already asked about this particular issue of wrong symbol returning by api but I'm using your template and we can only enter symbols in "Inputs" tab. Yes i've been reading, but i believe its only possible to do that with a paid subscription to Coin Market, right? Portugues. Top notch crypto portfolio tracking at no cost. However, Google sheets is not working or updating because of this error. Hi Kyle, sorry! If you also want to check out the composition of your investments across different coins, check the Allocation tab on this summary section. CoinMarketCap hat das Portfolio-Tool entwickelt, das es dir erlaubt, deine Krypto-Investitionsdaten einzugeben, hnlich wie ein Buchhaltungs-Tool, mit dem du alle deine Investitionen an einem Ort aufbewahren kannst nur besser, da wir nur CMC-Daten und -Methoden verwenden, um dir dabei zu helfen, deinen Investitionswert, Gewinn und Verlust zu analysieren!