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
Topic: Where / How can I download historical prices of Alts into an Excel Spreadsheet (Read 1096 times)
June 14, 2017, 08:51:29 AM
June 07, 2017, 11:41:18 PM
@ ItalianMiner :
I could only find bitcoin data on Quandl, there was no altcoins data, im interested in altcoin data,
unless I have missed smthg ??
I could only find bitcoin data on Quandl, there was no altcoins data, im interested in altcoin data,
unless I have missed smthg ??
June 05, 2017, 03:16:49 AM
would anyone have a working spreadsheet with APIs setup that I could use ?
Bounty available ! : )
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!!
June 03, 2017, 09:32:58 AM
not for free, we can agree a price !
June 03, 2017, 08:17:21 AM
would anyone have a working spreadsheet with APIs setup that I could use ?
Bounty available ! : )
Bounty available ! : )
I would be interested in this too
Guess no-one will provide a good one for free.. 
June 03, 2017, 07:46:20 AM
would anyone have a working spreadsheet with APIs setup that I could use ?
Bounty available ! : )
Bounty available ! : )
May 30, 2017, 04:38:09 PM
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
May 30, 2017, 01:19:45 PM
Use poloniex api.
May 30, 2017, 09:35:41 AM
That's very interesting , thank you.
Do you know if they have data for altcoins ?
I could only find bitcoin related on quandl
Do you know if they have data for altcoins ?
I could only find bitcoin related on quandl
May 30, 2017, 08:15:06 AM
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
May 30, 2017, 04:56:49 AM
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
Jump to: