Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart

in LeoFinance3 months ago

Get historical cryptocurrency pricing into Excel using CoinGecko API and learn to create a quick stock chart. The CoinGecko API is (currently) a free API that allows you so much cryptocurrency data from live/current cryptocurrency pricing to historical data. From top coins like Bitcoin to a very large selection of Altcoins and tokens. In this video, we will explore the APIs, find out how to get the URL required to connect to the data, then we will use Excel to connect to the API, and we will clean up the JSON so the data can be used with ease in Excel.

CoinGecko API documentation
https://www.coingecko.com/api/documentations/v3#/

Each API returns data in a different JSON format. To learn more about working with JSON in Excel check out this post

https://theexcelclub.com/how-to-parse-custom-json-data-using-excel/

Posted Using LeoFinance Beta

Sort:  

NERD!

But legit though I didn't realize you were into this sorta stuff. Impressed!

OMG @klye, this is what I do for a day job, how did you not know this was my type of gig? Data, Excel, Numbers!!!!! You probably missed it when I posted it, so guess what? I won a Microsoft MVP award in Excel this year. heheheh I'm the only Irish female MVP in all areas of Microsoft tech and I am the only Irish Excel MVP too.

Guess am fucking oblivious.. lmao.

that is bad ass though.

hehehehehhe its good to be oblivious most of the time. I hope you are keeping well :-)

very cool! thanks for this tutorial, you'll never know when you need something like this :D

Posted Using LeoFinance Beta

a lot of devs would use the API, but you don't need dev skills, just an Excel spreadsheet and you can create some awesome apps and reports.

Good for tax returns 👏

Watch your language lad....

Posted Using LeoFinance Beta

🤐🤑

Hay @abh12345 I hope you are well. Tax returns, hahah I'm still recouping the losses of the bear market

Very useful, thank you very much for sharing with us your advanced knowledge in Excel. I am sure that I use Excel only at most 10% of its capacity.

Posted Using LeoFinance Beta

most people only do use a fraction of its ability, thanks for stopping by

Posted Using LeoFinance Beta

Yes.me too. With pleasure!

Posted Using LeoFinance Beta

Congratulations @paulag! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :

You distributed more than 65000 upvotes. Your next target is to reach 66000 upvotes.

You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP

Do not miss the last post from @hivebuzz:

Saint-Nicolas challenge for well-behaved girls and boys
HiveFest⁵ badges available in the HiveBuzz shop
The new HiveFest⁵ Attendee badge is waiting for you