Spreadsheet: f0a1d40a-ad58-4741-a3e4-f49492e7c731
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
Transaction Date: 01/06/2012
Debt and Money Market Securities Transaction Details
S.No | Name of the Security | ISIN | 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 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI SHORT HORI DEBT FUND-SHORTTERM | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 1000000 | 104790000 | 104.79 | 8.5175 | MARKET TRADE
2 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI SHORT HORI DEBT FUND-SHORTTERM | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 500000 | 52395000 | 104.79 | 8.5175 | MARKET TRADE
3 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI SHORT HORI DEBT FUND-SHORTTERM | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 1000000 | 104790000 | 104.79 | 8.5175 | MARKET TRADE
4 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI SHORT HORI DEBT FUND-SHORTTERM | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 200000 | 20958000 | 104.79 | 8.5175 | MARKET TRADE
5 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM CHILDREN BENEFIT PLAN | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 300000 | 31437000 | 104.79 | 8.5175 | MARKET TRADE
6 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 1000000 | 104750000 | 104.75 | 8.5226 | MARKET TRADE
7 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 1000000 | 104750000 | 104.75 | 8.5226 | MARKET TRADE
8 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 500000 | 52375000 | 104.75 | 8.5226 | MARKET TRADE
9 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 1000000 | 104750000 | 104.75 | 8.5226 | MARKET TRADE
10 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 500000 | 52375000 | 104.75 | 8.5226 | MARKET TRADE
11 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 500000 | 52375000 | 104.75 | 8.5226 | MARKET TRADE
12 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 500000 | 52375000 | 104.75 | 8.5226 | MARKET TRADE
13 | ANDHRA BANK CD MAT. 20.03.2013 | INE434A16BL6 | SBI DYNAMIC BOND FUND | 20-MAR-2013 | 293 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 1960 | 181743940 | 92726.5 | 9.805 | MARKET TRADE
14 | ANDHRA BANK CD MAT. 20.03.2013 | INE434A16BL6 | MAGNUM INCOME FUND - 1998 | 20-MAR-2013 | 293 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 500 | 46363250 | 92726.5 | 9.805 | MARKET TRADE
15 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI SHORT HORI DEBT FUND-SHORTTERM | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 1000000 | 105220000 | 105.22 | 8.4627 | MARKET TRADE
16 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI SHORT HORI DEBT FUND-SHORTTERM | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 500000 | 52622500 | 105.25 | 8.4596 | MARKET TRADE
17 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM INCOME FUND - 1998 | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 600000 | 63150000 | 105.25 | 8.4589 | MARKET TRADE
18 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 1500000 | 157875000 | 105.25 | 8.4589 | MARKET TRADE
19 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 400000 | 42100000 | 105.25 | 8.4589 | MARKET TRADE
20 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 2000000 | 210500000 | 105.25 | 8.4589 | MARKET TRADE
21 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 2500000 | 263025000 | 105.21 | 8.464 | MARKET TRADE
22 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 500000 | 52702500 | 105.41 | 8.4393 | MARKET TRADE
23 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 500000 | 52702500 | 105.41 | 8.4393 | MARKET TRADE
24 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 1000000 | 105455000 | 105.46 | 8.433 | MARKET TRADE
25 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 500000 | 52727500 | 105.46 | 8.433 | MARKET TRADE
26 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI DYNAMIC BOND FUND | 08-NOV-2021 | 3448 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 1000000 | 102685000 | 102.69 | 8.3713 | MARKET TRADE
27 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI DYNAMIC BOND FUND | 08-NOV-2021 | 3448 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 1500000 | 154027500 | 102.69 | 8.3713 | MARKET TRADE
28 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 500000 | 52800000 | 105.6 | 8.4146 | MARKET TRADE
29 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 500000 | 52800000 | 105.6 | 8.4146 | MARKET TRADE
30 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 500000 | 52800000 | 105.6 | 8.4146 | MARKET TRADE
31 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4550 | T+1 | 31-MAY-2012 | 31-MAY-2012 | 01-JUN-2012 | 500000 | 52800000 | 105.6 | 8.4146 | MARKET TRADE
32 | TATA CAPITAL LTD, 0% MAT 01/06/2012 | INE976I07765 | SBI DEBT FUND SERIES -18 MONTHS -4  (03/12/2010) | 01-JUN-2012 | 0 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 250 | 250000000 | 1000000 | 0 | MARKET TRADE
33 | SUNDARAM FINANCE LTD, 0%  01/06/2012 | INE660A07FB7 | SBI DEBT FUND SERIES -18 MONTHS -4  (03/12/2010) | 01-JUN-2012 | 0 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 250 | 250000000 | 1000000 | 0 | MARKET TRADE
34 | 91 DAY TBILL MAT 29.06.2012 | IN002011X026 | SBI PREMIER LIQUID FUND | 29-JUN-2012 | 28 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 10063000 | 999971379.3 | 99.37 | 8.25 | MARKET TRADE
35 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI PREMIER LIQUID FUND | 08-NOV-2021 | 3447 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 10000000 | 1026500000 | 102.65 | 8.3766 | MARKET TRADE
36 | 91 DAY TBILL MAT 27.07.2012 | IN002012X024 | SBI PREMIER LIQUID FUND | 27-JUL-2012 | 56 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 10143000 | 999906068.7 | 98.58 | 9.3826 | MARKET TRADE
37 | 91 DAY TBILL MAT 27.07.2012 | IN002012X024 | SBI PREMIER LIQUID FUND | 27-JUL-2012 | 56 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 20287000 | 1999910718.3 | 98.58 | 9.3826 | MARKET TRADE
38 | 91 DAY TBILL MAT 17.08.2012 | IN002012X024 | SBI PREMIER LIQUID FUND | 17-AUG-2012 | 77 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 20349000 | 1999964836.8 | 98.28 | 8.2802 | MARKET TRADE
39 | 182 DAY TBILL MAT 28.09.2012 | IN002011Y024 | SBI PREMIER LIQUID FUND | 28-SEP-2012 | 119 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 10277000 | 999922296.7 | 97.3 | 8.5207 | MARKET TRADE
40 | 91 DAY TBILL MAT 08.06.12 | IN002011X026 | SBI PREMIER LIQUID FUND | 08-JUN-2012 | 7 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 2403000 | 239919845.4 | 99.84 | 8.2621 | MARKET TRADE
41 | 91 DAY TBILL MAT 21.06.12 | IN002011X026 | SBI PREMIER LIQUID FUND | 21-JUN-2012 | 20 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 4923000 | 489946313.7 | 99.52 | 8.7672 | MARKET TRADE
42 | 91 DAY TBILL MAT 24.08.2012 | IN002012X024 | SBI PREMIER LIQUID FUND | 24-AUG-2012 | 84 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 1019000 | 99992330.1 | 98.13 | 8.2899 | MARKET TRADE
43 | 91 DAY TBILL MAT 27.07.2012 | IN002012X024 | SBI PREMIER LIQUID FUND | 27-JUL-2012 | 56 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 1825000 | 179910142.5 | 98.58 | 9.3826 | MARKET TRADE
44 | 91 DAY TBILL MAT 13.07.2012 | IN002012X024 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 13-JUL-2012 | 42 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 30292000 | 2999901577.6 | 99.03 | 8.4875 | MARKET TRADE
45 | CORPORATION BANK CD MAT. 27.08.2012 | INE112A16AG0 | SBI PREMIER LIQUID FUND | 27-AUG-2012 | 87 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 5000 | 488718000 | 97743.6 | 9.685 | MARKET TRADE
46 | CORPORATION BANK CD MAT. 27.08.2012 | INE112A16AG0 | SBI PREMIER LIQUID FUND | 27-AUG-2012 | 87 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 10000 | 977436000 | 97743.6 | 9.685 | MARKET TRADE
47 | SOUTH INDIAN BANK CD MAT 30.05.2013 | INE683A16781 | SBI DEBT FUND SERIES - 366 DAYS - 5 (30.05.2012) | 30-MAY-2013 | 363 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 2500 | 227293500 | 90917.4 | 10.045 | MARKET TRADE
48 | SOUTH INDIAN BANK CD MAT 30.05.2013 | INE683A16781 | SBI DEBT FUND SERIES - 366 DAYS - 5 (30.05.2012) | 30-MAY-2013 | 363 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 2500 | 227293500 | 90917.4 | 10.045 | MARKET TRADE
49 | ALLAHABAD BANK CD MAT 30.08.2012 | INE428A16GQ6 | SBI PREMIER LIQUID FUND | 30-AUG-2012 | 90 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 2500 | 244186750 | 97674.7 | 9.6549 | MARKET TRADE
50 | ALLAHABAD BANK CD MAT 30.08.2012 | INE428A16GQ6 | SBI PREMIER LIQUID FUND | 30-AUG-2012 | 90 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 7500 | 732560250 | 97674.7 | 9.6549 | MARKET TRADE
51 | ALLAHABAD BANK CD MAT 30.08.2012 | INE428A16GQ6 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 30-AUG-2012 | 90 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 5000 | 488373500 | 97674.7 | 9.6549 | MARKET TRADE
52 | PUNJAB NATIONAL BANK CD MAT. 06.12.2012 | INE160A16GO0 | SBI SHORT HORI DEBT FUND-SHORTTERM | 06-DEC-2012 | 188 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 2400 | 228579840 | 95241.6 | 9.6999 | MARKET TRADE
53 | ORIENTAL BANK OF COMMERCE CD MAT 13.12.2012 | INE141A16FQ7 | SBI SHORT HORI DEBT FUND-SHORTTERM | 13-DEC-2012 | 195 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 2400 | 228152400 | 95063.5 | 9.7199 | MARKET TRADE
54 | ALLAHABAD BANK CD MAT 30.08.2012 | INE428A16GQ6 | MAGNUM INSTACASH FUND | 30-AUG-2012 | 90 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 10000 | 976747000 | 97674.7 | 9.6549 | MARKET TRADE
55 | PUNJAB NATIONAL BANK CD MAT. 06.12.2012 | INE160A16GO0 | MAGNUM MONTHLY INCOME PLAN FLOATER | 06-DEC-2012 | 188 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 100 | 9524160 | 95241.6 | 9.6999 | MARKET TRADE
56 | ORIENTAL BANK OF COMMERCE CD MAT 13.12.2012 | INE141A16FQ7 | MAGNUM MONTHLY INCOME PLAN FLOATER | 13-DEC-2012 | 195 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 100 | 9506350 | 95063.5 | 9.7199 | MARKET TRADE
57 | UNION BANK CD MAT. 31.05.2013 | INE692A16BE4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 31-MAY-2013 | 364 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 7500 | 682111500 | 90948.2 | 9.98 | MARKET TRADE
58 | UNION BANK CD MAT. 31.05.2013 | INE692A16BE4 | SBI SHORT HORI DEBT FUND-SHORTTERM | 31-MAY-2013 | 364 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 2500 | 227370500 | 90948.2 | 9.98 | MARKET TRADE
59 | YES BANK CD MAT 30.05.2013 | INE528G16PE7 | SBI DEBT FUND SERIES - 366 DAYS - 5 (30.05.2012) | 30-MAY-2013 | 363 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 2500 | 227386000 | 90954.4 | 10 | MARKET TRADE
60 | MAHINDRA & MAHINDRA FINANCIAL SERVICES LTD CP MAT 27.08.2012 | INE774D14CO6 | SBI PREMIER LIQUID FUND | 27-AUG-2012 | 87 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 2000 | 976947000 | 488473.5 | 9.8999 | MARKET TRADE
61 | STERLITE ENERGY LIMITED CP MAT 31.08.2012 | INE957I14217 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 31-AUG-2012 | 91 | T+0 | 01-JUN-2012 | 01-JUN-2012 | 01-JUN-2012 | 3000 | 1463512500 | 487837.5 | 10 | 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.