Patrick-Bay
commented
6 years ago It would seem that most of the desired information is already present, if not in the table then at least in the database and available via an API call. Possibly the only update here may be to fix erroneous calculations and possibly add an additional historical item if required.
I would estimate 1 hour to complete this task.
To recap:
-
the first table should be a list of rake transactions with the following columns (date, description, amount, balance). The date column should show the date & time, the description column should list where the transaction came from (i.e. the investment e.g. "bankroll" dividend), the amount column should show the transaction amount (i.e. the amount credited to the rake account due to this transaction), and the balance column should show the current balance of the rake account (which should also equal the sum of all transactions).
-
so if the bankroll gained 1 btc during the period, and we are raking 5% of this amount, then the "amount" column in the rake transaction table should show 0.05 btc. If this was the first distribution, then the "balance" column should also show 0.05. Say the next day goes by and the bankroll makes 0.50 then we rake 5% and so the "amount" column for this transaction should show 0.025 and the "balance" column should now show 0.075 (which is the total now in the rake account). These amounts need to be logged somewhere in our database, so we can audit the data.
see explanation #41
Patrick, if necessary, can you provide a brief list of what needs to be done with an estimated timeframe?