Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart
hive-167922·@paulag·
0.000 HBDConnect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart
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. https://youtu.be/T4wIaw5HmbE 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 <sup>Beta</sup>](https://leofinance.io/@paulag/connect-excel-to-coingecko-api-for-historical-ohlc-cryptocurrency-data-and-chart)
👍 stmdev, haxxdump, toni.curation, toni.pal, limka, investingpennies, thelordsharvest, steemvault, steem4all, communitybank, utube, sportscontest, videosteemit, photohunt, photohunter1, photohunter2, photohunter3, photohunter4, photohunter5, superlotto, citizendog, cakemonster, steemstorage, fire451, starfighter, seekingalpha, tokensink, beta500, knightsunited, shadowspub, dtrade, nascimentocb, tankadiary, savagebits, thegoldencobra, roleerob, kendra19, abh12345, akdx, ctime, jayna, philnewton, tobias-g, automaton, quello, revisesociology, votehero, scholaris, ninnu, clixmoney, thehive, drew0, crokkon, abh12345.stem, peekbit, thekillingqueen, battlemaster, vxc.stem, itisjustme, gimp, slider2990, organicgardener, lookplz, gmlrecordz, chrismadcboy2016, communityaction, lmon, amico, lion200, alexis555, simplymike, src3, freebornsociety, journeyofanomad, abdul.qadir, steembasicincome, taskmaster4450pa, dyrt88, pupu93, raspibot, anikys3reasure, celinavisaez, dcooperation, heyhaveyamet, sbi-tokens, ctl001, jacekw, gavinatorial, strongwoman, stevelivingston, soufiani, newageinv, scottshots, zainenn, sbi-booster, prettynicevideo, sm-skynet, por500bolos, investegg, sbi2, sbi3, nervi, sbi6, lauchmelder, sbi4, sbi5, sbi8, tryskele, sbi7, sbi9, djennyfloro, gamer00, created, livingfree, rehan12, steemflow, bert0, josevas217, franyeligonzalez, memeteca, voxmonkey, vtol79, ambyr00, kiemis, wesphilbin, brainpod, wolfhart, flamingirl, mangou007, eastmael, paintingangels, dernan, beamentor, solar, solrasol, c0ff33a, nanzo-scoop, marblely, theexcelclub, binkyprod, blue.panda, deepsouthpiddlin, whiterosecoffee, mummyimperfect, ak2020, emily-cook, t-bot, mafeeva, ravenruis, beeyou, fitat40, princessamber, ghostdylan, scoopstakes, nanzo-snaps, marblesz, espoem, khaleelkazi, dreemsteem, hgn66, the.lazy.panda, aneukpineung78, khalil319, organduo, nateaguila, leo.curator, refinement, chloem, leotrail, gcomplex, hanez, plasticsoul, scrpt, ropehold, fitlet, strk, hemerit, midtrain, starle, thorc, basechain, flowc, tv-d, supersla, alorian, slat, protoleo, muski, twrk, eth2, hodol, theco, muskland, hochismin, finleo, givup, etheru, bynd, midlet-yourleo, akpofure, untersatz, leo.voter, ahmadmanga, annabellenoelle, gadrian, break-out-trader, alokkumar121, thefalcons, tiffin, snoochieboochies, leofinance, pixiedust4u, chucknun, nickyhavey, engrsayful, megavest, bala-leo, thatsweeneyguy, bahagia-arbi, gadrian-sp, juanvegetarian, senseiphil, arteem, abh12345.leo, meta.condeas, laputis, babytarazkp, empoderat, xcountytravelers, torrey.leo, steeminer4up, nascimentoab, jeronimorubio, camuel, bennettitalia, he-index, tslap, travelwritemoney, pladozero, paragism, crimsonclad, anarcist69, clayboyn, blarchive, lordoffaux, kenny-crane, richatvns, davidlionfish, luoq, followbtcnews, bewithbreath, localgrower, emrebeyler.stem, bashadow, beehivetrader, tariqul.bibm, hedge-x, joythewanderer, etherpunk, penderis, oldtimer, dalz, scaredycatcurate, dalz1, fullcoverbetting, tomhall, bluerobo, doze, psos, onze, oldmans, meestemboom, spectrumecons, vegoutt-travel, captainhive, wxmark, yggdrasil.laguna, brofund-stem, lrekt01, mariosfame, niallon11, dylanhobalart, v4vapid, likwid, primeradue, promobot, enki, zorg67, metzli, monstermama, diamondrainbow, batsandvampires, diamondlighthp, vxc.leo, mytechtrail, nathen007.leo, tonimontana, we-are-palcoin, kharma.scribbles, dera123, mrhill, santigs, klye, ash, jahedhossain, jk6276, krunkypuram, thebluewin, auminda, good.game, steemboat-steve, investprosper, ace108, stem.curate, balticbadger, samuel.steem, quantumdeveloper, maruskina, nalacanecorso, axel-blaze, boomalex, meppij, stuntman.mike, icuz, shmoogleosu.stem, vallesleoruther, acungametrailers, friendlymoose, troublemakerrr, teammo, academiccuration, rikarivka, bluemoon, netaterra.leo, nealmcspadden, luppers, mhm-philippines, gillianpearce, tute, damla, steinhammer, enforcer48, heystack, themightyvolcano, iseeyouvee, stemline, stemcur, altleft, voter000, blewitt, teamashen, we-are, onealfa.leo, sk1920,