How to connect Excel to Coinmarketcap API for Up to date cryptocurrency pricing
HTML-код
- Опубликовано: 30 июл 2024
- #excel #cryptocurrency #coinmarketcap
theexcelclub.com/how-to-conne...
*brave verified creator*
Learn how to connect Excel to the Coinmarketcap API for live and up to date cryptocurrency pricing right to your spreadsheet.
To get all of the links needed and further details of the URLs used in this video visit the blogpost now
theexcelclub.com/how-to-conne...
**Community Invitation****
- Excel For All - Decentralized and tokenized - Join today
peakd.com/c/hive-102332/about
Grab 50% off Access All Areas Unlimited Excel Training
theexcelclub.newzenler.com/co...
If you want to learn more about Excel I hope you will visit our website
theexcelclub.com/excel-tips/
Sign up to our newsletter
theexcelclub.newzenler.com/f/...
Watch more Excel Videos
• Learn Excel - Playlist
Find out about the Brave Browser and receiving BAT rewards
• Brave Browser Explaine...
Thanks! Your patience is just amazing - explained each link from start to end
This is a splendid effort. One of the most complete, concise and informative tutorials I've ever watched! Thank you.
if you want to see like in coin market cap start from @10:40
thank you so much
Excellent explanation. The best I've seen on the Internet. Thank you very much.
Great job Paula!!! Thank you very much.
A very well put together video. I can't thank you enough!
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!
Thank you so much for providing this very helpful and crystal clear video for free! You got a subscriber!
Thanks for the sub!
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 ...
You are amazing Paula! thank you very much!
Exactly what I needed, and so clearly explained. Subscribed. Thanks!
Thanks for the sub!
Incredibly helpful. Thank you so much for sharing your knowledge with all of us!!
You are so welcome!
Paula - well done on this video.
Thank you Paula spent 3 days looking for this info.
Glad it was helpful!
Thanks Paula. I've been looking for how to do this for a long time.
you are welcome
Many thanks for the detailed explanation. Greatly helpful.
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.👋👍
you are very welcome
Thanks Paula. Very interesting. Thumbs up!!
its a bit niche, but something many people have been asking me for. The cryptocurrency game is not for everyone but this is a great example of how Power query in Excel can be used
Very helpful, Paula. Thanks a lot 😀
Glad it was helpful!
Hi Paula
thank you so much , it was easy and helpful 💚🙏
Thank you !!!! I have learned this key element to get external data, and succeed
OMG I was looking this so bAD. Thanks a lot, You have a new subscriber
best tutorial ever seen. Great!
Wow, thanks!
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!
Really well explained :) Helped a lot!
Glad it helped!
Brilliant, Thank you this is very very helpful
Glad it was helpful!
Paula, you are great!!!!!!!!!!!
Thank you for the amazing video!!!
Very clear explaination mam. thanks a lot...
Thank you very much Paula, that helped a lot.
Великолепно! Огромное спасибо за этот мануал!
Thank you for making great videos
AMAAAZING!!!
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!
Glad it helped! I have a feeling you might like the tracker we have ruclips.net/video/3Zg8ufnFQHM/видео.html
@@PaulaWeb3andCrypto yes, I'm binging your content, thank you!
Regarding exchange data, I've stumbled upon an exchange that wants to receive an encrypted header, so basic excel won't do. I guess I'll have to dig into VBA to do this.
@@RussianPunchProductions will power query not wor
@@PaulaWeb3andCrypto oh, i am rather new to excel. the most complicated thing i did with power query was combining a few other queries & tables. :D
i am not aware of power querys possibilities with regards to sending API requests with encrypted headers. :O
Thank you, this has been a great help!
Glad it helped!
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 :)
Investing with expert Nora has been the best step I have ever took in my life, may God bless that day I meet her
It's not about watching videos and westing your time on strategies, I was ignorant doing so, so I decided to try Mrs Nora and ever since then she she has made me about $14000 for me on every &5,000 I invested
That is true Mrs Nora has been having a lot of featuresin and crypto and investors
Wow I just made my second withdraw again today trading with expert Nora
She is the best broker I have ever seen
Awesome! Thank you
Thanks for nice video.
Hello Paula. Help me with the calculation formulas of the price sheet, totals. Thanks in advance!
Help me with the calculation formulas of the price sheet, totals. Thanks in advance!
Thks u very much P.G
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?
wow, great tutorial! Is it possible to make the table with more than the first 100 tokens?
Excellent !! Wish I saw that sooner, all good tho, many thnks!!
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?
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?
Love it
hello i couldn't find the first url, can you leave a link help, please
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 ?
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" ❤️
Can you please share the link (or better everthing after the ?) you used to convert into euro? I still struggle with the convertion, ?convert=EUR doesn't work for me.
@@schnepertv7824 I answered your question but it gets removed
@@schnepertv7824 I answered your question but it gets removed
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
good job
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.
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
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!
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
How can add more coins to the list ?
Hello, thank you for your video, is it possible to also have ATH with date and ATL with date?
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?
Thanks so much for putting this up. A question, how do i pull out more than 100 data thru this API.
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
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
Is there a way to use the API key in Excel on MacBook?
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?
What would be the api call to retriev the data of the cointmarketmap Portfolio?
Would be interesting how can be create such connection with Binance. Seems there is more complicated to connect in such way.
How to get OHLC prices hourly in excel sheet everyday at certain time?
how can I get the top listings converted to another currency, Thank you
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?
Can you do this on Macs? Unfortunately Macs don't have the connect from web feature and can't seem to link the api :(
use google sheets. The process is gonna be slightly different so look for tutorials on how to link APIs with google sheets
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.
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?
Hi. How do get the prices to display in GBP (British pound sterling) instead of USD (US dollars)?
You need to create an API end point using CONVERT=GBP however, there seems to be some restrictions on this using the free API which is so annoying. To overcome this, I would just pull in the GBP/USD exchange rate using the stock data types in excel and use this in a formula to make your conversion. you can find out more about these data types here ruclips.net/video/G6RGNthmw1I/видео.html. Or you could pull in the exch. rate from other sources
@@PaulaWeb3andCrypto Thank you
Getting error on connect, says “‘X-CMC_PRO_API_KEY’ header is only supported when connecting anonymously
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?
it depends on what the error is and what you are trying to do
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?
there is something on the page number on the API, although I think with the free one we don't have access. If you check the API documentation you should be able to find it
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
Time difference between the free Api and actual trading data
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🙏🧡
what can you do when multiple currencies have the same symbol?
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?
Is there a way to pull the first 2000 coins? Can you provide a URL please?
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).
ok
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!!!
Sorry, no. I dont use mac
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
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.
Did you solve your problem?
I should do some thing like this.
I have Excel for MAC which does not have this. How can you do it on Excel for MAC?
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?
Excel 2016 or later
@@PaulaWeb3andCrypto Only Windows?
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?
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..
read the api documentation and it should help you
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!!
please check the new crypto tracker we have ruclips.net/video/3Zg8ufnFQHM/видео.html&t
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?
not sure what you are trying to do, but it sounds like you need a lookup function
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
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 ...
can you provide the excel sheet? : )
It does not work anymore. I think they changed something
Totally skipped over how to supply your newly acquired API key.
great simple and straight howto