Spreadsheet: 4b0e1357-acdd-4923-a3b8-4161cbb19c40
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:28/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 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4523 | T+1 | 27-JUN-2012 | 27-JUN-2012 | 28-JUN-2012 | 1500000 | 158505000 | 105.67 | 8.4021 | MARKET TRADE
2 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4523 | T+1 | 27-JUN-2012 | 27-JUN-2012 | 28-JUN-2012 | 1000000 | 105700000 | 105.7 | 8.3983 | MARKET TRADE
3 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4523 | T+1 | 27-JUN-2012 | 27-JUN-2012 | 28-JUN-2012 | 500000 | 52815000 | 105.63 | 8.4072 | MARKET TRADE
4 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4523 | T+1 | 27-JUN-2012 | 27-JUN-2012 | 28-JUN-2012 | 500000 | 52815000 | 105.63 | 8.4072 | MARKET TRADE
5 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4523 | T+1 | 27-JUN-2012 | 27-JUN-2012 | 28-JUN-2012 | 500000 | 52815000 | 105.63 | 8.4072 | MARKET TRADE
6 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4523 | T+1 | 27-JUN-2012 | 27-JUN-2012 | 28-JUN-2012 | 1000000 | 105650000 | 105.65 | 8.4047 | MARKET TRADE
7 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2759 | T+1 | 27-JUN-2012 | 27-JUN-2012 | 28-JUN-2012 | 500000 | 50055000 | 100.11 | 8.1689 | MARKET TRADE
8 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2759 | T+1 | 27-JUN-2012 | 27-JUN-2012 | 28-JUN-2012 | 1000000 | 100110000 | 100.11 | 8.1689 | MARKET TRADE
9 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2759 | T+1 | 27-JUN-2012 | 27-JUN-2012 | 28-JUN-2012 | 500000 | 50055000 | 100.11 | 8.1689 | MARKET TRADE
10 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2759 | T+1 | 27-JUN-2012 | 27-JUN-2012 | 28-JUN-2012 | 500000 | 50055000 | 100.11 | 8.1689 | MARKET TRADE
11 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2759 | T+1 | 27-JUN-2012 | 27-JUN-2012 | 28-JUN-2012 | 1000000 | 100100000 | 100.1 | 8.1707 | MARKET TRADE
12 | INDIAN OVERSEAS BANK CD MAT 21.03.2013 | INE565A16616 | SBI DEBT FUND SERIES - 18 MONTHS - 9 (28.12.11) | 21-MAR-2013 | 266 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 100 | 9355592.19 | 93555.92 | 9.4515 | INTERSCHEME
13 | INDIAN OVERSEAS BANK CD MAT 21.03.2013 | INE565A16616 | SBI DEBT FUND SERIES - 367 DAYS - 17 (21.03.12) | 21-MAR-2013 | 266 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 100 | 9355592.19 | 93555.92 | 9.4515 | INTERSCHEME
14 | E.I.D.PARRY INDIA LTD 8.65% 04/09/2012 | INE126A07160 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 04-SEP-2012 | 68 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 170 | 169712700 | 998310 | 9.9993 | MARKET TRADE
15 | E.I.D.PARRY INDIA LTD 8.65% 04/09/2012 | INE126A07160 | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 04-SEP-2012 | 68 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 180 | 179695800 | 998310 | 9.9993 | MARKET TRADE
16 | ANDHRA BANK CD MAT. 27.06.2013 | INE434A16CI0 | SBI DYNAMIC BOND FUND | 27-JUN-2013 | 364 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 5000 | 456148000 | 91229.6 | 9.64 | MARKET TRADE
17 | PUNJAB NATIONAL BANK CD MAT. 26.06.2013 | INE160A16HZ4 | SBI DYNAMIC BOND FUND | 26-JUN-2013 | 363 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 2500 | 228268750 | 91307.5 | 9.5725 | MARKET TRADE
18 | PUNJAB NATIONAL BANK CD MAT. 26.06.2013 | INE160A16HZ4 | SBI DYNAMIC BOND FUND | 26-JUN-2013 | 363 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 2500 | 228268750 | 91307.5 | 9.5725 | MARKET TRADE
19 | ANDHRA BANK CD MAT. 27.06.2013 | INE434A16CI0 | SBI SHORT HORI DEBT FUND-SHORTTERM | 27-JUN-2013 | 364 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 2500 | 228074000 | 91229.6 | 9.64 | MARKET TRADE
20 | ANDHRA BANK CD MAT. DT. 28.12.2012 | INE434A16AW5 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 28-DEC-2012 | 183 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 2500 | 238748000 | 95499.2 | 9.4001 | MARKET TRADE
21 | ANDHRA BANK CD MAT. DT. 28.12.2012 | INE434A16AW5 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 28-DEC-2012 | 183 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 7500 | 716244000 | 95499.2 | 9.4001 | MARKET TRADE
22 | BANK OF INDIA CD MAT. DT. 25.03.2013 | INE084A16774 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 25-MAR-2013 | 270 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 7500 | 700973250 | 93463.1 | 9.455 | MARKET TRADE
23 | BANK OF INDIA CD MAT. DT. 25.03.2013 | INE084A16774 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 25-MAR-2013 | 270 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 2500 | 233657750 | 93463.1 | 9.455 | MARKET TRADE
24 | ORIENTAL BANK OF COMMERCE CD MAT 13.03.2013 | INE141A16GV5 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 13-MAR-2013 | 258 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 2500 | 234338500 | 93735.4 | 9.455 | MARKET TRADE
25 | ORIENTAL BANK OF COMMERCE CD MAT 19.03.2013 | INE141A16GW3 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 19-MAR-2013 | 264 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 7500 | 701993250 | 93599.1 | 9.4549 | MARKET TRADE
26 | NATIONAL BANK FOR AGRI. & RURAL DEVT. 9.35% , 29/06/2015 | INE261F09HP5 | SBI DYNAMIC BOND FUND | 29-JUN-2015 | 1096 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 500 | 500000000 | 1000000 | 9.3503 | MARKET TRADE
27 | POWER GRID CORPORATION  OF INDIA LTD STRPP-A 9.30% 28/06/2016 (D) | INE752E07JP6 | SBI DYNAMIC BOND FUND | 28-JUN-2016 | 1461 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 40 | 50000000 | 1250000 | 9.2997 | MARKET TRADE
28 | POWER GRID CORPORATION  OF INDIA LTD STRPP-L 9.30% 28/06/2027 (D) | INE752E07KA6 | SBI DYNAMIC BOND FUND | 28-JUN-2027 | 5478 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 40 | 50000000 | 1250000 | 9.2998 | MARKET TRADE
29 | POWER GRID CORPORATION  OF INDIA LTD STRPP-K 9.30% 27/06/2026 (D) | INE752E07JZ5 | SBI DYNAMIC BOND FUND | 27-JUN-2026 | 5112 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 40 | 50000000 | 1250000 | 9.2998 | MARKET TRADE
30 | POWER GRID CORPORATION  OF INDIA LTD STRPP-J 9.30% 28/06/2025 (D) | INE752E07JY8 | SBI DYNAMIC BOND FUND | 28-JUN-2025 | 4748 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 40 | 50000000 | 1250000 | 9.2998 | MARKET TRADE
31 | POWER GRID CORPORATION  OF INDIA LTD STRPP-I 9.30% 28/06/2024 (D) | INE752E07JX0 | SBI DYNAMIC BOND FUND | 28-JUN-2024 | 4383 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 40 | 50000000 | 1250000 | 9.2997 | MARKET TRADE
32 | POWER GRID CORPORATION  OF INDIA LTD STRPP-H 9.30% 28/06/2023 (D) | INE752E07JW2 | SBI DYNAMIC BOND FUND | 28-JUN-2023 | 4017 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 40 | 50000000 | 1250000 | 9.2998 | MARKET TRADE
33 | POWER GRID CORPORATION  OF INDIA LTD STRPP-G 9.30% 28/06/2022 (D) | INE752E07JV4 | SBI DYNAMIC BOND FUND | 28-JUN-2022 | 3652 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 40 | 50000000 | 1250000 | 9.2998 | MARKET TRADE
34 | POWER GRID CORPORATION  OF INDIA LTD STRPP-F 9.30% 28/06/2021 (D) | INE752E07JU6 | SBI DYNAMIC BOND FUND | 28-JUN-2021 | 3287 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 40 | 50000000 | 1250000 | 9.2998 | MARKET TRADE
35 | POWER GRID CORPORATION  OF INDIA LTD STRPP-E 9.30% 27/06/2020 (D) | INE752E07JT8 | SBI DYNAMIC BOND FUND | 27-JUN-2020 | 2921 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 40 | 50000000 | 1250000 | 9.2999 | MARKET TRADE
36 | POWER GRID CORPORATION  OF INDIA LTD STRPP-D 9.30% 28/06/2019 (D) | INE752E07JS0 | SBI DYNAMIC BOND FUND | 28-JUN-2019 | 2556 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 40 | 50000000 | 1250000 | 9.2998 | MARKET TRADE
37 | POWER GRID CORPORATION  OF INDIA LTD STRPP-C 9.30% 28/06/2018 (D) | INE752E07JR2 | SBI DYNAMIC BOND FUND | 28-JUN-2018 | 2191 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 40 | 50000000 | 1250000 | 9.2998 | MARKET TRADE
38 | POWER GRID CORPORATION  OF INDIA LTD STRPP-B 9.30% 28/06/2017 (D) | INE752E07JQ4 | SBI DYNAMIC BOND FUND | 28-JUN-2017 | 1826 | T+0 | 28-JUN-2012 | 28-JUN-2012 | 28-JUN-2012 | 40 | 50000000 | 1250000 | 9.2998 | 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.