EASILY Import Any Crypto Price Into Excel

This enables you to pull all kinds of live crypto metrics, such as:
• Prices
• Supply Metrics
• Volume Metrics
• Price Changes
• Blockchain information

This data can then be used to create dashboards and track your portfolio's performance!

This is the fastest and most robust method to import live crypto data. Other methods such as using IMPORTXML will eventually break when the website adapts their HTML / CSS classes.

𝐓𝐈𝐌𝐄𝐒𝐓𝐀𝐌𝐏𝐒
▬▬▬▬▬▬▬▬▬▬
00:00 - Beginning
01:00 - Importing Specific Crypto
03:58 - Parsing The JSON
06:00 - Mass Market Import

𝐋𝐈𝐍𝐊𝐒
▬▬▬▬▬▬▬▬▬▬

𝗔𝗣𝗜 𝗛𝗘𝗔𝗗𝗘𝗥
▬▬▬▬▬▬▬▬▬▬
X-CMC_PRO_API_KEY

𝐈𝐦𝐩𝐨𝐫𝐭𝐢𝐧𝐠 𝐒𝐩𝐞𝐜𝐢𝐟𝐢𝐜 𝐂𝐨𝐢𝐧𝐬
▬▬▬▬▬▬▬▬▬▬
?
convert=GBP&
slug=bitcoin,litecoin,solana,hedera

𝐈𝐦𝐩𝐨𝐫𝐭𝐢𝐧𝐠 𝐓𝐨𝐩 𝐗 𝐂𝐨𝐢𝐧𝐬
▬▬▬▬▬▬▬▬▬▬
?
convert=GBP&
start=1&limit=5000

This video is for entertainment purposes only and does not contain financial advice, if you are investing please seek advice from a professional.

If you have any questions, please drop a comment and I will get back to you.

Thank you for watching, if you would like to see further content like this please like the video and subscribe to my channel.

[Dan_Read]

Let me know if you want to see how to create a Crypto Portfolio Tracker / Dashboard in Excel!

[robbertag]

Sir. I've watched 5 video's already and this one is the only one explaining it correct while I can see on the screen. Thanks. It worked for me. Probs.

[mrtracyut]

Okay after an hour or so I finally did it. Your video size was so hard to see and the speed hard to follow but repeated watching and some reading I got there. Thanks. You never explained that I had to go and register for a free API but eventually I realised. Phew!!

[patcharanimitpornsuko]

Hi Dan, I rarely comments but this content is a gold. I've struggled updating crypto price. What i used to do was i imported many pages (let's say 10 pages) into power query. And what i found is that excel crash many time and also website usually change their format. So i have to fix it almost once a month. But your technigue using API (never used this kind of tool before) made it piece of cake. No more crash and no more chore task anymore.

I can't thank you enough.

[graps]

Great video that made sense to me and works as it should. Thank you. The problem I have is upon refreshing, the columns that have manually entered information move to different cells within the same column. Any idea how to fix? Thanks

[rejanetoigomkt]

Thank You So Much! This video was so helpful! Cheers from Brazil! And keep up with the amazing content

[DrSoapHippo]

Amazing Video Thank you so much! Earned a sub

[SimpleLife]

Hello sir
Can we get crypto prices every 15 minutes automatically in the sheet..
Can you please make a video on it

[marwanel]

Hi Dan, thanks a lot for the awesome video. Would you happen to know how I could request to get the marketcap for the currency? and perhaps all time high market cap? (use a MAX() function in excel perhaps?). Would love to hear your thoughts on this one. Thanks mate!

[mystepnjournal]

Hi Dan, this is awesome. The only part im lost is the second header space that you have blurred out. How do i get the input for that area? thanks

[Phantomgaming-ny]

bro isn't that possible to load 1 to 7000 tokens?? when i'm trying to load it says some error. looks like methos is working for onlu top 5000. you have any idea on this??

[ayhamtibi]

Thank you, Dan, for the video, I get this error // Details: "The 'X-CMC_PRO_API_KEY' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Range, Referer"

[Cdbd]

Hi Dan, many thanks for this great video.
You have put me on track to extract data from cmc. How should I link the tickers from my portfolio to the data extracted from cmc ? Should I use Vloopup or Index/Match type formulas in Excel or are there easier ways ?

[sulemanpatel]

Hi mate firstlt thanks for the video it was very easy to follow. I came up with an issue one of the coins I'm looking at SGO has several pairings so I used the contract address for the specific one I need as follows... slug=BNB, contract address I click ok & get an "unable to connect b7680'(400):Bad Request"

Any ideas what Im doing wrong mate?

[SimpleLife]

Sir can you please share how to import crypto data in Excel sheet every 15 minutes automatically

[dwaynerobare]

There has been quite a bit of change to this. Have you done this, or modified yours since?

[kimsreang]

My Query was an error, it showed "[Datasource. Error]Web. Contents failed to get contents, Too Many Requests". Could you tell me the reason? Thank you

[bipbopboom]

Hiya bud, thanks for this vid. Would you happen to know what the best move is if the slug for some of the cryptos I'm after have a space in the name? It seems to cause the query to fail. Thanks!

[Chillout_mode]

How does it update? I mean if that’s live prices do I have to manually update it

[amzapn]

Really helpful video! Do you know slug name for Shiba Inu?