Spreadsheet: fbe25525-fb23-4e6e-bf76-2bdb47feddf4
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: 28/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 | 91 DAY TBILL MAT 08.06.12 |  | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/06/2012 | 72 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 3000000 | 294804900 | 98.27 | 8.9335 | INTERSCHEME
2 | 91 DAY TBILL MAT 08.06.12 |  | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 08/06/2012 | 72 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 3000000 | 294804900 | 98.27 | 8.9335 | INTERSCHEME
3 | 91 DAY TBILL MAT 08.06.12 |  | SBI MUTUAL FUND | MAGNUM GILT FUND - SHORT TERM | 08/06/2012 | 72 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 800000 | 78614640 | 98.27 | 8.9335 | INTERSCHEME
4 | 91 DAY TBILL MAT 08.06.12 |  | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 08/06/2012 | 72 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 800000 | 78614640 | 98.27 | 8.9335 | INTERSCHEME
5 | CANARA BANK CD MAT 15.03.2013 | INE476A16GU7 | SBI MUTUAL FUND | MAGNUM MONTHLY INCOME PLAN | 15/03/2013 | 352 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 1500 | 136136100 | 90757.4 | 10.56 | MARKET TRADE
6 | CANARA BANK CD MAT 15.03.2013 | INE476A16GU7 | SBI MUTUAL FUND | MAGNUM BALANCED FUND - 1995 | 15/03/2013 | 352 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 1000 | 90757400 | 90757.4 | 10.56 | MARKET TRADE
7 | CANARA BANK CD MAT 15.03.2013 | INE476A16GU7 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 15/03/2013 | 352 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 2500 | 226259750 | 90503.9 | 10.88 | MARKET TRADE
8 | CANARA BANK CD MAT 15.03.2013 | INE476A16GU7 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 15/03/2013 | 352 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 2500 | 226893500 | 90757.4 | 10.56 | MARKET TRADE
9 | CENTRAL BANK OF INDIA CD MAT. DT. 26.06.2012 | INE483A16AZ5 | SBI MUTUAL FUND | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 26/06/2012 | 90 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 5000 | 486376000 | 97275.2 | 11.3601 | MARKET TRADE
10 | IDBI BANK CD MAT 05.06.2012 | INE008A16GX2 | SBI MUTUAL FUND | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 05/06/2012 | 69 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 2500 | 245043500 | 98017.4 | 10.6998 | MARKET TRADE
11 | UCO BANK CD MAT 26.06.12 | INE691A16FX7 | SBI MUTUAL FUND | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 26/06/2012 | 90 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 7500 | 729582000 | 97277.6 | 11.3498 | MARKET TRADE
12 | VIJAYA BANK CD MAT 26.03.13 | INE705A16EU4 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 12 (06.03.12) | 26/03/2013 | 363 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 2500 | 225996000 | 90398.4 | 10.6799 | MARKET TRADE
13 | VIJAYA BANK CD MAT 26.03.13 | INE705A16EU4 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 12 (06.03.12) | 26/03/2013 | 363 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 7500 | 677988000 | 90398.4 | 10.6799 | MARKET TRADE
14 | CANARA BANK CD MAT 26.03.2013 | INE476A16HF6 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 12 (06.03.12) | 26/03/2013 | 363 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 5000 | 452174500 | 90434.9 | 10.6351 | MARKET TRADE
15 | CANARA BANK CD MAT 26.03.2013 | INE476A16HF6 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 26/03/2013 | 363 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 5000 | 452174500 | 90434.9 | 10.6351 | MARKET TRADE
16 | CENTRAL BANK OF INDIA CD MAT. DT. 27.03.2013 | INE483A16CK3 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 12 (06.03.12) | 27/03/2013 | 364 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 2500 | 225854750 | 90341.9 | 10.72 | MARKET TRADE
17 | CENTRAL BANK OF INDIA CD MAT. DT. 27.03.2013 | INE483A16CK3 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 12 (06.03.12) | 27/03/2013 | 364 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 7500 | 677564250 | 90341.9 | 10.72 | MARKET TRADE
18 | VIJAYA BANK CD MAT 26.03.13 | INE705A16EU4 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 13 (20.03.12) | 26/03/2013 | 363 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 2500 | 225752250 | 90300.9 | 10.8 | MARKET TRADE
19 | VIJAYA BANK CD MAT 26.03.13 | INE705A16EU4 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 13 (20.03.12) | 26/03/2013 | 363 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 5000 | 451504500 | 90300.9 | 10.8 | MARKET TRADE
20 | IDBI BANK CD MAT 26.03.2013 | INE008A16JW8 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 13 (20.03.12) | 26/03/2013 | 363 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 7500 | 677500500 | 90333.4 | 10.76 | MARKET TRADE
21 | DENA BANK CD MAT 25.06.2012 | INE077A16844 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS  - 60 (27.03.12) | 25/06/2012 | 89 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 2500 | 243411750 | 97364.7 | 11.1002 | MARKET TRADE
22 | DENA BANK CD MAT 25.06.2012 | INE077A16844 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS  - 60 (27.03.12) | 25/06/2012 | 89 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 7500 | 730235250 | 97364.7 | 11.1002 | MARKET TRADE
23 | UNITED BANK OF INDIA CD MAT 25.06.2012 | INE695A16EV5 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS  - 60 (27.03.12) | 25/06/2012 | 89 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 2500 | 243411750 | 97364.7 | 11.1002 | MARKET TRADE
24 | UNITED BANK OF INDIA CD MAT 25.06.2012 | INE695A16EV5 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS  - 60 (27.03.12) | 25/06/2012 | 89 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 7500 | 730235250 | 97364.7 | 11.1002 | MARKET TRADE
25 | VIJAYA BANK CD MAT 28.03.13 | INE705A16EY6 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 19 (27.03.12) | 28/03/2013 | 365 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 2500 | 226121500 | 90448.6 | 10.56 | MARKET TRADE
26 | VIJAYA BANK CD MAT 28.03.13 | INE705A16EY6 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 19 (27.03.12) | 28/03/2013 | 365 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 7500 | 678364500 | 90448.6 | 10.56 | MARKET TRADE
27 | YES BANK CD MAT 28.03.2013 | INE528G16OG5 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 19 (27.03.12) | 28/03/2013 | 365 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 10000 | 904568000 | 90456.8 | 10.55 | MARKET TRADE
28 | CANARA BANK CD MAT 26.03.2013 | INE476A16HF6 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 18 (28.03.12) | 26/03/2013 | 363 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 2500 | 227180500 | 90872.2 | 10.1 | MARKET TRADE
29 | CANARA BANK CD MAT 26.03.2013 | INE476A16HF6 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 18 (28.03.12) | 26/03/2013 | 363 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 5000 | 454361000 | 90872.2 | 10.1 | MARKET TRADE
30 | PUNJAB NATIONAL BANK CD MAT. 25.03.2013 | INE160A16HL4 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 18 (28.03.12) | 25/03/2013 | 362 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 5000 | 454393500 | 90878.7 | 10.12 | MARKET TRADE
31 | ALLAHABAD BANK CD MAT 18.06.2012 | INE428A16GC6 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 18/06/2012 | 82 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 2500 | 244185000 | 97674 | 10.6001 | MARKET TRADE
32 | BANK OF BARODA CD MAT. DT. 18.06.2012 | INE028A16441 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 18/06/2012 | 82 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 1800 | 175813200 | 97674 | 10.6001 | MARKET TRADE
33 | UCO BANK CD MAT 19.06.12 | INE691A16FT5 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 19/06/2012 | 83 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 1800 | 175724280 | 97624.6 | 10.7002 | MARKET TRADE
34 | BANK OF BARODA CD MAT. DT. 18.06.2012 | INE028A16441 | SBI MUTUAL FUND | SBI ARBITRAGE OPPORTUNITIES FUND | 18/06/2012 | 82 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 700 | 68371800 | 97674 | 10.6001 | MARKET TRADE
35 | UCO BANK CD MAT 19.06.12 | INE691A16FT5 | SBI MUTUAL FUND | SBI ARBITRAGE OPPORTUNITIES FUND | 19/06/2012 | 83 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 700 | 68337220 | 97624.6 | 10.7002 | MARKET TRADE
36 | AXIS BANK CD MAT. 26.03.2013 | INE238A16OJ8 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 19 (27.03.12) | 26/03/2013 | 363 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 5000 | 452806000 | 90561.2 | 10.48 | MARKET TRADE
37 | SYNDICATE BANK CD MAT 25.06.2012 | INE667A16AF5 | SBI MUTUAL FUND | MICF-LIQUID FLOATER PLAN | 25/06/2012 | 89 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 2000 | 194720200 | 97360.1 | 11.1201 | MARKET TRADE
38 | SYNDICATE BANK CD MAT 25.06.2012 | INE667A16AF5 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS  - 60 (27.03.12) | 25/06/2012 | 89 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 8000 | 778880800 | 97360.1 | 11.1201 | MARKET TRADE
39 | INDIAN OVERSEAS BANK CD MAT 28.05.2012 | INE565A16574 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 28/05/2012 | 61 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 5000 | 491584681.3231 | 98316.94 | 10.2432 | INTERSCHEME
40 | INDIAN OVERSEAS BANK CD MAT 28.05.2012 | INE565A16574 | SBI MUTUAL FUND | MICF-LIQUID FLOATER PLAN | 28/05/2012 | 61 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 5000 | 491584681.3231 | 98316.94 | 10.2432 | INTERSCHEME
41 | CORPORATION BANK CD MAT. 05.06.2012 | INE112A16BG8 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 05/06/2012 | 69 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 8000 | 783940596.3144 | 97992.57 | 10.8365 | INTERSCHEME
42 | CORPORATION BANK CD MAT. 05.06.2012 | INE112A16BG8 | SBI MUTUAL FUND | MAGNUM INSTACASH FUND | 05/06/2012 | 69 | T+0 | 28/03/2012 | 28/03/2012 | 2012-03-28 00:00:00 | 8000 | 783940596.3144 | 97992.57 | 10.8365 | INTERSCHEME
43 | CORPORATION BANK CD MAT. 03.04.2012 | INE112A16AW7 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 11 (14/03/2011) | 03/04/2012 | 6 | T+1 | 28/03/2012 | 28/03/2012 | 2012-03-29 00:00:00 | 6000 | 599015400 | 99835.9 | 11.999 | MARKET TRADE
44 | CORPORATION BANK CD MAT. 03.04.2012 | INE112A16AW7 | SBI MUTUAL FUND | SBI DEBT FUND SERIES 370 DAYS - 13 (07/04/2011) | 03/04/2012 | 6 | T+1 | 28/03/2012 | 28/03/2012 | 2012-03-29 00:00:00 | 4000 | 399343600 | 99835.9 | 11.999 | MARKET TRADE
45 | DENA BANK CD MAT 03.04.2012 | INE077A16711 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 11 (14/03/2011) | 03/04/2012 | 6 | T+1 | 28/03/2012 | 28/03/2012 | 2012-03-29 00:00:00 | 6000 | 599015400 | 99835.9 | 11.999 | MARKET TRADE
46 | DENA BANK CD MAT 03.04.2012 | INE077A16711 | SBI MUTUAL FUND | SBI DEBT FUND SERIES 370 DAYS - 13 (07/04/2011) | 03/04/2012 | 6 | T+1 | 28/03/2012 | 28/03/2012 | 2012-03-29 00:00:00 | 4000 | 399343600 | 99835.9 | 11.999 | MARKET TRADE
47 | CANARA BANK CD MAT 03.04.2012 | INE476A16FY1 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 180 DAYS - 22 (18.10.11) | 03/04/2012 | 6 | T+1 | 28/03/2012 | 28/03/2012 | 2012-03-29 00:00:00 | 1000 | 99835900 | 99835.9 | 11.999 | 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.