Integrate CoinGecko Live Cryptocurrency Prices with Microsoft Excel | Excel Crypto
In this video you will learn how you can integrate live cryptocurrency prices with Microsoft Excel from CoinGecko.com.. The technics and skills will allow you integrate any website data for your any purpose. After watching this video, you will be able to do following:
1) Automatically fetch live prices from Coingecko
2) How to Identify the crypto coins?
3) How to apply conditional formatting?
4) How to use vlookup formula?
5) How to run web query?
6) How to convert text values in to number values?
To get this file. Please subscribe to this channel and visit
or email your request at email@example.com
or send request through contact form at www.exceldoers.com
or through our facebook page
Only people with subscribe this channel will be able to request this file.. so make sure you subscribe to this channel
#Cryptocurrency #CoinGecko #Excel #Microsoft Excel #WebIntegeration #Spreadhseet #ExcelCrypto #api #Vlookup #WebQuery #Textvalues
I can see you are very smart and a spreadsheet guru and you teach as if your viewers are also gurus. You go extremely too fast for me. Please make another video which is twice as long so normal users can follow.
When I finished none of the data was usable because it was all text. This is a very important step. I will watch again to see how you converted the text to numbers.
Pls can you write out the vlookup formula out?
Excellent video bro
OK this is already works, but i have into the log in Area a private Token list. i cant log via excel to my preferred Token. Have u the also a solution?
Appreciate the video i really enjoyed it u need to make more like this
Great video! How do you also import the list of exchanges for each coin onto the spreadsheet?
Be careful, trading isn't for the week heated.i started great and look at me almost lost it all until I meet chris Romero I'm gonna tell a detailed storey of my folly😂
I have needed to do this for months and have been putting it off.
The only one which really helped 😆
It is not I expected video, but I learned a lot from it/
great video! If I want it to be in CAD, how do I do it? I tried but the URL is the same when I changed from defaulted USD to CAD.
You're awesome, thank you 😍
Great video! Can you please upload the ready excel where we can just refresh daily prices?
how to freeze it??
I haven't seen someone this trustworthy like davecracks on !!!nsta his extremely good
Two times I paused hearing some talking in the background wondering if it was coming from my house. Haha! Nope. It's your house. :-)) No problem.
Thanks for the useful video!!
Hi! What if I only want the price of one token to show on my excel?
Good video! Do you or anyone knows if it is possible to do this with Google Sheet? Thanks!
how did you copy the price without the USD symbol?
why can't this tutor answer our questions?
THIS IS SO USELESS AS IT ONLY WORKS FOR THE FIRST 100 COINS, AND NONE OF MY COINS IN THE TOP 100
how can i pull up my own purchased coin?
so… this does the upload for 100 coins .. what if you wanted more than that? Thank you for showing how to do this! Why not post the excel spreadsheet on the page and save us the work?
Thank you very much. Good presentation. Last question. How is possible to get number 100 to number 500 rankings of Coingecko in the Excel sheet, please?
Nice Video Bro. I have done.
Great work. appreciate u.
can u share this excel file
its live update ?
Thanks for this video, I want write one email, Please send me your email for my question. Thanks
Great video! Very useful, but how do you convert text to numbers. After the VLOOKUP function, the price and market cap are still text formats?
Appreciate the video, can you please make a video on how to get previous day's open high low close on excel
okay so how different is this method from getting data through an API? A bit confused.. this obviously seems a lot simpler
Congratulations pal, this was the first video that really explained how to do it in the easy way….thank you very very much
ITS WORK ON EXCEL 2013 ?