How to connect Excel to Coinmarketcap API for Up to date cryptocurrency pricing 

Investing with expert Nora has been the best step I have ever took in my life, may God bless that day I meet her

if you want to see like in coin market cap start from @10:40 thank you so much

I thanked you few months ago, and i'd like to thank you again. And, I will thank you again and again whenever I come back to this video ...

After a lot of problems with binance api import in spreadsheets. This is the best solution! Used the same method but with Binance. And works perfect!

This is a splendid effort. One of the most complete, concise and informative tutorials I've ever watched! Thank you.

Can't thank you enough. You've literally saved years of my life. Really appreciate the efforts you have done to prepare this master piece. Thank you!

oh my god, thank you! i was opening up my exchange every time just to fill in some excel data, but this is soooo much better! im learning excel at the moment and this gives me just the right motivation, hehe! i got the data in now, from a different API, but your example showed me how to deal with APIs in general. :) awesome, thank you very much!

Thank you!!! Good contribution, I was looking for this information and of the 34 videos I have seen, none explains it as you explain it , much appreciated. Thank you very much.👋👍

Hi Paula! No obligation for you to answer this and you'd probably need more information anyway but when I hit enter (after adding the URL and relevant header info to the web data) power query looks like it's launching but all that shows is an entirely transparent box with no distinguishable text or data inside. Unlikely you've seen this before but I thought I'd mention it incase you had a fix. As a side note, I actually use powerbi almost every day at work so I'm a little confused :D

Excellent explanation. The best I've seen on the Internet. Thank you very much.

Very clear explaination mam. thanks a lot...

hi paula sorry to go OT but just seen your vids on your API's; what an astonishing piece of work; you are so gifted and humble to share it with us. i was wondering if you could help me please? can you point me in the direction of a simple API guide to pull ether: Block Time, Block Reward, Last Block, Network Difficulty Market Cap, Market Volume, Mining Pool Hashrate in to a spreadsheet? many thanks in advance

Thanks Paula. I've been looking for how to do this for a long time.

It's great. I'm really excited to practice with your video. In case I would like to load more than 100 coins. Do you know how to do that? Thank you!

Excellent video which has allowed me to create a very effective live Crypto tracking tool. One question - what's the most easiest way of adding a ticker symbol to the first query (say you want to add another coin holdings), without having to recreate the whole table again?

Thank you very much Paula, that helped a lot.

Thank you for making great videos

Thank you so much for making this video. I nearly gave up after several days trying to get the actual price in the sheet (in euro's). By showing to press quote twice .... and by using "convert=EUR" ❤️

Hi Paula thank you so much , it was easy and helpful 💚🙏

Thank you so much for providing this very helpful and crystal clear video for free! You got a subscriber!

How can add more coins to the list ?

This is a great video and I was able to get the download to work even though I am not overly proficient with this type of thing.. I do have a question that is asked a few times below, but I don't see any answers. Is there a way to have it automatically download more than the top 100 crypto prices?

Thanks Paula. Very interesting. Thumbs up!!

Thanks! Your patience is just amazing - explained each link from start to end

Thanks so much for putting this up. A question, how do i pull out more than 100 data thru this API.

Великолепно! Огромное спасибо за этот мануал!

So once you set this up for say 5 cryptos, how do you add a 6th one to your table? Does not seem to be a straight forward way to do it?

Very helpful, Paula. Thanks a lot 😀

Excellent But i have a qustion How can get and export to excel all coin in coin narket cap not only 100 best I appresiate help me🙏🧡

Thank you !!!! I have learned this key element to get external data, and succeed

Thank you, this has been a great help!

Hello, thank you for your video, is it possible to also have ATH with date and ATL with date?

Thanks for nice video.

Love it

Hello, I'm French and it's not obvious when you haven't been attentive at school, I made the unfortunate observation today. your video has nevertheless been a great help in organizing my investments, however I would like (the icing on the cake) to be able to see the current prices in EUR and not in UDS. could you tell me how to proceed? my scientists thank you for your work

Great job Paula!!! Thank you very much.

Paula, you are great!!!!!!!!!!!

great video, it makes my work much easier ;D you should show us that we need to accept everything as anonymous it was the only thing that I struggle :)

Dear sir, Appreciate your help and wonderful explanation. Just one more thing that I want to finalize the prices of any cryptocurrency for all platforms So, how can get this inquiry... Please your efforts... As this option is available in coinmarket but i don't know how to export it to Excel ...

Incredibly helpful. Thank you so much for sharing your knowledge with all of us!!

Getting error on connect, says “‘X-CMC_PRO_API_KEY’ header is only supported when connecting anonymously

Paula - well done on this video.

Excellent !! Wish I saw that sooner, all good tho, many thnks!!

Nice video. Thxs for that. I have 1 question. I know how to convert to EUR but is it possible to get in a table as well EUR as USD? or is that not possible?

The best excel crypto drawing video I've ever watched. Others are normal on the web, but the "API" offers features with a full range of professional options. I think the API we got with our coinmarketcap site membership offers limited withdrawals. Ex. Can you recommend an unlimited api source that I can get an update in 5 minutes? Health for your labor. Thanks. It was good that I discovered you. Achievements.

Was anyone able to use convert=BTC & USD at the same time? No matter what different separators and ways I use I can't make it work. I have to choose one or another.

wow, great tutorial! Is it possible to make the table with more than the first 100 tokens?

Exactly what I needed, and so clearly explained. Subscribed. Thanks!

Hi Paula, I'm using Excel 365 on a MAC. It doesn't give me an option to get data, FROM WEB. How do I enter my API header, Key, etc? The only Get Data options that are available are: from HTML,Text, SQl, Database? Apple Mac version on Excel 365 has slightly different menu options

Thank you Paula spent 3 days looking for this info.

Many thanks for the detailed explanation. Greatly helpful.

Excellent video and step by step guidance. Amazing effort. Thank you. Quick question, I am running Excel version 16.43 and it seams to me that there is no Go To Web function or button. Any suggestions ?

How to get OHLC prices hourly in excel sheet everyday at certain time?

Hi. How do get the prices to display in GBP (British pound sterling) instead of USD (US dollars)?

how can I get the top listings converted to another currency, Thank you

Is there a way to pull the first 2000 coins? Can you provide a URL please?

OMG I was looking this so bAD. Thanks a lot, You have a new subscriber

what can you do when multiple currencies have the same symbol?

Can you do this on Macs? Unfortunately Macs don't have the connect from web feature and can't seem to link the api :(

good job

Awesome! Thank you

You left out a step after entering the API key. Another dialog box appears asking to "Select which level to apply these settings to..." (using Excel 365).

AMAAAZING!!!

Thks u very much P.G

Would be interesting how can be create such connection with Binance. Seems there is more complicated to connect in such way.

What would be the api call to retriev the data of the cointmarketmap Portfolio?

Really well explained :) Helped a lot!

Brilliant, Thank you this is very very helpful

A very well put together video. I can't thank you enough!

Is there a way to use the API key in Excel on MacBook?

Hi Paula, when extracting data with the coinmarketcap API, only the first 100 coins are listed. How can we withdraw all coins or the first 300 coins?

Hello Paula. Help me with the calculation formulas of the price sheet, totals. Thanks in advance!

I have Excel for MAC which does not have this. How can you do it on Excel for MAC?

How can I scrape the category data from Coinmarketcap? I already tried it with tag and both category options, but nothing is working.. If I want to extract all coins from Animoca Brands, what would I have to do for it?

Thank you for the amazing video!!!

Hi, someone can help me please with the CMC API ? I made a request to get informations about a currencie but it have the same ticker as another and I get information about the second one, how can I select the currencie I need please ? thanks

Can you also do this on a Mac?

hello i couldn't find the first url, can you leave a link help, please

Help me with the calculation formulas of the price sheet, totals. Thanks in advance!

Hello Paula, Thank you so much for this, ive been searching for days for this. I managed to pull this but when i link the price cell from the sheet the table is in to the cell in my portfolio sheet it links a different cell everytime it updates. any help with this will be much appreciated. Best

Really excellent tutorial. I have completed my first API query :) Just a little snag. The values such as price, % changes columns, and 24 h volume have different values than Coinmarketcap website. Not a rounding error since the differences are larger than that. For example, on ETH the % change 1h on query = -1.95% but webpage shows 0.34%. Any ideas please? Thank you

best tutorial ever seen. Great!

Hi Paula. Really helpful since I am new to this. One question: Do you know if it is also possible to retreive all the data within a range of market cap? For example, all the coins ranging between 5 and 10 mln market cap?

I have a crypto (CELO) in my portfolio that has just dropped out of the top 100. Yesterday it was jumping back and forth between #100 and #101. Is there are way to have more than the top 100 in my query? I have found that there is a "limit" parameter that can be used to specify the number of records to pull. Can I put this parameter and the convert parameter in the same query? If so, I am not getting the correct syntax - I am getting an error back when submitting the query.

Hi Paula, is there a way to lock the rows of the cells? When I refresh the chart, some coins move up and down, depending on increase in market cap, which ruins my chart that I link the data to. I either need a way to make the chart not move (not in order of market cap) or make it so my linked cells move with the moves in rank, but not sure how

can you provide the excel sheet? : )

Hi mate wondering if you could help me out, i have imported web data onto another sheet, when trying to multiply my vlookup cell with another cell value the Value error appears how can i resolve this thanks?

This is a great tutorial. I can get data for all my coins but I cannot seem to find the ID for shiba inu at coin gecko. Can anyone help me out with this?

Hi, I have been trying to follow your steps but the listing part cannot work. i seems to be getting only 3 rows instead of 100 listings. is there a free api that shows entire crypto listings or at least 300?

Can I get price Stats from coinmarketcap with a basic plan?

Hi Paula, great video! Thank you :) I do have 2 questions if thats OK, 1. When I get the live data and put it into excel some coins are shifting rows after a while, is there a way to stop this? For example if I am trying to compare purchase cost vs current value for BTC I want link the live BTC quote from the API sheet to my dashboard sheet (eg Dashboard sheet D7 = API sheet C4) when it is first linked it works a treat but after the row shifts it shows values for the wrong coin. In this example API sheet C4 is no longer the quote for BTC it is a different coin say BCH My assumption is that its because when the data is refreshed the top 100 come back in an updated order. Url I have been using: *pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest?convert=GBP 2. Is there a way to link more than one command on the URL? Part of my trying to solve problem number 1 was to use the manual input of the coins like you showed on the initial part of the video e.g. (pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=BTC,ETH,ADA) Only problem with this is that it comes back un USD not GBP I tried to add the convert function but it just comes up with an error (pro-api.coinmarketcap.com/v1/cryptocurrency/quotes/latest?symbol=BTC,ETH,ADA?convert=gbp) Would either of these solve my problem? Apologies if I've explained poorly I'm happy to clarify if necessary, I'm very new to this. Cheers, Josh

Thank you for this excellent video and your clear delivery. I am using Excel 2010 - although it has an Import from Web feature - it does not have the settings you describe at 05:25. I presume this pocedure will only work with Office 365?..... not even Excel 2013 .....is that correct?

great simple and straight howto

Great video!!! But my I have a Mac and my excel does not have the "DATA > From Web option" :( Do you know how to do it in a Mac? Thank you!!!

Hi Paula, thanks for the video. I've already loaded the data table and have referenced my 'current price' cells using the formula ='Table 0 (2)'!Dx. The problem is, when I refresh my data, the coins that have moved up/down in the rankings, then give me different values. Sorry for the novice query but, could you suggest a fix please?

Thank you for this video. Any idea what I would do if two tokens have the same symbol. i.e TRADE. I'm after PolyTrade, however the api pulls in data from Unitrade. Is there pro-api where I can pull data in by 'name' rather than symbol. And will it find it if it's not in a top 100 crypto. Many thanks!!

hello. I have a sheet with prices in BTC of first 100 coins (top marketcap) - I need add another coins, but I can't! How I can do this? Thank you..

It does not work anymore. I think they changed something

Totally skipped over how to supply your newly acquired API key.

I respect the work you put into your videos. I find it really baffling that all the major crypto RU-vidrs are just looking at pure waves and completely ignoring the broader narrative of why BTC is pumping and why the future outlook may not be as optimistic as it seems. It's kind of irresponsible to ignore the fact that every ETF launch so far has caused a major spike in BTC's spike. Already on shaky ground with historically low volumes and near-pure whale pumps, we narrowly avoided a long-term bear market. This is the worst time in history to invest as so many are not backing up their crypto assets. Day trading should be given more attention as it is less affected by the unpredictability of the market. I made over 11 BTC from day trading with Christoph Hoffmann insights and signals in less than 2 weeks, along with the people around me Extreme success with Mr Christoph Hoffmann day trading signals. This is one of the best tools to protect your wealth in case it starts to decline. ͲeIєɠɾαm👉 Christophsignals..