Spreadsheet: 101126d1299263527-display-formula-value-as-a-negative-number-example
Sheet: Sheet1

Target | Sell |  |  | Notional Execution | Notional Liquidation | PnL | % Change |  | $ [NAME] | Target $ [NAME] | Basket $ [NAME] | % PnL | Target % PnL | Basket % PnL | Dollar Exposure | Commissions
Basket | Buy |  | Buy
 |  |  | Sell
Execution
Enab | [NAME] | Symbol | Side | Quantity | Open Quantity | Exec Qty | [NAME] | Notional | Open Notional | % Exec | Exec Notional | [NAME] | % ADV21 | PL1 (Real) | PL1 (Unreal) | PL1 ( Total) | Beta | Prv | Last | % Chg | Bid | Ask | Curr Trade Vol | Rej | [NAME] | Commisions | BB Ticker | Eqy_Prim_Exch
0 | SRE | EXC | Buy | 121 | 0 | 121 | 0 | 4997 | 0 | 100 | 5007 | 41.38 | 0.0027 | -21.8 | 0 | -21.8 | 0.25 | 41.29 | 41.37 | 0.19 | 41.34 | 41.37 | 6800 | 0 | 41.39 | 1.209999999999759 | SRE Equity | New York
0 | SRE | CMS | Buy | 261 | 0 | 261 | 0 | 4993 | 0 | 100 | 5022 | 19.24 | 0.0089 | -57.5 | 0 | -57.5 | 0.67 | 19.13 | 19.27 | 0.73 | 19.26 | 19.28 | 68700 | 0 | 19.25 | 2.610000000000408 | SRE Equity | New York
0 | SRE | D | Buy | 111 | 0 | 111 | 0 | 4995 | 0 | 100 | 4994 | 44.99 | 0.005 | 2.22 | 0 | 2.22 | 0.27 | 45 | 44.99 | -0.02 | 44.98 | 44.99 | 54300 | 0 | 45 | 1.109999999999779 | SRE Equity | New York
0 | SRE | PEG | Buy | 154 | 0 | 154 | 0 | 4996 | 0 | 100 | 4997 | 32.45 | 0.0066 | -9.25 | 0 | -9.25 | 0.09 | 32.42 | 32.46 | 0.12 | 32.46 | 32.5 | 31500 | 0 | 32.46 | 1.539999999999694 | SRE Equity | New York
0 | SRE | POM | Buy | 271 | 0 | 271 | 0 | 4995 | 0 | 100 | 5005 | 18.47 | 0.0179 | -21.7 | 0 | -21.7 | 0.48 | 18.43 | 18.48 | 0.27 | 18.46 | 18.47 | 17800 | 0 | 18.48 | 2.710000000000424 | SRE Equity | New York
0 | SRE | PPL | Buy | 199 | 0 | 199 | 0 | 5027 | 0 | 100 | 5017 | 25.21 | 0.0049 | -161.23 | 0 | -161.23 | 0.19 | 24.81 | 25.34 | 2.14 | 25.35 | 25.37 | 288400 | 0 | 25.22 | 1.990000000000311 | SRE Equity | New York
0 | SRE | [NAME] | Buy | 279 | 0 | 279 | 0 | 5002 | 0 | 100 | 4989 | 17.88 | 0.0031 | -5.6 | 0 | -5.6 | 0.32 | 17.87 | 17.88 | 0.06 | 17.88 | 17.89 | 126500 | 0 | 17.89 | 2.790000000000436 | SRE Equity | New York
0 | SRE | SO | Buy | 131 | 0 | 131 | 0 | 4986 | 0 | 100 | 4992 | 38.11 | 0.0035 | -13.14 | 0 | -13.14 | 0.26 | 38.06 | 38.08 | 0.05 | 38.08 | 38.1 | 67800 | 0 | 38.12 | 1.309999999999739 | SRE Equity | New York
0 | SRE | EIX | Buy | 139 | 0 | 139 | 0 | 5005 | 0 | 100 | 4900 | 35.25 | 0.0078 | 211.05 | 0 | 211.05 | 0.57 | 36.01 | 35.55 | -1.28 | 35.59 | 35.6 | 74200 | 0 | 35.26 | 1.389999999999723 | SRE Equity | New York
0 | SRE | SRE | Sell | 1896 | 0 | 1896 | 0 | 99976 | 0 | 100 | 99976 | 52.73 | 0.1161 | -131.01 | 0 | -131.01 | 0.49 | 53.43 | 52.92 | -0.95 | 52.89 | 52.92 | 89100 | 0 | 52.72 | 18.95999999999623 | SRE Equity | New York
0 | SRE | PNW | Buy | 120 | 0 | 120 | 0 | 5006 | 0 | 100 | 5017 | 41.81 | 0.0178 | -21.57 | 0 | -21.57 | 0.75 | 41.72 | 41.86 | 0.34 | 41.83 | 41.87 | 9500 | 0 | 41.82 | 1.199999999999761 | SRE Equity | New York
0 | SRE | NEE | Buy | 91 | 0 | 91 | 0 | 4977 | 0 | 100 | 4986 | 54.79 | 0.0052 | -18.28 | 0 | -18.28 | 0.29 | 54.69 | 54.84 | 0.27 | 54.8 | 54.85 | 29000 | 0 | 54.8 | 0.909999999999819 | SRE Equity | New York
0 | SRE | XEL | Buy | 210 | 0 | 210 | 0 | 5002 | 0 | 100 | 5000 | 23.81 | 0.0123 | 4.2 | 0 | 4.2 | 0.65 | 23.82 | 23.84 | 0.08 | 23.85 | 23.86 | 30100 | 0 | 23.82 | 2.100000000000328 | SRE Equity | New York
0 | SRE | ETR | Buy | 70 | 0 | 70 | 0 | 4965 | 0 | 100 | 4974 | 71.05 | 0.0072 | -16.92 | 0 | -16.92 | 0.48 | 70.93 | 71.05 | 0.17 | 71.05 | 71.1 | 9500 | 0 | 71.06 | 0.7000000000003581 | SRE Equity | New York
0 | SRE | ED | Buy | 101 | 0 | 101 | 0 | 4990 | 0 | 100 | 4996 | 49.47 | 0.0061 | -12.14 | 0 | -12.14 | 0.13 | 49.41 | 49.48 | 0.14 | 49.46 | 49.48 | 17900 | 0 | 49.48 | 1.009999999999799 | SRE Equity | New York
0 | SRE | DTE | Buy | 106 | 0 | 106 | 0 | 4980 | 0 | 100 | 4983 | 47.01 | 0.0139 | -6.39 | 0 | -6.39 | 0.59 | 46.98 | 47 | 0.04 | 46.98 | 47.01 | 18200 | 0 | 47.02 | 1.059999999999789 | SRE Equity | New York
0 | SRE | PCG | Buy | 109 | 0 | 109 | 0 | 4997 | 0 | 100 | 4994 | 45.82 | 0.0056 | 4.36 | 0 | 4.36 | 0.32 | 45.84 | 45.92 | 0.17 | 45.92 | 45.97 | 24400 | 0 | 45.83 | 1.089999999999783 | SRE Equity | New York
0 | SRE | NU | Buy | 149 | 0 | 149 | 0 | 5006 | 0 | 100 | 5032 | 33.77 | 0.0088 | -50.6 | 0 | -50.6 | 0.33 | 33.6 | 33.77 | 0.51 | 33.75 | 33.77 | 21600 | 0 | 33.78 | 1.489999999999704 | SRE Equity | New York
0 | SRE | PGN | Buy | 110 | 0 | 110 | 0 | 4983 | 0 | 100 | 4995 | 45.41 | 0.0087 | -24.28 | 0 | -24.28 | 0.32 | 45.3 | 45.41 | 0.24 | 45.4 | 45.42 | 13300 | 0 | 45.41999999999999 | 1.099999999999781 | SRE Equity | New York
0 | SRE | DPL | Buy | 193 | 0 | 193 | 0 | 4999 | 0 | 100 | 5018 | 26 | 0.0267 | -38.61 | 0 | -38.61 | 0.8 | 25.9 | 25.99 | 0.35 | 25.97 | 26 | 18300 | 0 | 26.01 | 1.930000000000302 | SRE Equity | New York
0 | SRE | AEP | Buy | 142 | 0 | 142 | 0 | 5010 | 0 | 100 | 5028 | 35.41 | 0.0048 | -36.85 | 0 | -36.85 | 0.55 | 35.28 | 35.46 | 0.51 | 35.44 | 35.46 | 30000 | 0 | 35.41999999999999 | 1.419999999999717 | SRE Equity | New York
Liquidation
Enab | [NAME] | Symbol | Side | Quantity | Open Quantity | Exec Qty | [NAME] | Notional | Open Notional | % Exec | Exec Notional | [NAME] | % ADV21 | PL1 (Real) | PL1 (Unreal) | PL1 ( Total) | Beta | Prv | Last | % Chg | Bid | Ask | Curr Trade Vol | Rej | [NAME] | Commisions | BB Ticker | Eqy_Prim_Exch
0 | SRE | EXC | Buy | 121 | 0 | 121 | 0 | 4997 | 0 | 100 |  | 41.38 | 0.0027 | -21.8 | 0 | -21.8 | 0.25 | 41.29 | 41.37 | 0.19 | 41.34 | 41.37 | 6800 | 0 | 41.39 | 1.209999999999759 | SRE Equity | New York
0 | SRE | CMS | Buy | 261 | 0 | 261 | 0 | 4993 | 0 | 100 |  | 19.24 | 0.0089 | -57.5 | 0 | -57.5 | 0.67 | 19.13 | 19.27 | 0.73 | 19.26 | 19.28 | 68700 | 0 | 19.25 | 2.610000000000408 | SRE Equity | New York
0 | SRE | D | Buy | 111 | 0 | 111 | 0 | 4995 | 0 | 100 |  | 44.99 | 0.005 | 2.22 | 0 | 2.22 | 0.27 | 45 | 44.99 | -0.02 | 44.98 | 44.99 | 54300 | 0 | 45 | 1.109999999999779 | SRE Equity | New York
0 | SRE | PEG | Buy | 154 | 0 | 154 | 0 | 4996 | 0 | 100 |  | 32.45 | 0.0066 | -9.25 | 0 | -9.25 | 0.09 | 32.42 | 32.46 | 0.12 | 32.46 | 32.5 | 31500 | 0 | 32.46 | 1.539999999999694 | SRE Equity | New York
0 | SRE | POM | Buy | 271 | 0 | 271 | 0 | 4995 | 0 | 100 |  | 18.47 | 0.0179 | -21.7 | 0 | -21.7 | 0.48 | 18.43 | 18.48 | 0.27 | 18.46 | 18.47 | 17800 | 0 | 18.48 | 2.710000000000424 | SRE Equity | New York
0 | SRE | PPL | Buy | 199 | 0 | 199 | 0 | 5027 | 0 | 100 |  | 25.21 | 0.0049 | -161.23 | 0 | -161.23 | 0.19 | 24.81 | 25.34 | 2.14 | 25.35 | 25.37 | 288400 | 0 | 25.22 | 1.990000000000311 | SRE Equity | New York
0 | SRE | [NAME] | Buy | 279 | 0 | 279 | 0 | 5002 | 0 | 100 |  | 17.88 | 0.0031 | -5.6 | 0 | -5.6 | 0.32 | 17.87 | 17.88 | 0.06 | 17.88 | 17.89 | 126500 | 0 | 17.89 | 2.790000000000436 | SRE Equity | New York
0 | SRE | SO | Buy | 131 | 0 | 131 | 0 | 4986 | 0 | 100 |  | 38.11 | 0.0035 | -13.14 | 0 | -13.14 | 0.26 | 38.06 | 38.08 | 0.05 | 38.08 | 38.1 | 67800 | 0 | 38.12 | 1.309999999999739 | SRE Equity | New York
0 | SRE | EIX | Buy | 139 | 0 | 139 | 0 | 5005 | 0 | 100 |  | 35.25 | 0.0078 | 211.05 | 0 | 211.05 | 0.57 | 36.01 | 35.55 | -1.28 | 35.59 | 35.6 | 74200 | 0 | 35.26 | 1.389999999999723 | SRE Equity | New York
0 | SRE | SRE | Sell | 1896 | 0 | 1896 | 0 |  | 0 | 100 |  | 55 | 0.1161 | -131.01 | 0 | -131.01 | 0.49 | 53.43 | 52.92 | -0.95 | 52.89 | 52.92 | 89100 | 0 | 52.72 | 18.95999999999623 | SRE Equity | New York
0 | SRE | PNW | Buy | 120 | 0 | 120 | 0 | 5006 | 0 | 100 |  | 41.81 | 0.0178 | -21.57 | 0 | -21.57 | 0.75 | 41.72 | 41.86 | 0.34 | 41.83 | 41.87 | 9500 | 0 | 41.82 | 1.199999999999761 | SRE Equity | New York
0 | SRE | NEE | Buy | 91 | 0 | 91 | 0 | 4977 | 0 | 100 |  | 54.79 | 0.0052 | -18.28 | 0 | -18.28 | 0.29 | 54.69 | 54.84 | 0.27 | 54.8 | 54.85 | 29000 | 0 | 54.8 | 0.909999999999819 | SRE Equity | New York
0 | SRE | XEL | Buy | 210 | 0 | 210 | 0 | 5002 | 0 | 100 |  | 23.81 | 0.0123 | 4.2 | 0 | 4.2 | 0.65 | 23.82 | 23.84 | 0.08 | 23.85 | 23.86 | 30100 | 0 | 23.82 | 2.100000000000328 | SRE Equity | New York
0 | SRE | ETR | Buy | 70 | 0 | 70 | 0 | 4965 | 0 | 100 |  | 71.05 | 0.0072 | -16.92 | 0 | -16.92 | 0.48 | 70.93 | 71.05 | 0.17 | 71.05 | 71.1 | 9500 | 0 | 71.06 | 0.7000000000003581 | SRE Equity | New York
0 | SRE | ED | Buy | 101 | 0 | 101 | 0 | 4990 | 0 | 100 |  | 49.47 | 0.0061 | -12.14 | 0 | -12.14 | 0.13 | 49.41 | 49.48 | 0.14 | 49.46 | 49.48 | 17900 | 0 | 49.48 | 1.009999999999799 | SRE Equity | New York
0 | SRE | DTE | Buy | 106 | 0 | 106 | 0 | 4980 | 0 | 100 |  | 47.01 | 0.0139 | -6.39 | 0 | -6.39 | 0.59 | 46.98 | 47 | 0.04 | 46.98 | 47.01 | 18200 | 0 | 47.02 | 1.059999999999789 | SRE Equity | New York
0 | SRE | PCG | Buy | 109 | 0 | 109 | 0 | 4997 | 0 | 100 |  | 45.82 | 0.0056 | 4.36 | 0 | 4.36 | 0.32 | 45.84 | 45.92 | 0.17 | 45.92 | 45.97 | 24400 | 0 | 45.83 | 1.089999999999783 | SRE Equity | New York
0 | SRE | NU | Buy | 149 | 0 | 149 | 0 | 5006 | 0 | 100 |  | 33.77 | 0.0088 | -50.6 | 0 | -50.6 | 0.33 | 33.6 | 33.77 | 0.51 | 33.75 | 33.77 | 21600 | 0 | 33.78 | 1.489999999999704 | SRE Equity | New York
0 | SRE | PGN | Buy | 110 | 0 | 110 | 0 | 4983 | 0 | 100 |  | 45.41 | 0.0087 | -24.28 | 0 | -24.28 | 0.32 | 45.3 | 45.41 | 0.24 | 45.4 | 45.42 | 13300 | 0 | 45.41999999999999 | 1.099999999999781 | SRE Equity | New York
0 | SRE | DPL | Buy | 193 | 0 | 193 | 0 | 4999 | 0 | 100 |  | 26 | 0.0267 | -38.61 | 0 | -38.61 | 0.8 | 25.9 | 25.99 | 0.35 | 25.97 | 26 | 18300 | 0 | 26.01 | 1.930000000000302 | SRE Equity | New York
0 | SRE | AEP | Buy | 142 | 0 | 142 | 0 | 5010 | 0 | 100 |  | 35.41 | 0.0048 | -36.85 | 0 | -36.85 | 0.55 | 35.28 | 35.46 | 0.51 | 35.44 | 35.46 | 30000 | 0 | 35.41999999999999 | 1.419999999999717 | SRE Equity | New York