coinmarketcap portfolio import coinmarketcap portfolio import

Next, we need to input the URL we want to use and setup our API key as a header item to authenticate with CoinMarketCap. It is always hard to keep track of all the coins or tokens you have when they are all over the place, or you just simply cannot remember how much you own and where you put them! Du kannst jetzt auf beiden Plattformen genau dieselben Daten einsehen, wenn du dich mit demselben Konto anmeldest! How do I return URLS only for all of the crypto currencies ? You can check their documentation to confirm, but I don't think CoinMarketCap has any endpoint that returns only the price of the currency without any other information, but you can edit the fields displayed in your sheet. sorry my technical english isn't so good Hey Florian! It is a light-weight app with an aesthetically pleasing user interface. I will need your help on another one though, it's the last thing missing to completely set up my excel. I see investments in crypto currencies as a great alternative to diversify my portfolio. Can you please tell me how should I use this tutorial to see all the recently listed coins on CMC? B. Bitcoin in meinem Fall, klickst, kommst du zur Seite mit den Transaktionsdetails. Thanks Ana, I just submit a form to support. Sie klingen hnlich und du wirst dich vielleicht fragen, warum wir uns die Mhe gemacht haben, diese beiden Funktionen zu trennen. Please check the documentation link as it describes their requirements for access (you'll need a paid CMC plan). As for getting historical data, you should be able to manually change parameters or use pagination handling to automatically cycle through a complete data set, but the specifics depend on the endpoint. Jetzt setzt sich mein Guthaben aus 79,24%, Du kannst so viele Vermgenswerte "beobachten", wie du willst, ohne einen dieser tatschlich zu kaufen. You can check CoinMarketCap's docs for specifics, but their faq says "Most endpoints update every 1 minute". I am currently trying to use your template and getting the following error, when trying to refresh the data: " 1) Data: Completed with errors - We received an error from coinmarketcap.com (401) show response { "status": { "timestamp": "2022-07-23T10:48:22.816Z", "error_code": 1002, "error_message": "API key missing. For more information, please see our Can you please try that and see how it goes? Hello, thank you very much for the tutorial, and the (free) template. The CoinMarketCap portfolio is a place where you can track all of your crypto holdings. Can you please refresh your sheet and try again? and second one ends with no results or no error! You can do a request to https://pro-api.coinmarketcap.com/v1/cryptocurrency/map?symbol=SHIB,WARS,BTC. I want to sort API with filter: Marketcap $10M - $100M and 24h Volume ($10M - $100M), You can add filters to the /listings/latest endpoint. Hey Nicolas, sure, you can put all your symbols into one cell (e.g. I tried some tests with the recommanded endpoint (specific crypto), but I can't find all the crypto I want on the list. Thanks for this great article. For example a function like this would get columns A, C, and E: =QUERY(Data!A:Z, select A, C, E). If I include SHDW, it reports the Shadow Token, but I want to have the GenesysGo Shadow, which apparently has the same ticker in coinmarket. Thank you very much for all the time and effort you put into this. Or if you meant you want fewer columns returned, you can use the "aux" parameter described in their documentation to cut out response properties you don't need. but the time stamp of the data is always old not the actual time I make the request. Do they? There's no way I'm going to manually add hundreds, if not thousands, of transactions I've made into CMC to track and manage my portfolio.. surely they don't expect us to do that? I have put all these into Inputs tab. I'm wondering how to differentiate between coins with the same ticker symbol (e.g. After some back and forth, I received this response from CMC: Thanks for your patience. thanks for the great work; having a problem looking up certain coins like: RVN (2577), HNT (5665), etc. As for auto-updating the price, you can check out scheduling. ahhh thanks a lot, i made a little bit of digging myself and found the googlefinance method! The circulating supply is not available and a max. To do? I think the issue here is that pagination settings only apply to loops after the first loop, so you need to add your limit parameter to that first request URL too, like this https://pro-api.coinmarketcap.com/v1/global-metrics/quotes/latest?limit=1000. Integrated new features into a platform that supports application development at high level for users. Matt Shango. Du kannst neue Transaktionen ber das "+"-Symbol rechts hinzufgen oder auf "" klicken, um Transaktionsdetails anzuzeigen oder den gesamten Vermgenswert aus deinem Portfolio entfernen. Du kannst deine Watchlist sogar ffentlich machen und sie mit deinen Freunden teilen. Wenn du dir auch die Zusammensetzung deiner Investitionen ber verschiedene Coins hinweg ansehen mchtest, schau dir die Registerkarte "Verteilung" in diesem bersichtsabschnitt an. Google Drive Portfolio Link:https://drive.google.com/file/d/1Qx2x3V4BZWE50I-6gyL8dwOS3CpTgpyh/view?usp=sharingGet your API Key here:https://coinmarketcap.com. Die Webseiten von Drittanbietern unterliegen nicht der Kontrolle von CoinMarketCap, und CoinMarketCap ist nicht verantwortlich fr den Inhalt von Webseiten von Drittanbietern, einschlielich und ohne Einschrnkung fr Links, die Webseiten von Drittanbietern beinhalten, oder fr nderungen oder Aktualisierungen einer Webseite von Drittanbietern. Not totally sure what you're referring to, which endpoint are you using? Top notch crypto portfolio tracking at no cost. I'm CoinMarketCap you've probably heard of me. 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. The concepts of Portfolio and Watchlist, from CoinMarketCaps point of view, are totally different. You can add the parameter limit=5000 to get 5000 rows of data. This is super helpful. Das gleiche gilt hier: gib den erhaltenen Betrag ein und du kannst Zeit, Gebhren und Notizen ndern, die dir dabei helfen, dich an diese Transaktion zu erinnern! Hello Ana, I had selected "Append" in the Output mode and due to that nothing gets updated(Date,Price),Once I changed to "Overwrite" then everything gets updated properly. The global ethyl acetate market grew from $4.32 billion in 2022 to $4.76 billion in 2023 at a compound annual growth rate (CAGR) of 10.1%. Espaol. and need to input everything again No import/export Cannot merge portfolios 1 1 1 comment jxkos9soxdi 1 min. I'll update the article to reflect this. Hey! For example, for BTC with USDT, # 1 - BTC - Binance - BTCUSDT - 39,000 # 2 - BTC - Huobi - BTCUSDT - 38950, Do you mean you want to get the price of Bitcoin on different exchanges? This article is not intended as, and shall not be construed as, financial advice. The CoinMarketCap Portfolio lets you store all of the information about your crypto holdings in one place. Seems odd to me it was working fine and now it doesn't. Thanks, Khaled! hi Ana, thanks for the article, very helpful. import coinmarketcap import bs4 as bs import datetime as dt import os import pandas_datareader as web import pickle import requests def save_cmc_tickers (): resp = requests.get ('https://coinmarketcap.com') soup = bs.BeautifulSoup (resp.text, "lxml") table = soup.find ('table', {'class': 'table floating-header'}) #table1 = soup.find ('table', Hey there, yeah, there's an example in the article of pulling in specific coins. Du kannst auch den besten Performer und den schlechtesten Performer unter deinen Vermgenswerten finden und deren individuelle P&L + P&L % sehen. Read about how we use cookies and how you can control them on our. The endpoint returns 3 different timestamps: 1) Timestamp (ISO 8601) of the last time this cryptocurrency's market data was updated, 2) Timestamp (ISO 8601) of when the conversion currency's current value was referenced, and 3) Current timestamp (ISO 8601) on the server. Excel Import CoinMarketCap API Data with Query SyntaxByte 8.59K subscribers Subscribe 62K views 2 years ago Import CoinmarketCap API cryptocurrency prices in Excel using a Web Query and. For more info, please check my JMESPath guide. Thank you. Choose a destination sheet, name your request, and hit, CoinMarketCap limits the number of records returned in each request. Get Cryptosheets for Microsoft Excel. Da du notieren kannst, an welcher Brse du die Kryptowhrung gekauft hast, weit du genau, wohin du gehen musst, falls du diese in der Zukunft verkaufen willst! Update: you can now set a starting cell to avoid overwriting your formulas. Hi Kyle, sorry! CoinMarketCap only provides historical data on their paid plans, so if you're looking for free data, I suggest using a different crypto API like CryptoCompare. I discover the CoinMarketCap API and that should do it. I tried it again this morning and still failing with that error. Try this: https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?sort=date_added&sort_dir=asc. Eine kurze Zusammenfassung der drei Registerkarten: Jetzt hast du den ersten Schritt zur Erstellung deines eigenen Portfolios abgeschlossen! It has never been easier to have your crypto portfolio, coin stats and latest Bitcoin, Ethereum and crypto news together in the same crypto tracker and portfolio app. Follow the steps below to get started: Their historical data view is an excellent alternative to a graphical view. is it possible te replace the list of symbols, https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=CHSB,XRP,BTC. If i am using Symbol to pull lets say prices for 100 coins. I see info for, say, Enjin Coin with a URL like https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=ENJ. Hello! How much does it cost to use the CoinMarketCap API? Clearly, everyone needs this. CoinMarketCap's documentation says that you can convert currency in the quote object from USD to BTC by adding ?convert=BTC to the end of your URL. Import CSV File. would the following formula be correct? Ana, First of all, i would like to thank for your very informative articles. Du kannst auerdem die bersichtsstatistiken deiner Investition mit Hilfe der Registerkarte "Statistiken" berprfen. I have couple of problems, first my Pagination doesnt change, It is on none and I have no option to change it. Part 1: Pull Data from Coinbase into Sheets Part 2: Create a Custom Request Part 3: Get Private Coinbase Account Data Part 4: API Documentation Before You Begin Click here to install the API Connector add-on from the Google Marketplace. Thank you so much Ana, that worked. What about if the rank of the coins change, will the connection be wrong or invalid afterwards? Just add &limit=1000 to the end of your URL to get more. Create a new transaction job: Your BSC Address: Import incoming and outgoing transactions Wenn du auf die anderen Daten klickst, wirst du auf die Detailseite der Transaktionen weitergeleitet. https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?limit=600&convert_id=2781,2790 https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?id=1,2,3&convert_id=2781,2790. Wenn du noch kein Konto bei uns hast, rufe einfach die Seite, Nehmen wir an, ich habe am 2. Feel free to contact support if you'd like me to take a look there. Watchlist gives you a good summary of lists of assets you can keep tracking, and you can even make your Watchlist public and share it with your friends. Kaufen: Jede Transaktion, die angibt, dass du eine bestimmte Menge an Vermgenswerten kaufst. Compare price, features, and reviews of the software side-by-side to make the best choice for your business. The price (data.XYCoinname.quote.USD.price) shows a "very" rounded number (for example: 0.56$ is 1$ according to this, altough if I look it up in the data_NoJMES sheet, it shows the correct price) Is there any way to make it show the full value? So how do you use the API? So it looks like MLT isn't a valid symbol. CoinMarketCap is providing these links to you only as a convenience, and the inclusion of any link does not imply endorsement, approval or recommendation by CoinMarketCap of the site or any association with its operators. CoinGecko has a /coins/{id}/history endpoint. Thank you. You don't need to do anything extra, as logo is already included as one of the fields from your original request URL. by Perkuuns When will CoinMarketCap portfolio feature not suck anymore? You'll need to pull from the ID instead of the symbol. Thx! I'm trying to track the prices against my purchases but the way the API organizes by CMC rank messes with how my table links to different cells I.e, if a coin changes rank, my price tracker will link to the wrong coin. Credit portfolio management is a key function for banks (and other financial institutions, including insurers and institutional investors) with large, multifaceted portfolios of credit, often including illiquid loans. Is the above possible? Dies ist der Privatsphrenmodus, in dem du die wichtigsten Werte wie den Gesamtsaldo oder einzelne Vermgensbestnde verbergen kannst. Privacy Policy. You can enter the quantity of coins you bought, price per coin when you bought it, date and time of purchasing, fee associated with the transaction and a note to this transaction. In this guide, well walk through how to pull cryptocurrency data from the CoinMarketCap API directly into Google Sheets, using the API Connector add-on for Sheets. Thank you for your help, have a nice day Ana. Besides the measures announced by the . We can confirm that there was indeed a 403 error due to some backend configuration issues on our end. Question for you is there a way to make a single click button on my Google sheet that will trigger the "Refresh All Now" function in the the API connector instead of having to click on Extensions>API Connector>Refresh All Now, Thank you for your nice comment! That sounds like it's correct but I can't really say without seeing it. Signing up for Cryptosheets is free get crypto data in 30 seconds or less. You need to use IDs or symbols, you can't mix and match. Tools using : Vue.js, Hapi.js, JavaScript, APIs, Bit Bucket, JSON, GIT, JIRA, confluence . 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 you provide content to customers through CloudFront, you can find steps to troubleshoot and help prevent this error by reviewing the CloudFront documentation. Hi I think this is the issue mentioned in the article under the header "latest quotes for BTC and ETH, converted to euros". CoinMarketCap is one of the most popular websites used for tracking various cryptocurrencies and obtaining data about them. 2. the endpoint that I am using is cryptocurrency. Can you provide more details on how to use the importapi in this context? This is the system I would have built if I had to build a . and in excel i have the same. minute by minute data from Cryptocompare: https://min-api.cryptocompare.com/documentation?key=Historical&cat=dataHistominute, Hi Ana- Thanks very much for a great app here. Can i update the URL to use symbols for 99 coins and ID for the 1 coin? I have used many thing but is just not working. All of a sudden 1 coin came up with a wrong / duplicate symbol, hence pulling in the wrong price. I was able to set this up in my spreadsheet in no time at all. How do I pull all the information for coins in DeFi because using, https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?tag=defi. You can create a new portfolio at any time. That one is still working for me, too. You can directly import a .csv file to Crypto Pro if you have a backup or a compatible file. How do you add trade history to your coinmarket portfolio? I am having trouble with part 5 (to get more than just the top 100). Could you please contact support so I can take a look? This means, daily prices for the last months/year, etc? Hier zeigen wir dir den Gesamtgewinn/-verlust deiner Kryptoanlagen zusammen mit dem P&L % (Profit&Loss, Gewinn- und Verlustprozentsatz) seit Beginn deines Kaufs. That looks fine to me, I think you just need to remove the quotation marks, e.g. 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. When you make a spreadsheet you usually dont want to reference cells directly, since its pretty normal for source data to move around. Hello Ana, I am using the API based on your useful Article put here. Does that make sense? Lets start! We will demonstrate this in this article using Python. Q&A for work. Step 1: Setup the CoinMarketCap Web Request in Excel To pull the data into Excel, we use a web query. The current balance is using your current asset holding amount X current price to calculate. It doesn't work. Available for import via both desktop, iOS, and Android 3. Die Daten werden ber die verschiedenen Plattformen hinweg vollstndig synchronisiert. The current CoinMarketCap ranking is #7432, with a live market cap of not available. Just used an API key on blockfolio to import all my coinbase transactions and holdings. Are all of them looking off? supply of 10,000,000 PORT coins. To fix, go to the Summary tab cell B9. Phil, I just want to show only the price of the currency in USDT without any other information in one sell lets choose ETH for example. Step 2: Add the script. Obwohl wir dir die Mglichkeit geben, alle Transaktionsdetails im Portfolio-Feature einzugeben, solltest du nicht vergessen, dass wir dein Geld NICHT einziehen, du berweist also kein Geld an CoinMarketCap. This user-oriented wallet allows investors to safely store Shibcat tokens, remain up to date with their investments, and import other tokens. Our multi-query request function can help automate that by letting you cycle through a list of currencies or dates. Neither method is exactly realtime though (scheduling is limited to 1x an hour, and importapi to once every couple minutes). I'm not sure what you mean by the example works, but not in your sheet. Please change it to AMLT and your request should work. Neben dem aktuellen Kontostand kannst du auch ein Liniendiagramm aufrufen, das die Vernderung deines Kontostandes im Laufe der Zeit darstellt. In 2017, pantera reported a 25,000% return and in 2018, a loss of 41% against all its investments. There was an update on AGI to AGIX. I am in hurry as my subscription to coinmarket will end in 7 days. Please copy it again and you should see the updates (you'll need to import the new JSON file too). Now I would like to import the full listings data so I can have all the prices updated, in order to get a realistic value of my portfolio. How can I build an endpoint to call, for example the BTC and ETH, symbols and logos at the same time? Mach dir also keine Sorgen, etwas zu verpassen, wenn du unterwegs bist. Inhaltsverzeichnis Was ist das CMC-Portfolio? Reddit and its partners use cookies and similar technologies to provide you with a better experience. Sorry, what do I need to find a solution for? Launch the Crypto Pro app; Go to the portfolio you'd like to import trades to; Tap on the '+' in the top . Wenn du eine neue Transaktion hinzufgst oder eine bestehende Transaktion bearbeitest, bentigen sowohl das Liniendiagramm als auch das Verteilungsdiagramm einige Zeit, um den Saldo neu fr dich zu berechnen. 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. I've mostly only been trading on Binance. Generated by cloudfront (CloudFront) Request ID: xj3pJgljwmuhrszJ0ZsVg2TKhAxpxxWta_QwcaQCAa06i_rfpGEF4A==. Only pulls the first hundred. I have this URL but due to 8 calls limits of the free API plan I'm not able to test today: https://pro-api.coinmarketcap.com/v1/cryptocurrency/info?symbol=BTC,ETH?logo=BTC,ETH, But I'm not sure, since "logo" belongs to the "aux" parameter https://imgur.com/a/jMws1fV. Awesome tutorial. Mit dem Portfolio von CoinMarketCap kannst du alle Informationen in Bezug auf deine Krypto-Bestnde an einem Ort speichern. Bitcoin in my case, will bring you to a page showing the transaction details. Keep in mind that the API Connector timestamp will reflect the time zone of your sheet, which can be viewed by clicking File > Spreadsheet settings. Tokyo, Japan, Feb. 28, 2023 . api.coinmarketcap.com/v1/cryptocurrency/info?symbols="BTC,ETH"?logo="BTC,ETH", It is based on what I've seen here: https://imgur.com/a/jMws1fV. to get the quotations of cryptocurrencies in euros? I'm not sure about that, I don't see YTD in their documentation. Thank you for the suggestion, I just updated the template to accept either IDs or symbols. Quick feedback, for some reason I can't run the request since 2 days while it was working perfectly before. what are you waiting for? Wenn du mehr ber Watchlist erfahren mchtest, klicke bitte. Connecting Excel to the Coinmarketcap API. Here's how you can do this: Add Portfolio Tap on the 'Portfolio' tab in the bottom left of panel Tap on any portfolio you have Tap on '+' in the top right corner Hit 'Create Portfolio' Name your new portfolio then hit 'OK' Rename Portfolio Go to the portfolio you'd like to rename Tap on the '' Hit 'Rename Portfolio' Duplicate Portfolio Hey Alex, you can run https://pro-api.coinmarketcap.com/v1/cryptocurrency/map to see all coins and their IDs. Please wait until the process is completed and the page has been fully reloaded. So you'll need to switch to an ID-based request. Use that link and follow steps 1.1 to 1.5. trying to pull in wonderland TIME and its pulling the other one.. Can you help. We'll first get an API key from CoinMarketCap, and then set up a request to pull in crypto data to your spreadsheet. Congrats! You can also find the best performer and the worst performer amongst your assets and see their individual P&L + P&L %. Yes i've been reading, but i believe its only possible to do that with a paid subscription to Coin Market, right? Are you still having an issue? Sure, you can use cell values in your request by wrapping the references in +++ on each side. Fourth . I successfully did it. Connect and share knowledge within a single location that is structured and easy to search. Daher ist ein gutes Tool, das dir dabei hilft, dieses Chaos zu beseitigen, sehr wichtig. Wir pflegen den Preis automatisch ein, zu dem Zeitpunkt, zu dem du den Modalwert eingegeben hast, aber du kannst den Preis noch entsprechend ndern. Importing portfolios from markets Both Binance/Kraken etc. Second how can I get the entire historical data (starting from 2013) till today for all coins? I have an HTTP 400 Bad Request in my dashboard. Is there a way to modify the request URL so it displays prices in BTC? If you still need more records after that, you can apply pagination handling. My last question is how to get the logo of each one of these cryptos. 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. In order to use the new CoinMarketCap portfolio feature, all you need to do is either. I would have a list of top 100 market cap coins only on Binance , is it possible ? Do you know if the endpoints has been changed? Technical events of import appeared on the S&P 500 (see above), Nasdaq Composite and Nasdaq 100 as they closed back below their near-term downtrend lines leaving all the charts short-term bearish. Is there something I am doing wrong? Then i want a real time converter to change the prices to euro as well. In the value box next to it I have: application/json. Thanks Ana. 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. Wenn du Kryptowhrung als ersten Schritt gekauft hast, gib eine "Kaufen"-Transaktion aus diesem Modal ein. Update: You can now use API Connector's visual field editor to do this more simply. Thanks, I don't think CoinMarketCap provides an option to get all at once. 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/. Appsheet changed something, and they don't support anymore the free plan. You can see this article for more info on that (check the section called Fast Cell-Based Refresh): https://mixedanalytics.com/knowledge-base/importapi-custom-sheets-function/, Hello Ana, thank you for the wonderful detailed article! 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. https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?convert=EUR. Learn more about Teams Hi, Great work! If you're looking for a free solution you can check some other crypto APIs, e.g. Thank you for the nice comment, I'm glad the article was useful! CoinTracker - 10% Off for my readers. (only 1 row, all tickers & their values displayed horizontally in many many columns) How do I fix this? Are you running any other requests in your sheet? They have automatic import from exchanges built-in, and the interface is very clean. That was a bug related to (what should have been) a very minor update. So maybe you can check or post in there for more info. By rejecting non-essential cookies, Reddit may still use certain cookies to ensure the proper functionality of our platform. You ROCK!!! Thank you for your nice comment. Sorry, I didn't test these first as I don't have a paid CMC account. Hope that helps pointyou in the right direction! If you have found a solution could you explain it and how I can solve it . Whle hier eine Coin oder einen Token aus, die bzw. Yep, the "Your plan is limited" error is an HTTP 400 error. den du zuerst in dein Portfolio aufnehmen mchtest: Zu Beginn deiner Investition musstest du einen Geldbetrag einzahlen. install either the app or access the web version, Once youre logged in, find Portfolio on the navigation bar. Hmm I'm not sure either, their error message says "symbol should only include comma-separated alphanumeric cryptocurrency symbols" so it seems like a bug on their side related to the periods in the symbol name. This can be done using CoinMarketCap's API (Application Programming Interface). Hey Ana, yep, this was exactly what caused the problem! I hope that you can help me about API. . I don't think CoinMarketCap provides historical daily info for all coins at once. Since overwrite mode overwrites everything in the sheet, I suggest using a formula like =query({Sheet1!A1:Z10000}) to pull all your data into a second sheet. What is the best way to connect the fields? Es ist wichtig, dass du eigene Nachforschungen und Analysen anstellst, bevor du grundlegende Entscheidungen im Zusammenhang mit den beschriebenen Produkten oder Dienstleistungen triffst. Thanks, it works fine but how can i filter columns? Auf dieser Seite kannst du auerdem Transaktionsdetails bearbeiten oder ungewnschte Transaktionen entfernen. Feel free to message support if you'd like me to take a look. I used CRYPTOFINANCE.ai with Google Spreadsheets for some months now and I want to move on, to be able to get cryptocurrency data by "myself".. ago DEXO #C-DEX DEXO is here to Disrupt the whole market You can create multiple portfolios on the CoinMarketCap desktop site and mobile app. CoinMarketCap is a free crypto tracker app that allows you to: Track 11,000+ cryptocurrencies, including: Bitcoin, Ethereum, Binance Coin, Ripple, Cardano, Dogecoin, Shiba Inu Suggest adding it to the guide. So verwendet man das Portfolio von CoinMarketCap, Schritte zum Erstellen eines CMC-Portfolios, Schritt eins: Fge eine "Kaufen"-Transaktion oder eine "eingehende berweisung"-Transaktion hinzu, Schritt zwei: gehe zur Hauptportfolioseite, Seit Juli 2021 knnen CoinMarketCap-Nutzer an ihren Laptops jetzt auch, Bevor du die Funktion "Portfolio" auf unserer Webseite verwenden kannst, musst du ber ein CMC-Konto verfgen und dich anmelden, da wir wissen mssen, welche Daten dir gehren. Auf der rechten Seite dieser Webpage findest du eine Liste aller Coins/Tokens, die du in dieses Portfolio aufgenommen hast, mit einigen Daten. Btw, I recommend using compact report style (under Output Options) to make the output easier to read. Viel Spa bei der Nutzung unseres Portfolios und geniee es, mehr Profit mit deinen Kryptos zu machen! Is there a way to get this data only for BTC and ETH, and historic? I just tried that URL and it worked for me. Like e.g. Can you show me some tricks how to solve it? Need this urgently. In Sheets, open API Connector and create a new request (. With VLOOKUP, it doesn't matter if your coin data changes position, since you'll be matching on the coin name or ID. Hi! I just tested a request to https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?limit=5000 and found all 3 of those coins on the list. Fortunately, CoinMarketCap has an excellent way to view historical data. Could you please tell what can I do with it? I was writing to you in case you can guide me to capture the different markets for one or more currencies. I'm not really sure about that, but maybe this link is what you're looking for: https://coinmarketcap.com/api/documentation/v1/#operation/getV1ExchangeQuotesLatest. Simply click on the + Add New button and follow the same steps mentioned above!