Post
Topic
Board Speculation
Re: Goomboo's Journal
by
bitg
on 09/05/2013, 20:39:33 UTC
How can I generate a fresh new BTC.last.txt like you've uploaded in this post?
- https://bitcointalk.org/index.php?topic=60501.msg716004#msg716004

Depends on the source you have.

looking at the first line:
Quote
20100104;0.71;0.76001;0.69;0.716;5627

Don't quote me but it appears to be:
Quote
YYYYMMDD;OPEN;HIGH;LOW;CLOSE;VOLUME
separated by ";"

You could obtain data to play with here:
http://bitcoincharts.com/about/markets-api/

with the format (unixtime,price,amount)

you would need to, pseudocode:

Code:
for each line
  convert unixtime to YYYY-MM-DD date (save current day)
  check if new day (create new dialy record, save open)
  check if price > high (save new high)
  check if price < low (save new low)
  saved amount + amount (save amount result)
  save close
  update daily record in format (YYYYMMDD;OPEN;HIGH;LOW;CLOSE;VOLUME)

if my initial assumption is correct you would need something along these lines, unless you are able to find historical data on a daily basis instead of trade by trade.