Friday, December 9, 2022

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

#excel #cryptocurrency #coinmarketcap

**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

***Community Invitation*****
– Excel For All – Decentralized and tokenized – Join today

Grab 50% off Access All Areas Unlimited Excel Training

If you want to learn more about Excel I hope you will visit our website

Sign up to our newsletter

Watch more Excel Videos

Find out about the Brave Browser and receiving BAT rewards

Source link


  • 🚀🚀BeefSwap Launching in 3 hours🚀🚀
    First dapp in the Beef ecosystem to support Roast Beef Contract❤️

    Buy & Sell $Burger tokens in BeefSwap and earn trading dividends in BNB.

    Buy Dividends — 20%
    Sell Dividends — 10%
    Referral Bonus — 15%
    Dev Fee — 1.5%
    Treasury: 5% of sell fees goes Treasury and will support Roast Beef Contract every 72 hours 💥💥💥

    Launch Time: Mon Apr 25 2022

  • Very clear explaination mam. thanks a lot…

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

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

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

  • I respect the work you put into your videos. I find it really baffling that all the major crypto YouTubers 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..

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

  • 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

  • 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

  • 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!

  • 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 ?

  • 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?

  • 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

  • Thank you very much Paula, that helped a lot.

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

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

  • Can you also do this on a Mac?

  • can you provide the excel sheet? : )

  • 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 🙂

  • 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!

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

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

  • 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

  • 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

  • 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! 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 😀

  • great simple and straight howto <3

    is there a way to insert the latest price into my table to somehow build up a personal history? e.g. to account Liquidity Mining profits now and then…

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

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

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

  • Many thanks for the detailed explanation. Greatly helpful.

  • Thank you for the amazing video!!!

Leave a Reply

Your email address will not be published.