Spreadsheet: b5eb519e-b436-4e06-acf5-5b265404734a
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: 06/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 | SYNDICATE BANK CD MAT 21.01.13 | INE667A16941 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 21-JAN-2013 | 200 | T+1 | 05-JUL-2012 | 05-JUL-2012 | 06-JUL-2012 | 1000 | 95199000 | 95199 | 9.2499 | MARKET TRADE
2 | SYNDICATE BANK CD MAT 21.01.13 | INE667A16941 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 21-JAN-2013 | 200 | T+1 | 05-JUL-2012 | 05-JUL-2012 | 06-JUL-2012 | 1500 | 142798500 | 95199 | 9.2499 | MARKET TRADE
3 | SUNDARAM FINANCE LTD, 8.10% 25/06/13 | INE660A07EO3 | MAGNUM INCOME FUND - 1998 | 25-JUN-2013 | 355 | T+1 | 05-JUL-2012 | 05-JUL-2012 | 06-JUL-2012 | 45 | 44281485 | 984033 | 9.8987 | MARKET TRADE
4 | SUNDARAM FINANCE LTD, 8.10% 25/06/13 | INE660A07EO3 | MAGNUM BALANCED FUND - 1995 | 25-JUN-2013 | 355 | T+1 | 05-JUL-2012 | 05-JUL-2012 | 06-JUL-2012 | 5 | 4920165 | 984033 | 9.8987 | MARKET TRADE
5 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2751 | T+1 | 05-JUL-2012 | 05-JUL-2012 | 06-JUL-2012 | 1000000 | 99900000 | 99.9 | 8.2071 | MARKET TRADE
6 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2751 | T+1 | 05-JUL-2012 | 05-JUL-2012 | 06-JUL-2012 | 500000 | 49950000 | 99.9 | 8.2071 | MARKET TRADE
7 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2751 | T+1 | 05-JUL-2012 | 05-JUL-2012 | 06-JUL-2012 | 1000000 | 99900000 | 99.9 | 8.2071 | MARKET TRADE
8 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2751 | T+1 | 05-JUL-2012 | 05-JUL-2012 | 06-JUL-2012 | 2500000 | 249675000 | 99.87 | 8.2125 | MARKET TRADE
9 | PUNJAB NATIONAL BANK CD MAT. 23.08.2012 | INE160A16FY1 | SBI PREMIER LIQUID FUND | 23-AUG-2012 | 48 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 2500 | 247191250 | 98876.5 | 8.6404 | MARKET TRADE
10 | PUNJAB NATIONAL BANK CD MAT. 01.03.2013 | INE160A16HG4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 01-MAR-2013 | 238 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 5000 | 471674000 | 94334.8 | 9.21 | MARKET TRADE
11 | PUNJAB NATIONAL BANK CD MAT. 01.03.2013 | INE160A16HG4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 01-MAR-2013 | 238 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 2500 | 235822500 | 94329 | 9.22 | MARKET TRADE
12 | PUNJAB NATIONAL BANK CD MAT. 01.03.2013 | INE160A16HG4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 01-MAR-2013 | 238 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 2500 | 235822500 | 94329 | 9.22 | MARKET TRADE
13 | SYNDICATE BANK CD MAT 06.09.12 | INE667A16AM1 | MAGNUM INSTACASH FUND | 06-SEP-2012 | 62 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 2000 | 197120400 | 98560.2 | 8.6001 | MARKET TRADE
14 | UCO BANK CD MAT 21.09.2012 | INE691A16GI6 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 21-SEP-2012 | 77 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 5000 | 490689000 | 98137.8 | 8.9948 | MARKET TRADE
15 | UCO BANK CD MAT 21.09.2012 | INE691A16GI6 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 21-SEP-2012 | 77 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 5000 | 490689000 | 98137.8 | 8.9948 | MARKET TRADE
16 | UCO BANK CD MAT 21.09.2012 | INE691A16GI6 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 21-SEP-2012 | 77 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 5000 | 490689000 | 98137.8 | 8.9948 | MARKET TRADE
17 | UCO BANK CD MAT 21.09.2012 | INE691A16GI6 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 21-SEP-2012 | 77 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 5000 | 490689000 | 98137.8 | 8.9948 | MARKET TRADE
18 | UCO BANK CD MAT 21.09.2012 | INE691A16GI6 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 21-SEP-2012 | 77 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 5000 | 490689000 | 98137.8 | 8.9948 | MARKET TRADE
19 | UCO BANK CD MAT 21.09.2012 | INE691A16GI6 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 21-SEP-2012 | 77 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 5000 | 490689000 | 98137.8 | 8.9948 | MARKET TRADE
20 | HDFC BANK CD MAT  02.07.2013 | INE040A16859 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 02-JUL-2013 | 361 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 5000 | 457500000 | 91500 | 9.3925 | MARKET TRADE
21 | TUBE INVESTMENT OF INDIA LIMITED MAT.28.09.12 | INE149A14473 | SBI PREMIER LIQUID FUND | 28-SEP-2012 | 84 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 1000 | 489666500 | 489666.5 | 9.1698 | MARKET TRADE
22 | INDIAN OIL [NAME] MAT 14.08.2012 | INE242A14CH4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 14-AUG-2012 | 39 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 3000 | 1486059000 | 495353 | 8.7798 | MARKET TRADE
23 | INDIAN OIL [NAME] MAT 14.08.2012 | INE242A14CH4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 14-AUG-2012 | 39 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 2500 | 1238382500 | 495353 | 8.7798 | MARKET TRADE
24 | YES BANK CD MAT 21.09.2012 | INE528G16ML9 | SBI DEBT FUND SERIES - 18 MONTHS - 8 (21.10.2011) | 21-SEP-2012 | 77 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 100 | 9808455.61 | 98084.56 | 9.257 | INTERSCHEME
25 | YES BANK CD MAT 21.09.2012 | INE528G16ML9 | SBI DEBT FUND SERIES - 367 DAYS - 6 (21.09.11) | 21-SEP-2012 | 77 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 100 | 9808455.61 | 98084.56 | 9.257 | INTERSCHEME
26 | HINDUSTAN PETROLEUM CORPORATION LIMITED CP MAT. 28.08.2012 | INE094A14893 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 28-AUG-2012 | 53 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 2000 | 987454000 | 493727 | 8.7499 | MARKET TRADE
27 | GODREJ AGROVET LTD. CP MAT 21.08.12 | INE850D14561 | SBI PREMIER LIQUID FUND | 21-AUG-2012 | 46 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 1000 | 494349000 | 494349 | 9.0704 | MARKET TRADE
28 | STCI FINANCE LTD. CP. MAT. 22.08.2012 | INE020E14AB3 | SBI PREMIER LIQUID FUND | 22-AUG-2012 | 47 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 2000 | 988544000 | 494272 | 8.9998 | MARKET TRADE
29 | L & T FINANCE LIMITED CP MAT. DT. 26.09.2012 | INE523E14GT5 | SBI PREMIER LIQUID FUND | 26-SEP-2012 | 82 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 2000 | 979858000 | 489929 | 9.1499 | MARKET TRADE
30 | ICICI SECURITIES PRIMARY DEALERSHIP LTD CP MAT 24.09.2012 | INE849D14CX7 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 24-SEP-2012 | 80 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 500 | 245058500 | 490117 | 9.2001 | MARKET TRADE
31 | ICICI SECURITIES PRIMARY DEALERSHIP LTD CP MAT 24.09.2012 | INE849D14CX7 | MAGNUM INSTACASH FUND | 24-SEP-2012 | 80 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 500 | 245058500 | 490117 | 9.2001 | MARKET TRADE
32 | TUBE INVESTMENT OF INDIA LIMITED MAT.31.08.12 | INE149A14481 | SBI PREMIER LIQUID FUND | 31-AUG-2012 | 56 | T+0 | 06-JUL-2012 | 06-JUL-2012 | 06-JUL-2012 | 500 | 246505500 | 493011 | 9.2398 | 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.