Friday, January 27, 2012 10:02:22 |
Statistics |
Total changed lines : 23 (2%); Same : 763 |
Target Only : 1 |
Source Only : 1 |
Changed : 21 |
C:\Users\skankanala\Desktop\Report 1.xlsm | C:\Users\skankanala\Desktop\Report 2.xlsm |
1 | 1 | 41. Ready-to-Ship Best Execution |
2 | 2 | |
3 | 3 | |
4 | 4 | Shock Value Filter (Multiple Items) |
5 | Status READY |
6 | 5 | Position (Multiple Items) |
6 | Status READY |
7 | 7 | Report Group True ALL Global |
8 | 8 | |
9 | 9 | Values |
10 | 10 | Loans Face Amt |
94 | 94 | FN10MBS 354 20 417 60004 BEST 4 81236 103 1 104 104 0 177 |
95 | 95 | 4.000 |
96 | 96 | FN10MBS 96 26 439 15835 BEST 4 81236 103 2 104 104 0 71 |
97 | 97 | 4.125 |
98 | FN10MBS 71 43 355 10275 BEST 4 81236 103 2 105 104 1 98 | 98 | FN10MBS 71 43 355 10275 BEST 3 81236 103 2 105 104 1 98 |
99 | 99 | 4.250 |
100 | 100 | FN10MBS 69 26 400 10036 BEST 4 81236 104 1 105 105 0 36 |
101 | 101 | 4.375 |
102 | 102 | FN10MBS 46 34 392 6667 BEST 4 81236 104 1 106 105 1 43 |
123 | 123 | FH15 12 30 373 2308 BEST 3 81236 98 2 99 103 -4 -82 |
124 | 124 | FN15MBS 57 71 581 12336 MIN 3 81236 98 2 100 102 -2 -258 |
125 | 125 | 3.750 |
126 | 126 | FH15 24 41 616 4722 BEST 4 81236 99 1 101 103 -2 -97 |
127 | FN15MBS 206 43 540 40868 MIN 3 81236 100 1 101 103 -1 -596 | 127 | FN15MBS 206 43 540 40868 MIN 4 81236 100 1 101 103 -1 -596 |
128 | 128 | 3.875 |
129 | FH15 41 39 325 6098 BEST 4 81236 100 1 101 103 -2 -116 | 129 | FH15 41 39 325 6098 BEST 3 81236 100 1 101 103 -2 -116 |
130 | 130 | FN15MBS 370 38 688 72364 MIN 4 81236 100 1 101 102 -1 -837 |
131 | 131 | 4.000 |
132 | 132 | FH15 30 50 385 4752 BEST 4 81236 100 2 102 103 -1 -52 |
133 | 133 | FN15MBS 306 22 570 60125 MIN 4 81236 101 1 102 103 -1 -307 |
174 | 174 | GN15 20 19 181 1343 MINWB 4 81236 106 1 107 102 5 71 |
175 | 175 | 5.500 |
176 | 176 | GN15 11 20 118 625 MINWB 5 81236 107 1 108 104 5 31 |
177 | 177 | 6.000 |
178 | GN15 6 31 70 289 MINWB 6 81236 108 1 110 103 7 19 | 178 | GN15 6 31 70 289 MINWB 5 81236 108 1 110 103 7 19 |
179 | 179 | 7.000 |
180 | 180 | GN15 1 84 84 84 MINWB 6 81236 112 1 113 100 13 11 |
181 | 181 | 15 Yr Govt 1 Total 189 24632 25525212 367328 25892540 25705196 1 187 |
182 | 182 | 15 Yr Govt 2 |
268 | 268 | 4.625 |
269 | 269 | FH20 24 100 403 4532 BEST 4 81224 101 1 103 103 -1 -34 |
270 | 270 | FN20MBS 129 39 417 26891 BEST 4 81224 101 2 103 103 -0 -113 |
271 | 271 | 4.750 |
272 | FH20 34 54 393 7210 BEST 4 81224 102 1 104 104 -0 -12 | 272 | FH20 34 54 393 7210 BEST 5 81224 102 1 104 104 -0 -12 |
273 | FN20MBS 170 29 488 33928 BEST 4 81224 103 1 104 104 0 87 | 273 | FN20MBS 170 29 488 33928 BEST 5 81224 103 1 104 104 0 87 |
274 | 274 | 4.875 |
275 | 275 | FH20 41 64 464 8120 BEST 5 81224 103 1 105 104 0 15 |
276 | FN20MBS 141 47 409 28007 BEST 4 81224 103 1 105 104 1 147 | 276 | FN20MBS 141 47 409 28007 BEST 5 81224 103 1 105 104 1 147 |
277 | 277 | 4.990 |
278 | 278 | FN20MBS 2 103 233 336 BEST 4 81224 103 2 105 104 1 4 |
279 | 279 | 5.000 |
280 | FH20 13 96 326 2385 BEST 5 81224 104 1 105 105 0 11 | 280 | FH20 13 96 326 2385 BEST 4 81224 104 1 105 105 0 11 |
281 | 281 | FN20MBS 49 61 362 9445 BEST 4 81224 104 2 105 104 1 74 |
282 | 282 | 5.125 |
283 | FH20 9 120 345 1908 BEST 5 81224 104 1 105 105 1 12 | 283 | FH20 9 120 345 1908 BEST 4 81224 104 1 105 105 1 12 |
284 | FN20MBS 21 37 480 4271 BEST 4 81224 103 2 105 105 -0 -9 | 284 | FN20MBS 21 37 480 4271 BEST 5 81224 103 2 105 105 -0 -9 |
285 | 285 | 5.250 |
286 | 286 | FH20 8 93 298 1361 BEST 5 81224 105 1 106 106 0 0 |
287 | 287 | FN20MBS 26 54 589 4656 BEST 5 81224 105 1 106 105 1 39 |
288 | 288 | 5.375 |
312 | 312 | FN30MBS 13 126 408 3766 BEST 4 81224 94 2 96 101 -5 -192 |
313 | 313 | 3.990 |
314 | 314 | FN30MBS 3 327 411 1076 BEST 4 81224 95 2 97 100 -3 -31 |
315 | 315 | 4.000 |
316 | FN30MBS 65 90 417 18277 BEST 4 81224 95 2 97 101 -5 -836 | 316 | FN30MBS 65 90 417 18277 BEST 3 81224 95 2 97 101 -5 -836 |
317 | 317 | 4.125 |
318 | 318 | FH30 3 283 355 970 BEST 4 81224 95 2 97 102 -5 -52 |
319 | FN30MBS 133 60 720 38121 BEST 3 81224 96 2 97 101 -4 -1421 | 319 | FN30MBS 133 60 720 38121 BEST 4 81224 96 2 97 101 -4 -1421 |
320 | 320 | 4.250 |
321 | 321 | FH30 19 56 405 4211 BEST 4 81224 97 2 99 103 -4 -186 |
322 | 322 | FN30MBS 285 40 730 75026 BEST 4 81224 97 2 99 102 -3 -2414 |
323 | 323 | 4.375 |
333 | 333 | FH30 133 56 582 29177 BEST 5 81224 101 1 102 104 -2 -509 |
334 | 334 | FN30MBS 1277 42 729 323756 BEST 4 81224 101 2 102 103 -1 -2770 |
335 | 335 | 4.875 |
336 | 336 | FH30 245 55 525 53054 BEST 4 81224 102 1 103 104 -1 -481 |
337 | FN30MBS 1923 27 857 478721 BEST 5 81224 102 1 103 104 -0 -1446 | 337 | FN30MBS 1923 27 857 478721 BEST 4 81224 102 1 103 104 -0 -1446 |
338 | 338 | 4.950 |
339 | 339 | FN30MBS 1 173 173 173 BEST 4 81224 102 2 104 103 1 1 |
340 | 340 | 4.990 |
341 | FN30MBS 41 70 654 10561 BEST 5 81224 102 2 104 103 0 39 | 341 | FN30MBS 41 70 654 10561 BEST 4 81224 102 2 104 103 0 39 |
342 | 342 | 4.999 |
343 | 343 | FN30MBS 5 55 235 816 BEST 4 81224 102 2 104 102 1 12 |
344 | 344 | 5.000 |
345 | 345 | FH30 117 24 568 27711 BEST 4 81224 102 2 104 104 -1 -178 |
346 | 346 | FN30MBS 773 35 730 192205 BEST 4 81224 102 2 104 104 -0 -335 |
347 | 347 | 5.125 |
348 | FH30 95 56 581 20616 BEST 4 81224 103 1 104 104 -0 -85 | 348 | FH30 95 56 581 20616 BEST 5 81224 103 1 104 104 -0 -85 |
349 | FN30MBS 469 37 730 112334 BEST 5 81224 102 2 104 104 -0 -147 | 349 | FN30MBS 469 37 730 112334 BEST 4 81224 102 2 104 104 -0 -147 |
350 | 350 | 5.250 |
351 | 351 | FH30 74 81 670 17427 BEST 5 81224 103 1 105 105 0 14 |
352 | 352 | FN30MBS 539 30 800 117706 BEST 5 81224 104 1 105 105 0 230 |
353 | 353 | 5.375 |
404 | 404 | GN30 27 41 301 2726 MINWB 6 81246 109 2 110 103 7 203 |
405 | 405 | 6.500 |
406 | 406 | GN30 19 50 196 1565 MINWB 6 81246 110 2 112 103 10 149 |
407 | 407 | 7.000 |
408 | GN30 9 25 142 758 MINWB 7 81246 113 2 115 102 13 99 | 408 | GN30 9 25 142 758 MINWB 6 81246 113 2 115 102 13 99 |
409 | 409 | 7.500 |
410 | 410 | GN30 9 21 100 474 MINWB 7 81246 113 1 115 100 14 67 |
411 | 411 | 8.000 |
412 | 412 | GN30 9 20 78 500 MINWB 8 81246 114 1 115 101 14 72 |
481 | 481 | GN302 1 82 82 82 BEST 6 81246 108 2 110 101 9 7 |
482 | 482 | 6.125 |
483 | 483 | GN302 10 53 150 845 BEST 6 81246 108 2 110 103 8 66 |
484 | 484 | 6.250 |
485 | GN302 7 45 135 498 BEST 5 81246 108 2 111 102 9 45 | 485 | GN302 7 45 135 498 BEST 6 81246 108 2 111 102 9 45 |
486 | 486 | 6.375 |
487 | 487 | GN302 4 78 141 398 BEST 6 81246 109 1 111 103 7 30 |
488 | 488 | 6.500 |
489 | 489 | GN302 1 102 102 102 BEST 6 81246 109 2 111 106 5 5 |
501 | 501 | GN302 3 51 152 282 BEST 7 81246 113 1 114 104 9 26 |
502 | 502 | 8.000 |
503 | 503 | GN302 1 92 92 92 BEST 8 81246 113 1 114 100 14 13 |
504 | 504 | 8.250 |
505 | GN302 3 56 85 221 BEST 7 81246 113 2 115 103 12 26 | 505 | GN302 3 56 85 221 BEST 8 81246 113 2 115 103 12 26 |
506 | 506 | 30 Yr Govt 2 Total 950 177076 182175268 2273527 184448795 183578269 0 871 |
507 | 507 | 30 Yr Non Conforming |
508 | 508 | 180FC |
509 | 509 | 4.125 |
515 | 515 | CM30 1 205 205 205 MINWB 4 81204 57 3 60 102 -41 -85 |
516 | 516 | 4.750 |
517 | 517 | CM30 2 270 600 871 MINWB 4 81204 83 1 84 102 -18 -154 |
518 | 518 | 4.875 |
519 | CM30 4 80 1129 2232 MINWB 4 81204 90 2 92 102 -10 -217 | 519 | CM30 4 80 1129 2232 MINWB 5 81204 90 2 92 102 -10 -217 |
520 | 520 | 5.000 |
521 | 521 | CM30 2 236 287 523 MINWB 4 81204 60 3 63 103 -40 -207 |
522 | 522 | 5.125 |
523 | 523 | CM30 2 161 230 391 MINWB 4 81204 79 3 83 103 -21 -81 |
665 | 665 | 051AC 3 158 211 544 BEST 2 81250 100 1 101 101 -0 -0 |
666 | 666 | 2.875 |
667 | 667 | 051AC 14 117 417 4197 BEST 2 81250 100 1 101 101 -0 -14 |
668 | 668 | 3.000 |
669 | 051AC 18 30 378 3871 BEST 3 81250 101 1 102 102 -1 -31 | 669 | 051AC 18 30 378 3871 BEST 2 81250 101 1 102 102 -1 -31 |
670 | 670 | 3.125 |
671 | 671 | 051AC 25 76 415 6490 BEST 3 81250 101 1 102 103 -1 -47 |
672 | 672 | 3.250 |
673 | 673 | 051AC 48 62 613 12204 BEST 3 81250 101 1 102 103 -1 -79 |