Excel Import CoinMarketCap API Data with Query

Import CoinmarketCap API cryptocurrency prices in Excel using a Web Query and have them refresh automatically at an interval of your choosing!
----
The CoinMarketCap Pro API is a great source for cryptocurrency data on current and historical prices, exchange information and more. If it is your wish to use Excel to import CoinMarketCap API data, and have it updated live, look no further. In this video, I will show you how to use a query to import current prices into Excel and have them updated regularly using the methods shown in the Import JSON Data in Excel article. Be aware that this works best with Excel 2016 or greater, and doesn't work with Excel for Mac. If you are using Excel 2013 or prior, you will need to install Power Query before attempting these steps.
----

[holycow_productions]

im getting DataSource.Error: The request was aborted: Could not create SSL/TLS secure channel . how to fix

[MrBravemind]

thank you so much for your support, i'would like to ask if i want to import all currencies not just BTC and LTC, how can i do this?

[salvadorperez]

Great tutorial, it´s been so useful for me. Thanks a lot

[dpywzhk]

The update occurs 1 time per minute, but does not coincide with the minutes on the clock, for example, it is updated not at 06:01:00, but at 06:01:44, which is why there is no coincidence with the candles on the chart. Is there any way to fix this, please? And another question is, is it possible to output parameters such as maximum and minimum, opening and closing prices to Excel? Thanks.

[chiro-man]

Excellent tutorial. Question: how do you ADD a crypto to the connection? so example, ETH needs to be added to BTC and LTC. Thank you!

[fotalimark]

Fine sir, just used this tutorial to make an excellent portfolio viewer in Excel. Thank you for your wonderful work!

[jacobholmgren]

Great stuff! How do I add more currency pairs in a easy way? Without having to import the data all over again and copy paste the API URL and key

[kryno]

Can I get the RON or USD with the same query? I mean.. I want to keep my evidence with an excel file. I made some math and now I would love to convert the final answear into RON. Can I just put RON, USD near BTC, LTC ?

[kingsmeadow]

Thanks, this has been the simplest explanation with all the correct steps I have seen.

[slickxbt]

Hi, can I just ask how exactly do you use the convert function to get for instance GBP? Thank you and I appreciate your video!

[luucasrosa]

TKS for the video, man i have a question, how i introduce more coins to spreadsheet. like ETH, LINK, others coins.

[PontificusPinion]

This is excellent, thank you. If I want the latest prices for ALL the coins, not just BTC and LTC, what do I enter instead the string instead of BTC, LTC?

[kartelkraft]

This make me easier than use Google Drive Thank you

[gjmsouthafrica]

excellent. thanks. no music no fancy intros. just really good stuff.

[giugot]

very useful guide, thanks. After all the setup, how can I add new crypto currency in the table?

[MrHanabil]

Thank you for the explanation, please how do I add the rest of the currencies, at least the currencies I chose

[AhmadZaytoun]

can I do it the other way around? I have my transaction history from Binance and I want to import it to CoinMarket Cap. Is that possible?

[Pyxal]

Hey cheers for the tutorial, quick question - I have the table loaded in but when going to the query properties to try and set a time interval to see the latest values, I don't have all of the options show in the video. Any idea why that may be? tia

[BlackMamba-vlks]

How would I go about adding new coins, without going through the whole process?

[alanstjohn]

Is there a URL we can use to import all data related to all the coins listed on Coinmarketcap