Spreadsheet: 2434d2b4-66b6-4a5a-9a4c-de43a47a3759
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: 16/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 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2743 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 50065000 | 100.13 | 8.1665 | MARKET TRADE
2 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2743 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 50065000 | 100.13 | 8.1665 | MARKET TRADE
3 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2743 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 50075000 | 100.15 | 8.1629 | MARKET TRADE
4 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2743 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 50075000 | 100.15 | 8.1629 | MARKET TRADE
5 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2743 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 50075000 | 100.15 | 8.1629 | MARKET TRADE
6 | INDIAN OVERSEAS BANK CD MAT 21.03.2013 | INE565A16616 | SBI DYNAMIC BOND FUND | 21-MAR-2013 | 251 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 2000 | 188161400 | 94080.7 | 9.26 | MARKET TRADE
7 | INDIAN OVERSEAS BANK CD MAT 21.03.2013 | INE565A16616 | MAGNUM INCOME FUND - 1998 | 21-MAR-2013 | 251 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500 | 47040350 | 94080.7 | 9.26 | MARKET TRADE
8 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4507 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 53115000 | 106.23 | 8.3292 | MARKET TRADE
9 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4507 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 53115000 | 106.23 | 8.3292 | MARKET TRADE
10 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4507 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 106230000 | 106.23 | 8.3292 | MARKET TRADE
11 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM BALANCED FUND - 1995 | 14-NOV-2024 | 4507 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 106230000 | 106.23 | 8.3292 | MARKET TRADE
12 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4507 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 3000000 | 318690000 | 106.23 | 8.3292 | MARKET TRADE
13 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4507 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 53115000 | 106.23 | 8.3292 | MARKET TRADE
14 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM INCOME FUND - 1998 | 14-NOV-2024 | 4507 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 53125000 | 106.25 | 8.3267 | MARKET TRADE
15 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM MONTHLY INCOME PLAN | 14-NOV-2024 | 4507 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 106230000 | 106.23 | 8.3292 | MARKET TRADE
16 | GOI 8.15%  11/06/2022 | IN0020120013 | MAGNUM INCOME FUND - 1998 | 11-JUN-2022 | 3620 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 50110000 | 100.22 | 8.1154 | MARKET TRADE
17 | GOI 8.15%  11/06/2022 | IN0020120013 | MAGNUM GILT FUND-LONG TERM | 11-JUN-2022 | 3620 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 50110000 | 100.22 | 8.1154 | MARKET TRADE
18 | GOI 8.15%  11/06/2022 | IN0020120013 | SBI DYNAMIC BOND FUND | 11-JUN-2022 | 3620 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 50110000 | 100.22 | 8.1154 | MARKET TRADE
19 | GOI 8.15%  11/06/2022 | IN0020120013 | SBI DYNAMIC BOND FUND | 11-JUN-2022 | 3620 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 100220000 | 100.22 | 8.1154 | MARKET TRADE
20 | GOI 8.15%  11/06/2022 | IN0020120013 | SBI DYNAMIC BOND FUND | 11-JUN-2022 | 3620 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 2500000 | 250550000 | 100.22 | 8.1154 | MARKET TRADE
21 | GOI 8.97%  05/12/2030 | IN0020110055 | MAGNUM GILT FUND-LONG TERM | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 104300000 | 104.3 | 8.5017 | MARKET TRADE
22 | GOI 8.97%  05/12/2030 | IN0020110055 | MAGNUM GILT FUND-LONG TERM | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 104400000 | 104.4 | 8.4912 | MARKET TRADE
23 | GOI 8.97%  05/12/2030 | IN0020110055 | MAGNUM GILT FUND-LONG TERM | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 52200000 | 104.4 | 8.4912 | MARKET TRADE
24 | GOI 8.97%  05/12/2030 | IN0020110055 | MAGNUM GILT FUND-LONG TERM | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 104400000 | 104.4 | 8.4912 | MARKET TRADE
25 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 2000000 | 208600000 | 104.3 | 8.5017 | MARKET TRADE
26 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 52170000 | 104.34 | 8.4975 | MARKET TRADE
27 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 52170000 | 104.34 | 8.4975 | MARKET TRADE
28 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1500000 | 156510000 | 104.34 | 8.4975 | MARKET TRADE
29 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 104350000 | 104.35 | 8.4965 | MARKET TRADE
30 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 104300000 | 104.3 | 8.5017 | MARKET TRADE
31 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 104300000 | 104.3 | 8.5017 | MARKET TRADE
32 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 104300000 | 104.3 | 8.5017 | MARKET TRADE
33 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 104300000 | 104.3 | 8.5017 | MARKET TRADE
34 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 104300000 | 104.3 | 8.5017 | MARKET TRADE
35 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 104300000 | 104.3 | 8.5017 | MARKET TRADE
36 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 52175000 | 104.35 | 8.4965 | MARKET TRADE
37 | GOI 8.97%  05/12/2030 | IN0020110055 | SBI DYNAMIC BOND FUND | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 52175000 | 104.35 | 8.4965 | MARKET TRADE
38 | GOI 8.97%  05/12/2030 | IN0020110055 | MAGNUM MONTHLY INCOME PLAN | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 104350000 | 104.35 | 8.4965 | MARKET TRADE
39 | GOI 8.97%  05/12/2030 | IN0020110055 | MAGNUM MONTHLY INCOME PLAN | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 52210000 | 104.42 | 8.4891 | MARKET TRADE
40 | GOI 8.97%  05/12/2030 | IN0020110055 | MAGNUM INCOME FUND - 1998 | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 52150000 | 104.3 | 8.5017 | MARKET TRADE
41 | GOI 8.97%  05/12/2030 | IN0020110055 | MAGNUM BALANCED FUND - 1995 | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 1000000 | 104390000 | 104.39 | 8.4923 | MARKET TRADE
42 | GOI 8.97%  05/12/2030 | IN0020110055 | MAGNUM BALANCED FUND - 1995 | 05-DEC-2030 | 6719 | T+1 | 13-JUL-2012 | 13-JUL-2012 | 16-JUL-2012 | 500000 | 52210000 | 104.42 | 8.4891 | MARKET TRADE
43 | UCO BANK CD MAT 24.09.2012 | INE691A16GJ4 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 70 | T+0 | 16-JUL-2012 | 16-JUL-2012 | 16-JUL-2012 | 2500 | 245911250 | 98364.5 | 8.6698 | MARKET TRADE
44 | UCO BANK CD MAT 24.09.2012 | INE691A16GJ4 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 70 | T+0 | 16-JUL-2012 | 16-JUL-2012 | 16-JUL-2012 | 2500 | 245911250 | 98364.5 | 8.6698 | MARKET TRADE
45 | UCO BANK CD MAT 24.09.2012 | INE691A16GJ4 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 70 | T+0 | 16-JUL-2012 | 16-JUL-2012 | 16-JUL-2012 | 2500 | 245911250 | 98364.5 | 8.6698 | MARKET TRADE
46 | INDIAN OVERSEAS BANK CD MAT 21.03.2013 | INE565A16616 | SBI DYNAMIC BOND FUND | 21-MAR-2013 | 248 | T+0 | 16-JUL-2012 | 16-JUL-2012 | 16-JUL-2012 | 2500 | 235262000 | 94104.8 | 9.2199 | MARKET TRADE
47 | INDIAN OVERSEAS BANK CD MAT 21.03.2013 | INE565A16616 | SBI DYNAMIC BOND FUND | 21-MAR-2013 | 248 | T+0 | 16-JUL-2012 | 16-JUL-2012 | 16-JUL-2012 | 5000 | 470524000 | 94104.8 | 9.2199 | MARKET TRADE
48 | ANDHRA BANK CD MAT. 26.06.2013 | INE434A16CJ8 | SBI DYNAMIC BOND FUND | 26-JUN-2013 | 345 | T+0 | 16-JUL-2012 | 16-JUL-2012 | 16-JUL-2012 | 2500 | 229759750 | 91903.9 | 9.32 | MARKET TRADE
49 | UCO BANK CD MAT 24.09.2012 | INE691A16GJ4 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 70 | T+0 | 16-JUL-2012 | 16-JUL-2012 | 16-JUL-2012 | 2500 | 245897250 | 98358.9 | 8.6999 | MARKET TRADE
50 | UCO BANK CD MAT 24.09.2012 | INE691A16GJ4 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 70 | T+0 | 16-JUL-2012 | 16-JUL-2012 | 16-JUL-2012 | 5000 | 491794500 | 98358.9 | 8.6999 | MARKET TRADE
51 | ICICI BANK LTD CD MAT 12.07.2013 | INE090A16VK6 | SBI DEBT FUND SERIES - 366 DAYS - 8 (12.07.2012) | 12-JUL-2013 | 361 | T+0 | 16-JUL-2012 | 16-JUL-2012 | 16-JUL-2012 | 3500 | 320141500 | 91469 | 9.43 | MARKET TRADE
52 | NATIONAL BANK FOR AGRI. & RURAL DEVT. 9.41% , 16/07/2015 | INE261F09HS9 | SBI SHORT HORI DEBT FUND-SHORTTERM | 16-JUL-2015 | 1095 | T+0 | 16-JUL-2012 | 16-JUL-2012 | 16-JUL-2012 | 150 | 150000000 | 1000000 | 9.41 | MARKET TRADE
53 | NATIONAL BANK FOR AGRI. & RURAL DEVT. 9.41% , 16/07/2015 | INE261F09HS9 | SBI DYNAMIC BOND FUND | 16-JUL-2015 | 1095 | T+0 | 16-JUL-2012 | 16-JUL-2012 | 16-JUL-2012 | 450 | 450000000 | 1000000 | 9.41 | MARKET TRADE
54 | SHRIRAM CITY UNION FINANCE LTD CP MAT 20.09.12 | INE722A14279 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 20-SEP-2012 | 66 | T+0 | 16-JUL-2012 | 16-JUL-2012 | 16-JUL-2012 | 1500 | 737334000 | 491556 | 9.5 | 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.