Spreadsheet: 700406d1603189099-cost-of-stocks-sold-fifo-cogs
Sheet: TXN

DATE | TXN TYPE | SECURITY NAME | QTY | VALUE | [NAME]
2020-02-04 00:00:00 | BUY | G003 | 20000 | 712135.6483333332
2020-02-05 00:00:00 | BUY | G003 | 138000 | 4894435.44
2020-01-07 00:00:00 | BUY | L001 | 21682.811 | 21682815
2020-01-31 00:00:00 | BUY | L001 | 117.342 | 117342
2020-02-04 00:00:00 | BUY | L001 | 200 | 200000
2020-02-05 00:00:00 | BUY | L001 | 2000 | 2000000
2020-02-11 00:00:00 | BUY | L001 | 5900 | 5900000
2020-02-29 00:00:00 | BUY | L001 | 82.092 | 82092
2020-03-04 00:00:00 | BUY | L001 | 56500 | 56500434.2
2020-03-12 00:00:00 | BUY | L001 | 43000 | 43000330.46
2020-03-31 00:00:00 | BUY | L001 | 160.431 | 160431
2019-12-31 00:00:00 | BUY | L002 | 0.247 | 247
2018-09-24 00:00:00 | BUY | S002 | 10000 | 169366.27
2020-04-01 00:00:00 | DIV | L001 | 8.078 | 8078
2020-04-07 00:00:00 | BUY | G003 | 280000 | 11189737.57
2020-04-07 00:00:00 | SELL | L001 | 25000 | 24997469.23
2020-04-07 00:00:00 | BUY | L001 | 14000 | 14001557.24
2020-04-13 00:00:00 | BUY | G003 | 582000 | 25043040.81
2020-04-13 00:00:00 | SELL | L001 | 25000 | 24997516.24
2020-04-15 00:00:00 | BUY | G003 | 240000 | 10263289.27
2020-04-15 00:00:00 | SELL | L001 | 10000 | 9999006.49
2020-04-20 00:00:00 | BUY | G003 | 240000 | 9954707.92
2020-04-20 00:00:00 | SELL | L001 | 10000 | 9999006.5
2020-04-21 00:00:00 | BUY | A005 | 3000 | 1913790.22
2020-04-21 00:00:00 | BUY | B008 | 1000 | 2895037.85
2020-04-21 00:00:00 | BUY | D002 | 500 | 2008965.22
2020-04-21 00:00:00 | BUY | G002 | 6000 | 1911104.2
2020-04-21 00:00:00 | SELL | L001 | 10000 | 9999006.49
2020-04-27 00:00:00 | DIV | L001 | 149.508 | 149508
2020-05-19 00:00:00 | BUY | B005 | 10000 | 5868115.24
2020-05-19 00:00:00 | SELL | L001 | 10000 | 9999006.49
2020-05-27 00:00:00 | DIV | L001 | 108.393 | 108393
2020-06-01 00:00:00 | BUY | A002 | 11000 | 3681761.76
2020-06-01 00:00:00 | BUY | B001 | 5000 | 13945239.72
2020-06-01 00:00:00 | SELL | B001 | 3000 | 8349210.89
2020-06-01 00:00:00 | BUY | B008 | 800 | 2740703.35
2020-06-01 00:00:00 | BUY | I001 | 10000 | 2293330.86
2020-06-01 00:00:00 | SELL | L001 | 20000 | 19997779.53
2020-06-01 00:00:00 | BUY | L001 | 11000 | 11001111.27
2020-06-03 00:00:00 | BUY | A002 | 20000 | 6847160.03
2020-06-03 00:00:00 | BUY | B001 | 2000 | 5570852.72
2020-06-03 00:00:00 | BUY | B004 | 400 | 2150126.17
2020-06-03 00:00:00 | BUY | B005 | 10000 | 5553452.36
2020-06-03 00:00:00 | BUY | B007 | 7000 | 2690253.51
2020-06-03 00:00:00 | BUY | B008 | 1800 | 6425099.66
2020-06-03 00:00:00 | SELL | G003 | 80000 | 3261432.56
2020-06-03 00:00:00 | BUY | I001 | 1000 | 218651.76
2020-06-03 00:00:00 | SELL | L001 | 40000 | 39995846.02
2020-06-21 00:00:00 | DIV | L001 | 29.665 | 29665
2020-06-22 00:00:00 | BUY | L001 | 13800 | 13801316.47
2020-07-01 00:00:00 | BUY | A001 | 358 | 470105.91
2020-07-01 00:00:00 | SELL | A002 | 31000 | 10682063.3
2020-07-01 00:00:00 | BUY | A003 | 2464 | 471512.67
2020-07-01 00:00:00 | BUY | A004 | 6282 | 10608226.14
2020-07-01 00:00:00 | SELL | A005 | 3000 | 2326314.34
2020-07-01 00:00:00 | SELL | B001 | 300 | 855555.5
2020-07-01 00:00:00 | BUY | B001 | 280 | 797610.93
2020-07-01 00:00:00 | BUY | B002 | 184 | 471922.47
2020-07-01 00:00:00 | BUY | B003 | 274 | 797095.52
2020-07-01 00:00:00 | SELL | B005 | 1200 | 676114.87
2020-07-01 00:00:00 | BUY | B006 | 23426 | 844257.93
2020-07-01 00:00:00 | BUY | C001 | 344 | 472432.97
2020-07-01 00:00:00 | BUY | C002 | 1149 | 472728.7
2020-07-01 00:00:00 | BUY | D001 | 1006 | 470057.71
2020-07-01 00:00:00 | SELL | D002 | 500 | 1951958.49
2020-07-01 00:00:00 | BUY | E001 | 43 | 790614.51
2020-07-01 00:00:00 | BUY | G001 | 5581 | 848658.12
2020-07-01 00:00:00 | SELL | G002 | 6000 | 2570036.17
2020-07-01 00:00:00 | SELL | G003 | 60000 | 2578114.15
2020-07-01 00:00:00 | BUY | H001 | 435 | 796841.45
2020-07-01 00:00:00 | BUY | H002 | 313 | 796828.25
2020-07-01 00:00:00 | BUY | H003 | 2154 | 473966.49
2020-07-01 00:00:00 | BUY | H004 | 367 | 793078.38
2020-07-01 00:00:00 | BUY | I001 | 11000 | 2416477.06
2020-07-01 00:00:00 | BUY | J001 | 4163 | 799564.1
2020-07-01 00:00:00 | SELL | L001 | 9320 | 9318877.47
2020-07-01 00:00:00 | BUY | R001 | 459 | 797779.55
2020-07-01 00:00:00 | BUY | S001 | 27797 | 843732.12
2020-07-01 00:00:00 | BUY | T001 | 7936 | 798052.93
2020-07-01 00:00:00 | BUY | T002 | 379 | 796247.48
2020-07-01 00:00:00 | BUY | T003 | 1465 | 797414.31
2020-07-01 00:00:00 | BUY | U001 | 461 | 471416.66
2020-07-01 00:00:00 | BUY | V001 | 7404 | 797853.96
2020-07-07 00:00:00 | BUY | G003 | 2000 | 84996.06
2020-07-07 00:00:00 | BUY | L001 | 2000 | 2000397.95