Spreadsheet: 095b58cd-d879-488c-82cc-6339846f35d8
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:29/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 | SUNDARAM FINANCE LTD, 0%  29/06/2012 | INE660A07EP0 | SBI DEBT FUND SERIES - 18 MONTHS - 5 (10/01/2011) | 29-JUN-2012 | 0 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 114 | 114000000 | 1000000 | 0 | MARKET TRADE
2 | SUNDARAM FINANCE LTD, 0%  29/06/2012 | INE660A07EP0 | SBI DEBT FUND SERIES - 18 MONTHS - 6 (21/01/2011) | 29-JUN-2012 | 0 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 40 | 40000000 | 1000000 | 0 | MARKET TRADE
3 | POWER FINANCE CORPORATION LTD               9.39%  29/06/2022 (D) | INE134E08EU6 | SBI DYNAMIC BOND FUND | 29-JUN-2022 | 3652 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 250 | 250000000 | 1000000 | 0.00 | MARKET TRADE
4 | CANARA BANK CD MAT 27.09.2012 | INE476A16HS9 | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 27-SEP-2012 | 90 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 2000 | 195587200 | 97793.6 | 9.1501 | MARKET TRADE
5 | ANDHRA BANK CD MAT. 26.06.2013 | INE434A16CJ8 | SBI DYNAMIC BOND FUND | 26-JUN-2013 | 362 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 2500 | 228183750 | 91273.5 | 9.6401 | MARKET TRADE
6 | ANDHRA BANK CD MAT. 26.06.2013 | INE434A16CJ8 | SBI DYNAMIC BOND FUND | 26-JUN-2013 | 362 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 2500 | 228183750 | 91273.5 | 9.6401 | MARKET TRADE
7 | PUNJAB NATIONAL BANK CD MAT. 17.09.2012 | INE160A16GF8 | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 17-SEP-2012 | 80 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 2000 | 196046800 | 98023.4 | 9.2001 | MARKET TRADE
8 | CANARA BANK CD MAT 17.09.2012 | INE476A16IF4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 17-SEP-2012 | 80 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 12500 | 1225292500 | 98023.4 | 9.2001 | MARKET TRADE
9 | VIJAYA BANK CD MAT 28.09.12 | INE705A16FG0 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 28-SEP-2012 | 91 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 10000 | 977708000 | 97770.8 | 9.1452 | MARKET TRADE
10 | VIJAYA BANK CD MAT 28.09.12 | INE705A16FG0 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 28-SEP-2012 | 91 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 20000 | 1955416000 | 97770.8 | 9.1452 | MARKET TRADE
11 | PUNJAB NATIONAL BANK CD MAT. 17.09.2012 | INE160A16GF8 | SBI DEBT FUND SERIES - 90 DAYS - 67 (26.06.2012) | 17-SEP-2012 | 80 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 500 | 49011700 | 98023.4 | 9.2001 | MARKET TRADE
12 | ANDHRA BANK CD MAT. 01.03.2013 | INE434A16BG6 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 01-MAR-2013 | 245 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 2500 | 235080500 | 94032.2 | 9.4551 | MARKET TRADE
13 | ANDHRA BANK CD MAT. 28.03.2013 | INE434A16BP7 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 28-MAR-2013 | 272 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 2500 | 233544750 | 93417.9 | 9.4549 | MARKET TRADE
14 | ANDHRA BANK CD MAT. 14.03.2013 | INE434A16BH4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 14-MAR-2013 | 258 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 4960 | 464927584 | 93735.4 | 9.455 | MARKET TRADE
15 | PUNJAB NATIONAL BANK CD MAT. 05.03.2013 | INE160A16HM2 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 05-MAR-2013 | 249 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 7500 | 704668500 | 93955.8 | 9.4299 | MARKET TRADE
16 | CANARA BANK CD MAT 27.09.2012 | INE476A16HS9 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 27-SEP-2012 | 90 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 10000 | 977936000 | 97793.6 | 9.1501 | MARKET TRADE
17 | CANARA BANK CD MAT 27.09.2012 | INE476A16HS9 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 27-SEP-2012 | 90 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 10000 | 977936000 | 97793.6 | 9.1501 | MARKET TRADE
18 | CANARA BANK CD MAT 27.09.2012 | INE476A16HS9 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 27-SEP-2012 | 90 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 27500 | 2689324000 | 97793.6 | 9.1501 | MARKET TRADE
19 | CANARA BANK CD MAT 05.03.2013 | INE476A16GM4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 05-MAR-2013 | 249 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 2500 | 234889500 | 93955.8 | 9.4299 | MARKET TRADE
20 | CANARA BANK CD MAT 17.09.2012 | INE476A16IF4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 17-SEP-2012 | 80 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 2500 | 245164000 | 98065.6 | 8.9998 | MARKET TRADE
21 | CANARA BANK CD MAT 17.09.2012 | INE476A16IF4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 17-SEP-2012 | 80 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 2500 | 245164000 | 98065.6 | 8.9998 | MARKET TRADE
22 | NATIONAL HOUSING BANK CP MAT.27.09.2012 | INE557F14AU1 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 27-SEP-2012 | 90 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 2000 | 977818000 | 488909 | 9.2001 | MARKET TRADE
23 | INDOSTAR CAPITAL FINANCE PVT. LTD CP MAT.12.09.2012 | INE896L14047 | MAGNUM INSTACASH FUND | 12-SEP-2012 | 75 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 500 | 244744750 | 489489.5 | 10.4499 | MARKET TRADE
24 | PUNJAB NATIONAL BANK CD MAT. 17.09.2012 | INE160A16GF8 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 17-SEP-2012 | 80 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 3000 | 294070200 | 98023.4 | 9.2001 | MARKET TRADE
25 | PUNJAB NATIONAL BANK CD MAT. 17.09.2012 | INE160A16GF8 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 17-SEP-2012 | 80 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 7000 | 686163800 | 98023.4 | 9.2001 | MARKET TRADE
26 | INDIAN OVERSEAS BANK CD MAT 24.09.2012 | INE565A16640 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 24-SEP-2012 | 87 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 10000 | 978964573.0368 | 97896.46 | 9.0148 | INTERSCHEME
27 | INDIAN OVERSEAS BANK CD MAT 24.09.2012 | INE565A16640 | MAGNUM INSTACASH FUND | 24-SEP-2012 | 87 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 10000 | 978964573.0368 | 97896.46 | 9.0148 | INTERSCHEME
28 | BANK OF INDIA CD MAT. DT. 07.09.2012 | INE084A16725 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 07-SEP-2012 | 70 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 5000 | 491516500 | 98303.3 | 8.9998 | MARKET TRADE
29 | ANDHRA BANK CD MAT. 14.03.2013 | INE434A16BH4 | MAGNUM INCOME FUND-FLOATIG RT-LTP | 14-MAR-2013 | 258 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 40 | 3749416 | 93735.4 | 9.455 | MARKET TRADE
30 | CANARA BANK CD MAT 27.09.2012 | INE476A16HS9 | MICF-LIQUID FLOATER PLAN | 27-SEP-2012 | 90 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 500 | 48896800 | 97793.6 | 9.1501 | MARKET TRADE
31 | NATIONAL HOUSING BANK CP MAT.27.09.2012 | INE557F14AU1 | MICF-LIQUID FLOATER PLAN | 27-SEP-2012 | 90 | T+0 | 29-JUN-2012 | 29-JUN-2012 | 29-JUN-2012 | 500 | 244454500 | 488909 | 9.2001 | 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.