Spreadsheet: 247c7245-35c5-4e43-8dd7-ea91bc8b3c1e
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: [NAME]
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 | TATA SONS LTD  9.78%  23/07/2015 | INE895D08485 | SBI SHORT HORI DEBT FUND-SHORTTERM | 23-JUL-2015 | 1094 | T+1 | 24-JUL-2012 | 24-JUL-2012 | 25-JUL-2012 | 150 | 150408450 | 1002723 | 9.67 | MARKET TRADE
2 | GOI 8.33%  09/07/2026 | IN0020120039 | MAGNUM GILT FUND-LONG TERM | 09-JUL-2026 | 5098 | T+1 | 24-JUL-2012 | 24-JUL-2012 | 25-JUL-2012 | 417600 | 42202656 | 101.06 | 8.2002 | MARKET TRADE
3 | CORPORATION BANK CD MAT. 15.03.13 | INE112A16BD5 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 15-MAR-2013 | 234 | T+1 | 24-JUL-2012 | 24-JUL-2012 | 25-JUL-2012 | 10000 | 945384000 | 94538.4 | 9.05 | MARKET TRADE
4 | BANK OF INDIA CD MAT. DT. 15.03.2013 | INE084A16741 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 15-MAR-2013 | 234 | T+1 | 24-JUL-2012 | 24-JUL-2012 | 25-JUL-2012 | 10000 | 945384000 | 94538.4 | 9.05 | MARKET TRADE
5 | GOI 8.15%  11/06/2022 | IN0020120013 | MAGNUM GILT FUND - SHORT TERM | 11-JUN-2022 | 3609 | T+1 | 24-JUL-2012 | 24-JUL-2012 | 25-JUL-2012 | 400000 | 40216000 | 100.54 | 8.0674 | MARKET TRADE
6 | GOI 8.15%  11/06/2022 | IN0020120013 | MAGNUM GILT FUND-LONG TERM | 11-JUN-2022 | 3609 | T+1 | 24-JUL-2012 | 24-JUL-2012 | 25-JUL-2012 | 1500000 | 150810000 | 100.54 | 8.0674 | MARKET TRADE
7 | GOI 8.15%  11/06/2022 | IN0020120013 | MAGNUM GILT FUND-LONG TERM | 11-JUN-2022 | 3609 | T+1 | 24-JUL-2012 | 24-JUL-2012 | 25-JUL-2012 | 100000 | 10054000 | 100.54 | 8.0674 | MARKET TRADE
8 | GOI 8.15%  11/06/2022 | IN0020120013 | SBI DYNAMIC BOND FUND | 11-JUN-2022 | 3609 | T+1 | 24-JUL-2012 | 24-JUL-2012 | 25-JUL-2012 | 1000000 | 100540000 | 100.54 | 8.0674 | MARKET TRADE
9 | GOI 8.15%  11/06/2022 | IN0020120013 | SBI DYNAMIC BOND FUND | 11-JUN-2022 | 3609 | T+1 | 24-JUL-2012 | 24-JUL-2012 | 25-JUL-2012 | 1000000 | 100540000 | 100.54 | 8.0674 | MARKET TRADE
10 | GOI 8.15%  11/06/2022 | IN0020120013 | SBI DYNAMIC BOND FUND | 11-JUN-2022 | 3609 | T+1 | 24-JUL-2012 | 24-JUL-2012 | 25-JUL-2012 | 1000000 | 100540000 | 100.54 | 8.0674 | MARKET TRADE
11 | GOI 8.15%  11/06/2022 | IN0020120013 | SBI DYNAMIC BOND FUND | 11-JUN-2022 | 3609 | T+1 | 24-JUL-2012 | 24-JUL-2012 | 25-JUL-2012 | 1000000 | 100540000 | 100.54 | 8.0674 | MARKET TRADE
12 | GOI 8.15%  11/06/2022 | IN0020120013 | SBI DYNAMIC BOND FUND | 11-JUN-2022 | 3609 | T+1 | 24-JUL-2012 | 24-JUL-2012 | 25-JUL-2012 | 2500000 | 251350000 | 100.54 | 8.0674 | MARKET TRADE
13 | GOI 8.15%  11/06/2022 | IN0020120013 | SBI DYNAMIC BOND FUND | 11-JUN-2022 | 3609 | T+1 | 24-JUL-2012 | 24-JUL-2012 | 25-JUL-2012 | 1000000 | 100540000 | 100.54 | 8.0674 | MARKET TRADE
14 | GOI 8.15%  11/06/2022 | IN0020120013 | MAGNUM INCOME FUND - 1998 | 11-JUN-2022 | 3609 | T+1 | 24-JUL-2012 | 24-JUL-2012 | 25-JUL-2012 | 500000 | 50270000 | 100.54 | 8.0674 | MARKET TRADE
15 | BANK OF BARODA CD MAT. DT. 12.09.2012 | INE028A16433 | MICF-LIQUID FLOATER PLAN | 12-SEP-2012 | 49 | T+0 | 25-JUL-2012 | 25-JUL-2012 | 25-JUL-2012 | 2500 | 247182750 | 98873.1 | 8.4899 | MARKET TRADE
16 | INDIAN OVERSEAS BANK CD MAT 12.09.2012 | INE565A16632 | SBI PREMIER LIQUID FUND | 12-SEP-2012 | 49 | T+0 | 25-JUL-2012 | 25-JUL-2012 | 25-JUL-2012 | 2500 | 247182750 | 98873.1 | 8.4899 | MARKET TRADE
17 | ING VYSYA BANK CD MAT 24.07.2013 | INE166A16GA6 | SBI DEBT FUND SERIES - 366 DAYS - 10 (24.07.2012) | 24-JUL-2013 | 364 | T+0 | 25-JUL-2012 | 25-JUL-2012 | 25-JUL-2012 | 2000 | 183121400 | 91560.7 | 9.2425 | MARKET TRADE
18 | ING VYSYA BANK CD MAT 24.07.2013 | INE166A16GA6 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 24-JUL-2013 | 364 | T+0 | 25-JUL-2012 | 25-JUL-2012 | 25-JUL-2012 | 500 | 45780350 | 91560.7 | 9.2425 | MARKET TRADE
19 | FEDERAL BANK CD MAT 24.07.2013 | INE171A16DN6 | SBI DEBT FUND SERIES - 366 DAYS - 10 (24.07.2012) | 24-JUL-2013 | 364 | T+0 | 25-JUL-2012 | 25-JUL-2012 | 25-JUL-2012 | 2000 | 183150600 | 91575.3 | 9.225 | MARKET TRADE
20 | FEDERAL BANK CD MAT 24.07.2013 | INE171A16DN6 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 24-JUL-2013 | 364 | T+0 | 25-JUL-2012 | 25-JUL-2012 | 25-JUL-2012 | 500 | 45787650 | 91575.3 | 9.225 | MARKET TRADE
21 | ICICI BANK LTD CD MAT 24.07.2013 | INE090A16VP5 | MAGNUM INCOME FUND - 1998 | 24-JUL-2013 | 364 | T+0 | 25-JUL-2012 | 25-JUL-2012 | 25-JUL-2012 | 500 | 45789750 | 91579.5 | 9.22 | MARKET TRADE
22 | ICICI BANK LTD CD MAT 24.07.2013 | INE090A16VP5 | SBI DEBT FUND SERIES - 366 DAYS - 10 (24.07.2012) | 24-JUL-2013 | 364 | T+0 | 25-JUL-2012 | 25-JUL-2012 | 25-JUL-2012 | 2000 | 183159000 | 91579.5 | 9.22 | MARKET TRADE
23 | ICICI SECURITIES PRIMARY DEALERSHIP LTD CP MAT 06.08.2012 | INE849D14CW9 | SBI PREMIER LIQUID FUND | 06-AUG-2012 | 12 | T+0 | 25-JUL-2012 | 25-JUL-2012 | 25-JUL-2012 | 200 | 99714800 | 498574 | 8.6996 | MARKET TRADE
24 | AXIS BANK CD MAT. 24.07.2013 | INE238A16QQ8 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 24-JUL-2013 | 364 | T+0 | 25-JUL-2012 | 25-JUL-2012 | 25-JUL-2012 | 1000 | 91512600 | 91512.6 | 9.3 | MARKET TRADE
25 | AXIS BANK CD MAT. 24.07.2013 | INE238A16QQ8 | SBI DEBT FUND SERIES - 366 DAYS - 10 (24.07.2012) | 24-JUL-2013 | 364 | T+0 | 25-JUL-2012 | 25-JUL-2012 | 25-JUL-2012 | 1500 | 137268900 | 91512.6 | 9.3 | MARKET TRADE
26 | RURAL ELECTRIFICATION CORPORATION  LTD 9.40% 20/07/2017 (D) | INE020B08757 | SBI SHORT HORI DEBT FUND-SHORTTERM | 20-JUL-2017 | 1821 | T+0 | 25-JUL-2012 | 25-JUL-2012 | 25-JUL-2012 | 50 | 50225000 | 1004500 | 9.2816 | MARKET TRADE
27 | HOUSING DEVELOPMENT FIN. COR LTD 9.55% 25/07/2014 | INE001A07IX2 | SBI SHORT HORI DEBT FUND-SHORTTERM | 25-JUL-2014 | 730 | T+0 | 25-JUL-2012 | 25-JUL-2012 | 25-JUL-2012 | 250 | 250000000 | 1000000 | 9.55 | 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.