LittlBro (OP)
Newbie
Offline
Activity: 5
Merit: 0
|
|
April 11, 2018, 12:15:34 PM |
|
When we have a complete history of trading, then to calculate the profit is not a problem. But suppose, we want to calculate the profit in the time interval from 13:42 to 20:00
+------------------+------+---------+------------+--------+ | date | type | fiat | coin | price | +------------------+------+---------+------------+--------+ | 2017-12-03 13:42 | buy | 3610,28 | 0,011587 | 311580 | | 2017-12-03 13:43 | buy | 3128,47 | 0,010032 | 311849 | | 2017-12-03 14:30 | _sell | 1956,82 | 0,00612102 | 319689 | | 2017-12-03 14:31 | _sell | 236381 | 0,74101 | 318999 | | 2017-12-03 14:38 | buy | 2975,82 | 0,009432 | 315502 | | 2017-12-03 14:57 | buy | 1050,15 | 0,003292 | 319001 | | 2017-12-03 14:58 | buy | 5024,27 | 0,01575 | 319001 | | 2017-12-03 18:49 | buy | 16692 | 0,051662 | 323100 | | 2017-12-03 19:10 | buy | 32045,8 | 0,099114 | 323323 | | 2017-12-03 19:31 | _sell | 5102,79 | 0,015701 | 324998 | | 2017-12-03 19:32 | _sell | 324,998 | 0,001 | 324998 | | 2017-12-03 19:36 | buy | 2720,62 | 0,008397 | 323999 | | 2017-12-03 19:36 | buy | 119698 | 0,369439 | 323999 | | 2017-12-03 19:41 | _sell | 4479,86 | 0,0137546 | 325699 | | 2017-12-03 19:43 | buy | 9164,49 | 0,028344 | 323331 | | 2017-12-03 19:46 | _sell | 13999 | 0,043074 | 324999 | | 2017-12-03 19:51 | buy | 10412,4 | 0,032137 | 324001 | | 2017-12-03 19:56 | buy | 456,841 | 0,00141 | 324001 | +------------------+------+---------+------------+--------+
But when we begin to reduce the balance of purchases / sales, we will see such things: | 2017-12-03 14:31 | _sell | 236381 | 0,74101 | 318999 | - sale of coins purchased earlier, and not included in our sample | 2017-12-03 19:36 | buy | 119698 | 0,369439 | 323999 | - purchase, sale of these coins will occur later
And as a result of such calculations, we will constantly receive a loss, well, it's logical - sales go after purchases, and next to the purchases we can have sales of coins purchased earlier. What to do in this case - do a sample of sales with a certain time lag after purchases , because neither the FIFI nor the LIFO method will help here.
|