Spreadsheet: 777209d1650261117-need-help-solving-this-split-data-scenario-sample-file
Sheet: Table 2

Sir/ [NAME], I / We have this day done by your order and on your account the following transactions:
Order No. | Order Time | Trade No. | Trade Time | Security/Contract Description | Buy(B) /Sell(S) | Quantity | [NAME] Price per | Brokerage Rate per Unit(Rs.) | Net Rate per Unit(Rs.) | Closing Rate per Unit(only for Derivatives) (Rs.) | Net Total (Before Levies) (Rs.)
 |  |  |  |  |  |  | Unit(Rs.)
ISIN:INE238A01034*Net Total* |  | -1,200 |  | BUY : (Q) 0 (R) 0.0000 (A) 0.00 |  | SELL : (Q) 1200 (R) 23.1500 (A) 27780.00 |  |  | Gross Brokerage Amt :0.02 |  | -27,779.98
B/F  1800000004820396 | 09:32:25 | 80006583 0 | [NAME] | BAJAJ-AUTO 28APR22  FUTSTK BAJAJ-AUTO 28APR22 | Sell  Buy | 250  500 | 3667.4500  3674.7500 | 0.0037 | 3667.4500  3674.7537 | 3724.7500  3724.7500 | 14,325.00  -24,998.17
ISIN:INE917I01010*Net Total* |  | 250 |  | BUY : (Q) 500 (R) 3674.7500 (A) 1837375.00 |  | SELL : (Q) 0 (R) 0.0000 (A) 0.00 |  |  | Gross Brokerage Amt :1.83 |  | -10,673.17
B/F |  |  |  | BAJAJFINSV 28APR22 | Buy | 50 | 17150.5 |  | 17150.5 | 17241.5 | -4,550.00
ISIN:INE918I01018*Net Total* |  | 50 |  | BUY : (Q) 0 (R) 0.0000 (A) 0.00 |  | SELL : (Q) 0 (R) 0.0000 (A) 0.00 |  |  | Gross Brokerage Amt :0.00 |  | -4,550.00
B/F |  |  |  | BAJFINANCE 28APR22 | Buy | 125 | 7304.75 |  | 7304.75 | 7455.55 | -18,850.00
ISIN:INE296A01024*Net Total* |  | 125 |  | BUY : (Q) 0 (R) 0.0000 (A) 0.00 |  | SELL : (Q) 0 (R) 0.0000 (A) 0.00 |  |  | Gross Brokerage Amt :0.00 |  | -18,850.00
1800000041691171 | 12:34:15 | 80030055 5 | 12:34:16 | OPTSTK BAJFINANCE 28APR22 7300.00 PE | Sell | 125 | 241.45 | 0.0002 | 241.4498 |  | -30,181.22
ISIN:INE296A01024*Net Total* |  | -125 |  | BUY : (Q) 0 (R) 0.0000 (A) 0.00 |  | SELL : (Q) 125 (R) 241.4500 (A) 30181.25 |  |  | Gross Brokerage Amt :0.03 |  | -30,181.22
B/F |  |  |  | BANDHANBNK 28APR22 | Buy | 1,800 | 309.45 |  | 309.45 | 321.75 | -22,140.00
ISIN:INE545U01014*Net Total* |  | 1,800 |  | BUY : (Q) 0 (R) 0.0000 (A) 0.00 |  | SELL : (Q) 0 (R) 0.0000 (A) 0.00 |  |  | Gross Brokerage Amt :0.00 |  | -22,140.00
B/F  1800000004695824 | 09:31:55 | 80006430 7 | 09:31:55 | BANKBARODA 28APR22  FUTSTK BANKBARODA 28APR22 | Sell  Buy | 11,700  23,400 | 112.3000  113.3000 | 0.0001 | 112.3000  113.3001 | 116.5500  116.5500 | 49,725.00  -76,047.35
ISIN:INE028A01039*Net Total* |  | 11,700 |  | BUY : (Q) 23400 (R) 113.3000 (A) 2651220.00 |  | SELL : (Q) 0 (R) 0.0000 (A) 0.00 |  |  | Gross Brokerage Amt :2.65 |  | -26,322.35
B/F  1800000005480399 | 09:34:55 | 20004654 5 20002170 7 | 80007330 0 | 09:35:13 | Buy  Buy  Sell | ADANIPORTS 28APR22  FUTSTK ADANIPORTS 28APR22 | 36553.9500  36658.5750  37115.4500 | 0.0366  0.0371 | Sell  Buy | 1,250  2,500 | -1,61,925.00  -27,151.92  30,182.99
ISIN:*Net Total* |  | -50 |  | BUY : (Q) 50 (R) 36658.5750 (A) 1832928.75 |  | SELL : (Q) 350 (R) 37115.4500 (A) 12990407.50 |  |  | Gross Brokerage Amt :14.82 |  | -1,58,893.93
1400000007873091  1400000002132026 | 09:47:17  09:21:51 | 40046928 5 40016258 1 | 09:47:17  09:21:53 | OPTIDX BANKNIFTY 07APR22 36400.00 CE  OPTIDX BANKNIFTY 07APR22 36400.00 CE | Buy  Sell | 400  400 | 615.8000  585.7406 | 0.0006  0.0006 | 615.8006  585.7400 |  | 2,46,320.24  -2,34,296.01
ISIN:*Net Total* |  |  |  | BUY : (Q) 400 (R) 615.8000 (A) 246320.00 |  | SELL : (Q) 400 (R) 585.7406 (A) 234296.24 |  |  | Gross Brokerage Amt :0.47 |  | 12,024.23
B/F  1500000007521332  1500000002699684 | 09:45:45  09:23:23 | 50043943 3 50018005 4 | 09:45:45  09:23:23 | BANKNIFTY 07APR22 36500.00 CE  OPTIDX BANKNIFTY 07APR22 36500.00 CE  OPTIDX BANKNIFTY 07APR22 36500.00 CE | Buy  Buy  Sell | 475  950  1,425 | 573.7632  584.6132 | 0.0006  0.0006 | 573.7638  584.6126 |  | 5,45,075.58  -8,33,072.98
ISIN:*Net Total* |  |  |  | BUY : (Q) 950 (R) 573.7632 (A) 545075.04 |  | SELL : (Q) 1425 (R) 584.6132 (A) 833073.81 |  |  | Gross Brokerage Amt :1.37 |  | -2,87,997.40
B/F  1400000007653478  1400000002081991 | 09:46:09  09:21:43 | 40045930 2 40015827 4 | 09:46:14  09:21:43 | BANKNIFTY 07APR22 36600.00 CE  OPTIDX BANKNIFTY 07APR22 36600.00 CE  OPTIDX BANKNIFTY 07APR22 36600.00 CE | Buy  Buy  Sell | 25  400  425 | 584.6719  463.6588 | 0.0006  0.0004 | 584.6725  463.6584 |  | 2,33,868.99  -1,97,054.80
ISIN:*Net Total* |  |  |  | BUY : (Q) 400 (R) 584.6719 (A) 233868.76 |  | SELL : (Q) 425 (R) 463.6588 (A) 197054.99 |  |  | Gross Brokerage Amt :0.42 |  | 36,814.19
1500000007845876  1500000002402936 | 09:47:17  09:22:24 | 50045693 1 50016334 7 | 09:47:17  09:22:24 | OPTIDX BANKNIFTY 07APR22 36700.00 CE  OPTIDX BANKNIFTY 07APR22 36700.00 CE | Buy  Sell | 1,875  1,750 | 511.7287  416.0871 | 0.0005  0.0004 | 511.7292  416.0867 |  | 9,59,492.26  -7,28,151.71
ISIN:*Net Total* |  | 125 |  | BUY : (Q) 1875 (R) 511.7287 (A) 959491.31 |  | SELL : (Q) 1750 (R) 416.0871 (A) 728152.43 |  |  | Gross Brokerage Amt :1.67 |  | 2,31,340.55
1400000012790883  1400000024914304 | 10:11:53  11:46:14 | 40077246 6 40131350 9 | 10:11:53  11:46:15 | OPTIDX BANKNIFTY 07APR22 36800.00 CE  OPTIDX BANKNIFTY 07APR22 36800.00 CE | Buy  Sell | 550  100 | 445.4727  427.1500 | 0.0004  0.0004 | 445.4731  427.1496 |  | 2,45,010.23  -42,714.96
ISIN:*Net Total* |  | 450 |  | BUY : (Q) 550 (R) 445.4727 (A) 245009.99 |  | SELL : (Q) 100 (R) 427.1500 (A) 42715.00 |  |  | Gross Brokerage Amt :0.28 |  | 2,02,295.27
1500000004782209 | 09:32:21 | 50028829 | 09:32:21 | OPTIDX BANKNIFTY 07APR22 36900.00 CE | Buy | 775 | 489.2048 | 0.0005 | 489.2053 |  | 3,79,134.09
Trade Date : 01/Apr/2022 |  |  |  | Contract No. : 18 |  |  | Client Code :3549
I required
B/F | 09:34:55 | 200046545 | 80007330 0 | 09:35:13 | Buy | ADANIPORTS 28APR22 | 36553.95 | 0.0366 | Sell | 1250 | -161925
1800000005480390 | 09:34:55 | 200021707 | 80007330 0 | 09:35:13 | Sell | FUTSTK ADANIPORTS 28APR22 | 36658.575 | 0.0371 | Buy | 2500 | -27151.92
 |  |  |  |  |  |  | 37115.45 |  |  |  | 30182.99