Spreadsheet: 81ec2503-34bb-4fb2-b6d4-d57e3f25c84a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Transaction Date: 29/03/2012
Debt and Money Market Securities Transaction Details
SR. NO. | NAME OF SECURITY | ISIN | FUND HOUSE | SCHEME NAME | MATURITY DATE | RESIDUAL DAYS | SETTLEMENT TYPE | TRADE DATE | VALUATION DATE | SETTLEMENT DATE | QUANTITY TRADED | VALUE OF THE TRADE | PRICE AT WHICH VALUED | YIELD AT WHICH VALUED | TYPE OF TRADE
1 | CENTRAL BANK OF INDIA CD MAT. DT. 28.03.2013 | INE483A16C05 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 28/03/2013 | 364 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 2500 | 225316750 | 90126.7 | 10.985 | MARKET TRADE
2 | BANK OF INDIA CD MAT. DT. 26.03.2013 | INE084A16782 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 26/03/2013 | 362 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 2500 | 225752000 | 90300.8 | 10.83 | MARKET TRADE
3 | CANARA BANK CD MAT 20.06.2012 | INE476A16HB5 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 20/06/2012 | 83 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 2500 | 244040000 | 97616 | 10.7399 | MARKET TRADE
4 | BANK OF INDIA CD MAT. DT. 25.03.2013 | INE084A16774 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 18 (28.03.12) | 25/03/2013 | 361 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 10000 | 909343000 | 90934.3 | 10.08 | MARKET TRADE
5 | VIJAYA BANK CD MAT 25.03.13 | INE705A16ET6 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 18 (28.03.12) | 25/03/2013 | 361 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 5000 | 454671500 | 90934.3 | 10.08 | MARKET TRADE
6 | UCO BANK CD MAT 26.06.12 | INE691A16FX7 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 26/06/2012 | 89 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 2500 | 243452250 | 97380.9 | 11.0301 | MARKET TRADE
7 | UCO BANK CD MAT 26.06.12 | INE691A16FX7 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 26/06/2012 | 89 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 2500 | 243452250 | 97380.9 | 11.0301 | MARKET TRADE
8 | UCO BANK CD MAT 26.06.12 | INE691A16FX7 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 26/06/2012 | 89 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 15000 | 1460713500 | 97380.9 | 11.0301 | MARKET TRADE
9 | ORIENTAL BANK OF COMMERCE CD MAT 28.03.2013 | INE141A16HE9 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 19 (27.03.12) | 28/03/2013 | 364 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 5000 | 452790500 | 90558.1 | 10.455 | MARKET TRADE
10 | ORIENTAL BANK OF COMMERCE CD MAT 28.03.2013 | INE141A16HE9 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 19 (27.03.12) | 28/03/2013 | 364 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 5000 | 452821000 | 90564.2 | 10.4475 | MARKET TRADE
11 | ALLAHABAD BANK CD MAT 25.06.2012 | INE428A16GG7 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 25/06/2012 | 88 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 2500 | 243741500 | 97496.6 | 10.65 | MARKET TRADE
12 | BANK OF INDIA CD MAT. DT. 28.03.2013 | INE084A16816 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 19 (27.03.12) | 28/03/2013 | 364 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 2500 | 226354250 | 90541.7 | 10.475 | MARKET TRADE
13 | BANK OF INDIA CD MAT. DT. 28.03.2013 | INE084A16816 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 19 (27.03.12) | 28/03/2013 | 364 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 7500 | 679062750 | 90541.7 | 10.475 | MARKET TRADE
14 | YES BANK CD MAT 25.06.2012 | INE528G16OJ9 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS  - 60 (27.03.12) | 25/06/2012 | 88 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 5000 | 486968000 | 97393.6 | 11.0999 | MARKET TRADE
15 | JINDAL STEEL & POWER LTD CP MAT 18.06.2012 | INE749A14967 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS  - 60 (27.03.12) | 18/06/2012 | 81 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 1000 | 488106500 | 488106.5 | 10.98 | MARKET TRADE
16 | CANARA BANK CD MAT 20.06.2012 | INE476A16HB5 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 20/06/2012 | 83 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 2500 | 244040000 | 97616 | 10.7399 | MARKET TRADE
17 | CANARA BANK CD MAT 26.06.2012 | INE476A16HH2 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 26/06/2012 | 89 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 2500 | 243354000 | 97341.6 | 11.2002 | MARKET TRADE
18 | BANK OF INDIA CD MAT. DT. 25.06.2012 | INE084A16717 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 25/06/2012 | 88 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 2500 | 243770250 | 97508.1 | 10.5999 | MARKET TRADE
19 | PUNJAB NATIONAL BANK CD MAT. 19.06.2012 | INE160A16HR1 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 19/06/2012 | 82 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 2500 | 243864000 | 97545.6 | 11.2 | MARKET TRADE
20 | ALLAHABAD BANK CD MAT 25.06.2012 | INE428A16GG7 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS  - 60 (27.03.12) | 25/06/2012 | 88 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 4000 | 389986400 | 97496.6 | 10.65 | MARKET TRADE
21 | ALLAHABAD BANK CD MAT 25.06.2012 | INE428A16GG7 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 25/06/2012 | 88 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 1000 | 97496600 | 97496.6 | 10.65 | MARKET TRADE
22 | CANARA BANK CD MAT 18.06.2012 | INE476A16GZ6 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 18/06/2012 | 81 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 4900 | 478686390 | 97691.1 | 10.6502 | MARKET TRADE
23 | CANARA BANK CD MAT 18.06.2012 | INE476A16GZ6 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS - 59 (21.03.12) | 18/06/2012 | 81 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 100 | 9769110 | 97691.1 | 10.6502 | MARKET TRADE
24 | PUNJAB NATIONAL BANK CD MAT. 06.06.2012 | INE160A16HN0 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 06/06/2012 | 69 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 5000 | 490132000 | 98026.4 | 10.6503 | MARKET TRADE
25 | PUNJAB NATIONAL BANK CD MAT. 06.06.2012 | INE160A16HN0 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 06/06/2012 | 69 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 7500 | 735198000 | 98026.4 | 10.6503 | MARKET TRADE
26 | ALLAHABAD BANK CD MAT 18.06.2012 | INE428A16GC6 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS  - 60 (27.03.12) | 18/06/2012 | 81 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 2000 | 195149600 | 97574.8 | 11.2 | MARKET TRADE
27 | ADITYA BIRLA FINANCE LTD CP MAT 11.06.2012 | INE860H14GA4 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 11/06/2012 | 74 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 1000 | 489044000 | 489044 | 11.0501 | MARKET TRADE
28 | ADITYA BIRLA FINANCE LTD CP MAT 14.06.2012 | INE860H14FP4 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 14/06/2012 | 77 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 1000 | 488610000 | 488610 | 11.05 | MARKET TRADE
29 | UNION BANK CD MAT. 26.06.2012 | INE692A16BB0 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 26/06/2012 | 89 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 20000 | 1948220000 | 97411 | 10.9 | MARKET TRADE
30 | ALLAHABAD BANK CD MAT 28.03.2013 | INE428A16GN3 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 18 (28.03.12) | 28/03/2013 | 364 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 10000 | 908082000 | 90808.2 | 10.15 | MARKET TRADE
31 | ALLAHABAD BANK CD MAT 13.06.2012 | INE428A16GE2 | SBI MUTUAL FUND | MICF-LIQUID FLOATER PLAN | 13/06/2012 | 76 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 2500 | 244576500 | 97830.6 | 10.6499 | MARKET TRADE
32 | SYNDICATE BANK CD MAT 26.06.2012 | INE667A16AG3 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 13 (20.03.12) | 26/06/2012 | 89 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 2500 | 243550750 | 97420.3 | 10.8598 | MARKET TRADE
33 | ORIENTAL BANK OF COMMERCE CD MAT 08.06.2012 | INE141A16GS1 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 08/06/2012 | 71 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 7500 | 734498250 | 97933.1 | 10.8499 | MARKET TRADE
34 | UCO BANK CD MAT 23.05.12 | INE691A16FK4 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 23/05/2012 | 55 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 3500 | 344684783.007355 | 98481.37 | 10.2336 | INTERSCHEME
35 | UCO BANK CD MAT 23.05.12 | INE691A16FK4 | SBI MUTUAL FUND | MAGNUM INSTACASH FUND | 23/05/2012 | 55 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 3500 | 344684783.007355 | 98481.37 | 10.2336 | INTERSCHEME
36 | STERLITE ENERGY LIMITED CP MAT 13.04.2012 | INE957I14159 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 13/04/2012 | 15 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 300 | 149281312.500324 | 497604.38 | 11.7148 | INTERSCHEME
37 | STERLITE ENERGY LIMITED CP MAT 13.04.2012 | INE957I14159 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 13/04/2012 | 15 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 300 | 149281312.500324 | 497604.38 | 11.7148 | INTERSCHEME
38 | INDIAN OVERSEAS BANK CD MAT 18.06.2012 | INE565A16608 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 18/06/2012 | 81 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 100 | 9763773.736481 | 97637.74 | 10.9023 | INTERSCHEME
39 | INDIAN OVERSEAS BANK CD MAT 18.06.2012 | INE565A16608 | SBI MUTUAL FUND | MICF-LIQUID FLOATER PLAN | 18/06/2012 | 81 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 100 | 9763773.736481 | 97637.74 | 10.9023 | INTERSCHEME
40 | BANK OF BARODA CD MAT. DT. 08.06.2012 | INE028A16417 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 12 (06.03.12) | 08/06/2012 | 71 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 3400 | 332883514.80715 | 97906.92 | 10.9903 | INTERSCHEME
41 | BANK OF BARODA CD MAT. DT. 08.06.2012 | INE028A16417 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 08/06/2012 | 71 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 3400 | 332883514.80715 | 97906.92 | 10.9903 | INTERSCHEME
42 | HOUSING DEVELOPMENT FIN. COR LTD 9.68% 09/02/2015 SERIES- (I-034) | INE001A07HW6 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 09/02/2015 | 1047 | T+1 | 29/03/2012 | 29/03/2012 | 2012-03-30 00:00:00 | 50 | 49770750 | 995415 | 9.8502 | MARKET TRADE
43 | ANDHRA BANK CD MAT. 21.05.2012 | INE434A16953 | SBI MUTUAL FUND | MAGNUM TAXGAIN SCHEME - 1993 | 21/05/2012 | 53 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 10000 | 985368386.362 | 98536.84 | 10.2261 | INTERSCHEME
44 | ANDHRA BANK CD MAT. 21.05.2012 | INE434A16953 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 21/05/2012 | 53 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 10000 | 985368386.362 | 98536.84 | 10.2261 | INTERSCHEME
45 | BANK OF BARODA CD MAT. DT. 08.06.2012 | INE028A16417 | SBI MUTUAL FUND | SBI ARBITRAGE OPPORTUNITIES FUND | 08/06/2012 | 71 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 1600 | 156651065.7916 | 97906.92 | 10.9903 | INTERSCHEME
46 | BANK OF BARODA CD MAT. DT. 08.06.2012 | INE028A16417 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 08/06/2012 | 71 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 1600 | 156651065.7916 | 97906.92 | 10.9903 | INTERSCHEME
47 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3511 | T+1 | 29/03/2012 | 29/03/2012 | 2012-03-30 00:00:00 | 1500000 | 151785000 | 101.19 | 8.6031 | MARKET TRADE
48 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3511 | T+1 | 29/03/2012 | 29/03/2012 | 2012-03-30 00:00:00 | 200000 | 20300000 | 101.5 | 8.5555 | MARKET TRADE
49 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM INCOME FUND - 1998 | 08/11/2021 | 3511 | T+1 | 29/03/2012 | 29/03/2012 | 2012-03-30 00:00:00 | 300000 | 30450000 | 101.5 | 8.5555 | MARKET TRADE
50 | STERLITE ENERGY LIMITED CP MAT 13.04.2012 | INE957I14159 | SBI MUTUAL FUND | MAGNUM SECTOR FUNDS UMBRELLA - CONTRA | 13/04/2012 | 15 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 300 | 149281312.500324 | 497604.38 | 11.7148 | INTERSCHEME
51 | STERLITE ENERGY LIMITED CP MAT 13.04.2012 | INE957I14159 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 13/04/2012 | 15 | T+0 | 29/03/2012 | 29/03/2012 | 2012-03-29 00:00:00 | 300 | 149281312.500324 | 497604.38 | 11.7148 | INTERSCHEME
52 | CANARA BANK CD MAT 21.03.2013 | INE476A16HD1 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 15 MONTHS - 10 (22.03.12) | 21/03/2013 | 357 | T+1 | 29/03/2012 | 29/03/2012 | 2012-03-30 00:00:00 | 500 | 45496000 | 90992 | 10.15 | MARKET TRADE
Note: | Value of the trade is based on the clean price.
 | Repo/CBLO and Fixed Deposits trades as not valued have not be reported.
 | Report is on Transaction level basis.