Historic data on bitcoin price

[Mikcik]

Where can i get historic data on bitcoin price dating as back as possible (even around 2010 for example) in a "table" fashion that will allow me to import it via copying into excel?

Preferably bitstamp or mgtox (but i would like bitstamp). I found this:

http://www.cryptocoincharts.info/

But it doesnt go as much back in history as i would like it to go. and there are also few weeks that missed the data (for example the start of the buble in 2013 april)

Is there some place when i can get the data (in number formats for importing into excel)
?

[deepceleron]

http://api.bitcoincharts.com/v1/csv/

This much data will make Excel shit the bed though.

[Mikcik]

http://api.bitcoincharts.com/v1/csv/

This much data will make Excel shit the bed though.

OMG! Thats a statistician wet dream... :-). Ill check it out, thanks, might even use SPSS (statistician software).

[Mikcik]

I gave it a look but i dont know how to interpret the data, i dont know whats a date and whats the price (low high open close...?)

Can someone redirect me elsewhere please?

[deepceleron]

It is the unix epoch timestamp, the trade price, and the trade volume, for every single trade.

[Coin_Master]

It is the unix epoch timestamp, the trade price, and the trade volume, for every single trade.

Well he certainly asked for it, didn't he.  Absolutely massive. Thank you for this deepceleron.

[Mikcik]

Well i have got data in rows... per row theres info like this:

1315922016,5.800000000000,1.000000000000


I have loaded it into excel (i donmt have SPSS installed), how can i interpret it (im not a programmer by the way)?

The first should be date i suppose but whats the stupiud format, how can i get it to normal format recognizeable by excel?

Or does excel import it somewhat improperly?

(Its the 86 MB (or so) bitstampUSD data file...

[deepceleron]

Well i have got data in rows... per row theres info like this:

1315922016,5.800000000000,1.000000000000


I have loaded it into excel (i donmt have SPSS installed), how can i interpret it (im not a programmer by the way)?

The first should be date i suppose but whats the stupiud format, how can i get it to normal format recognizeable by excel?

Or does excel import it somewhat improperly?

Both Excel times and Unix Epoch time are simply a number.

• Epoch time is seconds since midnight 1/1/1970.
• Excel time is days since January "0" 1900

Excel time is 1 greater than it should be after Feb 28 1900, since Excel replicates a 25-year-old Lotus 1-2-3 bug.
The Excel formula is:
=(A1/86400)+25569
This makes the time right now 1388349029 -> 41637.8545023148. You then only need to format the cells as the date/time format you want.


It sounds like you might want just daily pricing, the maths of which can be done less painlessly in a programming language. It's already been done, press download on this site:
http://www.quandl.com/BITCOIN-Bitcoin-Charts/BITSTAMPUSD-Bitcoin-Markets-bitstampUSD

[knightcoin]

Well i have got data in rows... per row theres info like this:

1315922016,5.800000000000,1.000000000000


I have loaded it into excel (i donmt have SPSS installed), how can i interpret it (im not a programmer by the way)?

The first should be date i suppose but whats the stupiud format, how can i get it to normal format recognizeable by excel?

Or does excel import it somewhat improperly?

Both Excel times and Unix Epoch time are simply a number.

• Epoch time is seconds since midnight 1/1/1970.
• Excel time is days since January "0" 1900

Excel time is 1 greater than it should be after Feb 28 1900, since Excel replicates a 25-year-old Lotus 1-2-3 bug.
The Excel formula is:
=(A1/86400)+25569
This makes the time right now 1388349029 -> 41637.8545023148. You then only need to format the cells as the date/time format you want.


It sounds like you might want just daily pricing, the maths of which can be done less painlessly in a programming language. It's already been done, press download on this site:
http://www.quandl.com/BITCOIN-Bitcoin-Charts/BITSTAMPUSD-Bitcoin-Markets-bitstampUSD

Interesting info.. Why SPSS ? I've been played a litte bit with nodexl (similar to pajek) http://nodexl.codeplex.com/ ...

[yitingyou]

 

[Mikcik]

Well i have got data in rows... per row theres info like this:

1315922016,5.800000000000,1.000000000000


I have loaded it into excel (i donmt have SPSS installed), how can i interpret it (im not a programmer by the way)?

The first should be date i suppose but whats the stupiud format, how can i get it to normal format recognizeable by excel?

Or does excel import it somewhat improperly?

Both Excel times and Unix Epoch time are simply a number.

• Epoch time is seconds since midnight 1/1/1970.
• Excel time is days since January "0" 1900

Excel time is 1 greater than it should be after Feb 28 1900, since Excel replicates a 25-year-old Lotus 1-2-3 bug.
The Excel formula is:
=(A1/86400)+25569
This makes the time right now 1388349029 -> 41637.8545023148. You then only need to format the cells as the date/time format you want.


It sounds like you might want just daily pricing, the maths of which can be done less painlessly in a programming language. It's already been done, press download on this site:
http://www.quandl.com/BITCOIN-Bitcoin-Charts/BITSTAMPUSD-Bitcoin-Markets-bitstampUSD

Interesting info.. Why SPSS ? I've been played a litte bit with nodexl (similar to pajek) http://nodexl.codeplex.com/ ...

I have been "forced" to use SPSS at university on some projects so i know it a little, and since its the only "real stascian" soft. i know, i mentioned it :-).

[knightcoin]

Well i have got data in rows... per row theres info like this:

1315922016,5.800000000000,1.000000000000


I have loaded it into excel (i donmt have SPSS installed), how can i interpret it (im not a programmer by the way)?

The first should be date i suppose but whats the stupiud format, how can i get it to normal format recognizeable by excel?

Or does excel import it somewhat improperly?

Both Excel times and Unix Epoch time are simply a number.

• Epoch time is seconds since midnight 1/1/1970.
• Excel time is days since January "0" 1900

Excel time is 1 greater than it should be after Feb 28 1900, since Excel replicates a 25-year-old Lotus 1-2-3 bug.
The Excel formula is:
=(A1/86400)+25569
This makes the time right now 1388349029 -> 41637.8545023148. You then only need to format the cells as the date/time format you want.


It sounds like you might want just daily pricing, the maths of which can be done less painlessly in a programming language. It's already been done, press download on this site:
http://www.quandl.com/BITCOIN-Bitcoin-Charts/BITSTAMPUSD-Bitcoin-Markets-bitstampUSD

Interesting info.. Why SPSS ? I've been played a litte bit with nodexl (similar to pajek) http://nodexl.codeplex.com/ ...

I have been "forced" to use SPSS at university on some projects so i know it a little, and since its the only "real stascian" soft. i know, i mentioned it :-).

ok. I had one module in psychology (extra grade) and I was forced to use SPSS too .. its oK I guess ...

[Mikcik]

Well i have got data in rows... per row theres info like this:

1315922016,5.800000000000,1.000000000000


I have loaded it into excel (i donmt have SPSS installed), how can i interpret it (im not a programmer by the way)?

The first should be date i suppose but whats the stupiud format, how can i get it to normal format recognizeable by excel?

Or does excel import it somewhat improperly?

Both Excel times and Unix Epoch time are simply a number.

• Epoch time is seconds since midnight 1/1/1970.
• Excel time is days since January "0" 1900

Excel time is 1 greater than it should be after Feb 28 1900, since Excel replicates a 25-year-old Lotus 1-2-3 bug.
The Excel formula is:
=(A1/86400)+25569
This makes the time right now 1388349029 -> 41637.8545023148. You then only need to format the cells as the date/time format you want.


It sounds like you might want just daily pricing, the maths of which can be done less painlessly in a programming language. It's already been done, press download on this site:
http://www.quandl.com/BITCOIN-Bitcoin-Charts/BITSTAMPUSD-Bitcoin-Markets-bitstampUSD

Ok, thanks for this, this looks cool and it looks even a statistic and programmer noob as myself can work with it, so thanks :-)!

Just out of curiosity, these are day data, what are the interval of the original data you posted link to?

Are they hour data (24 rows per day) 12 hour data (2 rows per day)?

[deepceleron]

Ok, thanks for this, this looks cool and it looks even a statistic and programmer noob as myself can work with it, so thanks :-)!

Just out of curiosity, these are day data, what are the interval of the original data you posted link to?

Are they hour data (24 rows per day) 12 hour data (2 rows per day)?

The Bitcoincharts CSVs are a list of every single individual trade that has ever happened on that exchange:

It is the unix epoch timestamp, the trade price, and the trade volume, for every single trade.

[knightcoin]

what about

http://www.quantabytes.com/faq

 

[Mikcik]

deleted, problems solved :-).

After my noobish calculations (the log price and the trendline) it showed me that btc should get to price around 10 000 somewhere around the end of 2014.