Spreadsheet: 59593a38-28ee-4c16-9186-ef0029ed751a
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:23/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 SHORT HORI DEBT FUND-SHORTTERM | 04-JUN-2015 | 1016 | T+1 | 22-AUG-2012 | 22-AUG-2012 | 23-AUG-2012 | 50 | 50378000 | 1007560 | 9.15 | MARKET TRADE
2 | RURAL ELECTRIFICATION CORPORATION  LTD 9.35% 15/06/2022 (D) | INE020B08740 | SBI MAGNUM BALANCED FUND | 15-JUN-2022 | 3584 | T+1 | 22-AUG-2012 | 22-AUG-2012 | 23-AUG-2012 | 50 | 50234550 | 1004691 | 9.2646 | MARKET TRADE
3 | LIC HOUSING FINANCE LTD. 9.90% 08/04/2015 | INE115A07CE3 | SBI SHORT HORI DEBT FUND-SHORTTERM | 08-APR-2015 | 959 | T+1 | 22-AUG-2012 | 22-AUG-2012 | 23-AUG-2012 | 150 | 150781950 | 1005213 | 9.62 | MARKET TRADE
4 | EXPORT-IMPORT BANK OF INDIA, 9.32% 06/07/2015 | INE514E08BC3 | SBI SHORT HORI DEBT FUND-SHORTTERM | 06-JUL-2015 | 1048 | T+1 | 22-AUG-2012 | 22-AUG-2012 | 23-AUG-2012 | 150 | 150806250 | 1005375 | 9.08 | MARKET TRADE
5 | HOUSING DEVELOPMENT FIN. COR LTD 9.60% 18/07/2015 | INE001A07IS2 | SBI SHORT HORI DEBT FUND-SHORTTERM | 18-JUL-2015 | 1060 | T+1 | 22-AUG-2012 | 22-AUG-2012 | 23-AUG-2012 | 150 | 150051750 | 1000345 | 9.57 | MARKET TRADE
6 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI MAGNUM INCOME FUND | 05-DEC-2030 | 6679 | T+1 | 22-AUG-2012 | 22-AUG-2012 | 23-AUG-2012 | 1000000 | 103750000 | 103.75 | 8.5581 | MARKET TRADE
7 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6679 | T+1 | 22-AUG-2012 | 22-AUG-2012 | 23-AUG-2012 | 500000 | 51875000 | 103.75 | 8.5581 | MARKET TRADE
8 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6679 | T+1 | 22-AUG-2012 | 22-AUG-2012 | 23-AUG-2012 | 1000000 | 103700000 | 103.7 | 8.5634 | MARKET TRADE
9 | GOI 8.33%  09/07/2026 | IN0020120039 | SBI DYNAMIC BOND FUND | 09-JUL-2026 | 5069 | T+1 | 22-AUG-2012 | 22-AUG-2012 | 23-AUG-2012 | 1500000 | 149325000 | 99.55 | 8.3834 | MARKET TRADE
10 | GOI 8.15%  11/06/2022 | IN0020120013 | SBI MAGNUM BALANCED FUND | 11-JUN-2022 | 3580 | T+1 | 22-AUG-2012 | 22-AUG-2012 | 23-AUG-2012 | 500000 | 49710000 | 99.42 | 8.2343 | MARKET TRADE
11 | GOI 8.33%  09/07/2026 | IN0020120039 | SBI MAGNUM INCOME FUND | 09-JUL-2026 | 5069 | T+1 | 22-AUG-2012 | 22-AUG-2012 | 23-AUG-2012 | 1000000 | 99550000 | 99.55 | 8.3834 | MARKET TRADE
12 | NATIONAL BANK FOR AGRI. & RURAL DEVT. 9.40% , 31/07/2015 | INE261F09HF6 | SBI DYNAMIC BOND FUND | 31-JUL-2015 | 1072 | T+0 | 23-AUG-2012 | 23-AUG-2012 | 23-AUG-2012 | 150 | 150931350 | 1006209 | 9.1449 | MARKET TRADE
13 | POWER FINANCE CORPORATION LTD 92-B 9.27%  21/08/2017 (D) | INE134E08EW2 | SBI MAGNUM INCOME FUND | 21-AUG-2017 | 1824 | T+0 | 23-AUG-2012 | 23-AUG-2012 | 23-AUG-2012 | 50 | 50000000 | 1000000 | 9.2692 | MARKET TRADE
14 | POWER FINANCE CORPORATION LTD 92-B 9.27%  21/08/2017 (D) | INE134E08EW2 | SBI DYNAMIC BOND FUND | 21-AUG-2017 | 1824 | T+0 | 23-AUG-2012 | 23-AUG-2012 | 23-AUG-2012 | 450 | 450000000 | 1000000 | 9.2692 | MARKET TRADE
15 | ERICSSON INDIA PVT LTD CP MAT 20.11.2012 | INE310I14441 | SBI PREMIER LIQUID FUND | 20-NOV-2012 | 89 | T+0 | 23-AUG-2012 | 23-AUG-2012 | 23-AUG-2012 | 1000 | 488540500 | 488540.5 | 9.6198 | MARKET TRADE
16 | MARICO LTD CP MAT 07.11.12 | INE196A14342 | SBI PREMIER LIQUID FUND | 07-NOV-2012 | 76 | T+0 | 23-AUG-2012 | 23-AUG-2012 | 23-AUG-2012 | 1500 | 736489500 | 490993 | 8.8102 | 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.