Where / How can I download historical prices of Alts into an Excel Spreadsheet

[jdlr]

How can I get it the prices into an excel sheet with the date of each price.

Is there some kind of website where I can download ?

coimarketcap shows last 7 days only, and it is not detailed enough.

Some of you might have a ready made API or smth they use to do that, pls share, as Ive been looking for sometime and couldnt find.

Bounty available for whoever is helpful

thanks

[italianMiner72]

How can I get it the prices into an excel sheet with the date of each price.

Is there some kind of website where I can download ?

coimarketcap shows last 7 days only, and it is not detailed enough.

Some of you might have a ready made API or smth they use to do that, pls share, as Ive been looking for sometime and couldnt find.

Bounty available for whoever is helpful

thanks

usually i use this service
https://www.quandl.com/collections/markets/bitcoin-data
really interesting for the wide of the hystorical data.
There are a lots of Exchange...
give it a try

[jdlr]

That's very interesting , thank you.

Do you know if they have data for altcoins ?

I could only find bitcoin related on quandl

[ulhaq]

Use poloniex api.

[gjhiggins]

coimarketcap shows last 7 days only, and it is not detailed enough.

Detailed historical price data requires storage === costs money.

Otherwise:

Navigate to https://coinmarketcap.com, select “Tools” drop-down menu, click on “Historical Snapshots”, click on any date, import the HTML table to Excel.

https://coinmarketcap.com/historical/

Cheers

Graham

[jdlr]

would anyone have a working spreadsheet with APIs setup that I could use ?
Bounty available ! : )

[ppc.pt]

would anyone have a working spreadsheet with APIs setup that I could use ?
Bounty available ! : )

I would be interested in this too Guess no-one will provide a good one for free..

[jdlr]

not for free, we can agree a price !

[italianMiner72]

would anyone have a working spreadsheet with APIs setup that I could use ?
Bounty available ! : )

hi jdlr!!!
what's wrong with quandl???
you have tons of data there.
there are a lot's of exchange and cross there..
can you explain better what do you need???
thank you!!

[jdlr]

@ ItalianMiner :
I could only find bitcoin data on Quandl, there was no altcoins data, im interested in altcoin data,
unless I have missed smthg ??

[rijnsent]

Hi all,
you could indeed connect Excel via VBA to any of the online available APIs. It's work-in-process for me:
I am working on an Excel/VBA tool for e.g. Kraken, BTC-e and Poloniex in this project: https://github.com/krijnsent/crypto_vba
Getting data from e.g. min-api.cryptocompare.com is on my ToDo list. What data are you looking for? Historical rates? Daily/hourly/monthly? High-Low-Open-Close-Volume? Per exchange or just one exchange?
Cheers,
Koen