Author

Topic: Importing historic marketcap data into excel (Read 521 times)

hero member
Activity: 686
Merit: 500
I am now using this addon for excel to scrape historic data from coinmarketcap's hystoric snapshots: http://analystcave.com/excel-scrape-html-element-id/
Using the ID 'total-marketcap' to import the data into excel.
Data from before 2013 I got from https://data.bitcoinity.org/, with the assumption that Bitcoin was the only cryptocoin.

Below all the marketcap data (in USD) for people who would want it:

Code:
Date Marketcap
22-7-2010 280079.37
23-7-2010 203592.22
24-7-2010 215564.15
25-7-2010 194593.46
3-8-2010 216090.00
4-8-2010 225087.41
11-8-2010 228169.30
17-8-2010 245137.03
21-8-2010 245254.75
22-8-2010 243118.95
23-8-2010 247519.35
27-8-2010 245443.20
31-8-2010 247975.88
5-9-2010 244154.52
10-9-2010 240892.05
12-9-2010 244649.76
13-9-2010 246405.33
19-9-2010 245826.67
21-9-2010 255896.64
23-9-2010 253021.79
29-9-2010 256582.35
2-10-2010 257443.15
5-10-2010 256449.52
7-10-2010 264684.42
9-10-2010 351239.46
10-10-2010 392383.28
11-10-2010 384711.60
13-10-2010 390422.70
14-10-2010 434894.81
20-10-2010 426059.29
24-10-2010 471198.60
27-10-2010 663735.60
1-11-2010 857159.17
4-11-2010 890201.74
5-11-2010 969470.36
6-11-2010 1157530.37
7-11-2010 1692730.08
10-11-2010 954675.01
13-11-2010 1287898.84
18-11-2010 1028856.04
23-11-2010 1317158.55
24-11-2010 1323838.17
28-11-2010 1334394.53
29-11-2010 1318191.30
30-11-2010 1020031.99
1-12-2010 994019.89
3-12-2010 1190887.50
4-12-2010 1217370.00
6-12-2010 995522.75
8-12-2010 1157190.00
9-12-2010 1092291.90
16-12-2010 1164606.73
23-12-2010 1225164.38
24-12-2010 1239881.25
27-12-2010 1250739.28
29-12-2010 1354932.25
5-1-2011 1466710.53
6-1-2011 1514056.89
7-1-2011 1509912.07
13-1-2011 1641045.69
17-1-2011 1994772.73
18-1-2011 1805272.35
20-1-2011 1621890.71
21-1-2011 2023941.66
22-1-2011 2131754.00
23-1-2011 2313814.43
24-1-2011 2213218.11
26-1-2011 2152264.73
29-1-2011 2339876.75
31-1-2011 2530586.34
1-2-2011 2835351.70
2-2-2011 3809073.65
3-2-2011 3885551.02
5-2-2011 4489490.28
6-2-2011 4899598.00
8-2-2011 4756538.25
9-2-2011 4727466.86
10-2-2011 5503065.43
11-2-2011 5160018.04
12-2-2011 5435542.25
14-2-2011 5635486.75
15-2-2011 5739170.03
16-2-2011 5694543.75
17-2-2011 5679522.75
18-2-2011 5645730.74
19-2-2011 4963083.46
20-2-2011 5015026.34
22-2-2011 4714322.24
23-2-2011 5000941.04
26-2-2011 5119435.08
27-2-2011 5310361.65
28-2-2011 4942692.02
1-3-2011 4754655.38
2-3-2011 5123246.17
4-3-2011 5181143.56
7-3-2011 4893619.50
8-3-2011 4855901.60
9-3-2011 4804403.14
12-3-2011 5019283.51
13-3-2011 5092595.24
16-3-2011 4932952.48
17-3-2011 4841195.96
18-3-2011 4844748.71
19-3-2011 4465568.59
20-3-2011 4431082.22
21-3-2011 4355246.53
22-3-2011 4310872.63
23-3-2011 4643932.50
25-3-2011 5063441.43
26-3-2011 5087551.93
27-3-2011 4778373.01
28-3-2011 4732773.50
29-3-2011 4577380.83
30-3-2011 4590044.47
31-3-2011 4556686.40
1-4-2011 4516364.56
2-4-2011 4504158.33
4-4-2011 4541476.47
5-4-2011 4025789.68
6-4-2011 4373787.48
7-4-2011 4387716.90
8-4-2011 4430494.05
9-4-2011 4388603.36
11-4-2011 4320384.83
12-4-2011 4684253.26
13-4-2011 5080600.50
14-4-2011 5496925.05
15-4-2011 5831728.98
16-4-2011 5768555.58
17-4-2011 6113045.80
18-4-2011 6792257.75
19-4-2011 6915993.23
20-4-2011 7082520.07
21-4-2011 6851521.82
22-4-2011 7185933.90
23-4-2011 8227771.03
24-4-2011 10263463.33
25-4-2011 9917548.52
26-4-2011 9464578.57
27-4-2011 10622861.98
28-4-2011 11366255.16
29-4-2011 13828546.13
30-4-2011 17353648.42
1-5-2011 21212625.00
2-5-2011 18666284.12
3-5-2011 19455920.00
4-5-2011 21092831.92
5-5-2011 20839856.63
6-5-2011 20363481.32
7-5-2011 21040085.46
8-5-2011 22389106.40
9-5-2011 23367875.83
10-5-2011 23604158.66
11-5-2011 34833763.39
12-5-2011 33192698.78
13-5-2011 39996786.43
14-5-2011 50119097.47
15-5-2011 45163694.83
16-5-2011 46031575.24
17-5-2011 49137594.26
18-5-2011 45400508.03
19-5-2011 42580312.01
20-5-2011 43644766.50
22-5-2011 38667622.86
23-5-2011 42540092.92
24-5-2011 45128712.25
25-5-2011 46837352.45
26-5-2011 52540648.10
27-5-2011 55504793.67
28-5-2011 54272474.81
29-5-2011 53226080.89
30-5-2011 53183674.41
31-5-2011 55969135.05
1-6-2011 54724724.88
2-6-2011 61459424.58
3-6-2011 69143370.39
4-6-2011 90956709.38
5-6-2011 118617094.12
6-6-2011 107476121.84
7-6-2011 119799656.37
8-6-2011 149913065.17
9-6-2011 195000465.37
10-6-2011 186197716.34
11-6-2011 155523796.38
12-6-2011 96878911.64
13-6-2011 119592053.17
14-6-2011 130687879.20
15-6-2011 129383146.43
16-6-2011 126817284.74
17-6-2011 113302652.07
18-6-2011 105496592.98
19-6-2011 113922335.62
13-9-2011 44634700.23
11-10-2011 36483440.00
2-12-2011 23988799.28
3-12-2011 24230335.52
4-12-2011 21708092.95
5-12-2011 21853132.50
6-12-2011 22736167.36
7-12-2011 23554623.88
8-12-2011 23428238.28
9-12-2011 23589697.73
10-12-2011 23379839.36
11-12-2011 24267316.66
12-12-2011 25700327.41
13-12-2011 25072608.21
15-12-2011 24704148.04
16-12-2011 25279179.03
17-12-2011 25221258.23
18-12-2011 25197172.70
19-12-2011 25277816.48
20-12-2011 27709632.86
21-12-2011 31088267.55
22-12-2011 30745372.50
23-12-2011 30673156.69
24-12-2011 31209800.38
25-12-2011 31366200.67
26-12-2011 33419466.57
27-12-2011 32067813.89
28-12-2011 32534840.74
29-12-2011 33485618.18
30-12-2011 33581886.88
31-12-2011 33997384.26
1-1-2012 37725699.40
2-1-2012 42224533.71
3-1-2012 41371525.49
4-1-2012 38974170.57
5-1-2012 46568692.61
6-1-2012 56920928.61
7-1-2012 53305004.63
8-1-2012 54647693.53
9-1-2012 57170795.87
10-1-2012 50881610.99
11-1-2012 52631355.68
12-1-2012 55846287.73
13-1-2012 54649942.07
14-1-2012 51492779.32
15-1-2012 55583734.19
16-1-2012 56725070.89
17-1-2012 54125616.20
18-1-2012 46899114.50
19-1-2012 48404316.08
20-1-2012 51783723.39
21-1-2012 53043362.85
22-1-2012 50430724.58
23-1-2012 51478970.38
24-1-2012 52142238.37
25-1-2012 51529385.06
26-1-2012 47496049.43
27-1-2012 44020923.04
28-1-2012 43594948.62
29-1-2012 46271930.51
30-1-2012 44418664.68
31-1-2012 45505037.63
1-2-2012 45589247.66
2-2-2012 50103281.36
3-2-2012 49089070.18
4-2-2012 48961807.32
5-2-2012 48010461.19
6-2-2012 45783716.62
7-2-2012 45614206.75
8-2-2012 47290006.98
9-2-2012 46819218.14
10-2-2012 48692597.77
11-2-2012 49184378.79
12-2-2012 46151218.76
13-2-2012 46903332.25
14-2-2012 44300075.15
15-2-2012 37652757.84
16-2-2012 34877010.91
17-2-2012 35897390.32
18-2-2012 36911053.72
19-2-2012 35963278.23
20-2-2012 36809368.75
21-2-2012 36805831.15
22-2-2012 36230554.09
23-2-2012 37672244.95
24-2-2012 42406759.56
25-2-2012 42283690.11
26-2-2012 40361826.10
27-2-2012 41678883.51
28-2-2012 41874753.68
29-2-2012 41073805.21
1-3-2012 41302319.22
2-3-2012 41775301.70
3-3-2012 39918357.46
4-3-2012 39376418.82
5-3-2012 41035345.39
6-3-2012 42310233.49
7-3-2012 42427138.71
8-3-2012 42186779.08
9-3-2012 41833143.31
10-3-2012 41655368.84
11-3-2012 41237034.31
12-3-2012 41978188.55
13-3-2012 42023854.97
14-3-2012 45127145.52
15-3-2012 46298456.12
16-3-2012 46041893.46
17-3-2012 45852352.49
18-3-2012 44929797.50
19-3-2012 45438156.30
20-3-2012 40536349.62
21-3-2012 41292830.27
22-3-2012 41556688.38
23-3-2012 40243458.21
24-3-2012 40602427.30
25-3-2012 40269918.43
26-3-2012 39508621.56
27-3-2012 39411389.20
28-3-2012 41647411.91
29-3-2012 41263284.49
30-3-2012 41713256.32
31-3-2012 42256302.35
1-4-2012 42628670.53
2-4-2012 41541644.93
3-4-2012 42912060.41
4-4-2012 43113487.91
5-4-2012 42817534.57
6-4-2012 42819334.55
7-4-2012 43204311.19
8-4-2012 40833907.30
9-4-2012 41833464.21
10-4-2012 42444173.92
11-4-2012 42403056.70
12-4-2012 43183799.26
13-4-2012 43087259.03
14-4-2012 43700098.89
15-4-2012 43513735.24
16-4-2012 43561031.11
17-4-2012 43594915.33
18-4-2012 44157402.99
19-4-2012 45373236.00
20-4-2012 45485741.89
21-4-2012 47470320.91
22-4-2012 46588238.27
23-4-2012 45971122.96
24-4-2012 44263952.00
25-4-2012 45179504.58
26-4-2012 45705192.56
27-4-2012 45200946.68
28-4-2012 45257797.96
29-4-2012 43653827.36
30-4-2012 43614571.40
1-5-2012 44012557.51
2-5-2012 45011804.51
3-5-2012 45044461.32
4-5-2012 45869434.51
5-5-2012 45413926.00
6-5-2012 45274287.10
7-5-2012 44796294.76
8-5-2012 45468189.90
9-5-2012 45125091.90
10-5-2012 45324069.75
11-5-2012 43895490.96
12-5-2012 44480063.16
13-5-2012 44628692.04
14-5-2012 44472746.82
15-5-2012 45129556.72
16-5-2012 45352836.09
17-5-2012 45921380.97
18-5-2012 45958701.85
19-5-2012 46265934.83
20-5-2012 46303162.68
21-5-2012 46130155.76
22-5-2012 46170570.55
23-5-2012 46199097.39
24-5-2012 46377850.78
25-5-2012 46486235.70
26-5-2012 46538571.33
27-5-2012 46421463.56
28-5-2012 46620822.19
29-5-2012 46620252.35
30-5-2012 46697581.41
31-5-2012 46800627.52
1-6-2012 47467895.09
2-6-2012 47998546.63
3-6-2012 47836777.33
4-6-2012 47637021.27
5-6-2012 48537658.04
6-6-2012 49837951.34
7-6-2012 50081527.88
8-6-2012 51234849.01
9-6-2012 51697549.84
10-6-2012 51019723.97
11-6-2012 50328091.47
12-6-2012 50854676.26
13-6-2012 52737876.16
14-6-2012 54600515.65
15-6-2012 54659350.98
16-6-2012 59149377.85
17-6-2012 59559470.38
18-6-2012 56947618.39
19-6-2012 58339863.70
20-6-2012 60236354.79
21-6-2012 62310127.23
22-6-2012 61895038.32
23-6-2012 61042681.57
24-6-2012 59820606.42
25-6-2012 59087380.24
26-6-2012 58619315.08
27-6-2012 59902282.93
28-6-2012 61535933.13
29-6-2012 61565727.46
30-6-2012 61778172.77
1-7-2012 62383515.89
2-7-2012 62058462.96
3-7-2012 63021602.13
4-7-2012 60786704.26
5-7-2012 61058469.61
6-7-2012 62334405.73
7-7-2012 62907194.26
8-7-2012 63507279.83
9-7-2012 64089595.68
10-7-2012 66435923.98
11-7-2012 67868531.97
12-7-2012 67763297.63
13-7-2012 71966612.43
14-7-2012 72189646.67
15-7-2012 71139584.45
16-7-2012 72508065.52
17-7-2012 82242400.90
18-7-2012 84335218.13
19-7-2012 86639905.37
20-7-2012 78461412.33
21-7-2012 78632333.81
22-7-2012 83239551.56
23-7-2012 77169073.30
24-7-2012 81510404.75
25-7-2012 81378440.19
26-7-2012 83137371.01
27-7-2012 85114764.60
28-7-2012 85103506.19
29-7-2012 84598255.71
30-7-2012 83724817.05
31-7-2012 87060375.91
1-8-2012 89492402.24
2-8-2012 91661039.54
3-8-2012 101992788.47
4-8-2012 102912688.88
5-8-2012 101125523.76
6-8-2012 103317874.64
7-8-2012 103951801.58
8-8-2012 107082320.13
9-8-2012 106710723.06
10-8-2012 107963291.61
11-8-2012 110928044.78
12-8-2012 111399222.37
13-8-2012 113296533.07
14-8-2012 116523615.10
15-8-2012 118543575.75
16-8-2012 129385503.70
17-8-2012 131620111.61
18-8-2012 114841187.50
19-8-2012 111575481.46
20-8-2012 83922992.84
21-8-2012 97266835.88
22-8-2012 97705759.75
23-8-2012 96033479.16
24-8-2012 98662026.77
25-8-2012 103065922.91
26-8-2012 103448756.55
27-8-2012 103826846.71
28-8-2012 107181888.97
29-8-2012 106972369.15
30-8-2012 106803740.28
31-8-2012 105561854.32
1-9-2012 100001798.88
2-9-2012 97889719.97
3-9-2012 100365153.24
4-9-2012 103461876.28
5-9-2012 102123862.23
6-9-2012 108018082.52
7-9-2012 109946814.28
8-9-2012 108883291.02
9-9-2012 109571251.86
10-9-2012 109582294.60
11-9-2012 110343786.28
12-9-2012 109499642.73
13-9-2012 112326834.60
14-9-2012 112915304.86
15-9-2012 116229526.42
16-9-2012 117638485.29
17-9-2012 118571501.26
18-9-2012 118611428.77
19-9-2012 121845390.11
20-9-2012 125470401.15
21-9-2012 123598724.59
22-9-2012 123103986.91
23-9-2012 121962758.66
24-9-2012 122379976.71
25-9-2012 121004368.59
26-9-2012 121257168.39
27-9-2012 123813695.50
28-9-2012 123513458.50
29-9-2012 124598034.54
30-9-2012 124599299.53
1-10-2012 124700183.05
2-10-2012 124820862.78
3-10-2012 128781037.74
4-10-2012 130571680.47
5-10-2012 130152666.40
6-10-2012 129263331.77
7-10-2012 125372087.84
8-10-2012 120273423.88
9-10-2012 119682520.28
10-10-2012 120465511.29
11-10-2012 122901542.20
12-10-2012 122769568.40
13-10-2012 121790316.65
14-10-2012 121012155.71
15-10-2012 119000032.18
16-10-2012 121374129.92
17-10-2012 120803304.48
18-10-2012 121455498.66
19-10-2012 121550953.16
20-10-2012 119987652.54
21-10-2012 119705738.60
22-10-2012 119014722.02
23-10-2012 119949467.50
24-10-2012 119765091.55
25-10-2012 118790262.98
26-10-2012 110974571.51
27-10-2012 104178333.73
28-10-2012 105939427.52
29-10-2012 110609196.49
30-10-2012 106145970.35
31-10-2012 112386490.71
1-11-2012 114302412.67
2-11-2012 109698855.26
3-11-2012 107570228.49
4-11-2012 109589703.52
5-11-2012 111462264.60
6-11-2012 110707039.96
7-11-2012 112142151.25
8-11-2012 112971625.71
9-11-2012 112653692.27
10-11-2012 112184175.03
11-11-2012 112690223.81
12-11-2012 112371711.11
13-11-2012 114753490.76
14-11-2012 114188805.85
15-11-2012 114410837.55
16-11-2012 116573442.24
17-11-2012 121958412.64
18-11-2012 122581810.88
19-11-2012 121385112.20
20-11-2012 122246919.83
21-11-2012 122519439.25
22-11-2012 122665861.13
23-11-2012 128214247.71
24-11-2012 129160644.67
25-11-2012 129795379.75
26-11-2012 130933495.82
27-11-2012 127725398.31
28-11-2012 127974958.77
29-11-2012 129273273.84
30-11-2012 131500281.33
1-12-2012 132031310.97
2-12-2012 132271911.20
3-12-2012 131640204.31
4-12-2012 132958381.92
5-12-2012 139805154.46
6-12-2012 139668126.82
7-12-2012 138202852.03
8-12-2012 141624106.10
9-12-2012 141394604.75
10-12-2012 140470555.96
11-12-2012 140854440.72
12-12-2012 142994484.72
13-12-2012 144352533.12
14-12-2012 144178363.01
15-12-2012 143116237.15
16-12-2012 142962973.55
17-12-2012 141018547.30
18-12-2012 140589522.28
19-12-2012 139968510.42
20-12-2012 143386598.78
21-12-2012 142862124.68
22-12-2012 142203921.27
23-12-2012 139654435.58
24-12-2012 140362937.31
25-12-2012 141467005.58
26-12-2012 141480220.32
27-12-2012 141772699.59
28-12-2012 142039104.83
29-12-2012 143550018.94
30-12-2012 141752673.15
31-12-2012 142880812.44
1-1-2013 143547800.06
2-1-2013 141357457.69
3-1-2013 141274605.19
4-1-2013 141830895.60
5-1-2013 143229884.77
6-1-2013 142703385.73
7-1-2013 142915413.11
8-1-2013 144045858.33
9-1-2013 145528768.12
10-1-2013 146904268.45
11-1-2013 150122736.77
12-1-2013 151100231.39
13-1-2013 151539859.63
14-1-2013 150530371.96
15-1-2013 152430032.00
16-1-2013 151953568.36
17-1-2013 156719130.63
18-1-2013 167309643.91
19-1-2013 167731365.02
20-1-2013 166089509.84
21-1-2013 167251705.99
22-1-2013 179699041.43
23-1-2013 185822655.67
24-1-2013 189602539.21
25-1-2013 177437832.19
26-1-2013 184220937.48
27-1-2013 188406653.73
28-1-2013 190843505.72
29-1-2013 200916018.34
30-1-2013 207905967.66
31-1-2013 211241498.25
1-2-2013 221354797.06
2-2-2013 217805491.13
3-2-2013 210367979.30
4-2-2013 220856770.93
5-2-2013 220961270.95
6-2-2013 222550016.28
7-2-2013 225165225.96
8-2-2013 238085821.58
9-2-2013 243656637.14
10-2-2013 255719343.98
11-2-2013 257613083.87
12-2-2013 263055549.01
13-2-2013 271384982.35
14-2-2013 248300232.86
15-2-2013 292823498.43
16-2-2013 293077352.26
17-2-2013 294758763.65
18-2-2013 288278773.43
19-2-2013 290758177.25
20-2-2013 317245296.48
21-2-2013 321579668.24
22-2-2013 321969271.79
23-2-2013 327386747.22
24-2-2013 320768382.79
25-2-2013 322277706.18
26-2-2013 328029759.10
27-2-2013 335621477.78
28-2-2013 345770431.59
1-3-2013 361414831.67
2-3-2013 374454386.33
3-3-2013 371423709.00
4-3-2013 373199293.54
5-3-2013 394833603.85
6-3-2013 441753078.42
7-3-2013 408468604.91
8-3-2013 455764260.68
9-3-2013 477117119.97
10-3-2013 508454256.10
11-3-2013 503256460.75
12-3-2013 520243534.47
13-3-2013 482307048.20
14-3-2013 511690121.47
15-3-2013 512270485.64
16-3-2013 509630826.19
17-3-2013 514708707.02
18-3-2013 518116118.47
19-3-2013 553384600.77
20-3-2013 648237411.16
21-3-2013 701333072.79
22-3-2013 775657272.50
23-3-2013 763872659.21
24-3-2013 695761431.91
25-3-2013 771313465.83
26-3-2013 807901250.24
27-3-2013 861960120.82
28-3-2013 977326827.56
29-3-2013 939154793.79
30-3-2013 985428849.75
31-3-2013 1011519644.93
1-4-2013 1022723777.25
2-4-2013 1135801555.56
3-4-2013 1286178962.88
4-4-2013 1405466891.73
5-4-2013 1447061078.52
6-4-2013 1563287304.01
7-4-2013 1574034893.63
8-4-2013 1821131511.43
9-4-2013 2070397108.21
10-4-2013 2528043063.72
11-4-2013 1921097022.01
12-4-2013 853506380.65
13-4-2013 1336583924.30
14-4-2013 1030348016.53
15-4-2013 1009371371.68
16-4-2013 890441691.41
17-4-2013 734815192.04
18-4-2013 1036515879.70
19-4-2013 1195806241.63
20-4-2013 1299190088.16
21-4-2013 1420245273.12
22-4-2013 1343625826.20
23-4-2013 1407694855.95
24-4-2013 1578200748.58
25-4-2013 1715119392.89
26-4-2013 1563967729.96
27-4-2013 1516413811.83
28-4-2013 1596170459.00
5-5-2013 1341783035.00
12-5-2013 1367920187.00
19-5-2013 1448321623.00
26-5-2013 1548981721.00
2-6-2013 1487465499.00
9-6-2013 1199680552.00
16-6-2013 1177742472.00
23-6-2013 1287573562.00
30-6-2013 1147557199.00
7-7-2013 830146596.00
14-7-2013 1161533234.00
21-7-2013 1097986517.00
28-7-2013 1157533984.00
4-8-2013 1275693704.00
11-8-2013 1296559186.00
18-8-2013 1424107276.00
25-8-2013 1511079284.00
1-9-2013 1703496657.00
8-9-2013 1563491511.00
15-9-2013 1631369960.00
22-9-2013 1647606831.00
29-9-2013 1801705443.00
6-10-2013 1659752178.00
13-10-2013 1739052073.00
20-10-2013 2156966857.00
27-10-2013 2276740215.00
3-11-2013 2593828490.00
10-11-2013 3972643647.00
17-11-2013 5703249683.00
24-11-2013 9553072909.00
1-12-2013 14812595338.00
8-12-2013 9826617193.00
15-12-2013 11588330002.00
22-12-2013 8360331552.00
29-12-2013 10059549893.00
5-1-2014 11955532016.00
12-1-2014 12377706984.00
19-1-2014 11466918031.00
26-1-2014 11782845793.00
2-2-2014 11584562128.00
9-2-2014 9339319336.00
16-2-2014 9116148352.00
23-2-2014 8629675866.00
2-3-2014 8047576132.00
9-3-2014 8891659862.00
16-3-2014 9054488764.00
23-3-2014 8130843063.00
30-3-2014 6753098780.00
6-4-2014 6464272468.00
13-4-2014 5916868130.00
20-4-2014 7134179934.00
27-4-2014 6379307495.00
4-5-2014 6107150939.00
11-5-2014 6347543249.00
18-5-2014 6343012860.00
25-5-2014 7723841926.00
1-6-2014 8899300285.00
8-6-2014 9139365192.00
15-6-2014 7966417363.00
22-6-2014 8446698872.00
29-6-2014 8378421008.00
6-7-2014 8764958494.00
13-7-2014 8765659339.00
20-7-2014 8739980805.00
27-7-2014 8331235442.00
3-8-2014 8200944045.00
10-8-2014 8240467782.00
17-8-2014 7124713006.00
24-8-2014 7045169827.00
31-8-2014 7120181961.00
7-9-2014 7002650073.00
14-9-2014 6949393564.00
21-9-2014 5903351424.00
28-9-2014 5889517238.00
5-10-2014 4886529533.00
12-10-2014 5339373745.00
19-10-2014 5781856424.00
26-10-2014 5194705547.00
2-11-2014 4828024718.00
9-11-2014 5159998716.00
16-11-2014 5667189126.00
23-11-2014 5406802496.00
30-11-2014 5910223097.00
7-12-2014 5916603162.00
14-12-2014 5615031869.00
21-12-2014 5614557515.00
28-12-2014 5513973609.00
4-1-2015 4843377075.00
11-1-2015 4687090901.00
18-1-2015 3480884538.00
25-1-2015 4235479865.00
1-2-2015 3672466209.00
8-2-2015 3836695491.00
15-2-2015 4315055946.00
22-2-2015 4099229716.00
1-3-2015 4192958006.00
8-3-2015 4440504692.00
15-3-2015 4568058063.00
22-3-2015 4212674884.00
29-3-2015 3995745797.00
5-4-2015 4066546893.00
12-4-2015 3801149009.00
19-4-2015 3616796211.00
26-4-2015 3561089168.00
3-5-2015 3817842183.00
10-5-2015 3858912692.00
17-5-2015 3776670315.00
24-5-2015 3868851073.00
31-5-2015 3845089941.00
7-6-2015 3728604006.00
14-6-2015 3861919560.00
21-6-2015 4186029370.00
28-6-2015 4285154752.00
5-7-2015 4477196122.00
12-7-2015 5037620311.00
19-7-2015 4600375069.00
26-7-2015 4842516604.00
2-8-2015 4680973917.00
9-8-2015 4480790382.00
16-8-2015 4492434387.00
23-8-2015 4018440648.00
30-8-2015 3984261566.00
6-9-2015 4141119952.00
13-9-2015 4060630694.00
20-9-2015 3991438483.00
27-9-2015 3992859056.00
4-10-2015 4026885684.00
11-10-2015 4108484676.00
18-10-2015 4467946282.00
25-10-2015 4727789381.00
1-11-2015 5235702497.00
8-11-2015 6277812164.00
15-11-2015 5447570275.00
22-11-2015 5344347673.00
29-11-2015 5837450315.00
6-12-2015 6453204158.00
13-12-2015 7179188197.00
20-12-2015 7519272202.00
27-12-2015 6840297446.00
3-1-2016 7092584989.00
10-1-2016 7305907940.00
17-1-2016 6397801172.00
24-1-2016 6601083549.00
31-1-2016 6520046543.00
7-2-2016 6590984823.00
14-2-2016 7135748988.00
21-2-2016 7799210820.00
28-2-2016 7724666960.00
6-3-2016 7746669089.00
13-3-2016 8252522780.00
20-3-2016 7920375578.00
27-3-2016 8113633212.00
3-4-2016 8193661811.00
10-4-2016 7912394455.00
17-4-2016 8090053223.00
24-4-2016 8449775734.00
1-5-2016 8421018669.00
8-5-2016 8617017640.00
15-5-2016 8663457781.00
22-5-2016 8797343300.00
29-5-2016 9962621877.00
5-6-2016 11143206542.00
12-6-2016 12043221786.00
19-6-2016 13889291614.00
26-6-2016 12532910075.00
3-7-2016 12977161091.00
10-7-2016 12254585336.00
17-7-2016 12882712904.00
24-7-2016 12879741553.00
31-7-2016 12492651746.00
7-8-2016 11638999573.00
14-8-2016 11560008512.00
21-8-2016 11515550201.00
28-8-2016 11262427474.00
4-9-2016 11840864472.00
11-9-2016 12315622956.00
18-9-2016 12111060135.00
25-9-2016 12082621564.00
2-10-2016 12218420453.00
9-10-2016 12253602442.00
16-10-2016 12574237580.00
23-10-2016 12925569597.00
30-10-2016 13464251691.00
6-11-2016 13625440140.00
13-11-2016 13308375877.00
20-11-2016 14175412237.00
27-11-2016 13820759194.00
4-12-2016 14279353037.00
11-12-2016 14282041272.00
18-12-2016 14668771316.00
25-12-2016 16106710995.00
1-1-2017 17700314429.00
8-1-2017 17226633499.00
15-1-2017 15504127778.00
22-1-2017 17577144408.00
29-1-2017 17426523507.00
5-2-2017 19563809241.00
12-2-2017 18851257528.00
19-2-2017 19888575067.00
26-2-2017 21441719523.00
5-3-2017 23814432204.00
12-3-2017 23286701272.00
19-3-2017 22617338502.00
26-3-2017 23338083738.00
2-4-2017 26183745930.00
9-4-2017 27769105748.00
16-4-2017 28726619311.00
23-4-2017 29768209789.00
30-4-2017 35314184683.00
7-5-2017 46567887425.00
14-5-2017 55167232636.00
21-5-2017 72005640042.00
28-5-2017 73276551382.00
4-6-2017 90751855973.00
11-6-2017 110011644694.00
18-6-2017 112023564520.00
25-6-2017 109205781828.00
2-7-2017 94716493346.00
9-7-2017 96413265892.00
legendary
Activity: 1792
Merit: 1283
I don't know if it's possible on Coinmarketcap, but I've found another website which allows you to get a csv file for the historic marketcap data.
Here you go:

https://data.bitcoinity.org/markets/market_cap/30d/USD?t=l

That is a nice one for Bitcoin, thnx for sharing Smiley
Bitcoin is only one part of what I want to analyze, I am looking for data on the whole cryptocurrency market, so including as much altcoins as possible.
Yeah, I can't find any similar ones for altcoins, I just found this one by searching on Google for: 'bitcoin marketcap csv'

I also looked on Coinmarketcap, but they really don't seem to provide csv files Sad

You can get other altcoin data here though:
http://alt19.com/
 * At the bottom of the page, you can download a csv file.

But it looks like you get all data in one CSV file, maybe it's still useful.
hero member
Activity: 686
Merit: 500
I don't know if it's possible on Coinmarketcap, but I've found another website which allows you to get a csv file for the historic marketcap data.
Here you go:

https://data.bitcoinity.org/markets/market_cap/30d/USD?t=l

That is a nice one for Bitcoin, thnx for sharing Smiley
Bitcoin is only one part of what I want to analyze, I am looking for data on the whole cryptocurrency market, so including as much altcoins as possible.
legendary
Activity: 1792
Merit: 1283
I don't know if it's possible on Coinmarketcap, but I've found another website which allows you to get a csv file for the historic marketcap data.
Here you go:

https://data.bitcoinity.org/markets/market_cap/30d/USD?t=l
hero member
Activity: 686
Merit: 500
I saw this topic on bct: https://bitcointalksearch.org/topic/total-marketcap-all-coins-logarithmic-regression-2000218 and I wanted to try something similar. Fiddel around with the data and trying some analysis on it. However I could nog find any way to import historic marketcap data into excel.
There is no such option on coinmarketcap.com in the API and I have not found another similar website that does have the option.

Does anyone of you guys have any suggestions or solutions on how to go about this?
Jump to: