Author

Topic: How to get historical data excel? (Read 2387 times)

legendary
Activity: 1372
Merit: 1252
December 19, 2015, 01:30:26 PM
#5
Which exchange was the data based on? Prior to 2013 MT Gox was the largest exchange but not after that.



I have no idea as I wasn't around back then. As far as I know Mt Gox was the first exchange ever, so if you further back in time im guessing that the price was stimated by looking at the average buy/sell orders of individuals doing trades.
member
Activity: 78
Merit: 10
December 18, 2015, 07:39:43 PM
#4

All trades:

http://api.bitcoincharts.com/v1/csv/

Im able to open this with OpenCalc, so you will be able to do it with Excel. This should be all you need.

Hey thank you for the links I was able to get good bitcoin data. But I am still trying to find historical prices for popular altcoins like DODGE, LTC, RIPPLE, NAMECOIN, etc. When I opened the above link and downloaded some of the csv files available I found the data a little unclear to me. I saw three columns, the first column appeared to be volume traded on that exchange the 2nd and 3rd column I was unsure of what they represented. For example in krakenLTC none of the columns to me seemed to reflect price of LiteCoin in either USD or BTC in addition their were no dates.
sr. member
Activity: 552
Merit: 250
December 17, 2015, 11:44:57 PM
#3
Which exchange was the data based on? Prior to 2013 MT Gox was the largest exchange but not after that.


legendary
Activity: 1372
Merit: 1252
December 17, 2015, 09:17:27 PM
#2
Historical data back to 2010 in csv format


https://api.bitcoinaverage.com/history/USD/per_day_all_time_history.csv

More

https://blockchain.info/charts/market-price

Look at the bottom and copypaste it on excel.

All trades:

http://api.bitcoincharts.com/v1/csv/

Im able to open this with OpenCalc, so you will be able to do it with Excel. This should be all you need.
member
Activity: 78
Merit: 10
December 17, 2015, 07:52:26 PM
#1
I am trying to do research and want to download raw historical price data into excel for various Cryptocurrancies. Are there any sites where I could download data for different altcoins or a way of extracting this from the graphs on sites like coinmarketcap.com?  Huh
Jump to: