Spreadsheet: 39d93771-62dd-4ebe-b5c0-d79b30ba0ba2
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: 15/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 | NATIONAL BANK FOR AGRI. & RURAL DEVT. 9.50% , 04/06/2015 | INE261F09HL4 | SBI DYNAMIC BOND FUND | 04-JUN-2015 | 1081 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 150 | 150497100 | 1003314 | 9.36 | MARKET TRADE
2 | NATIONAL BANK FOR AGRI. & RURAL DEVT. 9.50% , 04/06/2015 | INE261F09HL4 | SBI DYNAMIC BOND FUND | 04-JUN-2015 | 1081 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 100 | 100281500 | 1002815 | 9.38 | MARKET TRADE
3 | NATIONAL BANK FOR AGRI. & RURAL DEVT. 9.50% , 04/06/2015 | INE261F09HL4 | SBI DYNAMIC BOND FUND | 04-JUN-2015 | 1081 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 100 | 100356300 | 1003563 | 9.35 | MARKET TRADE
4 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM INCOME FUND - 1998 | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 500000 | 53002500 | 106.01 | 8.361 | MARKET TRADE
5 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM BALANCED FUND - 1995 | 16-JAN-2020 | 2768 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 500000 | 50150000 | 100.3 | 8.1343 | MARKET TRADE
6 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM BALANCED FUND - 1995 | 16-JAN-2020 | 2768 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 500000 | 50150000 | 100.3 | 8.1343 | MARKET TRADE
7 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 500000 | 53035000 | 106.07 | 8.3529 | MARKET TRADE
8 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 1000000 | 106070000 | 106.07 | 8.3529 | MARKET TRADE
9 | GOI 8.19%  16/01/2020 | IN0020110071 | SBI DYNAMIC BOND FUND | 16-JAN-2020 | 2768 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 500000 | 50150000 | 100.3 | 8.1343 | MARKET TRADE
10 | GOI 8.19%  16/01/2020 | IN0020110071 | SBI DYNAMIC BOND FUND | 16-JAN-2020 | 2768 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 500000 | 50150000 | 100.3 | 8.1343 | MARKET TRADE
11 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM MONTHLY INCOME PLAN | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 500000 | 52600000 | 105.2 | 8.4629 | MARKET TRADE
12 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM MONTHLY INCOME PLAN | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 500000 | 52650000 | 105.3 | 8.4502 | MARKET TRADE
13 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 2500000 | 263250000 | 105.3 | 8.4502 | MARKET TRADE
14 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 500000 | 52675000 | 105.35 | 8.4438 | MARKET TRADE
15 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 1500000 | 158025000 | 105.35 | 8.4438 | MARKET TRADE
16 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 1000000 | 105350000 | 105.35 | 8.4438 | MARKET TRADE
17 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM BALANCED FUND - 1995 | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 500000 | 52600000 | 105.2 | 8.4629 | MARKET TRADE
18 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM BALANCED FUND - 1995 | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 1000000 | 105200000 | 105.2 | 8.4629 | MARKET TRADE
19 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 2000000 | 210600000 | 105.3 | 8.4502 | MARKET TRADE
20 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 1000000 | 105200000 | 105.2 | 8.4629 | MARKET TRADE
21 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 1000000 | 105200000 | 105.2 | 8.4629 | MARKET TRADE
22 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 1000000 | 105200000 | 105.2 | 8.4629 | MARKET TRADE
23 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 1000000 | 105300000 | 105.3 | 8.4502 | MARKET TRADE
24 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 4000000 | 421200000 | 105.3 | 8.4502 | MARKET TRADE
25 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 5000000 | 527900000 | 105.58 | 8.4147 | MARKET TRADE
26 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 1000000 | 105350000 | 105.35 | 8.4438 | MARKET TRADE
27 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 1000000 | 105350000 | 105.35 | 8.4438 | MARKET TRADE
28 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 1000000 | 105250000 | 105.25 | 8.4565 | MARKET TRADE
29 | POWER FINANCE CORPORATION LTD 89-B 9.46%  02/05/2015 | INE134E08EQ4 | SBI SHORT HORI DEBT FUND-SHORTTERM | 02-MAY-2015 | 1048 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 100 | 99975900 | 999759 | 9.4502 | MARKET TRADE
30 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM INCOME FUND - 1998 | 14-NOV-2024 | 4532 | T+1 | 18-JUN-2012 | 18-JUN-2012 | 19-JUN-2012 | 500000 | 53002500 | 106.01 | 8.361 | MARKET TRADE
31 | 91 DAY TBILL MAT 14.09.2012 | IN002012X024 | SBI PREMIER LIQUID FUND | 14-SEP-2012 | 87 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 10192000 | 999965657.6 | 98.11 | 8.0699 | MARKET TRADE
32 | 364 DAY TBILL MAT 16.11.2012 | IN002011Z021 | SBI PREMIER LIQUID FUND | 16-NOV-2012 | 150 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 10341000 | 999927131.4 | 96.7 | 8.316 | MARKET TRADE
33 | 364 DAY TBILL MAT 16.11.2012 | IN002011Z021 | SBI PREMIER LIQUID FUND | 16-NOV-2012 | 150 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 10134000 | 979911183.6 | 96.7 | 8.316 | MARKET TRADE
34 | 91 DAY TBILL MAT 27.07.2012 | IN002012X024 | SBI PREMIER LIQUID FUND | 27-JUL-2012 | 38 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 4940000 | 489919560 | 99.17 | 8 | MARKET TRADE
35 | 91 DAY TBILL MAT 07.09.12 | IN002012X024 | SBI PREMIER LIQUID FUND | 07-SEP-2012 | 80 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 6921000 | 679997939.4 | 98.25 | 8.12 | MARKET TRADE
36 | 91 DAY TBILL MAT 09.07.2012 | IN002012X024 | SBI PREMIER LIQUID FUND | 09-JUL-2012 | 20 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 3315000 | 329964823.5 | 99.54 | 8.4909 | MARKET TRADE
37 | 91 DAY TBILL MAT 17.08.2012 | IN002012X024 | SBI PREMIER LIQUID FUND | 17-AUG-2012 | 59 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 2433000 | 239945379.6 | 98.62 | 8.6491 | MARKET TRADE
38 | 91 DAY TBILL MAT 27.07.2012 | IN002012X024 | SBI PREMIER LIQUID FUND | 27-JUL-2012 | 38 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 11999000 | 1189988826 | 99.17 | 8 | MARKET TRADE
39 | 364 DAY TBILL MAT 11.01.2013 | IN002011Z021 | SBI PREMIER LIQUID FUND | 11-JAN-2013 | 206 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 9934000 | 949947690.6 | 95.63 | 8.1047 | MARKET TRADE
40 | ALLAHABAD BANK CD MAT 17.09.2012 | INE428A16GW4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 17-SEP-2012 | 90 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 10000 | 977618000 | 97761.8 | 9.285 | MARKET TRADE
41 | ALLAHABAD BANK CD MAT 17.09.2012 | INE428A16GW4 | SBI PREMIER LIQUID FUND | 17-SEP-2012 | 90 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 20000 | 1955236000 | 97761.8 | 9.285 | MARKET TRADE
42 | CENTRAL BANK OF INDIA CD MAT. DT. 18.09.2012 | INE483A16DG9 | SBI PREMIER LIQUID FUND | 18-SEP-2012 | 91 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 10000 | 977250000 | 97725 | 9.3374 | MARKET TRADE
43 | CENTRAL BANK OF INDIA CD MAT. DT. 18.09.2012 | INE483A16DG9 | SBI PREMIER LIQUID FUND | 18-SEP-2012 | 91 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 22500 | 2198812500 | 97725 | 9.3374 | MARKET TRADE
44 | CENTRAL BANK OF INDIA CD MAT. DT. 18.09.2012 | INE483A16DG9 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 18-SEP-2012 | 91 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 15000 | 1465875000 | 97725 | 9.3374 | MARKET TRADE
45 | DENA BANK CD MAT 14.09.2012 | INE077A16927 | SBI PREMIER LIQUID FUND | 14-SEP-2012 | 87 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 5000 | 489322500 | 97864.5 | 9.1548 | MARKET TRADE
46 | DENA BANK CD MAT 14.09.2012 | INE077A16927 | SBI PREMIER LIQUID FUND | 14-SEP-2012 | 87 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 5000 | 489322500 | 97864.5 | 9.1548 | MARKET TRADE
47 | DENA BANK CD MAT 14.09.2012 | INE077A16927 | SBI PREMIER LIQUID FUND | 14-SEP-2012 | 87 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 10000 | 978645000 | 97864.5 | 9.1548 | MARKET TRADE
48 | KOTAK MAHINDRA BANK CD MAT - 14.06.2013 | INE237A16PI9 | SBI DEBT FUND SERIES - 366 DAYS - 6 (14.06.2012) | 14-JUN-2013 | 360 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 1500 | 137050350 | 91366.9 | 9.5801 | MARKET TRADE
49 | CENTRAL BANK OF INDIA CD MAT. DT. 18.09.2012 | INE483A16DG9 | MICF-LIQUID FLOATER PLAN | 18-SEP-2012 | 91 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 2500 | 244312500 | 97725 | 9.3374 | MARKET TRADE
50 | FEDERAL BANK CD MAT 09.07.2012 | INE171A16CW9 | SBI DEBT FUND SERIES - 18 MONTHS - 5 (10/01/2011) | 09-JUL-2012 | 20 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 700 | 69643210 | 99490.3 | 9.3497 | MARKET TRADE
51 | TRAPTI TRADING & INVESTMENTS PVT LTD CP MAT 18.09.2012 | INE977J14536 | SBI PREMIER LIQUID FUND | 18-SEP-2012 | 91 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 400 | 195249000 | 488122.5 | 9.76 | MARKET TRADE
52 | INDIABULLS FINANCIAL SERVICES LTD CP MAT. 18.09.2012 | INE894F14GJ8 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 18-SEP-2012 | 91 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 3000 | 1463691000 | 487897 | 9.9498 | MARKET TRADE
53 | INDIABULLS HOUSING FINANCE LTD. CP MAT 18.09.2012 | INE148I14510 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 18-SEP-2012 | 91 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 3000 | 1463691000 | 487897 | 9.9498 | MARKET TRADE
54 | KOTAK MAHINDRA BANK CD MAT - 14.06.2013 | INE237A16PI9 | MAGNUM MONTHLY INCOME PLAN FLOATER | 14-JUN-2013 | 360 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 100 | 9136690 | 91366.9 | 9.5801 | MARKET TRADE
55 | KOTAK MAHINDRA BANK CD MAT - 14.06.2013 | INE237A16PI9 | MAGNUM INCOME FUND-FLOATIG RT-LTP | 14-JUN-2013 | 360 | T+0 | 19-JUN-2012 | 19-JUN-2012 | 19-JUN-2012 | 100 | 9136690 | 91366.9 | 9.5801 | 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.