Spreadsheet: f96b9789-bffa-42fe-bf74-c5a83439cc72
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: 16/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 | ANDHRA BANK CD MAT. DT. 20.03.2012 | INE434A16AL8 | SBI MUTUAL FUND | MAGNUM INSTACASH FUND | 20/03/2012 | 4 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 7500 | 749240250 | 99898.7 | 9.253 | MARKET TRADE
2 | BANK OF INDIA CD MAT. DT. 15.06.2012 | INE084A16642 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 15/06/2012 | 91 | BROKER | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 2500 | 243191000 | 97276.4 | 11.2302 | MARKET TRADE
3 | BANK OF INDIA CD MAT. DT. 15.06.2012 | INE084A16642 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 15/06/2012 | 91 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 7500 | 729573000 | 97276.4 | 11.2302 | MARKET TRADE
4 | CORPORATION BANK CD MAT. 13.06.2012 | INE112A16AR7 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 13/06/2012 | 89 | BROKER | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 2500 | 243536250 | 97414.5 | 10.8849 | MARKET TRADE
5 | CORPORATION BANK CD MAT. 13.06.2012 | INE112A16AR7 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 13/06/2012 | 89 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 7500 | 730608750 | 97414.5 | 10.8849 | MARKET TRADE
6 | ALLAHABAD BANK CD MAT 11.06.2012 | INE428A16GB8 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 11/06/2012 | 87 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 7500 | 730600500 | 97413.4 | 11.14 | MARKET TRADE
7 | ALLAHABAD BANK CD MAT 11.06.2012 | INE428A16GB8 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS - 58 (13.03.12) | 11/06/2012 | 87 | BROKER | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 2500 | 243533500 | 97413.4 | 11.14 | MARKET TRADE
8 | ING VYSYA BANK CD MAT 11.06.2012 | INE166A16EI4 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS - 58 (13.03.12) | 11/06/2012 | 87 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 7500 | 730041000 | 97338.8 | 11.47 | MARKET TRADE
9 | ING VYSYA BANK CD MAT 11.06.2012 | INE166A16EI4 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS - 58 (13.03.12) | 11/06/2012 | 87 | BROKER | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 2500 | 243347000 | 97338.8 | 11.47 | MARKET TRADE
10 | ING VYSYA BANK CD MAT 17.04.2012 | INE166A16EZ8 | SBI MUTUAL FUND | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 17/04/2012 | 32 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 7000 | 693034300 | 99004.9 | 11.4644 | MARKET TRADE
11 | SOUTH INDIAN BANK CD MAT 17.04.2012 | INE683A16682 | SBI MUTUAL FUND | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 17/04/2012 | 32 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 7000 | 692892900 | 98984.7 | 11.6996 | MARKET TRADE
12 | ORIENTAL BANK OF COMMERCE CD MAT 17.04.2012 | INE141A16GZ6 | SBI MUTUAL FUND | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 17/04/2012 | 32 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 7000 | 693277900 | 99039.7 | 11.0596 | MARKET TRADE
13 | CANARA BANK CD MAT 17.04.2012 | INE476A16GX1 | SBI MUTUAL FUND | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 17/04/2012 | 32 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 7000 | 693283500 | 99040.5 | 11.0503 | MARKET TRADE
14 | ING VYSYA BANK CD MAT 17.04.2012 | INE166A16EZ8 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 17/04/2012 | 32 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 500 | 49502450 | 99004.9 | 11.4644 | MARKET TRADE
15 | SOUTH INDIAN BANK CD MAT 17.04.2012 | INE683A16682 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 17/04/2012 | 32 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 500 | 49492350 | 98984.7 | 11.6996 | MARKET TRADE
16 | PUNJAB NATIONAL BANK CD MAT. 15.03.2013 | INE160A16HI0 | SBI MUTUAL FUND | MAGNUM INCOME PLUS - INVESTMENT | 15/03/2013 | 364 | BROKER | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 300 | 27158850 | 90529.5 | 10.49 | MARKET TRADE
17 | PUNJAB NATIONAL BANK CD MAT. 15.03.2013 | INE160A16HI0 | SBI MUTUAL FUND | MAGNUM BALANCED FUND - 1995 | 15/03/2013 | 364 | BROKER | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 1000 | 90529500 | 90529.5 | 10.49 | MARKET TRADE
18 | PUNJAB NATIONAL BANK CD MAT. 15.03.2013 | INE160A16HI0 | SBI MUTUAL FUND | MAGNUM MONTHLY INCOME PLAN | 15/03/2013 | 364 | BROKER | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 3700 | 334959150 | 90529.5 | 10.49 | MARKET TRADE
19 | AXIS BANK CD MAT. 17.04.2012 | INE238A16IX1 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 17/04/2012 | 32 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 3500 | 346596600 | 99027.6 | 11.2003 | MARKET TRADE
20 | AXIS BANK CD MAT. 17.04.2012 | INE238A16IX1 | SBI MUTUAL FUND | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 17/04/2012 | 32 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 6500 | 643679400 | 99027.6 | 11.2003 | MARKET TRADE
21 | ORIENTAL BANK OF COMMERCE CD MAT 17.04.2012 | INE141A16GZ6 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 17/04/2012 | 32 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 3000 | 297119100 | 99039.7 | 11.0596 | MARKET TRADE
22 | CANARA BANK CD MAT 17.04.2012 | INE476A16GX1 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 17/04/2012 | 32 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-16 00:00:00 | 3000 | 297121500 | 99040.5 | 11.0503 | MARKET TRADE
23 | POWER FINANCE CORPORATION LTD  9.64%  15/12/2016 (SERIES 82-B) | INE134E08DZ7 | SBI MUTUAL FUND | MAGNUM INCOME FUND - 1998 | 15/12/2016 | 1735 | BROKER | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 40 | 40202520 | 1005063 | 9.4823 | MARKET TRADE
24 | POWER FINANCE CORPORATION LTD  9.64%  15/12/2016 (SERIES 82-B) | INE134E08DZ7 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 15/12/2016 | 1735 | BROKER | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 60 | 60303780 | 1005063 | 9.4823 | MARKET TRADE
25 | POWER FINANCE CORPORATION LTD  9.64%  15/12/2016 (SERIES 82-B) | INE134E08DZ7 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-SHORTTERM | 15/12/2016 | 1735 | BROKER | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 150 | 150759450 | 1005063 | 9.4823 | MARKET TRADE
26 | POWER FINANCE CORPORATION LTD  9.64%  15/12/2016 (SERIES 82-B) | INE134E08DZ7 | SBI MUTUAL FUND | MAGNUM MONTHLY INCOME PLAN | 15/12/2016 | 1735 | BROKER | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 100 | 100506300 | 1005063 | 9.4823 | MARKET TRADE
27 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 08/11/2021 | 3524 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 500000 | 51425000 | 102.85 | 8.3509 | MARKET TRADE
28 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 08/11/2021 | 3524 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 500000 | 51425000 | 102.85 | 8.3509 | MARKET TRADE
29 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 08/11/2021 | 3524 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 2500000 | 256875000 | 102.75 | 8.3659 | MARKET TRADE
30 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 08/11/2021 | 3524 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 1300000 | 133588000 | 102.76 | 8.3644 | MARKET TRADE
31 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 08/11/2021 | 3524 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 2000000 | 205600000 | 102.8 | 8.3584 | MARKET TRADE
32 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM BALANCED FUND - 1995 | 08/11/2021 | 3524 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 1000000 | 102500000 | 102.5 | 8.4036 | MARKET TRADE
33 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM INCOME FUND - 1998 | 08/11/2021 | 3524 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 500000 | 51375000 | 102.75 | 8.3659 | MARKET TRADE
34 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM MONTHLY INCOME PLAN | 08/11/2021 | 3524 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 1500000 | 154125000 | 102.75 | 8.3659 | MARKET TRADE
35 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM MONTHLY INCOME PLAN | 08/11/2021 | 3524 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 1000000 | 102520000 | 102.52 | 8.4006 | MARKET TRADE
36 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM MONTHLY INCOME PLAN | 08/11/2021 | 3524 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 500000 | 51260000 | 102.52 | 8.4006 | MARKET TRADE
37 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3524 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 1000000 | 102570000 | 102.57 | 8.393 | MARKET TRADE
38 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3524 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 500000 | 51425000 | 102.85 | 8.3509 | MARKET TRADE
39 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3524 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 1000000 | 102800000 | 102.8 | 8.3584 | MARKET TRADE
40 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3524 | DIRECT | 16/03/2012 | 16/03/2012 | 2012-03-19 00:00:00 | 200000 | 20552000 | 102.76 | 8.3644 | 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.