Spreadsheet: 622bd120-eb9b-47d1-9318-ab3113c1fb5a
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: 05/07/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 | 1065 | T+1 | 04-JUL-2012 | 04-JUL-2012 | 05-JUL-2012 | 100 | 100261600 | 1002616 | 9.38 | MARKET TRADE
2 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2752 | T+1 | 04-JUL-2012 | 04-JUL-2012 | 05-JUL-2012 | 2500000 | 249600000 | 99.84 | 8.2179 | MARKET TRADE
3 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2752 | T+1 | 04-JUL-2012 | 04-JUL-2012 | 05-JUL-2012 | 500000 | 49990000 | 99.98 | 8.1926 | MARKET TRADE
4 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2752 | T+1 | 04-JUL-2012 | 04-JUL-2012 | 05-JUL-2012 | 500000 | 49990000 | 99.98 | 8.1926 | MARKET TRADE
5 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2752 | T+1 | 04-JUL-2012 | 04-JUL-2012 | 05-JUL-2012 | 500000 | 49990000 | 99.98 | 8.1926 | MARKET TRADE
6 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2752 | T+1 | 04-JUL-2012 | 04-JUL-2012 | 05-JUL-2012 | 500000 | 49990000 | 99.98 | 8.1926 | MARKET TRADE
7 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2752 | T+1 | 04-JUL-2012 | 04-JUL-2012 | 05-JUL-2012 | 500000 | 49990000 | 99.98 | 8.1926 | MARKET TRADE
8 | PUNJAB NATIONAL BANK CD MAT. 23.08.2012 | INE160A16FY1 | SBI PREMIER LIQUID FUND | 23-AUG-2012 | 50 | T+1 | 04-JUL-2012 | 04-JUL-2012 | 05-JUL-2012 | 2500 | 247130250 | 98852.1 | 8.65 | MARKET TRADE
12 | BAJAJ  FINANCE LTD 8% 05/07/2012 | INE296A08441 | MAGNUM INCOME PLUS - INVESTMENT | 05-JUL-2012 | 0 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 4 | 40000000 | 10000000 | 0 | MARKET TRADE
11 | BAJAJ  FINANCE LTD 8% 05/07/2012 | INE296A08441 | SBI DEBT FUND SERIES - 18 MONTHS - 5 (10/01/2011) | 05-JUL-2012 | 0 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 9 | 90000000 | 10000000 | 0 | MARKET TRADE
10 | BAJAJ  FINANCE LTD 8% 05/07/2012 | INE296A08441 | SBI DEBT FUND SERIES - 18 MONTHS - 6 (21/01/2011) | 05-JUL-2012 | 0 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 4 | 40000000 | 10000000 | 0 | MARKET TRADE
9 | BAJAJ  FINANCE LTD 8% 05/07/2012 | INE296A08441 | SBI DEBT FUND SERIES - 24 MONTHS - 2 (21/09/2010) | 05-JUL-2012 | 0 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 4 | 40000000 | 10000000 | 0 | MARKET TRADE
13 | BAJAJ  FINANCE LTD 8% 05/07/2012 | INE296A08441 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 05-JUL-2012 | 0 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 14 | 140000000 | 10000000 | 0 | MARKET TRADE
14 | SYNDICATE BANK CD MAT 24.12.2012 | INE667A16891 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 24-DEC-2012 | 172 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 2500 | 239720250 | 95888.1 | 9.1 | MARKET TRADE
15 | ANDHRA BANK CD MAT. 26.12.2012 | INE434A16AS3 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 26-DEC-2012 | 174 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 5000 | 479036500 | 95807.3 | 9.1799 | MARKET TRADE
16 | GRUH FINANCE LTD CP MAT 28.09.2012 | INE580B14782 | SBI PREMIER LIQUID FUND | 28-SEP-2012 | 85 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 1500 | 734268750 | 489512.5 | 9.1999 | MARKET TRADE
17 | SHRIRAM TRANSPORT FINANCE CO. LTD CP MAT 27.09.2012 | INE721A14586 | SBI PREMIER LIQUID FUND | 27-SEP-2012 | 84 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 4000 | 1958532000 | 489633 | 9.2002 | MARKET TRADE
18 | TATA CAPITAL FINANCIAL SERVICES LTD CP MAT 25.09.2012 | INE306N14233 | SBI PREMIER LIQUID FUND | 25-SEP-2012 | 82 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 2000 | 979642000 | 489821 | 9.2501 | MARKET TRADE
19 | MOTHERSON SUMI SYSTEMS LTD CP MAT 28.09.2012 | INE775A14525 | SBI PREMIER LIQUID FUND | 28-SEP-2012 | 85 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 1000 | 489456500 | 489456.5 | 9.2501 | MARKET TRADE
20 | VIJAYA BANK CD MAT 28.09.12 | INE705A16FG0 | SBI PREMIER LIQUID FUND | 28-SEP-2012 | 85 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 5000 | 489713500 | 97942.7 | 9.0199 | MARKET TRADE
21 | VIJAYA BANK CD MAT 28.09.12 | INE705A16FG0 | SBI PREMIER LIQUID FUND | 28-SEP-2012 | 85 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 5000 | 489713500 | 97942.7 | 9.0199 | MARKET TRADE
22 | VIJAYA BANK CD MAT 28.09.12 | INE705A16FG0 | SBI PREMIER LIQUID FUND | 28-SEP-2012 | 85 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 5000 | 489713500 | 97942.7 | 9.0199 | MARKET TRADE
23 | VIJAYA BANK CD MAT 28.09.12 | INE705A16FG0 | SBI PREMIER LIQUID FUND | 28-SEP-2012 | 85 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 5000 | 489713500 | 97942.7 | 9.0199 | MARKET TRADE
24 | UNION BANK CD MAT. 19.12.2012 | INE692A16BI5 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 19-DEC-2012 | 167 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 5000 | 479845500 | 95969.1 | 9.1801 | MARKET TRADE
25 | ASHOK LEYLAND LTD CP MAT 27.09.2012 | INE208A14436 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 27-SEP-2012 | 84 | T+0 | 05-JUL-2012 | 05-JUL-2012 | 05-JUL-2012 | 2000 | 979311000 | 489655.5 | 9.1798 | 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.