Author

Topic: Need data!! (Read 2066 times)

full member
Activity: 175
Merit: 100
April 11, 2013, 02:24:35 AM
#7
thank you for the links, hope they are up to date
edit: they are not
legendary
Activity: 2506
Merit: 1010
donator
Activity: 477
Merit: 250
January 27, 2012, 05:10:56 PM
#5
hero member
Activity: 728
Merit: 500
165YUuQUWhBz3d27iXKxRiazQnjEtJNG9g
January 27, 2012, 04:59:07 PM
#4
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.
member
Activity: 76
Merit: 10
January 27, 2012, 04:57:30 PM
#3
Thanks... I know this may sound extremely noobish, but how can I get that data into an Excel file?
hero member
Activity: 728
Merit: 500
165YUuQUWhBz3d27iXKxRiazQnjEtJNG9g
January 27, 2012, 04:52:59 PM
#2
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.  Smiley
member
Activity: 76
Merit: 10
January 27, 2012, 04:46:01 PM
#1
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!
Jump to: