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.
Topic: Historic data on bitcoin price (Read 2685 times)
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: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)?
It is the unix epoch timestamp, the trade price, and the trade volume, for every single trade.
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?
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
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)?
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?
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
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 ...
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?
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
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 :-).
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?
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
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/ ...
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?
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
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
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...
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...
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.
It is the unix epoch timestamp, the trade price, and the trade volume, for every single trade.
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?
Can someone redirect me elsewhere please?
OMG! Thats a statistician wet dream... :-). Ill check it out, thanks, might even use SPSS (statistician software).
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)
?
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)
?
Jump to: