| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | ACCOUNT TRACKER | NB. You'll have to change the formula in column D (Net Balance $) of the month you start the tracking. eg. you start tracking in June 1. go to sheet 'JUN' 2. select cell D3 3. replace the formula =IF(B3>0,MAY!$C$33+H3,"") 4. with =IF(B3>0,Main$B$4+H3,"") 5. press enter 6. now select the cell D3 and press the blue square in the bottom-right corner and extend the formula till the end of the column eg. you start traking in October 1. go to sheet 'OCT' 2. select cell D3 3. replace the formula =IF(B3>0,SEP!$C$32+H3,"") 4. with =IF(B3>0,Main$B$4+H3,"") 5. press enter 6. now select the cell D3 and press the blue square in the bottom-right corner and extend the formula till the end of the column If you need my help contact me on Twitter @CodyMe72 | ||||||
2 | ||||||||
3 | Starting Date | 01/01/2018 | TRADES COUNTER | |||||
4 | Funds in margin at Starting Date $ | 1000.00 | LOST | WON | ||||
5 | 2 | 3 | ||||||
6 | TOT. GAINS $ | $0.00 | 0.00% | |||||
7 | ||||||||
8 | Tot. Funds moved IN margin | $0.00 | Difference* | |||||
9 | Tot. Funds moved OUT margin | $0.00 | $0.00 | |||||
10 | * the money in margin that are not made by trades (eg. extra deposit from other sources) | |||||||
11 | INSTRUCTIONS 1. Add your starting date in the cell 'Starting Date'. 2. In Bitfinex go under 'Balances', click on the balance money (either Exchange or Margin, depend on which one you want to track), then 'Ledger Entries'. 3. Copy the number from the column 'Balance' (the balance must be the last one of the day) and paste it in the cell 'Funds in margin at starting date'. 4. To keep track of the balance repeat the operation but this time paste the balance in the corresponding cell of the day, in the corresponding sheet of the month, in the column 'Tot. margin $'. To do that, select the cell and then paste the number in the formula bar. If you paste the number directly in the cell it will change the formatting of the cell. In this case you can press Ctrl+\ to clear the formatting of the cell . 5. If you add funds into your account (eg. from Exchange to Margin, from your bank account to Exchange, etc), add the amount you added in the column 'Funds moved IN margin'. If you take out funds, add the amount of the funds you took out in the column 'Funds moved OUT margin'. This will keep the gains (or losses) you make at the nett, means that you'll see only the results from the trades. You won't see a $100 gain when you add money (eg. if you deposit funds from Exchange to Margin) because they're not gain from a trade. 6. 'Trades Counter': enter the number of successful or unsuccessful trades you made. NB. Fill only the white cells. Coloured cells are with formulas. Be careful to don't change them. | |||||||
12 | ||||||||
13 | ||||||||
14 | ||||||||
15 | ||||||||
16 | ||||||||
17 | Twitter: @codyme72 | |||||||
18 | Tips are never obligated but always appreciated :) | |||||||
19 | BTC | 17biynFvNXxm8uZBTq5hgzgZZtt1dKbrSL | ||||||
20 | LTC | LSvWZfpsqxKZrZYJ4E7EP1pCJQSrSyth1C | ||||||
21 | ETH | 0x2a8461b7fddbfddd8d2b21c3852d9d45438a541d | ||||||
22 | NEO | AdsAntHihRGEyj8QEDffNW4x9NW5orxKnD | ||||||
23 | XRP | rEb8TK3gBgk5auZkwc6sHnwrGVJH8DuaLh | 109580464 | |||||
24 | ||||||||
25 | ||||||||
26 | ||||||||
27 | ||||||||
28 | ||||||||