Bitcoin Forum
December 04, 2016, 12:21:08 PM *
News: To be able to use the next phase of the beta forum software, please ensure that your email address is correct/functional.
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Need data!!  (Read 1875 times)
AndDuffy
Member
**
Offline Offline

Activity: 76


View Profile
January 27, 2012, 08: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!

1480854068
Hero Member
*
Offline Offline

Posts: 1480854068

View Profile Personal Message (Offline)

Ignore
1480854068
Reply with quote  #2

1480854068
Report to moderator
1480854068
Hero Member
*
Offline Offline

Posts: 1480854068

View Profile Personal Message (Offline)

Ignore
1480854068
Reply with quote  #2

1480854068
Report to moderator
1480854068
Hero Member
*
Offline Offline

Posts: 1480854068

View Profile Personal Message (Offline)

Ignore
1480854068
Reply with quote  #2

1480854068
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1480854068
Hero Member
*
Offline Offline

Posts: 1480854068

View Profile Personal Message (Offline)

Ignore
1480854068
Reply with quote  #2

1480854068
Report to moderator
1480854068
Hero Member
*
Offline Offline

Posts: 1480854068

View Profile Personal Message (Offline)

Ignore
1480854068
Reply with quote  #2

1480854068
Report to moderator
Revalin
Hero Member
*****
Offline Offline

Activity: 728


165YUuQUWhBz3d27iXKxRiazQnjEtJNG9g


View Profile
January 27, 2012, 08: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

      War is God's way of teaching Americans geography.  --Ambrose Bierce
Bitcoin is the Devil's way of teaching geeks economics.  --Revalin 165YUuQUWhBz3d27iXKxRiazQnjEtJNG9g
AndDuffy
Member
**
Offline Offline

Activity: 76


View Profile
January 27, 2012, 08:57:30 PM
 #3

Thanks... I know this may sound extremely noobish, but how can I get that data into an Excel file?

Revalin
Hero Member
*****
Offline Offline

Activity: 728


165YUuQUWhBz3d27iXKxRiazQnjEtJNG9g


View Profile
January 27, 2012, 08: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.

      War is God's way of teaching Americans geography.  --Ambrose Bierce
Bitcoin is the Devil's way of teaching geeks economics.  --Revalin 165YUuQUWhBz3d27iXKxRiazQnjEtJNG9g
Lord F(r)og
Donator
Sr. Member
*
Offline Offline

Activity: 477



View Profile
January 27, 2012, 09:10:56 PM
 #5

Stephen Gornick
Legendary
*
Offline Offline

Activity: 1988



View Profile
January 28, 2012, 07:19:46 AM
 #6

Available as Fusion tables on Google as well:
 - https://www.google.com/fusiontables/DataSource?snapid=S364820JWm5
 - http://bitcointalk.org/index.php?topic=59949.0

MusX
Full Member
***
Offline Offline

Activity: 177


View Profile
April 11, 2013, 06:24:35 AM
 #7

thank you for the links, hope they are up to date
edit: they are not

Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!