Topic: Bitcoin - Price History Analysis (excel?)/ Trends and Regression/Correlation (Read 1624 times)
April 20, 2013, 09:52:35 PM
Would there be any way to source, say, mean daily trade values since the inception of Bitcoin in a format that you could easily paste into Excel?
April 20, 2013, 09:39:02 PM
Most people seem to use Bitcoincharts.com
so you can download it as a CSV to open in Excel.
I've just build a site that shows current prices plus trading history for 1 day, 7 days, 30 days and 6 months. Not sure if I can post my own URLs here so PM me as don't want to come across as a spammer.
CA
Quote
Historic Trade Data
Trade data is available as CSV, delayed by approx. 15 minutes. It will return the 2000 most recent trades.
http://api.bitcoincharts.com/v1/trades.csv?symbol=SYMBOL[&end=UNIXTIME]
returns CSV:
unixtime,price,amount
You can use the end parameter to specify an earlier unix timestamp in order to retrieve older data.
Examples
Latest mtgoxUSD trades:
http://api.bitcoincharts.com/v1/trades.csv?symbol=mtgoxUSD
Trade data is available as CSV, delayed by approx. 15 minutes. It will return the 2000 most recent trades.
http://api.bitcoincharts.com/v1/trades.csv?symbol=SYMBOL[&end=UNIXTIME]
returns CSV:
unixtime,price,amount
You can use the end parameter to specify an earlier unix timestamp in order to retrieve older data.
Examples
Latest mtgoxUSD trades:
http://api.bitcoincharts.com/v1/trades.csv?symbol=mtgoxUSD
so you can download it as a CSV to open in Excel.
I've just build a site that shows current prices plus trading history for 1 day, 7 days, 30 days and 6 months. Not sure if I can post my own URLs here so PM me as don't want to come across as a spammer.
CA
April 19, 2013, 11:33:59 AM
Anyone have any excels, sources, or other methods for analyzing bitcoin price history they can share? For potential trends?
I've seen people with tables of price histories but not sure how they got them.
I've seen people with tables of price histories but not sure how they got them.
Jump to: