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

View this thread on: hive.blog | peakd.com | ecency.com

hive-167922 · @paulag · Dec 1 '20

$11.49

Connect 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)

👍 altleft, leo.voter, v4vapid, enki, alexis555, spectrumecons, niallon11, amico, ash, joythewanderer, blewitt, steembasicincome, captainhive, created, abh12345, meppij, nealmcspadden, revisesociology, c0ff33a, nanzo-scoop, kenny-crane, investegg, ctime, dalz, nateaguila, investingpennies, sbi2, bluemoon, organduo, followbtcnews, oldtimer, livingfree, dylanhobalart, steemflow, ace108, superlotto, teammo, theexcelclub, sbi3, thelordsharvest, sbi6, sbi4, sbi5, klye, sbi8, metzli, communitybank, scholaris, enforcer48, doze, cakemonster, sbi7, citizendog, roleerob, empoderat, steemstorage, heyhaveyamet, photohunt, thehive, bluerobo, khaleelkazi, eastmael, shadowspub, videosteemit, and 290 others

`author`	paulag
`permlink`	connect-excel-to-coingecko-api-for-historical-ohlc-cryptocurrency-data-and-chart
`category`	hive-167922
`json_metadata`	{"app":"leofinance/0.2","format":"markdown","tags":["excel","palnet","stemgeeks","tutorials","cryptocurrency","leofinance"],"canonical_url":"https://leofinance.io/@paulag/connect-excel-to-coingecko-api-for-historical-ohlc-cryptocurrency-data-and-chart","links":["https://youtu.be/T4wIaw5HmbE","https://www.coingecko.com/api/documentations/v3#/","https://theexcelclub.com/how-to-parse-custom-json-data-using-excel/"],"image":["https://img.youtube.com/vi/T4wIaw5HmbE/0.jpg"]}
`created`	2020-12-01 19:18:48
`last_update`	2020-12-01 19:18:48
`depth`	0
`children`	15
`last_payout`	2020-12-08 19:18:48
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	6.190 HBD
`curator_payout_value`	5.301 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1,016
`author_reputation`	274,264,287,951,003
`root_title`	"Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	100,767,932
`net_rshares`	51,226,617,643,427
`author_curate_reward`	""

properties (23)vote details (354)

voter	rshares	pct
enki	5,298,914,204,405	23.1%
ash	690,710,718,192	100%
nanzo-scoop	366,627,457,283	50%
mummyimperfect	52,383,204,662	50%
klye	145,932,238,811	100%
ak2020	20,881,368,867	50%
hedge-x	37,927,709,205	100%
kenny-crane	362,934,106,816	50%
mangou007	1,378,463,683	5.06%
emily-cook	1,573,207,601	50%
livingfree	215,553,809,940	4%
nascimentoab	12,547,701,381	100%
joythewanderer	687,776,861,582	100%
ace108	189,104,377,368	6%
djennyfloro	1,293,882,722	10%
anarcist69	943,950,374	4%
bert0	27,505,918,095	5.06%
solar	11,539,967,075	25%
shadowspub	83,630,709,396	50%
oldtimer	223,975,262,001	100%
solrasol	15,641,387,629	100%
por500bolos	32,109,010,034	75%
abh12345	506,848,386,388	20%
t-bot	942,261,418	50%
clayboyn	14,012,201,609	4%
dylanhobalart	205,981,614,519	100%
gamer00	50,941,139,931	5%
slider2990	499,505,307	24%
created	522,551,461,877	4%
zorg67	589,153,154	100%
ahmadmanga	709,513,835	14%
mafeeva	63,400,403,858	50%
dreemsteem	2,361,362,421	25%
v4vapid	5,343,379,841,022	33%
automaton	1,910,924,459	100%
ambyr00	3,898,876,458	0.75%
teammo	170,264,897,697	100%
dyrt88	2,775,439,611	100%
alexis555	2,681,742,290,468	31%
c0ff33a	376,881,560,501	15%
freebornsociety	1,702,810,577	10%
damla	24,500,780,158	50%
thatsweeneyguy	560,823,458	10%
followbtcnews	226,552,536,064	8%
clixmoney	51,914,734,970	50%
stevelivingston	35,793,278,253	25%
crimsonclad	74,729,031,761	8%
spectrumecons	1,407,824,844,900	30%
jayna	14,238,782,596	4%
wesphilbin	3,649,534,615	9%
binkyprod	39,420,948,533	50%
vallesleoruther	79,158,967,558	100%
jacekw	66,992,786,625	100%
dernan	849,658,036	100%
bluemoon	259,656,406,845	100%
jahedhossain	780,807,265	100%
investingpennies	273,655,343,096	100%
khalil319	2,278,366,998	25%
nascimentocb	1,468,294,657	100%
rehan12	8,163,651,741	5%
santigs	7,850,574,637	15%
bashadow	79,334,179,204	25%
bahagia-arbi	572,448,427	10%
lmon	23,549,534,564	45%
thelordsharvest	153,659,288,914	100%
niallon11	961,242,470,967	100%
aneukpineung78	3,861,132,641	100%
crokkon	25,925,468,461	50%
voxmonkey	211,915,175	100%
eastmael	91,816,779,150	100%
roleerob	123,079,663,674	20%
votehero	65,377,673,709	69.35%
revisesociology	378,883,825,194	25%
espoem	16,708,544,721	5%
investegg	337,491,802,367	9.86%
khaleelkazi	98,909,835,937	50%
vegoutt-travel	18,472,367,037	30%
flamingirl	1,310,957,866	5.06%
paintingangels	55,762,360,062	100%
mrhill	28,019,519,747	100%
steemflow	190,883,499,550	52%
steinhammer	468,149,379	25%
etherpunk	864,329,250	50%
tute	149,831,658	100%
mytechtrail	48,340,869,446	15%
steeminer4up	1,487,620,944	100%
mhm-philippines	8,308,707,534	25%
ravenruis	23,019,071,848	75%
steembasicincome	564,555,286,951	100%
blue.panda	887,344,886	15%
luoq	17,121,328,389	100%
metzli	141,811,191,938	100%
gillianpearce	2,992,261,354	100%
steemvault	36,683,422,414	100%
steem4all	1,982,943,950	50%
communitybank	136,761,839,269	100%
bennettitalia	23,268,510,018	25%
nealmcspadden	426,644,760,047	100%
utube	78,005,763,685	100%
tryskele	3,840,902,839	4%
steemboat-steve	3,631,646,069	50%
chrismadcboy2016	1,686,486,721	100%
fullcoverbetting	50,231,152,840	100%
soufiani	2,812,370,337	1.6%
philnewton	683,140,972	10%
psos	21,314,376,853	45%
sportscontest	63,579,789,669	100%
videosteemit	83,386,152,158	100%
newageinv	21,361,535,021	12%
tobias-g	61,745,433,829	15%
icuz	2,432,653,101	70%
organicgardener	1,228,187,911	50%
investprosper	1,379,829,964	50%
gavinatorial	952,493,364	100%
tomhall	2,895,409,661	100%
photohunt	115,745,869,760	100%
photohunter1	773,686,488	100%
photohunter2	1,874,238,008	100%
photohunter3	1,107,379,990	100%
photohunter4	1,184,189,312	100%
photohunter5	1,110,763,218	100%
penderis	41,322,327,887	100%
anikys3reasure	3,140,900,318	50%
annabellenoelle	1,021,703,962	100%
thebluewin	17,774,339,995	100%
auminda	4,058,816,003	100%
beeyou	37,887,387,284	100%
organduo	249,066,066,151	50%
richatvns	681,817,747	0.5%
superlotto	174,975,224,206	100%
simplymike	53,515,095,912	50%
lauchmelder	2,451,568,535	50%
nervi	5,072,428,793	100%
amico	778,781,254,460	100%
jeronimorubio	3,088,570,018	2%
scottshots	3,732,574,100	4%
josevas217	7,347,813,407	5.06%
stmdev	386,899,970	10%
sbi2	265,278,043,986	100%
dera123	11,593,641,007	2%
paragism	12,147,986,046	40%
franyeligonzalez	896,399,177	2.53%
wolfhart	6,881,099,789	17%
prettynicevideo	24,467,615,776	15%
gadrian	10,207,307,302	6.4%
tonimontana	7,207,906,815	100%
themightyvolcano	52,827,018,074	18%
iseeyouvee	826,793,198	18%
peekbit	29,382,512,812	100%
thegoldencobra	7,005,960,100	100%
brainpod	525,269,585	25%
camuel	46,325,028,360	20%
break-out-trader	2,242,812,297	20%
we-are	2,850,402,942	17%
sbi3	160,672,510,251	100%
savagebits	17,911,210,112	100%
promobot	5,635,567,049	6.6%
sbi4	151,365,167,984	100%
celinavisaez	4,018,893,118	15%
nickyhavey	4,971,122,891	10%
pladozero	34,852,225,809	10%
nateaguila	305,065,599,875	8%
enforcer48	131,252,366,140	15%
sk1920	8,631,964,856	100%
akdx	13,465,558,327	25%
laputis	29,763,429,246	50%
oldmans	8,999,337,967	10%
pupu93	6,661,268,232	100%
citizendog	127,119,331,195	100%
sbi5	149,110,929,402	100%
marblely	46,016,548,971	50%
fitat40	8,895,327,218	50%
blewitt	618,979,344,380	30%
sbi6	151,588,371,528	100%
thehive	112,752,413,284	70%
dalz	318,093,879,496	100%
zainenn	12,513,393,239	10%
jk6276	1,020,155,558	5%
sbi7	128,782,345,867	100%
luppers	77,225,505,173	50%
dcooperation	5,678,240,580	2%
theexcelclub	169,378,970,186	100%
voter000	335,760,672	20%
alokkumar121	2,015,541,990	2%
sbi8	142,379,386,252	100%
balticbadger	31,077,621,732	25%
lion200	12,491,837,838	50%
blarchive	9,755,846,112	8%
sbi9	11,046,394,046	13.24%
communityaction	5,078,449,488	100%
memeteca	634,307,270	5.06%
troublemakerrr	1,135,804,426	100%
arteem	5,254,404,954	75%
sbi-booster	46,055,474,452	100%
onze	620,196,678	45%
deepsouthpiddlin	9,230,354,267	50%
xcountytravelers	7,342,091,595	15%
cakemonster	130,687,103,373	100%
bluerobo	101,759,984,550	100%
tankadiary	438,286,899	12.61%
steemstorage	120,771,948,051	100%
fire451	1,499,417,663	100%
starfighter	948,641,304	100%
seekingalpha	783,211,260	100%
primeradue	40,815,378,880	33%
princessamber	2,130,915,151	100%
whiterosecoffee	2,672,113,378	7.5%
ctime	333,053,132,924	2%
thekillingqueen	596,746,167	50%
ghostdylan	2,139,476,118	100%
battlemaster	3,063,029,925	50%
scoopstakes	13,334,046,601	50%
nanzo-snaps	8,833,841,328	50%
limka	0	5%
heyhaveyamet	116,886,781,684	60%
doze	131,006,932,975	45%
sm-skynet	2,597,766,336	100%
monstermama	2,175,051,325	100%
bewithbreath	962,191,831	5%
kharma.scribbles	1,521,722,693	37.5%
samuel.steem	1,460,779,101	100%
src3	16,223,710,982	25%
beamentor	7,185,468,777	100%
itisjustme	1,075,049,691	50%
engrsayful	10,678,296,822	12%
thefalcons	1,234,698,668	100%
krunkypuram	1,766,644,665	100%
raspibot	3,685,758,854	100%
megavest	4,062,324,086	20%
gadrian-sp	1,485,189,939	6.4%
dtrade	600,824,616	20%
scholaris	134,684,322,725	50%
lordoffaux	665,749,993	0.5%
likwid	29,745,053,942	6.6%
haxxdump	114,064,105	10%
quantumdeveloper	2,439,248,204	50%
maruskina	42,732,408,190	50%
travelwritemoney	4,585,028,009	20%
kendra19	4,128,587,094	100%
nalacanecorso	1,161,377,498	100%
teamashen	1,577,101,006	3%
dalz1	1,362,247,543	100%
hgn66	1,929,167,859	100%
we-are-palcoin	0	9.15%
lookplz	7,803,228,378	100%
strongwoman	1,312,385,044	100%
lrekt01	2,948,679,500	100%
tiffin	733,248,867	20%
abh12345.leo	313,307,123	20%
leo.voter	8,614,991,780,856	20%
leo.curator	1,406,344,107	40%
onealfa.leo	155,704,008	1.09%
empoderat	121,769,849,870	20%
vxc.leo	64,885,835	21%
bala-leo	658,509,716	20%
good.game	20,050,812,833	100%
scaredycatcurate	5,083,023,179	100%
taskmaster4450pa	1,793,540,918	100%
babytarazkp	1,683,912,104	40%
midlet-yourleo	671,101,433	40%
abh12345.stem	506,336,882	70%
tokensink	45,587,682,087	100%
the.lazy.panda	1,338,653,528	15%
refinement	930,379,549	50%
beta500	81,577,069,113	100%
knightsunited	1,154,310,671	100%
sbi-tokens	2,859,885,041	35.19%
untersatz	9,978,106,691	50%
ctl001	597,239,315	100%
vxc.stem	27,728,163	100%
akpofure	223,153,658	50%
chloem	673,389,499	50%
leotrail	936,753,687	50%
axel-blaze	57,644,192,641	100%
yggdrasil.laguna	254,903,934	55%
snoochieboochies	6,594,864,241	10%
diamondrainbow	2,134,048,541	100%
batsandvampires	1,815,001,458	100%
stem.curate	902,430,229	100%
toni.curation	141,002,739	4%
tariqul.bibm	4,378,504,500	10%
boomalex	2,363,745,756	100%
gmlrecordz	573,439,770	50%
journeyofanomad	4,847,683,576	40%
toni.pal	103,623,617	12.61%
gimp	26,969,845,429	10%
juanvegetarian	34,104,965,010	100%
marblesz	3,224,255,586	50%
davidlionfish	6,160,299,359	50%
drew0	724,554,649	5%
stuntman.mike	58,112,083,411	100%
leofinance	61,265,607,858	20%
captainhive	542,297,136,857	30%
quello	6,582,847,479	15%
meppij	492,215,226,857	100%
ninnu	58,084,202,917	12.5%
kiemis	9,435,766,025	2.5%
heystack	1,716,472,638	100%
localgrower	741,185,395	1%
beehivetrader	3,250,651,008	10%
diamondlighthp	897,805,295	50%
pixiedust4u	1,016,815,268	50%
mariosfame	16,437,647,226	100%
vtol79	192,558,922	100%
friendlymoose	39,193,706,947	100%
senseiphil	3,287,652,377	20%
altleft	8,911,364,324,887	100%
abdul.qadir	0	5%
wxmark	0	100%
chucknun	9,425,946,358	20%
gcomplex	888,121,745	50%
acungametrailers	0	100%
stemcur	641,358,763	100%
hanez	1,123,689,597	50%
plasticsoul	927,786,737	50%
scrpt	925,172,325	50%
brofund-stem	1,440,868,191	55%
rikarivka	2,629,799,840	100%
ropehold	880,891,276	50%
fitlet	610,671,045	50%
strk	860,879,612	50%
hemerit	947,572,109	50%
midtrain	879,771,394	50%
starle	884,638,060	50%
thorc	868,701,223	50%
meta.condeas	638,268,762	60%
basechain	865,200,144	50%
torrey.leo	913,109,644	100%
flowc	866,802,212	50%
tv-d	867,002,760	50%
supersla	864,575,419	50%
alorian	868,452,930	50%
slat	849,017,158	50%
protoleo	858,710,950	50%
muski	820,931,755	50%
netaterra.leo	1,329,005,599	50%
twrk	905,155,701	50%
nathen007.leo	770,986,637	100%
stemline	9,857,772,496	100%
eth2	908,468,393	50%
he-index	524,424,518	1%
tslap	929,359,642	50%
hodol	774,836,591	50%
meestemboom	3,454,370,820	100%
shmoogleosu.stem	303,652,130	100%
academiccuration	856,587,115	100%
theco	928,050,945	50%
muskland	872,961,272	50%
hochismin	931,582,502	50%
emrebeyler.stem	1,497,667,576	100%
finleo	884,875,101	50%
givup	936,903,729	50%
etheru	948,512,429	50%
bynd	985,114,250	50%

@abh12345.stem · Dec 1 '20

$0.02

Good for tax returns 👏

👍 paulag, nathen007.leo, yggdrasil.laguna

`author`	abh12345.stem
`permlink`	qkolt6
`category`	hive-167922
`json_metadata`	{"tags":["stem"],"app":"stemgeeks/0.1","canonical_url":"https://stemgeeks.net/@abh12345.stem/qkolt6"}
`created`	2020-12-01 22:15:03
`last_update`	2020-12-01 22:15:03
`depth`	1
`children`	3
`last_payout`	2020-12-08 22:15:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.010 HBD
`curator_payout_value`	0.011 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	22
`author_reputation`	410,560,470,359
`root_title`	"Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	100,770,269
`net_rshares`	175,539,275,312
`author_curate_reward`	""

properties (23)vote details (3)

voter	rshares	pct
paulag	174,777,243,562	20%
yggdrasil.laguna	7,271,436	10%
nathen007.leo	754,760,314	100%

@nathen007.leo · Dec 2 '20

Watch your language lad....

Posted Using [LeoFinance <sup>Beta</sup>](https://leofinance.io/@nathen007.leo/re-abh12345-stem-64jfee)

👍 ash, slider2990, abh12345.stem

`author`	nathen007.leo
`permlink`	re-abh12345-stem-64jfee
`category`	hive-167922
`json_metadata`	{"app":"leofinance/0.2","format":"markdown","tags":["hive-167922","leofinance"],"canonical_url":"https://leofinance.io/@nathen007.leo/re-abh12345-stem-64jfee"}
`created`	2020-12-02 04:40:51
`last_update`	2020-12-02 04:40:51
`depth`	2
`children`	1
`last_payout`	2020-12-09 04:40:51
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	132
`author_reputation`	2,158,949,642,679
`root_title`	"Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	100,773,856
`net_rshares`	69,574,500,502
`author_curate_reward`	""

properties (23)vote details (3)

voter	rshares	pct
ash	69,154,100,082	10%
slider2990	305,743,884	14%
abh12345.stem	114,656,536	20%

@abh12345.stem · Dec 2 '20

🤐🤑

properties (22)

`author`	abh12345.stem
`permlink`	qkp9ml
`category`	hive-167922
`json_metadata`	{"tags":["stem"],"app":"stemgeeks/0.1","canonical_url":"https://stemgeeks.net/@abh12345.stem/qkp9ml"}
`created`	2020-12-02 06:49:30
`last_update`	2020-12-02 06:49:30
`depth`	3
`children`	0
`last_payout`	2020-12-09 06:49:30
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	2
`author_reputation`	410,560,470,359
`root_title`	"Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	100,774,877
`net_rshares`	0

@paulag · Dec 2 '20

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

properties (22)

`author`	paulag
`permlink`	re-abh12345stem-qkph8n
`category`	hive-167922
`json_metadata`	{"tags":["hive-167922"],"app":"peakd/2020.11.4"}
`created`	2020-12-02 09:34:27
`last_update`	2020-12-02 09:34:27
`depth`	2
`children`	0
`last_payout`	2020-12-09 09:34:27
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	104
`author_reputation`	274,264,287,951,003
`root_title`	"Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	100,776,419
`net_rshares`	0

@ash · Dec 2 '20

$0.02

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

Posted Using [LeoFinance <sup>Beta</sup>](https://leofinance.io/@ash/re-paulag-k3dvk)

👍 paulag, yggdrasil.laguna

`author`	ash
`permlink`	re-paulag-k3dvk
`category`	hive-167922
`json_metadata`	{"app":"leofinance/0.2","format":"markdown","tags":["hive-167922","leofinance"],"canonical_url":"https://leofinance.io/@ash/re-paulag-k3dvk"}
`created`	2020-12-02 08:20:21
`last_update`	2020-12-02 08:20:21
`depth`	1
`children`	1
`last_payout`	2020-12-09 08:20:21
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.011 HBD
`curator_payout_value`	0.011 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	178
`author_reputation`	286,803,743,324,398
`root_title`	"Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	100,775,711
`net_rshares`	182,182,806,271
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
paulag	0 B		182,175,420,893	21%
yggdrasil.laguna	0 B		7,385,378	10%

@paulag · Dec 2 '20

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.

properties (22)

`author`	paulag
`permlink`	re-ash-qkphjt
`category`	hive-167922
`json_metadata`	{"tags":["hive-167922"],"app":"peakd/2020.11.4"}
`created`	2020-12-02 09:40:42
`last_update`	2020-12-02 09:40:42
`depth`	2
`children`	0
`last_payout`	2020-12-09 09:40:42
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	139
`author_reputation`	274,264,287,951,003
`root_title`	"Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	100,776,496
`net_rshares`	0

@bluemoon · Dec 3 '20

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 <sup>Beta</sup>](https://leofinance.io/@bluemoon/re-paulag-a3gln)

properties (22)

`author`	bluemoon
`permlink`	re-paulag-a3gln
`category`	hive-167922
`json_metadata`	{"app":"leofinance/0.2","format":"markdown","tags":["hive-167922","leofinance"],"canonical_url":"https://leofinance.io/@bluemoon/re-paulag-a3gln"}
`created`	2020-12-03 09:43:21
`last_update`	2020-12-03 09:43:21
`depth`	1
`children`	2
`last_payout`	2020-12-10 09:43:21
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	239
`author_reputation`	654,411,213,847,146
`root_title`	"Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	100,791,382
`net_rshares`	0

@paulag · Dec 6 '20

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

Posted Using [LeoFinance <sup>Beta</sup>](https://leofinance.io/@paulag/re-bluemoon-4vyetn)

properties (22)

`author`	paulag
`permlink`	re-bluemoon-4vyetn
`category`	hive-167922
`json_metadata`	{"app":"leofinance/0.2","format":"markdown","tags":["hive-167922","leofinance"],"canonical_url":"https://leofinance.io/@paulag/re-bluemoon-4vyetn"}
`created`	2020-12-06 15:53:12
`last_update`	2020-12-06 15:53:12
`depth`	2
`children`	1
`last_payout`	2020-12-13 15:53:12
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	166
`author_reputation`	274,264,287,951,003
`root_title`	"Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	100,838,181
`net_rshares`	0

@bluemoon · Dec 6 '20

Yes.me too. With pleasure!

Posted Using [LeoFinance <sup>Beta</sup>](https://leofinance.io/@bluemoon/re-paulag-3bcadf)

properties (22)

`author`	bluemoon
`permlink`	re-paulag-3bcadf
`category`	hive-167922
`json_metadata`	{"app":"leofinance/0.2","format":"markdown","tags":["hive-167922","leofinance"],"canonical_url":"https://leofinance.io/@bluemoon/re-paulag-3bcadf"}
`created`	2020-12-06 16:54:24
`last_update`	2020-12-06 16:54:24
`depth`	3
`children`	0
`last_payout`	2020-12-13 16:54:24
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	119
`author_reputation`	654,411,213,847,146
`root_title`	"Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	100,838,909
`net_rshares`	0

@hivebuzz · Dec 6 '20

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

<table><tr><td><img src="https://images.hive.blog/60x70/http://hivebuzz.me/@paulag/upvotes.png?202012061046"></td><td>You distributed more than 65000 upvotes. Your next target is to reach 66000 upvotes.</td></tr>
</table>

<sub>_You can view your badges on [your board](https://hivebuzz.me/@paulag) and compare yourself to others in the [Ranking](https://hivebuzz.me/ranking)_</sub>
<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>



**Do not miss the last post from @hivebuzz:**
<table><tr><td><a href="/hivebuzz/@hivebuzz/st-nicholas-2020"><img src="https://images.hive.blog/64x128/https://i.imgur.com/KyCt9oC.png"></a></td><td><a href="/hivebuzz/@hivebuzz/st-nicholas-2020">Saint-Nicolas challenge for well-behaved girls and boys</a></td></tr><tr><td><a href="/hive-106258/@hivebuzz/hivefest5-shop"><img src="https://images.hive.blog/64x128/https://i.imgur.com/MY2RyEX.png"></a></td><td><a href="/hive-106258/@hivebuzz/hivefest5-shop">HiveFest⁵ badges available in the HiveBuzz shop</a></td></tr><tr><td><a href="/hive-106258/@hivebuzz/hivefest5-badge"><img src="https://images.hive.blog/64x128/https://i.imgur.com/YctqirB.png"></a></td><td><a href="/hive-106258/@hivebuzz/hivefest5-badge">The new HiveFest⁵ Attendee badge is waiting for you</a></td></tr></table>

properties (22)

`author`	hivebuzz
`permlink`	hivebuzz-notify-paulag-20201206t111435000z
`category`	hive-167922
`json_metadata`	{"image":["http://hivebuzz.me/notify.t6.png"]}
`created`	2020-12-06 11:14:33
`last_update`	2020-12-06 11:14:33
`depth`	1
`children`	0
`last_payout`	2020-12-13 11:14:33
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1,459
`author_reputation`	367,875,542,916,368
`root_title`	"Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	100,835,116
`net_rshares`	0

@klye · Dec 2 '20

$0.02

NERD!

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

👍 paulag, yggdrasil.laguna

`author`	klye
`permlink`	re-paulag-qkpcsm
`category`	hive-167922
`json_metadata`	{"tags":["hive-167922"],"app":"peakd/2020.11.4"}
`created`	2020-12-02 07:59:06
`last_update`	2020-12-02 07:59:06
`depth`	1
`children`	3
`last_payout`	2020-12-09 07:59:06
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.012 HBD
`curator_payout_value`	0.011 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	83
`author_reputation`	401,073,947,379,813
`root_title`	"Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	100,775,499
`net_rshares`	182,947,761,905
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
paulag	0 B		182,940,147,958	21%
yggdrasil.laguna	0 B		7,613,947	10%

@paulag · Dec 2 '20

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.

👍 klye, yggdrasil.laguna

`author`	paulag
`permlink`	re-klye-qkphhh
`category`	hive-167922
`json_metadata`	{"tags":["hive-167922"],"app":"peakd/2020.11.4"}
`created`	2020-12-02 09:39:18
`last_update`	2020-12-02 09:39:18
`depth`	2
`children`	2
`last_payout`	2020-12-09 09:39:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	329
`author_reputation`	274,264,287,951,003
`root_title`	"Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	100,776,483
`net_rshares`	146,486,540,282
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
klye	0 B		146,479,040,734	100%
yggdrasil.laguna	0 B		7,499,548	10%

@klye · Dec 2 '20

Guess am fucking oblivious.. lmao.

that is bad ass though.

properties (22)

`author`	klye
`permlink`	qkpiz4
`category`	hive-167922
`json_metadata`	{"app":"hiveblog/0.1"}
`created`	2020-12-02 10:12:39
`last_update`	2020-12-02 10:12:39
`depth`	3
`children`	1
`last_payout`	2020-12-09 10:12:39
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	59
`author_reputation`	401,073,947,379,813
`root_title`	"Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	100,776,816
`net_rshares`	0

1 reply

@poshbot · Dec 1 '20

$0.02

https://twitter.com/ProfTAcademy/status/1333856457528406017

👍 paulag

`author`	poshbot
`permlink`	re-connect-excel-to-coingecko-api-for-historical-ohlc-cryptocurrency-data-and-chart-20201201t193223z
`category`	hive-167922
`json_metadata`	"{"app": "beem/0.24.8"}"
`created`	2020-12-01 19:32:24
`last_update`	2020-12-01 19:32:24
`depth`	1
`children`	0
`last_payout`	2020-12-08 19:32:24
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.010 HBD
`curator_payout_value`	0.011 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	59
`author_reputation`	5,554,335,374,496
`root_title`	"Connect Excel to CoinGecko API for Historical OHLC cryptocurrency data and chart"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	100,768,120
`net_rshares`	172,771,550,949
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
paulag	0 B		172,771,550,949	20%