Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data 

Thank you ma'am. May Ganesha bless you. May Devi's Grace be upon you.

Great! This tutorial is pretty much solution-oriented and practical (totally free of useless talk).

Thank you Paula. For valuable information. I wish you good work.

Thanks saved me days of coding

lady ! you make my day! big warm hug from Barcelona

Thank Paula!

Just found this video after searching through how to properly download price history from coin gecko. Translating date from unix number was very helpful and I'm using it for another coingecko api. Thanks a lot and greatly appreciated on this!

good Thanks so much!

Thanks Paula. Interesting post and lesson. Good to know how to do this. Thanks for sharing :)) Thumbs up!!

Hi Paula, that was very educational. Good to know and thanks a mil for sharing. THUMBS UP.

This was exactly what I was looking for, thank you very much

amazing thanks

Great tutorial, as usual! Many thanks!

Thank you Paula! Very valuable!

Very helpful! Thank you!

Hi, Is it normal on the 30days formula that the API is pushing 6 times the same date with different data ? At the end, my graph looks messy. Thank you for your great tutorials (excel, coingecko, coinmarketcap...)!!!

Você é muito louca no excel parabéns Paula.

Excellent tutorial. Could you do a tutorial on the CryptoCompare API? Thank you.

This was amazing and helped me a ton. Thanks!

Thanks Paula, Very useful

Love it

Thank you for the video, a quick check if its possible to pull holders information for each coin or token? example from BSC network?

thank you so much for this you made my life easy

Thanks. Can you do it for Google sheets?

Hi Paula - great tutorial. What you describe seems easy enough, however, I am not able to make it run. Do you know of any Excel settings that would prevent someone from using the CoinGecko API? Could it be JSON related? I get all the way to entering the path into 'Data from Web' but then Excel either freezes or I ESC out after 10 mins and try it again. Thanks!

Great Viedo Paula!!! Thank u. Does anyone know how to get a list o criptocrurrencies data with a Coingecko API?

Really good, thx, awsome!

Hi Paula, This Coingecko API isn't working 18/5/22

Hi! This video is very informative. Can you please make a video on getting the same into google sheet? I tried but unable to.

When i select from web and hit enter after pasting the url a json file opens and not a table like in your video. What am i doing wrong? Thanks!

Thank you for a great video, however I can't use this as I have a MAC and it doesn't work on this. Any ideas?

I get an error message saying 'We cannot convert a value of type List to type Text' when I try the other APIs.

Anybody know how i can do this for bitcoin cash for example. Having trouble finding the list of tokens you can use with this!

amazing, thanks!

Hi Paula what privacy settings do i use for data feed, none seem to work

hi, i want to ask is there different effect on data if choose different delimiter function? thanks

Great spread sheet! I am using it, and expanded it! Just not sure yet how to expand a single query for getting more than 50 coins. I also created a portfolio prospector, with coins that I might want to ape in

Is there any way to get volume data and to track the volume changes for 5min, 15min, etc.. in excell ? The excell will report the hourly volume changes automatically, so we can track it easily.

You don't explain how to go to documentation page?

Hi Paula, thank you, it's very interresting. I'm looking for to have historical values at the close of many coins in ytd with automatic update (even if when a day is finish, it does not move anymore). Is it easy ? Thank you

Hi Paula this is quite complicated for me. Actually I want is the bitcoin value of all cryptocurrency displayed on CoinGecko. I tried importing it via New Web Query but it doesn't allow me to change the currency, probably because it's using javascript. Do you know by any chance how to easily get this?

Hi. Can you please explain how to add data on macos. Cuz the options are different and on selecting "Get eternal Data" then "From HTML" a pop up menu asking to select the file from which you want to add data appears. Please help.

hi paula, thanks for this video. Does this work for multiple coins (i.e. by typing "bitcoin,ethereum") into the id string? Doesnt seem to work for me. Just want to check. cheers

Great tutorial, thank you very much! Unfortunately my prices include commas as well, so splitting the column on a comma delimiter does not work.

how to convert the number for date in google sheets?

Hi Paula, thanks for the lovely video ..i need help i want to fetch data thru bitcoin not by usd can u help me on this regards plz reply

Paula, great tutorial. A question: trying to import btc pairs of altcoins. Your example on 3:46 works for me, but doesn't return values for for example 0x. Is it possible to import the general market data including prices in bitcoin AND in EUR or USD for say the top 500 coins? I'm able to load the top 500 from coinmarketcap but only USD.

I am interested in extracting historical open interest data for bitcoin futures from coingecko. I see I can get live data, but can I get historical derivatives data?

Hi paula, Is it true you make an investment program in telegram as admin ?

My excell data from web is disabled..please help me Paula..

is there a way to just import all coins ?

Thanks for the video. I've tried to replicate the same query for 180 days Bitcoin, but it's not showing me the every day OHLC. It's showing the OHLC every 4 days (e.g 9/11/2020 and then below row is for 9/15/2020). Do you know how to fix this issue? Thanks!

Thanks Paula! How can I do this for multiple coins at once? For example BTC/USD, ETH/USD, TRX/USD in one request? Thank you

How can this work on Excel for Mac

Hi Thanks for this video. the downloaded data have different value in same date can you help on this.

Thanks Paula, very good video. As I do not speak English I did not watch the entire video, but I managed to solve my main problem, which was the volume, as it took bitfinex, but it came with outliers. I would like to change the "include_24hr_change" to 7 days. Is it possible? Thank you very much in advance.

Alguém sabe como fazer isso no Excel 2013?

great! unfortunately i have a macbook