HomeНаука и техникаRelated VideosMore From: On1 Productions

Bitcoin Explained: How to import live cryptocurrency prices to Excel Spread Sheet

85 ratings | 13571 views
If you are like me then you monitor multiple cryptocurrencies in your investment portfolio. It can get annoying to go back and forth to Coinmarketcap.com in order to find out the value of portfolio. In this video I will show you how to import the live data to your excel





Html code for embedding videos on your blog
Text Comments (26)
Luiz A (6 months ago)
what happened between 2:00 and 2:02?
Edler Hufnagel (7 months ago)
Without an effective trading strategy, there is no way you can make money in this business. I have personally used this before. But i loose my money trading on this. Now i'm satisfied with *FIRST MILLION ROAD*.
Mrkientube (7 months ago)
It works greattttt. Thanks for sharing.
Erik Dominguez Jr. (9 months ago)
*I just got 0.1 BTC via this website. Google "bitxploit" for more info*
Beni Manggala (9 months ago)
THANK YOU... YOU SAVED ME!
David Cummuta (9 months ago)
FINALLY my goodness I searched everywhere... someone who doesn't just assume everything works. All the JSON tutorials were not working because they were trying to use Excel 2016 which can import live JSON data. they were using the api URL that 2013 apparently can't handle. Once you showed me that you can just do coinmarketcap.com as the URL it worked.... much thanks man
TheRevoLucian (10 months ago)
Thanks brother! I've wasted soo much of my damn time flicking back and forward to check the value of my portfolio with my spreadsheet. Most deserved like I have given for months :D
Rudeee66 (10 months ago)
Thank you for your clear explanation, question though. When I try to multiply the amount of a currency with the price I get the #VALUE! error. It doesn't recognise the price of the currency as a number. How could I change that?
GuitarFan7 (9 months ago)
Try formatting the cells to a currency? Only thing that comes to mind.
Had the same issue. The problem is the $ mark that coinmarketcap adds. Therefor excel thinks it's text. And sorry my excel is not in english so I can't give you the excact names of the functions that I am using. But click on a coins price in the sheet. Go to queries, go to edit which should open a new window in excel where you should be able to see your table. Press a coin price, and go to "replace values" Put in $ as the thing you want to replace, and you can leave the next one blank. Now it's just numbers which excel will accept
Marek Hlaváč (9 months ago)
Same here...no matter how I try to format the data cells :/
Metrowhite (10 months ago)
Exact same error dude, did you find out the solution to this problem?
GlobalVortex (10 months ago)
Damn, so easy. I thought it takes a degree in rocket science. LOL
iamdmc (10 months ago)
god damn looking at this I just have to say congratulations buddy you must be doing well now and thanks for the tips - I incorporated this into my own holdings file
Pradeesh R (10 months ago)
Im running Excel 2016 v 15.24 and updated it. But the Web option isn't available.
Pradeesh R (10 months ago)
Thanks Jerry for responding.  I forgot to mention I'm on a Mac as well. Did download Power Query and tried running it, but no luck. It is not supported on OS according to Microsoft. Guess i have to stick to Google sheets, that works like a dream. Just not comfortable with it online thats all.
Jerry de Blok (10 months ago)
Download Power Query for Excel
Capa Crypto (10 months ago)
Thank you
shaminique walker (11 months ago)
Can you share your spreadsheet?
Moosy Research (11 months ago)
Have a look at this sheet https://docs.google.com/spreadsheets/d/1_FchZPoFmP_0igDxxZPwPAhiXjWxKN1Fh-5M25k2x9E/edit#gid=224399891
Mark Anthony (11 months ago)
This is pretty cool. Thanks for sharing. What are your thoughts on Bitcoin Cash
PongGod (10 months ago)
Check out eos.io. The blockchain will go live in June 2018 and is reported to be capable of handling up to 100,000 transactions per second and with little or no fees. The project was started by Dan Larimer, creator of the Bitshares and Steem projects, two of the most highly successful crypto projects. So there is a great deal of credibility in the claims he's making. EOS is already up by over 15X in the past 3 months and should climb steadily over the next 12 months.
Uncle Sim (10 months ago)
What's EOS
PongGod (11 months ago)
Not too late to jump on the EOS train. It's going places in 2018!
Mark Anthony (11 months ago)
Thanks I am kinda late in the game with Crypto but better late than never.
On1 Productions (11 months ago)
no worries :) Until last week I didnt really care much for BCH. I think it is a competitor to Litecoin because both of them are forks of the bitcoin block chain that offer faster transactions and lower fees. i prefer the dev team in litecoin and I think they are doing more innovative things.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.