How to get historical data excel?

[hitchingAride]

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? 

[cellard]

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.

[tobacco123]

Which exchange was the data based on? Prior to 2013 MT Gox was the largest exchange but not after that.

Historical data back to 2010 in csv format


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

[hitchingAride]

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.

[cellard]

Which exchange was the data based on? Prior to 2013 MT Gox was the largest exchange but not after that.

Historical data back to 2010 in csv format


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

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.