UI

[pabx06]

i am missing something i cant get any UI on this. plus look like data are populated every hours only?

@schedule(hour = "*", minute = "0", persistent = false, info = "Exchange data reader")
in Exchnages.java

i wanted to use this data collected to back-test my trading bot.

also i ma having hard time to filter out specific exchange order-book between two hourly ticks ? how the id col is used in tick and ord tables

ALSO :
SELECT (
(SELECT sum(amount) FROM CoinStory.Ord WHERE ordertype like 'ASK')
/
(SELECT sum(amount) FROM CoinStory.Ord WHERE ordertype like 'BID'));

give me something like '0.00582475284584331'

witch doesn't make the case for the recent downtrend in bit coins

[mmazi]

Great to see this may be useful for someone!

There is no UI currently; I've been using coin-story just to get the data in the database, then I use a separate SQL client (eg. Squirrel SQL or PG Admin) to query the data; see coin-story.sql for some examples. I don't (yet) have a query for bid/ask ratio; you should probably convert bid into USD (see the bid query in coin-story.sql) and add some time constraints in the queries. I've calculated bid/ask from the results of queries in coin-story.sql using Excel.

The Java code is meant to be cloned and adapted to your needs. If hourly data is not enough, you can easily change it to eg. five minute data by specifying minute="*/10" or see the tutorial for more.

The value of the id column is populated from the hibernate_sequence database sequence (created by Hibernate, the JPA provider).

[pabx06]

i really like to get involved into this. i know java but don't have any background on the java web app UI . & stuff.

this project can be cool if i can add an ui like the one: https://cointhink.com/arbitrage/btcusd

[mmazi]

Sure, go ahead!

Coin-story is not just about the BTC/USD price though; it's more about the market depth (ie. recording all open orders on major exchanges).