Spreadsheet: 745795d1630219059-correction-needed-for-outbound-quantity-tracking-stocks-purchases-and-sales-by-warehouse-approach-xanaducsiv-_v3
Sheet: Version12

Totals: |  |  |  | Purchase
 |  |  |  | Sale
 |  |  |  |  | TRANSACTION |  |  |  | OUTBOUND |  |  | OUTSTANDING |  |  | P/L
Trade Symbol | Transaction | Date | Sale Portion | [NAME] | Quantity Bought(+) / Sold(-) | Price | Fees | Amount | Quantity Sold | Price | Amount (Cost of Goods Sold) | Quantity Remaing | Price | Amount (Inventory Value) | Gain(+) / Loss(-) Running Balance | Gain(+) / Loss(-) per Sale Only
 | Purchase | 2021-02-22 00:00:00 |  |  | 3.514923 | 14.21 | 0
 | Purchase | 2021-02-22 00:00:00 |  |  | 1.95554 | 12.8 | 0
 | Purchase | 2021-02-23 00:00:00 |  |  | 2.121327 | 11.78 | 0
 | Purchase | 2021-03-24 00:00:00 |  |  | 374.242645 | 13.45 | 0
 | Sale | 2021-03-29 00:00:00 | All | Short | -381.834442 | 13.34 | 0
 | Purchase | 2021-04-17 00:00:00 |  |  | 13.380624 | 37.72 | 0
 | Purchase | 2021-04-17 00:00:00 |  |  | 12.706329 | 39.39 | 0
 | Purchase | 2021-04-27 00:00:00 |  |  | 28.600846 | 35.18 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 74.626678 | 67.52 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 270.208195 | 74.56 | 0
 | Sale | 2021-05-04 00:00:00 | All | Short | -399.522672 | 78.52 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 179.734944 | 84.04 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 49.622456 | 101.4 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 246.20782 | 102.55 | 0 |  |  |  |  |  |  |  |  |  |  | Test Data Lines are Yellow
 | Purchase | 2021-05-05 00:00:00 |  |  | 165.37101 | 103.4 | 0 |  |  |  |  |  |  |  |  |  |  | Cell G29 would be shaded half orange / half blue if possible in Excel
 | Sale | 2021-05-05 00:00:00 | All | Short | -640.93623 | 104.18 | 0 |  |  |  |  |  |  |  |  |  |  | Cell G35 would be shaded half green / half baby blue if possible in Excel
 | Purchase | 2021-05-05 00:00:00 |  |  | 30.301633 | 99.03 | 0 |  |  |  |  |  |  |  |  |  |  |  | "--->"
 | Purchase | 2021-05-06 00:00:00 |  |  | 276.819944 | 145.41 | 0 |  |  |  |  |  |  |  |  |  |  | Sale Amount Tabulator | [NAME] | [NAME] | [NAME] | [NAME]
 | Sale | 2021-05-06 00:00:00 | All | Short | -307.121577 | 168.49 | 0 |  |  |  |  |  |  |  |  |  |  | Total Quantity
 | Purchase | 2021-05-06 00:00:00 |  |  | 277.1079 | 182.23 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 138.149505 | 182.77 | 0
 | Sale | 2021-05-08 00:00:00 | Partial | Short | -107.381606 | 127.43 | 0 |  |  |  |  |  |  |  |  |  |  | Q Sale 1
 | Sale | 2021-07-16 00:00:00 | Partial | Short | -160 | 100 | 0 |  |  |  |  |  |  |  |  |  |  | Q Sale 2
 | Sale | 2021-07-16 00:00:00 | Partial | Short | -140 | 80 | 0 |  |  |  |  |  |  |  |  |  |  | Q Sale 3 (Overlap)
 | Sale | 2021-07-16 00:00:00 | Partial | Short | -7.875792 | 65 | 0 |  |  |  |  |  |  |  |  |  |  | Q Sale 4
 | Purchase | 2021-07-18 00:00:00 |  |  | 55 | 55 | 0
 | Sale | 2021-07-29 00:00:00 | Partial | Short | -25 | 100 | 0 |  |  |  |  |  |  |  |  |  |  | Q Sale 5
 | Sale | 2021-07-29 00:00:00 | Partial | Short | -5 | 100 | 0 |  |  |  |  |  |  |  |  |  |  | Q Sale 6
 | Purchase | 2021-07-29 00:00:00 |  |  | 75 | 50 | 0
 | Sale | 2021-07-29 00:00:00 | Partial | Short | -30 | 30 | 0 |  |  |  |  |  |  |  |  |  |  | Q Sale 7 (Overlap)