Es ist immer schwer, alle Coins oder Tokens, die man besitzt, im Auge zu behalten, wenn sie berall verstreut sind. Marketing & Crypto Writer ~ For copywriting or ghostwriting enquiries: matt [at] mattshango.com. In 2017, pantera reported a 25,000% return and in 2018, a loss of 41% against all its investments. Du kannst neue Transaktionen ber das "+"-Symbol rechts hinzufgen oder auf "" klicken, um Transaktionsdetails anzuzeigen oder den gesamten Vermgenswert aus deinem Portfolio entfernen. In order to use the new CoinMarketCap portfolio feature, all you need to do is either. Wenn du auf die anderen Daten klickst, wirst du auf die Detailseite der Transaktionen weitergeleitet. You now have access to the CoinMarketCap API. 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! 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. Portfolios let you track your Crypto purchases, by sharing their performance, gains, and losses over time. 2. This page also allows you to edit transaction details, or remove any unwanted transactions. Can you please share the exact request URL you're using so I can test it? Hey Nicolas, sure, you can put all your symbols into one cell (e.g. I don't think CoinMarketCap provides historical daily info for all coins at once. Otherwise, how about using the preset template in this article? 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? trying to pull in wonderland TIME and its pulling the other one.. Can you help. Now it's ok. How can we add names of multiple coins and get data of the coins? We've since remedied the issue, and we are seeing a dissipation of 403 errors. We can confirm that there was indeed a 403 error due to some backend configuration issues on our end. 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. To do? Hi Kyle, sorry! I want to create a spreadsheet where i have the overview on my coins and their current values. 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. great article, i just wanted to know can we create forecast report using live price which will automatically update ? I was writing to you in case you can guide me to capture the different markets for one or more currencies. 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. Wenn du zur Portfolio-Seite gehst, siehst du ein Feld mit deinen Portfolios darin. Hey John, you can use the /v2/cryptocurrency/quotes/latest endpoint. Get Cryptosheets for Googlesheets *Note: you must have one of the supported versions of Microsoft Office or Excel for custom functions to work. If a symbol on CMC is duplicated, how do we pull in the Symbol by ID instead? Alternatively, you can run your own custom requests instead of using API Connectors pre-built integration, using any of the API URLs shown in the APIdocumentation. Mach dir also keine Sorgen, etwas zu verpassen, wenn du unterwegs bist. Hi I think this is the issue mentioned in the article under the header "latest quotes for BTC and ETH, converted to euros". May 26, 2021 236 Dislike Share CoinMarketCap 377K subscribers We are going to take a look at CoinMarketCap's new Portfolio feature. By default API Connector will return whatever the API sends back. I see the problem, if coins have a lot of tags, it's possible they may produce too many columns and go outside the bounds of the VLOOKUP. Like this coin for instance: "https://coinmarketcap.com/currencies/metawars/". [App Download]IOS : https://apple.co/3dOkokHAndroid : https://bit.ly/3gHyJkS[Join CoinMarketCap]https://bit.ly/3dVaEoS[Follow CoinMarketCap]https://twitter.com/CoinMarketCaphttps://www.facebook.com/CoinMarketCaphttps://www.instagram.com/CoinMarketCaphttps://reddit.com/r/CoinMarketCap[Subscribe Newsletter]https://coinmarketcap.com/newsletter/ All of a sudden 1 coin came up with a wrong / duplicate symbol, hence pulling in the wrong price. All the best for you and your assets! What can I do to get dexit finance values imported? Actually, strangely enough CoinMarketCap requests are still working fine for me. Click on the email to verify your account, and you'll be redirected into your new CoinMarketCap dashboard. Join us in showcasing the cryptocurrency revolution, one newsletter at a time. Available for import via both desktop, iOS, and Android 3. Id = 9180 & convert_id = 2781,2790. Any workaround?.. If you want to learn more about Watchlist, please click. I tried it with the template sheet out of the box. You can create multiple portfolios on the CoinMarketCap desktop site and mobile app. When i tried to put symbol and id in the same URL, it gave an error. I tried your set of symbols and saw the following error returned in the status bar: "Invalid value for "symbol": "MLT"). 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. Hey Ana, yep, this was exactly what caused the problem! Quite a lot of people are reporting this error right now, you can see some more reports in our user forum here. Oder vielleicht kannst du dich einfach nicht mehr daran erinnern, wie viele du besitzt und wo du sie platziert hast! If you have some crypto investments, you probably bought them from a few sources: perhaps you bought BTC from Coinbase, bought BNB from Binance, and then maybe bought many other coins or tokens from different exchanges. The error comes from CoinMarketCap, so unfortunately there's nothing we can do on this side besides report the error to them through their contact form. your article helped me a lot. Do you think it's spacing? I want to sort API with filter: Marketcap $10M - $100M and 24h Volume ($10M - $100M), You can add filters to the /listings/latest endpoint. Read about how we use cookies and how you can control them on our. sorry my technical english isn't so good Hey Florian! How much does it cost to use the CoinMarketCap API? We don't have a button, but you can refresh your requests through a checkbox if you run your requests through the IMPORTAPI function: https://mixedanalytics.com/knowledge-base/importapi-custom-sheets-function/. Jetzt setzt sich mein Guthaben aus 79,24%, Du kannst so viele Vermgenswerte "beobachten", wie du willst, ohne einen dieser tatschlich zu kaufen. I think this custom request URL should work, please check: https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?market_cap_min=10000000&market_cap_max=100000000&volume_24h_min=10000000&volume_24h_max=100000000&aux=num_market_pairs,cmc_rank,date_added. It was working before but not sure why it does not work now. Please see this article for examples: https://mixedanalytics.com/knowledge-base/api-connector-create-api-request-based-on-cell/. Dies ist der Privatsphrenmodus, in dem du die wichtigsten Werte wie den Gesamtsaldo oder einzelne Vermgensbestnde verbergen kannst. So maybe you can check or post in there for more info. ", "elapsed": 0, "credit_count": 0 } }, Please make sure you've included your API key in the headers section, with Key = X-CMC_PRO_API_KEY, Value = your API key, I'm also getting an error 'Attribute provided with invalid value:', In the header box I have this: Key = X-CMC_PRO_API_KEY, Value = my API key. Daher ist ein gutes Tool, das dir dabei hilft, dieses Chaos zu beseitigen, sehr wichtig. Thanks for the reply ! How to get data from the CoinMarketCap API into Google Sheets? 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. At the time of writing this resource, they offer manual addition of a coin which you can track, and see the profit/loss. So you'll need to switch to an ID-based request. If you have purchased crypto investments from multiple sources, you can now see them all in one place, right on CoinMarketCap. Have been using the paid version. If that's still not enough, you can combine it with the start parameter. Please check the documentation link as it describes their requirements for access (you'll need a paid CMC plan). Hey Guillermo, sorry, I'm not really sure what your question means, but it looks like people might be discussing it here? You don't need to do anything extra, as logo is already included as one of the fields from your original request URL. Cookie Notice Can you please try that and see how it goes? Holst du dir unsere CoinMarketCap-Apps auf dein iOS-Handy oder auch auf dein Android-Phone? Are you seeing something different? Hello! Please copy it again and you should see the updates (you'll need to import the new JSON file too). Matt Shango. Hello - I have been using this for a couple of months but now it is no longer working. Hover over the API Key box in the top left and copy the key to your clipboard. I discover the CoinMarketCap API and that should do it. 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! Cookie Notice thanks! In this case, I need CRP for CropperFinance, not Crypton. If you have found a solution could you explain it and how I can solve it . Is there a specific query for that. Follow the steps below to get started: Dezember 2020 auch Ethereum im Wert von 593 USD gekauft. By default, only 100 records will be returned unless you set the, With API Connector you can loop through multiple pages of 1000 with offset-limit. Dieser Artikel ist ausschlielich zu Informationszwecken bestimmt und darf nur zu Informationszwecken verwendet werden. To import coin data follow the steps as described below: 2.1. Please enter it like this: https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?limit=1000&convert=EUR&CMC_PRO_API_KEY=yourapikey Alternately you can run it like shown in the article, with the API key entered into the Headers section. I'm not sure why the second one didn't work. Pipedream's integration platform allows you to integrate CallHub and CoinMarketCap remarkably fast. In my own tests the timestamps don't differ from API Connector's own timestamps by more than about 30 seconds. Starting with "step 3 - there IS NO API key value provided ANYWHERE. Hey Daniel, I'm glad this works for you. I changed it to the coins what hold in my portfolio, but I faced 2 problems: 1. supply of 10,000,000 PORT coins. https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=ADA,ALGO. Thank you so much for the follow up, Hello Ana, Congratulations on your work. I see, in that case I think you need to use the slug instead of the symbol. Right now I'm running this query: https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=MIST&convert=USD, but it's pulling the wrong MIST. Don't forget to name the script clearly. Can you please add a timestamp (located at Output Options > Add timestamp) and compare the API Connector timestamp to the server timestamp? When you click again on the icon, it unlocks the privacy mode and shows you all the data available. Which endpoint are you using? the endpoint that I am using is cryptocurrency. unfortunately none of these URLs works. How do you add trade history to your coinmarket portfolio? Portfolio hilft dir dabei, all deine Asset-Investitionen an einem Ort zu verwalten und nachzuverfolgen, whrend Watchlist dir einen Ort bietet, an dem du Assets, die dir besonders aufgefallen sind, mit Lesezeichen versehen kannst. 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. Can you please refresh your sheet and try again? I tried it again this morning and still failing with that error. How do I return URLS only for all of the crypto currencies ? Therefore, a good tool to help you tidy up this mess is very important. Privacy Policy. Along with the current balance, you can also view a line chart showing the balance value changes over time, and we provide a few timeframes that you could use. Klicke einfach auf die Schaltflche "+ Neu hinzufgen" und befolge die oben genannten Schritte! Hi Alex! 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. For example; Aion, WAX and Peerplays are all not there, even after I had imported over 1000 coins. If you provide content to customers through CloudFront, you can find steps to troubleshoot and help prevent this error by reviewing the CloudFront documentation. The timestamp from API Connector should match the time you made the request, if not please double-check your sheet locale. Hi Ana, could you maybe elaborate on this solution. You can also check the summary stats of your investment from the Statistics tab. In the parameters section, select auxiliary fields to retrieve. Is there something I am doing wrong? Now on the CMC Android app, you can see the prices of your top coins follow you around our site. Thank you so much for your quick and helpful response! https://pro-api.coinmarketcap.com/v1/cryptocurrency/info?id=300 returns meta on 1 coin only. If you're looking for a free solution you can check some other crypto APIs, e.g. Inhaltsverzeichnis Was ist das CMC-Portfolio? Is there any tool that could retrieve trade records, and mirror them from one to the other? Once you navigate to the portfolio page, you will see a box with your portfolios in it. is there a way to export all coins in order to filter on market cap, circulating supply, volume? I was able to set this up in my spreadsheet in no time at all. 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. Input manual transactions both through desktop . Is there a wau to do that? I have put all these into Inputs tab. Du wirst nun zur Hauptseite des Portfolios weitergeleitet. CoinMarketCap could temporarily or permanently suspend accounts from being able to post, comment, repost or share any messages from the CoinMarketCap discussion feature if community rules are repeatedly violated. Mchtest du einen neuen Vermgenswert oder einen neuen Transaktionsdatensatz hinzufgen? The concepts of Portfolio and Watchlist, from CoinMarketCaps point of view, are totally different. For some reason I am not getting anything for this project. I just tried that URL and it worked for me. When I put in the parameters it skipped from coin#100 to coin #1000 and then continued from there. The coin ranking is constantly change so basically except the top 2 coins all the other prices change as well and i have to manually change it each time. Do they? Thanks Ana. I read almost your comments and feedbacks. In the value box next to it I have: application/json. 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. Hey Amanda, I would just pull the data into a 'raw data' sheet, then use Google Sheets' VLOOKUP or MATCH functions for this, that way it doesn't matter if the source rows get rearranged (the source rows will always get rearranged since sort order changes between pulls). 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. ber die Registerkarte "berweisung" kannst du auch eine Transaktion der Art "eingehende berweisung" eingeben; das sind Geldbetrge, die du zum Beispiel als Geschenk von einem Freund oder deiner Familie, als Gehalt von deinem Chef oder aus anderen Grnden erhalten hast. I am in hurry as my subscription to coinmarket will end in 7 days. However, there are many critical coins that are not being reported. But I have some formulas put in the Page 1(limit 5000) and these formuals are lost when I select Overwrite.Could you let me know how to fix the update issue by having Append option as I don't want to loose my Customer formulas added in page1. If you would like to know where to buy PackagePortal at the current rate, the top cryptocurrency exchange for trading in PackagePortal stock is currently ZilSwap. Wir bewahren nur diese Daten fr dich auf und fhren Analysen fr dich durch. Dieser Artikel enthlt Links zu Webseiten Dritter oder anderen Inhalten, die ausschlielich zu Informationszwecken dienen ("Webseiten Dritter"). I hope that you can help me about API. We auto-populate the price as of the timing you entered this modal, but you can still change the price accordingly. I tried some tests with the recommanded endpoint (specific crypto), but I can't find all the crypto I want on the list. I did this and it is working! Because I mainly invest into new/startup coins, usually they have "self reported" marketcap, circulating supply, etc. #excel #cryptocurrency #coinmarketcaphttps://theexcelclub.com/how-to-connect-excel-to-coinmarketcap-api/**brave verified creator**Learn how to connect Excel . Verkaufen: jede Transaktion, die angibt, dass du eine bestimmte Menge an Vermgenswerten verkaufst. So whichever method you choose, looks like you'll need to run multiple requests to retrieve all the data. We will create a request to import prices from CoinMarketCap. When you make a spreadsheet you usually dont want to reference cells directly, since its pretty normal for source data to move around. Hi! Anyone else got this problem? However, Google sheets is not working or updating because of this error. Also, their API documentation says 400 (Bad Request) = "The server could not process the request, likely due to an invalid argument" which implies a misconfigured URL, but I don't see any problem here. Can you please tell me how should I use this tutorial to see all the recently listed coins on CMC? Hey Bjohanna, I just tested the file and it worked fine on my end. That's a paid endpoint, but you can also find similar free data in other crypto APIs, e.g. Here's one article about how VLOOKUP works: https://exceljet.net/excel-functions/excel-vlookup-function. Step 2: Add the script. 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 . Update: you can now use API Connector's visual field editor to simply select the columns you want to see. Free for developers. I've added all my USDT purchases made through P2P. ahhh thanks a lot, i made a little bit of digging myself and found the googlefinance method! I have the same problem, even if I modify the request it doesn't work. So verwendet man das CMC-Portfolio Schritte zum Erstellen eines CMC-Portfolios Schritt eins: Fge eine "Kaufen"-Transaktion oder eine "eingehende berweisung"-Transaktion hinzu Just putting in my key returns the error Brad mentioned above. I almost get using Excel but the perfomance is horrible when i try to get the top 100 coins with their respective pairs. I think I need to see your sheet to help troubleshoot your issue. You need a different API key when using their sandbox environment, which you can get . But it's shown almost no sign of emerging from a free-fall in trading on the parallel foreign-exchange market, where it crashed to a record 90,000 on Wednesday. They sound similar, and you may wonder why we bothered to separate these two features. Du kannst deine Watchlist sogar ffentlich machen und sie mit deinen Freunden teilen. Auf der Desktop-Seite von CoinMarketCap kannst du mehrere Portfolios erstellen (bald auch mobil!). so i have done everything perfectly but i wanna add an extra something. This was super easy. So instead of https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=GRT you can use https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?slug=the-graph. Thank you so much for checking and your reply. Join the thousands already learning crypto! Reddit and its partners use cookies and similar technologies to provide you with a better experience. Hey Sergio, what does the error message say? 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. The CoinMarketCap is a free-to-use cryptocurrency API on RapidAPI when you register for an account (also free!) Deinen aktuellen Kontostand, Diagramme und eine Zusammenfassung. 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. Thx! Does that make sense? Their documentation says "Alternatively pass one or more comma-separated cryptocurrency symbols" so unfortunately I think it's just one or the other, you can't mix and match. Awesome tutorial. https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?convert=EUR. You can also input a transfer in transaction from the Transfer tab, which indicates funds transferred in as gifts from your friend or family, salary from your boss or for any other reasons. You need to use IDs or symbols, you can't mix and match. Du kannst auch den besten Performer und den schlechtesten Performer unter deinen Vermgenswerten finden und deren individuelle P&L + P&L % sehen. DataSource.Error: Web.Contents failed to get contents from 'https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=ADA,AGI,ALGO,ANKR,ATOM,BAND,BAT,BNB,BRD,BTC,CEL,CSC,DAI,DOT,DSLA,ENJ,ETH,FLR,Gzil,HBAR,HOT,ICX,LINK,MATIC,NPXS,OCE,ONE,PAC,POLX,QNT,RSR,SNX,STMX,TFUEL,THETA,UBX,VET,VTHO,WAN,XDC,XLM,XRP,XTZ,ZIL' (400): Bad Request Details: DataSourceKind=Web DataSourcePath=https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest Url=https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=ADA,AGI,ALGO,ANKR,ATOM,BAND,BAT,BNB,BRD,BTC,CEL,CSC,DAI,DOT,DSLA,ENJ,ETH,FLR,Gzil,HBAR,HOT,ICX,LINK,MATIC,NPXS,OCE,ONE,PAC,POLX,QNT,RSR,SNX,STMX,TFUEL,THETA,UBX,VET,VTHO,WAN,XDC,XLM,XRP,XTZ,ZIL. one more question. CoinMarketCap is now showing crypto exchanges proof-of-reserves on our ranking pages. Hey Van! 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. 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. Appsheet changed something, and they don't support anymore the free plan. 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. 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. Hier zeigen wir dir den Gesamtgewinn/-verlust deiner Kryptoanlagen zusammen mit dem P&L % (Profit&Loss, Gewinn- und Verlustprozentsatz) seit Beginn deines Kaufs. Did you have any luck? Du kannst mit der Erstellung deines Portfolios beginnen, indem du auf "Portfolio erstellen" klickst. I just tested and those IDs seemed to work fine on this side. Your current balance, charts and summary. Franais. What if I just want USD price, 24h % and 7jd % for a list of coins defined by their ID (because symbol is sometimes the same for 2 coins)? Die Daten werden ber die verschiedenen Plattformen hinweg vollstndig synchronisiert. I have used many thing but is just not working. 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. Then you can apply your formulas to that second sheet, and won't lose your formulas when the data refreshes. Thank you for providing code that works. Thanks Ana for your quick response. This is the privacy mode in which you can hide the most important values such as total balance or individual asset holdings. 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. My data does not update. Under the Data tab in the ribbon, select Get Data > From Other Sources > From Web. Want to add a new asset or new transaction record? Not totally sure what you're referring to, which endpoint are you using? Keep track of your profits, losses and portfolio valuation with our easy to use platform. First of all, thank you very much for the tutorial as it has helped me to understand the CoinmarketCap API. Integrated new features into a platform that supports application development at high level for users. Their support is fantastic, and best of all, everything is free for those with few transactions. Yeah, check out their endpoint for metadata, it returns social links and other info: https://coinmarketcap.com/api/documentation/v1/#operation/getV2CryptocurrencyInfo. Thank you so much Ana, that worked. Hi, I tried you URL as above and the result is displayed horizontally. Scoopnest. I'm the senior product manager at CoinMarketCap. So putting https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?limit=5000 as the API url doesn't work. Connect and share knowledge within a single location that is structured and easy to search. Join the thousands already learning crypto! I've mostly only been trading on Binance. when i put these in the inputs sheet, it returns N/A in the summary? 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. 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/. I've sent your site to a few friends as well. The ability to add notes could also be a very strong tool to use, as you can note down which exchange you purchased the crypto from, so in the future you want to sell youd know where to go to! Tried this one, but it's still not working Hmm, that's odd, what kind of error do you get? At CoinMarketCap, we really do listen to our users. Thank you very much! Hi Ana. Step 1: Setup the CoinMarketCap Web Request in Excel To pull the data into Excel, we use a web query. I'll update the article to reflect this. You can start creating your portfolio by clicking Create your Portfolio.. Hey Alex, you can run https://pro-api.coinmarketcap.com/v1/cryptocurrency/map to see all coins and their IDs. Anyway I tried your URL in API Connector and got the following error message: "error_code":400,"error_message":"Invalid value for "symbol": "AGI"" So it looks like AGI is no longer valid. Ana, First of all, i would like to thank for your very informative articles. Please check this comment for info on using the ID instead of symbol. Then copy it all the way across the row and the data should populate correctly. 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.