Spreadsheet: 269656d1381242439-sumprodcut-formula-to-return-data-based-on-certain-date-ranges-turnover
Sheet: Trade Blotter

Item | TradeDate | SettleDate | Security | Currency | Side | Portfolio | Prime | Broker | Description | [NAME] | Price | Local Gross Money | Commission | Fees | Local Net Money | [NAME] | Change Settle Rate | Process Currency Rate | USD
1 | [NAME] | 01/10/2012 | [NAME] | BRL | Buy | CORP GOV | STATE |  |  | 1901400 | 9.055 | 17217177 | 28494.427935 | 5939.9261 | -17251611.35 | 1.84 | 0 | 0 | -9359598.17
2 | [NAME] | 01/10/2012 | [NAME] | BRL | Buy | MASTER | STATE |  |  | 98600 | 9.055 | 892823 | 1477.622065 | 308.0239 | -894608.65 | 1.84 | 0 | 0 | -485356.25
3 | 01/04/2012 | 01/09/2012 | [NAME] | BRL | Sell | CORP GOV | STATE |  |  | 18133 | 26.054 | 472437.18 | 781.883536 | 162.9908 | 471492.31 | 1.84 | 0 | 0 | 255800.95
4 | 01/04/2012 | 01/09/2012 | [NAME] | BRL | Sell | MASTER | STATE |  |  | 567 | 26.054 | 14772.62 | 24.448683 | 5.0966 | 14743.07 | 1.84 | 0 | 0 | 7998.63
5 | [NAME] | 01/10/2012 | [NAME] | BRL | Sell | CORP GOV | STATE |  |  | 69140 | 26 | 1797640 | 2975.0942 | 620.1858 | 1794044.72 | 1.86 | 0 | 0 | 966306.54
6 | [NAME] | 01/10/2012 | [NAME] | BRL | Sell | MASTER | STATE |  |  | 2160 | 26 | 56160 | 92.9448 | 19.3752 | 56047.68 | 1.86 | 0 | 0 | 30188.34
7 | 01/06/2012 | 01/11/2012 | [NAME] | BRL | Sell | CORP GOV | STATE |  |  | 57406 | 26.3808 | 1514416.2 | 2506.358818 | 522.4736 | 1511387.37 | 1.86 | 0 | 0 | 814061.93
8 | 01/06/2012 | 01/11/2012 | [NAME] | BRL | Sell | MASTER | STATE |  |  | 1794 | 26.3808 | 47327.16 | 78.326442 | 16.3279 | 47232.5 | 1.86 | 0 | 0 | 25440.32
9 | 01/11/2012 | 01/16/2012 | [NAME] | BRL | Sell | CORP GOV | STATE |  |  | 167767 | 27.4929 | 4612401.35 | 7633.524241 | 1591.2785 | 4603176.55 | 1.79 | 0 | 0 | 2576933.63
10 | 01/11/2012 | 01/16/2012 | [NAME] | BRL | Sell | MASTER | STATE |  |  | 5233 | 27.4929 | 143870.35 | 238.105422 | 49.6353 | 143582.6 | 1.79 | 0 | 0 | 80379.89
11 | 01/26/2012 | 01/31/2012 | [NAME] | BRL | Buy | CORP GOV | STATE |  |  | 1426650 | 9.15 | 13053847.5 | 21604.117613 | 4503.5774 | -13079955.2 | 1.75 | 0 | 0 | -7478105.99
12 | 01/26/2012 | 01/31/2012 | [NAME] | BRL | Buy | MASTER | STATE |  |  | 73350 | 9.15 | 671152.5 | 1110.757388 | 231.5476 | -672494.8 | 1.75 | 0 | 0 | -384480.48
13 | 01/26/2012 | 01/31/2012 | [NAME] | BRL | Sell | CORP GOV | STATE |  |  | 95 | 9.13 | 867.35 | 1.088524 | 0.2993 | 865.96 | 1.75 | 0 | 0 | 495.09
14 | 01/26/2012 | 01/31/2012 | [NAME] | BRL | Sell | MASTER | STATE |  |  | 5 | 9.13 | 45.65 | 0.057291 | 0.0158 | 45.58 | 1.75 | 0 | 0 | 26.06
15 | 01/30/2012 | [NAME] | [NAME] | BRL | Buy | CORP GOV | STATE |  |  | 951100 | 9.3 | 8845230 | 14638.85565 | 3051.6044 | -8862920.46 | 1.75 | 0 | 0 | -5068001.18
16 | 01/30/2012 | [NAME] | [NAME] | BRL | Buy | MASTER | STATE |  |  | 48900 | 9.3 | 454770 | 752.64435 | 156.8957 | -455679.54 | 1.75 | 0 | 0 | -260566.98
17 | 02/21/2012 | 02/24/2012 | ALSEA | [NAME] | Buy | CORP GOV | STATE |  |  | 332815 | 16.4836 | 5485989.33 | 8228.984 | 0 | -5494218.32 | 12.78 | 0 | 0 | -429947.91
18 | 02/21/2012 | 02/24/2012 | ALSEA | [NAME] | Buy | MASTER | STATE |  |  | 17185 | 16.4836 | 283270.67 | 424.906 | 0 | -283695.57 | 12.78 | 0 | 0 | -22200.49
19 | 02/22/2012 | 02/27/2012 | ALSEA | [NAME] | Buy | CORP GOV | STATE |  |  | 47545 | 16.2 | 770229 | 1155.344 | 0 | -771384.34 | 12.82 | 0 | 0 | -60182.59
20 | 02/22/2012 | 02/27/2012 | ALSEA | [NAME] | Buy | MASTER | STATE |  |  | 2455 | 16.2 | 39771 | 59.657 | 0 | -39830.66 | 12.82 | 0 | 0 | -3107.55
21 | 02/22/2012 | 02/27/2012 | MPI | PHP | Buy | CORP GOV | STATE |  |  | 22536330 | 3.5801 | 80682315.03 | 282388.1026 | 24204.6945 | -80988907.83 | 42.74 | 0 | 0 | -1895053.65
22 | 02/22/2012 | 02/27/2012 | MPI | PHP | Buy | MASTER | STATE |  |  | 1163670 | 3.5801 | 4166054.97 | 14581.1924 | 1249.8165 | -4181885.98 | 42.74 | 0 | 0 | -97851.65
23 | 02/23/2012 | 02/28/2012 | MPI | PHP | Buy | CORP GOV | STATE |  |  | 22726510 | 3.5823 | 81413176.77 | 284946.1187 | 24423.953 | -81722546.84 | 42.74 | 0 | 0 | -1912220.01
24 | 02/23/2012 | 02/28/2012 | MPI | PHP | Buy | MASTER | STATE |  |  | 1173490 | 3.5823 | 4203793.23 | 14713.2763 | 1261.138 | -4219767.64 | 42.74 | 0 | 0 | -98738.04
25 | 02/24/2012 | 02/29/2012 | ALSEA | [NAME] | Buy | CORP GOV | STATE |  |  | 406148 | 16.7405 | 6799120.59 | 10198.681 | 0 | -6809319.28 | 12.86 | 0 | 0 | -529302.61
26 | 02/24/2012 | 02/29/2012 | ALSEA | [NAME] | Buy | MASTER | STATE |  |  | 20972 | 16.7405 | 351081.77 | 526.623 | 0 | -351608.39 | 12.86 | 0 | 0 | -27331.25
27 | 02/27/2012 | 03/01/2012 | ALSEA | [NAME] | Buy | CORP GOV | STATE |  |  | 190180 | 16.75 | 3185515 | 4778.273 | 0 | -3190293.27 | 12.88 | 0 | 0 | -247678.19
28 | 02/27/2012 | 03/01/2012 | ALSEA | [NAME] | Buy | MASTER | STATE |  |  | 9820 | 16.75 | 164485 | 246.728 | 0 | -164731.73 | 12.88 | 0 | 0 | -12788.94
29 | 02/28/2012 | 03/02/2012 | ALSEA | [NAME] | Buy | CORP GOV | STATE |  |  | 190180 | 16.7497 | 3185457.95 | 4778.187 | 0 | -3190236.13 | 12.85 | 0 | 0 | -248232.63
30 | 02/28/2012 | 03/02/2012 | ALSEA | [NAME] | Buy | MASTER | STATE |  |  | 9820 | 16.7497 | 164482.05 | 246.723 | 0 | -164728.78 | 12.85 | 0 | 0 | -12817.56
31 | 02/29/2012 | 03/05/2012 | ALSEA | [NAME] | Buy | CORP GOV | STATE |  |  | 380360 | 16.7432 | 6368443.55 | 9552.665 | 0 | -6377996.22 | 12.86 | 0 | 0 | -495890.61
32 | 02/29/2012 | 03/05/2012 | ALSEA | [NAME] | Buy | MASTER | STATE |  |  | 19640 | 16.7432 | 328836.45 | 493.255 | 0 | -329329.7 | 12.86 | 0 | 0 | -25605.46