Posts

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

avatar of @paulag
25
@paulag
·
·
0 views
·
1 min read

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