You'll see a formula like this: =arrayformula(if($B$9:$B<>"",iferror(vlookup($B9:$B,Data!$D:$AZ,match(E$7,Data!$1:$1,0)-3,false),""),"")), Change the AZ to ZZ, like this: =arrayformula(if($B$9:$B<>"",iferror(vlookup($B9:$B,Data!$D:$ZZ,match(E$7,Data!$1:$1,0)-3,false),""),"")). Is there a way to get this data only for BTC and ETH, and historic? I'll try submitting a contact form to CMC. Thanks for such a great post. I see info for, say, Enjin Coin with a URL like https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=ENJ. Born from Shiba Inu, Shibcat is a state-of-the-art cryptocurrency firm that offers a play-to-earn game, Shibcat NFTs, dApp, and a decentralized exchange. Join us in showcasing the cryptocurrency revolution, one newsletter at a time. Setup the CallHub API trigger to run a workflow which integrates with the CoinMarketCap API. and our How can I build an endpoint to call, for example the BTC and ETH, symbols and logos at the same time? 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. 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. Just used an API key on blockfolio to import all my coinbase transactions and holdings. 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. and if yes what's the exact code i should type in the app? The data we will be connecting to is stored as a table on a webpage and is not an API endpoint like the Ticker data. 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. Do you have a suggestion? Which endpoint are you using? [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/ The views and opinions expressed in this article are the authors [companys] own and do not necessarily reflect those of CoinMarketCap. Just putting in my key returns the error Brad mentioned above. There is no shortage of ways in which geopolitical risk can affect a portfolio. I succeed in import one or many quotes. Launch the Crypto Pro app; Go to the portfolio you'd like to import trades to; Tap on the '+' in the top . Auf der Desktop-Seite von CoinMarketCap kannst du mehrere Portfolios erstellen (bald auch mobil!). Sorry, I didn't test these first as I don't have a paid CMC account. Using the CoinMarketCap API, you can view: The Price The Market Cap Volume (in 24 hours) Circulating Supply (over the last 24 hours) Trends in price (over a day, a week, or a year) for each cryptocurrency enlisted on the CoinMarketCap website. Now on the CMC Android app, you can see the prices of your top coins follow you around our site. 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. Can you please try downloading the import file again? After some back and forth, I received this response from CMC: Thanks for your patience. All the best for you and your assets! CoinMarketCap. just wanted to ask if there's a way to get all the coins listed which have a market cap of $5M - $10M, Sure, you can check their documentation about it here: https://coinmarketcap.com/api/documentation/v1/#operation/getV1CryptocurrencyListingsLatest Basically you'll need to enter a URL like this: https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?market_cap_min=5000000&market_cap_max=10000000. Which URL are you using? If that isn't clear, feel free to share your sheet with edit access, I can then help you in your sheet directly. Have been using the paid version. The easiest way to get started with the CoinMarketCap API is through API Connectors built-in integration. hi. In your Google Sheets file, select Tools > Script editor. Tools using : Vue.js, Hapi.js, JavaScript, APIs, Bit Bucket, JSON, GIT, JIRA, confluence . unfortunately none of these URLs works. Check the section above called "Handle Pagination" for information on how to set that up, or feel free to respond if you'd like further clarification. 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. Get the API link for your coin of interest from the website I mentioned at the top. 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. Due the low request rate, I recommend you to test your application in a sandbox environment. 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. but the time stamp of the data is always old not the actual time I make the request. If you have found a solution could you explain it and how I can solve it . Thank you. sorry my technical english isn't so good Hey Florian! I'm not sure why the second one didn't work. 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 The current balance is using your current asset holding amount X current price to calculate. Compare CoinGecko vs. CoinMarketCap using this comparison chart. Can you please try that and see how it goes? Is the above possible? Bitcoin in my case, will bring you to a page showing the transaction details. As for auto-updating the price, you can check out scheduling. Also it should be ?symbol=, not ?symbols=. 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. Pipedream's integration platform allows you to integrate CallHub and CoinMarketCap remarkably fast. Clicking on the line of one asset, e.g. While it's not as granular as tick data, you can view daily prices, volume , and market cap for a given coin going back to inception. Thanks for the reply ! As far as I can see, these are your options: 1) The Listings Historical endpoint returns all cryptocurrencies on a specific date, like this: https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/historical?Date=2021-01-01&limit=5000&aux=date_added, 2) The OHLCV Historical endpoint returns historical open, high, low, close, and volume data for a list of currencies over a date range, like this: https://pro-api.coinmarketcap.com/v2/cryptocurrency/ohlcv/historical?slug=bitcoin,ethereum&time_period=daily&time_start=2018-09-19&time_end=2022-05-30. Please wait until the process is completed and the page has been fully reloaded. Whle hier eine Coin oder einen Token aus, die bzw. Jetzt setzt sich mein Guthaben aus 79,24%, Du kannst so viele Vermgenswerte "beobachten", wie du willst, ohne einen dieser tatschlich zu kaufen. thanks! 2. Du kannst hier auch den Privatsphrenmodus verwenden, indem du auf das Augensymbol klickst! Mit dem Portfolio von CoinMarketCap kannst du alle Informationen in Bezug auf deine Krypto-Bestnde an einem Ort speichern. I successfully did it. 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. It should do the vlookup, but somehow it is not successful. 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. 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. Bist du neugierig darauf zu erfahren, was dieses Symbol macht? Choose a destination sheet, name your request, and hit, CoinMarketCap limits the number of records returned in each request. 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%. Could you please tell what can I do with it? you can enter a function like =GOOGLEFINANCE("CURRENCY:USDEUR") directly into your cell to see a conversion rate. Hello, Thanks I use this one : https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?limit=1000. Enjoy using our Portfolio and enjoy earning more profits on your crypto! Then you can apply your formulas to that second sheet, and won't lose your formulas when the data refreshes. Hi! I tried some tests with the recommanded endpoint (specific crypto), but I can't find all the crypto I want on the list. I think for this it might be better to check out CoinMarketCap's API documentation, because they'll have the definitive answer on what's available. Yeah, check out their endpoint for metadata, it returns social links and other info: https://coinmarketcap.com/api/documentation/v1/#operation/getV2CryptocurrencyInfo. The timestamp from API Connector should match the time you made the request, if not please double-check your sheet locale. Tokyo, Japan, Feb. 28, 2023 . great article, i just wanted to know can we create forecast report using live price which will automatically update ? I just tried that URL and it worked for me. 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. That was a bug related to (what should have been) a very minor update. For example, https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?id=1&aux=max_supply would send a response without data tags. How can i get the historical data of the coins such as Bitcoin, Etherium and Eth withinin 90 days? I'm the senior product manager at CoinMarketCap. Are you still having an issue? That's a paid endpoint, but you can also find similar free data in other crypto APIs, e.g. Otherwise, how about using the preset template in this article? Your current balance, charts and summary. Neither method is exactly realtime though (scheduling is limited to 1x an hour, and importapi to once every couple minutes). Thanks for this great article. It has many features . Auerdem werden dir die 24-Stunden-Vernderung und die 24-Stunden-Vernderung in % angezeigt. Thank you very much! Could you please contact support so I can take a look? 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. Thank you. Unfortunately I don't understand your quote: "If youre looking for a more dynamic, ticker-like experience in Sheets, check out the API Connector custom function IMPORTAPI() for faster refresh rates. 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. 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. 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. Therefore, a good tool to help you tidy up this mess is very important. There might be too much traffic or a configuration error. I have an HTTP 400 Bad Request in my dashboard. 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? Hier siehst du die Bilanz von Bitcoin auf der Grundlage des aktuellen Preises, der 24-stndigen prozentualen Vernderung und den Gesamtgewinn & -verlust, oder du kannst eine Liste der Transaktionen sehen, die du fr Bitcoin eingegeben hast. My last question is how to get the logo of each one of these cryptos. Wir bewahren nur diese Daten fr dich auf und fhren Analysen fr dich durch. So putting https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?limit=5000 as the API url doesn't work. Join the thousands already learning crypto! Hi I think this is the issue mentioned in the article under the header "latest quotes for BTC and ETH, converted to euros". Portfolios let you track your Crypto purchases, by sharing. Thanks Ana. I'm not familiar with using Excel to connect to APIs so I can't comment on that, but I suspect it's the same issue. I wonder if it's gone over some limit, how many coins are you pulling data for? By clicking on the coin name, it would bring you to our coin detail page where you could take a good look at the coin details, or by clicking on the other data items also brings you to the transaction detail page. We'll first get an API key from CoinMarketCap, and then set up a request to pull in crypto data to your spreadsheet. Request blocked. When i tried to put symbol and id in the same URL, it gave an error. To fix, go to the Summary tab cell B9. Is there a way to modify the request URL so it displays prices in BTC? But it sounds like your table is linking to specific cells, right? DataSource.Error: Web.Contents failed to get content from "https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?id=9180&convert_id=2781,2790" (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? How do I return URLS only for all of the crypto currencies ? 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 Since the symbol isn't unique, you should use the ID instead. Is there a wau to do that? Part 1: Get your CoinMarketCap API Key Part 2: Pull Data from CoinMarketCap into Sheets Part 3: Create a Custom Request Part 4: Handle Pagination Part 5: API Documentation Appendix: CoinMarketCap Crypto Portfolio Template Before You Begin Click here to install the API Connector add-on from the Google Marketplace. Daher ist ein gutes Tool, das dir dabei hilft, dieses Chaos zu beseitigen, sehr wichtig. Can you please add a timestamp (located at Output Options > Add timestamp) and compare the API Connector timestamp to the server timestamp? Can you please share the exact request URL you're using so I can test it? Du kannst auch den besten Performer und den schlechtesten Performer unter deinen Vermgenswerten finden und deren individuelle P&L + P&L % sehen. Du kannst neue Transaktionen ber das "+"-Symbol rechts hinzufgen oder auf "" klicken, um Transaktionsdetails anzuzeigen oder den gesamten Vermgenswert aus deinem Portfolio entfernen. The section called "Fast Cell-Based Refresh" shows how you'd hook up your API call to a checkbox. I don't know why, but for some reason in the Summary Tab the columns percent_change_7d (0 value), percent_change_24h (0 value), last_updated and market_cap remain empty while all the other columns get regular values. Privacy Policy. On the home screen of the Data Fetcher extension, click 'Create your first request'. Privacy Policy. This article is not intended as, and shall not be construed as, financial advice. Well be covering some basics here. 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. Wenn du dir auch die Zusammensetzung deiner Investitionen ber verschiedene Coins hinweg ansehen mchtest, schau dir die Registerkarte "Verteilung" in diesem bersichtsabschnitt an. That will give you the current price of BTC in USD (you can substitute those symbols for other currencies if you like). You can directly import a .csv file to Crypto Pro if you have a backup or a compatible file. 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. I've mostly only been trading on Binance. https://pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=ADA,ALGO. Cheers, EC. Wenn du auf den Namen der Coin klickst, wirst du auf die Detailseite der Coin weitergeleitet, wo du die Details der Coin ansehen kannst. I was writing to you in case you can guide me to capture the different markets for one or more currencies. I don't have any other script running. 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. CoinTracker - 10% Off for my readers. When you make a spreadsheet you usually dont want to reference cells directly, since its pretty normal for source data to move around. If i am using Symbol to pull lets say prices for 100 coins. Next, we need to input the URL we want to use and setup our API key as a header item to authenticate with CoinMarketCap. I don't think anything has changed, I just tested that URL and it worked fine for me. Don't forget to name the script clearly. Join the thousands already learning crypto! I discover the CoinMarketCap API and that should do it. In this template, everything is configured for you to simply add your API key along with whatever currencies you're interested in and get a dashboard like below: When I load the data into google sheets it only loads 100 coins. Die Daten werden ber die verschiedenen Plattformen hinweg vollstndig synchronisiert. I'm wondering how to differentiate between coins with the same ticker symbol (e.g. Do you know if the endpoints has been changed? Matt Shango. If a symbol on CMC is duplicated, how do we pull in the Symbol by ID instead? In order to use the new CoinMarketCap portfolio feature, all you need to do is either. Delete any existing copy. https://pro-api.coinmarketcap.com/v1/cryptocurrency/info?id=300 returns meta on 1 coin only. Only pulls the first hundred. The "best" thing i thought was to take the api for only certain coins but still i would have that problem in a smaller scale and if i wanna add new coins then here we go again. Where does it work? Reddit and its partners use cookies and similar technologies to provide you with a better experience. Ive created a spreadsheet to do the auto updates for me from CMC and it has been working great. One more issue. Hey Daniel, I'm glad this works for you. Is it listed on coinmarketcap.com somewhere? 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. 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 It shows as an example, the bitcoin API link is https://api.coinmarketcap.com/v1/ticker/bitcoin/ 2.2. CoinMarketCap sends back some additional metadata fields in the response, so if you ONLY want to see the price, you could do an HLOOKUP on that field from another tab, like =hlookup("quote.USD.price",'Sheet1'!A1:K2,2,false). There are lots of tutorials online about how to use VLOOKUP, here's one: https://exceljet.net/excel-functions/excel-vlookup-function. Please see my comment here, it shows some examples. 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. That one is still working for me, too. I tried it in my own account and it says "Your plan is limited to 1 convert options" so it looks like you need to be on a paid plan for this request to work. If you find the metrics you want there, and don't know how to pull them into your sheet, feel free to reach out and I'll help you set up your request. How do you add trade history to your coinmarket portfolio? P.S. 2. Is there a way to specify exactly which token I desire? Thank you for your nice comment. I tried it again this morning and still failing with that error. Thank you very much for all the time and effort you put into this. This user-oriented wallet allows investors to safely store Shibcat tokens, remain up to date with their investments, and import other tokens. Create your Portfolio Also available on iOS and Android Sync your data between your desktop and mobile app and keep track of your crypto assets no matter where you are. Schau dir deine Lieblings-Coins und Tokens direkt vom Lock Screen deines iPhones aus an. Hey Cris, please check this article. Hello, first of all, congratulations on your website. 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. Hey Phil, thanks for the message! At CoinMarketCap, we really do listen to our users. The API used to import data into Excel is steadily growing in terms of capability. I've updated the template as well. How do you update the coins list? Deinen aktuellen Kontostand, Diagramme und eine Zusammenfassung. Du kannst deine Investitionen nicht nur ber unsere Webseite nachverfolgen und verwalten, sondern auch ber die mobile App! Copy and paste the content of CRYPTOFINANCE.gs into the page. Top notch crypto portfolio tracking at no cost. With CryptoCompare you can get 90 days of historical data for bitcoin with a URL like https://min-api.cryptocompare.com/data/v2/histoday?fsym=BTC&tsym=USD&limit=90 (please check the linked article for more info). If you have purchased crypto investments from multiple sources, you can now see them all in one place, right on CoinMarketCap. By rejecting non-essential cookies, Reddit may still use certain cookies to ensure the proper functionality of our platform. Thank you for your brilliant work! Hello! as well as CMC have APIs. I'm CoinMarketCap you've probably heard of me. Cookie Notice Thanks, it works fine but how can i filter columns? Input manual transactions both through desktop . The circulating supply is not available and a max. 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. berweisung: eingehende berweisungen von Vermgenswerten oder ausgehende berweisungen deiner Vermgenswerte aus bestimmten Grnden. i wanted to make a dynamic sheet where i will enter the symbol in cells ranges A3:A7 and it gives me respected prices in cell B3:B7 But here I can see that I have to manually enter the crypto symbol. I guess you're running this in Power BI? Crypto Portfolio Manager Free - Top 5 Best Crypto Portfolio Tracker And Management Apps 2020 Reviewed - You can connect all popular wallets, exchanges to your coinstats account, and it will automatically calculate profit.. So i have one sheet in which all the data for the top 500 coins come and another one in which i have my portfolio. Yes i've been reading, but i believe its only possible to do that with a paid subscription to Coin Market, right? Import all: Trades Incoming transactions (income, mining, gifts) Outgoing transactions (expenditure, donations, losses) The import may take a few seconds, if your CSV file has a lot of trades. You can check CoinMarketCap's docs for specifics, but their faq says "Most endpoints update every 1 minute". Do you think it's spacing? You probably know that we not only provide our Portfolio feature, but also another feature called Watchlist. I am not able to match on the coin name or ID and get the values in the second tab. You need to find a solution because we can't use anymore this google sheet. Here's one article about how VLOOKUP works: https://exceljet.net/excel-functions/excel-vlookup-function. The brand new "Introduction to Geopolitics" reading provides a structure for thinking about a wide range of geopolitical issues and assessing their risks. Appsheet changed something, and they don't support anymore the free plan. The concepts of Portfolio and Watchlist, from CoinMarketCaps point of view, are totally different. May 26, 2021 236 Dislike Share CoinMarketCap 377K subscribers We are going to take a look at CoinMarketCap's new Portfolio feature. I would have a list of top 100 market cap coins only on Binance , is it possible ? Mach dir also keine Sorgen, etwas zu verpassen, wenn du unterwegs bist. Subscribe now to get daily news and market updates right to your inbox, along with our millions of other subscribers (thats right, millions love us!) So hopefully the issue is now resolved. This was super easy. Please check this comment for info on using the ID instead of symbol. We auto-populate the price as of the timing you entered this modal, but you can still change the price accordingly. Not a lot of people know that CoinMarketCap also offers a crypto portfolio tracking feature. Then i want a real time converter to change the prices to euro as well. You need an API key from CoinMarketCap in order to utilize this module, you can get a key from here. Thank you. Import CSV File. I had difficulties as well since the data is ordered in a different way after importing. ****Coinmarketcap has changed and you now need a premium API to get historic information on Cryptocurrency. CoinTracker is the most complete portfolio tracker on the market. 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 . Learn more here Wenn du die Kontrolle ber deine Krypto-Investitionen verlierst, kannst du einen unerwarteten Verlust erleiden oder den besten Zeitpunkt fr den Verkauf deiner Kryptowhrungen verpassen. 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. https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?start=1&limit=1000&EUR=CONVERT&CMC_PRO_API_KEY= (MI API). . Connecting to historic data from Coinmarketcap is a little more complex than connecting to the ticker. B. Bitcoin in meinem Fall, klickst, kommst du zur Seite mit den Transaktionsdetails. Update: You can now use API Connector's visual field editor to do this more simply. If I understand correctly, you have a list of coins in one sheet, and want to keep all the data lined up? I have a problem. Lets start! Thanks Ana, I just submit a form to support. I am in hurry as my subscription to coinmarket will end in 7 days. I tried it with the template sheet out of the box. The error message received is the following : ERROR: The request could not be satisfied 403 ERROR The request could not be satisfied. SAN FRANCISCO, March 01, 2023--(BUSINESS WIRE)--Salesforce (NYSE: CRM), the global leader in CRM, today announced results for its fourth quarter and full fiscal year ended January 31, 2023. So maybe you can check or post in there for more info. 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. Connecting Excel to the Coinmarketcap API. Importing portfolios from markets Both Binance/Kraken etc. You ROCK!!! If you can't get it from the API maybe you can try a site like this: https://bitcoincharts.com/markets/. hi Ana, thanks for the article, very helpful. You can do a request to https://pro-api.coinmarketcap.com/v1/cryptocurrency/map?symbol=SHIB,WARS,BTC. The CoinMarketCap API is a method to retrieve cryptocurrency data such as price, volume, market cap, and exchange data from CoinMarketCap using code. Viel Spa bei der Nutzung unseres Portfolios und geniee es, mehr Profit mit deinen Kryptos zu machen! We can pull whatever data CoinMarketCap provides, but I don't know if those self-reported values are different from the "regular" marketcap, circulating supply etc values. Thanks, Khaled! 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. URL: http://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?limit=1000&aux=num_market_pairs%2Cdate_added Server: nginx_dispatcher_rl_0ec5dc4fac2d464d6 Date: 2022/08/13 18:30:45 Powered by Tenginetengine. CoinMarketCap is one of the most popular websites used for tracking various cryptocurrencies and obtaining data about them. You can create multiple portfolios on the CoinMarketCap desktop site and mobile app. The linked comment you're responding to has an example request of how to get the ID for a specific symbol. You'll need to pull from the ID instead of the symbol. Is there any tool that could retrieve trade records, and mirror them from one to the other? Thanks, I don't think CoinMarketCap provides an option to get all at once.