Spreadsheet: 72286d1272986084-count-with-several-criteria-and-average-with-complex-criteria-excel-help-sample
Sheet: IPO-Secondary List

 |  |  |  |  |  |  |  | Total PnL | 197000
 |  |  |  |  |  |  |  | Ave ROI | 0.07042052487742143 |  |  |  |  |  |  |  | Price action (close px) |  |  |  |  |  |  | DO NOT DELETE: USED TO CALCULATE AVERAGE / HIGH LOWS
 | Type | Participated? | Ticker | Leads | Size | Allocation | % filled | Deal Px | PnL | ROI |  |  | T-3 | T-2 | T-1 | T: [NAME] dt | Stk Priced at | T+1 | T+2 | T+3 | T+4 | T+5 | Perf 5 days | Stk Priced at | T+1 | T+2 | T+3 | T+4 | T+5 | Perf 5 days
 | IPOs:
 | IPO | No | Company 32 | GSCO |  |  |  |  |  |  |  |  |  |  |  |  | 21 | 19.2 | 19.03 | 19.4 | 19.38 | 19.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.08571428571428574 | -0.008854166666666607 | 0.01944298476090367 | -0.001030927835051543 | 0.01651186790505688 | -0.06190476190476191 |  | -0.08571428571428574 | -0.008854166666666607 | 0.01944298476090367 | -0.001030927835051543 | 0.01651186790505688 | -0.06190476190476191
 | IPO | Yes | Company 33 | BOA | 250000 | 90000 | 0.4 | 5 | 75000 | 0.1666666666666667 |  |  |  |  |  |  | 5 | 5.02 | 5.08 | 5.02 | 4.67 | 4.72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.004000000000000004 | 0.01195219123505975 | -0.01181102362204733 | -0.06972111553784854 | 0.01070663811563155 | -0.05600000000000005 |  | 0.004000000000000004 | 0.01195219123505975 | -0.01181102362204733 | -0.06972111553784854 | 0.01070663811563155 | -0.05600000000000005
 | IPO | Yes | Company 34 | Citi | 150000 | 110000 | 0.5 | 14.5 | 50000 | 0.03134796238244514 |  |  |  |  |  |  | 14.5 | 14.71 | 14.7 | 14.72 | 14.85 | 14.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01448275862068971 | -0.0006798096532971698 | 0.001360544217687165 | 0.008831521739130377 | -0.003367003367003241 | 0.02068965517241383 |  | 0.01448275862068971 | -0.0006798096532971698 | 0.001360544217687165 | 0.008831521739130377 | -0.003367003367003241 | 0.02068965517241383
 | IPO | Yes | Company 35 | Barcap | 400000 | 200000 | 0.2 | 20 | 35000 | 0.00875 |  |  |  |  |  |  | 20 | 20.5 | 20.2 | 20 | 19.84 | 19.98
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02499999999999991 | -0.01463414634146343 | -0.00990099009900991 | -0.008000000000000007 | 0.007056451612903247 | -0.001000000000000001 |  | 0.02499999999999991 | -0.01463414634146343 | -0.00990099009900991 | -0.008000000000000007 | 0.007056451612903247 | -0.001000000000000001
 | IPO | Yes | Company 36 | BOA | 100000 | 60000 | 0.8 | 13 | 7000 | 0.008974358974358974 |  |  |  |  |  |  | 13 | 12.75 | 12.7 | 12.7 | 12.68 | 12.68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.01923076923076927 | -0.003921568627451077 | 0 | -0.00157480314960623 | 0 | -0.02461538461538459 |  | -0.01923076923076927 | -0.003921568627451077 | 0 | -0.00157480314960623 | 0 | -0.02461538461538459
 | IPO | Yes | Company 37 | Citi | 125000 | 20000 | 0.3 | 11 | 30000 | 0.1363636363636364 |  |  |  |  |  |  | 11 | 11 | 11.01 | 11.05 | 11.015 | 11.06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.0009090909090909705 | 0.003633060853769354 | -0.003167420814479627 | 0.004085338175215503 | 0.005454545454545601 |  | 0 | 0.0009090909090909705 | 0.003633060853769354 | -0.003167420814479627 | 0.004085338175215503 | 0.005454545454545601
 | IPO | No | Company 38 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 15 | 15.18 | 14.99 | 14.38 | 14.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.01200000000000001 | -0.01251646903820813 | -0.0406937958639092 | -0.01877607788595281 | -0.05933333333333335 |  | 0 | 0.01200000000000001 | -0.01251646903820813 | -0.0406937958639092 | -0.01877607788595281 | -0.05933333333333335
 | IPO | No | Company 39 | BOA |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 12.3 | 12.07 | 12.1 | 11.8 | 11.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.1214285714285713 | -0.0186991869918699 | 0.002485501242750487 | -0.02479338842975198 | 0.008474576271186418 | -0.15 |  | -0.1214285714285713 | -0.0186991869918699 | 0.002485501242750487 | -0.02479338842975198 | 0.008474576271186418 | -0.15
 | IPO | No | Company 40 | CS |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 12 | 12 | 12 | 11.87 | 11.54
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | -0.01083333333333336 | -0.02780117944397642 | -0.03833333333333344 |  | 0 | 0 | 0 | -0.01083333333333336 | -0.02780117944397642 | -0.03833333333333344
 | IPO | No | Company 41 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 13.6 | 13.91 | 13.85 | 13.46 | 13.27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1333333333333333 | 0.02279411764705896 | -0.004313443565780006 | -0.02815884476534292 | -0.01411589895988119 | 0.1058333333333332 |  | 0.1333333333333333 | 0.02279411764705896 | -0.004313443565780006 | -0.02815884476534292 | -0.01411589895988119 | 0.1058333333333332
 | IPO | No | Company 42 | CS |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 13.26 | 14.04 | 14.45 | 14.3 | 13.88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02000000000000002 | 0.05882352941176472 | 0.02920227920227925 | -0.01038062283737018 | -0.0293706293706294 | 0.06769230769230772 |  | 0.02000000000000002 | 0.05882352941176472 | 0.02920227920227925 | -0.01038062283737018 | -0.0293706293706294 | 0.06769230769230772
 | IPO | No | Company 43 | MS |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 13.3 | 13.08 | 13 | 12.9 | 12.96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.04999999999999993 | -0.01654135338345875 | -0.006116207951070374 | -0.007692307692307665 | 0.004651162790697771 | -0.07428571428571418 |  | -0.04999999999999993 | -0.01654135338345875 | -0.006116207951070374 | -0.007692307692307665 | 0.004651162790697771 | -0.07428571428571418
 | IPO | No | Company 44 | Citi |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 20 | 20.01 | 20.01 | 20.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.000500000000000167 | 0 | 0 |  |  |  | 0 | 0.000500000000000167 | 0 | 0
 | IPO | No | Company 45 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 10.24 | 10.04 | 10.16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1377777777777778 | -0.01953125000000011 | 0.01195219123505975 |  |  |  |  | 0.1377777777777778 | -0.01953125000000011 | 0.01195219123505975
 | IPO | No | Company 46 | DB |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 17.7 | 17.91 | 17.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.01666666666666672 | 0.01186440677966116 | -0.0005583472920157595 |  |  |  |  | -0.01666666666666672 | 0.01186440677966116 | -0.0005583472920157595
 | IPO | No | Company 47 | Citi |  |  |  |  |  |  |  |  |  |  |  |  | 21.5 | 23.25 | 23.55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.08139534883720922 | 0.01290322580645165 |  |  |  |  |  | 0.08139534883720922 | 0.01290322580645165
 | Pending |  | Company 48 | CS
 | Pending |  | Company 49 | GSCO
 | Pending |  | Company 50 | CS
 | Pending |  | Company 51 | CS
 | Pending |  | Company 52 | MS
 | Pending |  | Company 53 | BOA
 | Pending |  | Company 54 | BOA
 | Pending |  | Company 55 | Citi