Spreadsheet: dfe34df1-a475-4e75-a043-58fa82b340cb
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: 27/03/2012
Debt and Money Market Securities Transaction Details
SR. NO. | NAME OF SECURITY | ISIN | FUND HOUSE | SCHEME NAME | MATURITY DATE | RESIDUAL MATURITY | 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 | CANARA BANK CD MAT 26.03.2013 | INE476A16HF6 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 12 (06.03.12) | 26/03/2013 | 364 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 2500 | 226835750 | 90734.3 | 10.24 | MARKET TRADE
2 | BANK OF INDIA CD MAT. DT. 26.03.2013 | INE084A16782 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-SHORTTERM | 26/03/2013 | 364 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 2500 | 225479000 | 90191.6 | 10.9049 | MARKET TRADE
3 | ALLAHABAD BANK CD MAT 25.06.2012 | INE428A16GG7 | SBI MUTUAL FUND | MAGNUM INSTACASH FUND | 25/06/2012 | 90 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 5000 | 486253500 | 97250.7 | 11.4652 | MARKET TRADE
4 | ALLAHABAD BANK CD MAT 25.06.2012 | INE428A16GG7 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 25/06/2012 | 90 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 15000 | 1458760500 | 97250.7 | 11.4652 | MARKET TRADE
5 | CANARA BANK CD MAT 26.06.2012 | INE476A16HH2 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 26/06/2012 | 91 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 7500 | 729343500 | 97245.8 | 11.3599 | MARKET TRADE
6 | PUNJAB NATIONAL BANK CD MAT. 26.06.2012 | INE160A16HT7 | SBI MUTUAL FUND | MICF-LIQUID FLOATER PLAN | 26/06/2012 | 91 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 2500 | 243123250 | 97249.3 | 11.3451 | MARKET TRADE
7 | PUNJAB NATIONAL BANK CD MAT. 26.06.2012 | INE160A16HT7 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 26/06/2012 | 91 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 2500 | 243123250 | 97249.3 | 11.3451 | MARKET TRADE
8 | PUNJAB NATIONAL BANK CD MAT. 26.06.2012 | INE160A16HT7 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 26/06/2012 | 91 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 5000 | 486246500 | 97249.3 | 11.3451 | MARKET TRADE
9 | PUNJAB NATIONAL BANK CD MAT. 26.06.2012 | INE160A16HT7 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 26/06/2012 | 91 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 10000 | 972493000 | 97249.3 | 11.3451 | MARKET TRADE
10 | PUNJAB NATIONAL BANK CD MAT. 26.06.2012 | INE160A16HT7 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 26/06/2012 | 91 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 10000 | 972493000 | 97249.3 | 11.3451 | MARKET TRADE
11 | CENTRAL BANK OF INDIA CD MAT. DT. 26.06.2012 | INE483A16AZ5 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 26/06/2012 | 91 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 7500 | 729343500 | 97245.8 | 11.3599 | MARKET TRADE
12 | CENTRAL BANK OF INDIA CD MAT. DT. 26.06.2012 | INE483A16AZ5 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 26/06/2012 | 91 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 20000 | 1944916000 | 97245.8 | 11.3599 | MARKET TRADE
13 | VIJAYA BANK CD MAT 25.03.13 | INE705A16ET6 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 13 (20.03.12) | 25/03/2013 | 363 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 2500 | 226229750 | 90491.9 | 10.565 | MARKET TRADE
14 | IDBI BANK CD MAT 25.03.2013 | INE008A16JS6 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 13 (20.03.12) | 25/03/2013 | 363 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 2500 | 226240000 | 90496 | 10.56 | MARKET TRADE
15 | CANARA BANK CD MAT 22.03.2013 | INE476A16HK6 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 17 (21.03.12) | 22/03/2013 | 360 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 2500 | 226579750 | 90631.9 | 10.48 | MARKET TRADE
16 | VIJAYA BANK CD MAT 03.04.12 | INE705A16DO9 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 11 (14/03/2011) | 03/04/2012 | 7 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 7500 | 748227750 | 99763.7 | 12.3505 | MARKET TRADE
17 | UNITED BANK OF INDIA CD MAT 04.04.2012 | INE695A16DD5 | SBI MUTUAL FUND | SBI DEBT FUND SERIES 370 DAYS - 13 (07/04/2011) | 04/04/2012 | 8 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 4500 | 448785000 | 99730 | 12.3521 | MARKET TRADE
18 | BANK OF INDIA CD MAT. DT. 26.03.2013 | INE084A16782 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 26/03/2013 | 364 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 5000 | 450958000 | 90191.6 | 10.9049 | MARKET TRADE
19 | ANDHRA BANK CD MAT. 20.03.2013 | INE434A16BL6 | SBI MUTUAL FUND | MAGNUM INCOME FUND-FLOATIG RT-LTP | 20/03/2013 | 358 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 40 | 3622652.596 | 90566.31 | 10.62 | INTERSCHEME
20 | ANDHRA BANK CD MAT. 20.03.2013 | INE434A16BL6 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 20/03/2013 | 358 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 40 | 3622652.596 | 90566.31 | 10.62 | INTERSCHEME
21 | BANK OF INDIA CD MAT. DT. 25.06.2012 | INE084A16717 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 25/06/2012 | 90 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 1500 | 146059950 | 97373.3 | 10.9401 | MARKET TRADE
22 | BANK OF INDIA CD MAT. DT. 25.06.2012 | INE084A16717 | SBI MUTUAL FUND | MAGNUM BALANCED FUND - 1995 | 25/06/2012 | 90 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 1000 | 97373300 | 97373.3 | 10.9401 | MARKET TRADE
23 | CANARA BANK CD MAT 26.03.2013 | INE476A16HF6 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 26/03/2013 | 364 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 2500 | 226856250 | 90742.5 | 10.23 | MARKET TRADE
24 | ALLAHABAD BANK CD MAT 25.06.2012 | INE428A16GG7 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS  - 60 (27.03.12) | 25/06/2012 | 90 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 3500 | 340716600 | 97347.6 | 11.05 | MARKET TRADE
25 | ALLAHABAD BANK CD MAT 25.06.2012 | INE428A16GG7 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 25/06/2012 | 90 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 6500 | 632759400 | 97347.6 | 11.05 | MARKET TRADE
26 | INDIABULLS HOUSING FINANCE LTD. CP MAT 21.06.2012 | INE148I14346 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 21/06/2012 | 86 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 500 | 243098000 | 486196 | 12.05 | MARKET TRADE
27 | INDIABULLS HOUSING FINANCE LTD. CP MAT 18.06.2012 | INE148I14361 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 18/06/2012 | 83 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 500 | 243332250 | 486664.5 | 12.0502 | MARKET TRADE
28 | STCI FINANCE LTD. CP. MAT. 25.06.2012 | INE020E14783 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 25/06/2012 | 90 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 2000 | 971378000 | 485689 | 11.9498 | MARKET TRADE
29 | VIJAYA BANK CD MAT 03.04.12 | INE705A16DO9 | SBI MUTUAL FUND | SBI DEBT FUND SERIES 370 DAYS - 13 (07/04/2011) | 03/04/2012 | 7 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 4500 | 448936650 | 99763.7 | 12.3505 | MARKET TRADE
30 | UNITED BANK OF INDIA CD MAT 04.04.2012 | INE695A16DD5 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 11 (14/03/2011) | 04/04/2012 | 8 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 7500 | 747975000 | 99730 | 12.3521 | MARKET TRADE
31 | INDIAN OVERSEAS BANK CD MAT 18.06.2012 | INE565A16608 | SBI MUTUAL FUND | MICF-LIQUID FLOATER PLAN | 18/06/2012 | 83 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 1400 | 136611173.845846 | 97579.41 | 10.9088 | INTERSCHEME
32 | INDIAN OVERSEAS BANK CD MAT 18.06.2012 | INE565A16608 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 18/06/2012 | 83 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 1400 | 136611173.845846 | 97579.41 | 10.9088 | INTERSCHEME
33 | BANK OF INDIA CD MAT. DT. 18.06.2012 | INE084A16766 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS - 59 (21.03.12) | 18/06/2012 | 83 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 2000 | 195014197.252 | 97507.1 | 11.243 | INTERSCHEME
34 | BANK OF INDIA CD MAT. DT. 18.06.2012 | INE084A16766 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 18/06/2012 | 83 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 2000 | 195014197.252 | 97507.1 | 11.243 | INTERSCHEME
35 | INDIAN OVERSEAS BANK CD MAT 21.03.2013 | INE565A16616 | SBI MUTUAL FUND | MAGNUM INCOME FUND-FLOATIG RT-LTP | 21/03/2013 | 359 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 40 | 3621698.24 | 90542.46 | 10.62 | INTERSCHEME
36 | INDIAN OVERSEAS BANK CD MAT 21.03.2013 | INE565A16616 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 21/03/2013 | 359 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 40 | 3621698.24 | 90542.46 | 10.62 | INTERSCHEME
37 | L & T FINANCE LIMITED CP MAT. DT. 30.03.2012 | INE523E14FX9 | SBI MUTUAL FUND | MAGNUM SECTOR FUNDS UMBRELLA - CONTRA | 30/03/2012 | 3 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 400 | 199848118.1818 | 499620.3 | 9.2465 | INTERSCHEME
38 | L & T FINANCE LIMITED CP MAT. DT. 30.03.2012 | INE523E14FX9 | SBI MUTUAL FUND | MAGNUM INSTACASH FUND | 30/03/2012 | 3 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 400 | 199848118.1818 | 499620.3 | 9.2465 | INTERSCHEME
39 | BAJAJ FINANCE LTD CP MAT 30.03.2012 | INE296A14DF2 | SBI MUTUAL FUND | MAGNUM MULTIPLIER PLUS SCHEME - 1993 | 30/03/2012 | 3 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 1000 | 499620098.8372 | 499620.1 | 9.2513 | INTERSCHEME
40 | BAJAJ FINANCE LTD CP MAT 30.03.2012 | INE296A14DF2 | SBI MUTUAL FUND | MAGNUM INSTACASH FUND | 30/03/2012 | 3 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 1000 | 499620098.8372 | 499620.1 | 9.2513 | INTERSCHEME
41 | BAJAJ FINANCE LTD CP MAT 30.03.2012 | INE296A14DF2 | SBI MUTUAL FUND | SBI BLUE CHIP FUND | 30/03/2012 | 3 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 1000 | 499620098.8372 | 499620.1 | 9.2513 | INTERSCHEME
42 | BAJAJ FINANCE LTD CP MAT 30.03.2012 | INE296A14DF2 | SBI MUTUAL FUND | MAGNUM INSTACASH FUND | 30/03/2012 | 3 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 1000 | 499620098.8372 | 499620.1 | 9.2513 | INTERSCHEME
43 | UCO BANK CD MAT 19.06.12 | INE691A16FT5 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 90 DAYS  - 60 (27.03.12) | 19/06/2012 | 84 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 2500 | 243581732.253825 | 97432.69 | 11.4495 | INTERSCHEME
44 | UCO BANK CD MAT 19.06.12 | INE691A16FT5 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 19/06/2012 | 84 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 2500 | 243581732.253825 | 97432.69 | 11.4495 | INTERSCHEME
45 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3513 | T+1 | 27/03/2012 | 27/03/2012 | 2012-03-28 00:00:00 | 500000 | 50905000 | 101.81 | 8.5081 | MARKET TRADE
46 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3513 | T+1 | 27/03/2012 | 27/03/2012 | 2012-03-28 00:00:00 | 500000 | 50932500 | 101.87 | 8.4997 | MARKET TRADE
47 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3513 | T+1 | 27/03/2012 | 27/03/2012 | 2012-03-28 00:00:00 | 500000 | 50932500 | 101.87 | 8.4997 | MARKET TRADE
48 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3513 | T+1 | 27/03/2012 | 27/03/2012 | 2012-03-28 00:00:00 | 500000 | 50932500 | 101.87 | 8.4997 | MARKET TRADE
49 | ORIENTAL BANK OF COMMERCE CD MAT 08.03.2013 | INE141A16GU7 | SBI MUTUAL FUND | MAGNUM MONTHLY INCOME PLAN | 08/03/2013 | 346 | T+1 | 27/03/2012 | 27/03/2012 | 2012-03-28 00:00:00 | 2500 | 227418750 | 90967.5 | 10.505 | MARKET TRADE
50 | PUNJAB NATIONAL BANK CD MAT. 15.03.2013 | INE160A16HI0 | SBI MUTUAL FUND | MAGNUM MONTHLY INCOME PLAN | 15/03/2013 | 353 | T+1 | 27/03/2012 | 27/03/2012 | 2012-03-28 00:00:00 | 2500 | 226973000 | 90789.2 | 10.5199 | MARKET TRADE
51 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3513 | T+1 | 27/03/2012 | 27/03/2012 | 2012-03-28 00:00:00 | 2000000 | 203300000 | 101.65 | 8.5325 | MARKET TRADE
52 | PUNJAB NATIONAL BANK CD MAT. 31.05.2012 | INE160A16HF6 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 31/05/2012 | 65 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 4500 | 441990803.570625 | 98220.18 | 10.1755 | INTERSCHEME
53 | PUNJAB NATIONAL BANK CD MAT. 31.05.2012 | INE160A16HF6 | SBI MUTUAL FUND | MAGNUM INSTACASH FUND | 31/05/2012 | 65 | T+0 | 27/03/2012 | 27/03/2012 | 2012-03-27 00:00:00 | 4500 | 441990803.570625 | 98220.18 | 10.1755 | INTERSCHEME
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.