Bitcoin Forum

Economy => Economics => Topic started by: AndDuffy on January 27, 2012, 08:46:01 PM



Title: Need data!!
Post by: AndDuffy on January 27, 2012, 08:46:01 PM
Does anyone have Bitcoin charts and data in an Excel file that they'd be willing to share? As far back as possible; Gox, TH, anything, with as much info as possible. Thanks!


Title: Re: Need data!!
Post by: Revalin on January 27, 2012, 08:52:59 PM
You can get everything you need over at http://bitcoincharts.com/about/markets-api/

Quote
Historic Trade Data

Trade data is available as CSV, delayed by approx. 15 minutes.

http://bitcoincharts.com/t/trades.csv?symbol=SYMBOL[&start=UNIXTIME][&end=UNIXTIME]

returns CSV:

unixtime,price,amount

Without start or end set it'll return the last few days (this might change!).

Edit: For example:
http://bitcoincharts.com/t/trades.csv?symbol=mtgoxUSD&start=1303000000&end=1303100000

If you use start=0 and no end, you'll get everything since the beginning.  I won't link it directly for the sake of their servers.  :)


Title: Re: Need data!!
Post by: AndDuffy on January 27, 2012, 08:57:30 PM
Thanks... I know this may sound extremely noobish, but how can I get that data into an Excel file?


Title: Re: Need data!!
Post by: Revalin on January 27, 2012, 08:59:07 PM
Save what it gives you as a .csv then open/import it in Excel.

edit: Although Excel may puke if you give it that much data.  I'm not sure what the row limit is these days.


Title: Re: Need data!!
Post by: Lord F(r)og on January 27, 2012, 09:10:56 PM
http://obscureinternet.com/wp-content/uploads/This-is-Data-Star-Trek-Funny.jpg


Title: Re: Need data!!
Post by: Stephen Gornick on January 28, 2012, 07:19:46 AM
Available as Fusion tables on Google as well:
 - https://www.google.com/fusiontables/DataSource?snapid=S364820JWm5
 - http://bitcointalk.org/index.php?topic=59949.0


Title: Re: Need data!!
Post by: MusX on April 11, 2013, 06:24:35 AM
thank you for the links, hope they are up to date
edit: they are not