Spreadsheet: 3632bb3f-9eb5-485f-b062-130cc02002a6
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: 25/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 | ING VYSYA BANK CD MAT 17.09.2012 | INE166A16FQ4 | SBI DEBT FUND SERIES - 90 DAYS - 66 (19.06.2012) | 17-SEP-2012 | 87 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 600 | 58755960 | 97926.6 | 9.2002 | MARKET TRADE
2 | ING VYSYA BANK CD MAT 17.09.2012 | INE166A16FQ4 | SBI DEBT FUND SERIES - 180 DAYS - 24 (08.05.2012) | 17-SEP-2012 | 87 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 400 | 39170640 | 97926.6 | 9.2002 | MARKET TRADE
3 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI DYNAMIC BOND FUND | 08-NOV-2021 | 3426 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 2000000 | 205900000 | 102.95 | 8.3276 | MARKET TRADE
4 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3426 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 2000000 | 205900000 | 102.95 | 8.3276 | MARKET TRADE
5 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM MONTHLY INCOME PLAN | 08-NOV-2021 | 3426 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 1000000 | 102950000 | 102.95 | 8.3276 | MARKET TRADE
6 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 1000000 | 105930000 | 105.93 | 8.3697 | MARKET TRADE
7 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 2500000 | 264900000 | 105.96 | 8.3659 | MARKET TRADE
8 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 500000 | 52980000 | 105.96 | 8.3659 | MARKET TRADE
9 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 1816300 | 192436985 | 105.95 | 8.3672 | MARKET TRADE
10 | PUNJAB NATIONAL BANK CD MAT. 15.03.2013 | INE160A16HI0 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 15-MAR-2013 | 266 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 10000 | 936060000 | 93606 | 9.48 | MARKET TRADE
11 | PUNJAB NATIONAL BANK CD MAT. 01.03.2013 | INE160A16HG4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 01-MAR-2013 | 252 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 10000 | 939257000 | 93925.7 | 9.4799 | MARKET TRADE
12 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM MONTHLY INCOME PLAN | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 500000 | 52980000 | 105.96 | 8.3659 | MARKET TRADE
13 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 500000 | 52978750 | 105.96 | 8.3662 | MARKET TRADE
14 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 1000000 | 105960000 | 105.96 | 8.3659 | MARKET TRADE
15 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 2500000 | 264875000 | 105.95 | 8.3672 | MARKET TRADE
16 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 1500000 | 158925000 | 105.95 | 8.3672 | MARKET TRADE
17 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 1000000 | 105950000 | 105.95 | 8.3672 | MARKET TRADE
18 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 1000000 | 105930000 | 105.93 | 8.3697 | MARKET TRADE
19 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 1000000 | 105930000 | 105.93 | 8.3697 | MARKET TRADE
20 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 1000000 | 105930000 | 105.93 | 8.3697 | MARKET TRADE
21 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 1000000 | 105910000 | 105.91 | 8.3722 | MARKET TRADE
22 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 1000000 | 105950000 | 105.95 | 8.3672 | MARKET TRADE
23 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 1000000 | 105950000 | 105.95 | 8.3672 | MARKET TRADE
24 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 2000000 | 211900000 | 105.95 | 8.3672 | MARKET TRADE
25 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4528 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 1000000 | 105950000 | 105.95 | 8.3672 | MARKET TRADE
26 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3426 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 5000000 | 514800000 | 102.96 | 8.3261 | MARKET TRADE
27 | AXIS BANK CD MAT. 16.07.2012 | INE238A16JS9 | SBI DEBT FUND SERIES - 18 MONTHS - 6 (21/01/2011) | 16-JUL-2012 | 24 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 500 | 49738150 | 99476.3 | 9.1503 | MARKET TRADE
28 | AXIS BANK CD MAT. 16.07.2012 | INE238A16JS9 | SBI PREMIER LIQUID FUND | 16-JUL-2012 | 24 | T+1 | 22-JUN-2012 | 22-JUN-2012 | 25-JUN-2012 | 500 | 49738150 | 99476.3 | 9.1503 | MARKET TRADE
29 | CANARA BANK CD MAT 24.09.2012 | INE476A16HQ3 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 91 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 2500 | 244242500 | 97697 | 9.4551 | MARKET TRADE
30 | CANARA BANK CD MAT 24.09.2012 | INE476A16HQ3 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 91 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 4000 | 390788000 | 97697 | 9.4551 | MARKET TRADE
31 | CANARA BANK CD MAT 24.09.2012 | INE476A16HQ3 | MICF-LIQUID FLOATER PLAN | 24-SEP-2012 | 91 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 1000 | 97697000 | 97697 | 9.4551 | MARKET TRADE
32 | IDBI BANK CD MAT 21.06.2013 | INE008A16LN3 | SBI DEBT FUND SERIES - 366 DAYS - 7 (21.06.2012) | 21-JUN-2013 | 361 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 5000 | 456395500 | 91279.1 | 9.66 | MARKET TRADE
33 | PUNJAB NATIONAL BANK CD MAT. 17.09.2012 | INE160A16GF8 | SBI PREMIER LIQUID FUND | 17-SEP-2012 | 84 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 5000 | 489473000 | 97894.6 | 9.3452 | MARKET TRADE
34 | PUNJAB NATIONAL BANK CD MAT. 17.09.2012 | INE160A16GF8 | SBI PREMIER LIQUID FUND | 17-SEP-2012 | 84 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 2500 | 244736500 | 97894.6 | 9.3452 | MARKET TRADE
35 | PUNJAB NATIONAL BANK CD MAT. 17.09.2012 | INE160A16GF8 | MICF-LIQUID FLOATER PLAN | 17-SEP-2012 | 84 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 2500 | 244736500 | 97894.6 | 9.3452 | MARKET TRADE
36 | PUNJAB NATIONAL BANK CD MAT. 17.09.2012 | INE160A16GF8 | SBI PREMIER LIQUID FUND | 17-SEP-2012 | 84 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 2500 | 244739500 | 97895.8 | 9.3398 | MARKET TRADE
37 | PUNJAB NATIONAL BANK CD MAT. 17.09.2012 | INE160A16GF8 | SBI PREMIER LIQUID FUND | 17-SEP-2012 | 84 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 7500 | 734218500 | 97895.8 | 9.3398 | MARKET TRADE
38 | PUNJAB NATIONAL BANK CD MAT. 17.09.2012 | INE160A16GF8 | SBI PREMIER LIQUID FUND | 17-SEP-2012 | 84 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 10000 | 978958000 | 97895.8 | 9.3398 | MARKET TRADE
39 | HDFC BANK CD MAT  21.06.2013 | INE040A16842 | SBI DYNAMIC BOND FUND | 21-JUN-2013 | 361 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 5000 | 456457000 | 91291.4 | 9.645 | MARKET TRADE
40 | HDFC BANK CD MAT  21.06.2013 | INE040A16842 | SBI DYNAMIC BOND FUND | 21-JUN-2013 | 361 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 4100 | 374303350 | 91293.5 | 9.6425 | MARKET TRADE
41 | HDFC BANK CD MAT  21.06.2013 | INE040A16842 | SBI DEBT FUND SERIES - 366 DAYS - 7 (21.06.2012) | 21-JUN-2013 | 361 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 900 | 82164150 | 91293.5 | 9.6425 | MARKET TRADE
42 | HDFC LTD CP MAT 24.09.2012 | INE001A14GH5 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 24-SEP-2012 | 91 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 2000 | 977101000 | 488550.5 | 9.4 | MARKET TRADE
43 | HDFC LTD CP MAT 24.09.2012 | INE001A14GH5 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 91 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 4000 | 1954202000 | 488550.5 | 9.4 | MARKET TRADE
44 | TRAPTI TRADING & INVESTMENTS PVT LTD CP MAT 24.09.2012 | INE977J14544 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 91 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 300 | 146376150 | 487920.5 | 9.93 | MARKET TRADE
45 | KOTAK MAHINDRA BANK CD MAT - 10.09.2012 | INE237A16LW9 | SBI DEBT FUND SERIES - 366 DAYS - 5 (30.05.2012) | 10-SEP-2012 | 77 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 60 | 5884894.5165012 | 98081.58 | 9.2717 | INTERSCHEME
46 | KOTAK MAHINDRA BANK CD MAT - 10.09.2012 | INE237A16LW9 | SBI ARBITRAGE OPPORTUNITIES FUND | 10-SEP-2012 | 77 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 60 | 5884894.5165012 | 98081.58 | 9.2717 | INTERSCHEME
47 | STERLITE ENERGY LIMITED CP MAT 21.09.2012 | INE957I14266 | SBI PREMIER LIQUID FUND | 21-SEP-2012 | 88 | T+0 | 25-JUN-2012 | 25-JUN-2012 | 25-JUN-2012 | 4000 | 1954756000 | 488689 | 9.6002 | 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.