Title: Where / How can I download historical prices of Alts into an Excel Spreadsheet Post by: jdlr on May 30, 2017, 09: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 Title: Re: Where / How can I download historical prices of Alts into an Excel Spreadsheet Post by: italianMiner72 on May 30, 2017, 01:15:06 PM 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 Title: Re: Where / How can I download historical prices of Alts into an Excel Spreadsheet Post by: jdlr on May 30, 2017, 02:35:41 PM That's very interesting , thank you.
Do you know if they have data for altcoins ? I could only find bitcoin related on quandl Title: Re: Where / How can I download historical prices of Alts into an Excel Spreadsheet Post by: ulhaq on May 30, 2017, 06:19:45 PM Use poloniex api.
Title: Re: Where / How can I download historical prices of Alts into an Excel Spreadsheet Post by: gjhiggins on May 30, 2017, 09: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 Title: Re: Where / How can I download historical prices of Alts into an Excel Spreadsheet Post by: jdlr on June 03, 2017, 12:46:20 PM would anyone have a working spreadsheet with APIs setup that I could use ?
Bounty available ! : ) Title: Re: Where / How can I download historical prices of Alts into an Excel Spreadsheet Post by: ppc.pt on June 03, 2017, 01:17:21 PM 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.. :( Title: Re: Where / How can I download historical prices of Alts into an Excel Spreadsheet Post by: jdlr on June 03, 2017, 02:32:58 PM not for free, we can agree a price !
Title: Re: Where / How can I download historical prices of Alts into an Excel Spreadsheet Post by: italianMiner72 on June 05, 2017, 08:16:49 AM 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!! Title: Re: Where / How can I download historical prices of Alts into an Excel Spreadsheet Post by: jdlr on June 08, 2017, 04:41:18 AM @ ItalianMiner :
I could only find bitcoin data on Quandl, there was no altcoins data, im interested in altcoin data, unless I have missed smthg ?? Title: Re: Where / How can I download historical prices of Alts into an Excel Spreadsheet Post by: rijnsent on June 14, 2017, 01:51:29 PM 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 |