Bitcoin Forum
May 03, 2024, 09:28:04 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Need data!!  (Read 2063 times)
AndDuffy (OP)
Member
**
Offline Offline

Activity: 76
Merit: 10


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!

1714771684
Hero Member
*
Offline Offline

Posts: 1714771684

View Profile Personal Message (Offline)

Ignore
1714771684
Reply with quote  #2

1714771684
Report to moderator
"With e-currency based on cryptographic proof, without the need to trust a third party middleman, money can be secure and transactions effortless." -- Satoshi
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1714771684
Hero Member
*
Offline Offline

Posts: 1714771684

View Profile Personal Message (Offline)

Ignore
1714771684
Reply with quote  #2

1714771684
Report to moderator
1714771684
Hero Member
*
Offline Offline

Posts: 1714771684

View Profile Personal Message (Offline)

Ignore
1714771684
Reply with quote  #2

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

Activity: 728
Merit: 500


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 (OP)
Member
**
Offline Offline

Activity: 76
Merit: 10


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
Merit: 500


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
Merit: 250



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

Stephen Gornick
Legendary
*
Offline Offline

Activity: 2506
Merit: 1010


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

Unichange.me

            █
            █
            █
            █
            █
            █
            █
            █
            █
            █
            █
            █
            █
            █
            █
            █


MusX
Full Member
***
Offline Offline

Activity: 175
Merit: 100


View Profile
April 11, 2013, 06:24:35 AM
Last edit: April 11, 2013, 11:16:03 AM by MusX
 #7

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

Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!