AB
1
This sheet is intended for lenders on bitfinex.com and was created by Sukrim on bitcointalk.org in 2013
2
I assume no responsibility or guarantees, but feel free to make a copy yourselves and use it to track your earnings. I'd also love to see improvements shared!
3
If you feel like tipping, please use the following address of mine:1KoiHGBmDF7xnY7BSBJw37PiXZ78qJmchM
4
5
In general, all data should be taken from the following link:https://www.bitfinex.com/account/ledger
6
Remember: The date shown in the Bitfinex ledger is from the end of the day, so depending on your time zone you might have some calculation to do (everyone east of UK get for example the money from the 1st of April credited on the 2nd some time after midnight).
7
8
Quickstart:
9
 You only need to input data in the columns C-F regularly.
10
The lowest row in K and L needs to contain a 0 (zero), not a formula
11
When setting up the sheet, you need to enter a reference to a date once in O1 and P1
12
It is easy to expand the sheet, just insert as many rows as you need below row 2, select at least 2 already populated rows below that and drag using the lower right corner of the selector to automatically fill the cells with the formulas.
13
I recommend to keep the date in A3 about 2 weeks in the future and expand it again once you reach approx. 1 week in the future.
14
15
In row 1 you will generally find sums of the amounts found below (e.g. a sum of all interests received so far) for quick reference.
16
I1 and J1 display the APR after 365 days, a number you usually see quoted when looking at interest rates on bank accounts.
17
The first row of O and P indicates the starting day of lending out BTC and USD (= the date of the first deposit in that currency)
18
19
You can write comments that show up in all 3 charts (BTC, USD and combined) in column B.
20
21
If you deposit something, enter a positive amount in either column C or D.
22
If you withdraw, enter a negative amount there.
23
If you deposit AND withdraw on the same day, I recommend to put in the net amount (e.g. deposit 5, withdraw 3 = deposit 2)
24
25
Enter your interest amounts in column E and F. Should you not have received any interest, I recommend to just enter a 0 as opposed to dates in the future that are left empty.
26
27
Columns G and H show the actual APR received (after fees) for this day.
28
29
In I and J you see the APR as if you received all interest at once after X days running. These values will react slower and slower over time to sudden spikes or lows in interest earned.
30
Also they work with total sums over all deposits, so if you deposit a little at first, earn some interests and then add later a lot more, don't be surprised if this value suddenly takes a big hit.
31
The value in row 1 is the value with X set to 365 days. Actually the value will be a bit weird after you lend out for more than 1 year, but I hope to have maybe a better tracking sheet template until then. :-)
32
33
K and L are a little bit special since you need to enter a 0 as starting balance once, after that they just take the closing balance of the previous day as open balance. I coloured these 2 cells to make you aware of that.
34
35
Just looking at the formula in M and N should be enough - the closing balance is the open balance of the day + interest + eventual deposits/withdrawals.