Spreadsheet: a15865d7-c2e3-463f-bb63-4249bb818b3f
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: 09/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
SR. NO. | NAME OF SECURITY | ISIN | SCHEME NAME | MATURITY DATE | RESIDUAL MATURITY | SETTLEMENT TYPE | TRADE DATE | VALUATION DATE | SETTLEMENT DATE | QUANTITY TRADED | VALUE OF THE TRADE | TRADED PRICE | TRADED YIELD | TYPE OF TRADE
1 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2750 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 3000000 | 299685000 | 99.9 | 8.2083 | MARKET TRADE
2 | GOI 8.33%  09/07/2026 | IN0020120039 | MAGNUM INCOME FUND - 1998 | 09-JUL-2026 | 5116 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 1300000 | 130000000 | 100 | 8.3299 | MARKET TRADE
3 | UNION BANK CD MAT. 17.09.2012 | INE692A16BG9 | SBI PREMIER LIQUID FUND | 17-SEP-2012 | 73 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 2500 | 245920500 | 98368.2 | 8.6498 | MARKET TRADE
4 | GOI 8.33%  09/07/2026 | IN0020120039 | MAGNUM GILT FUND-LONG TERM | 09-JUL-2026 | 5116 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 2617600 | 261760000 | 100 | 8.3299 | MARKET TRADE
5 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2750 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 1000000 | 99950000 | 99.95 | 8.1983 | MARKET TRADE
6 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2750 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 1000000 | 99950000 | 99.95 | 8.1983 | MARKET TRADE
7 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM GILT FUND-LONG TERM | 16-JAN-2020 | 2750 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 2500000 | 249850000 | 99.94 | 8.2001 | MARKET TRADE
8 | GOI 8.33%  09/07/2026 | IN0020120039 | MAGNUM GILT FUND-LONG TERM | 09-JUL-2026 | 5116 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 500000 | 50100000 | 100.2 | 8.3055 | MARKET TRADE
9 | GOI 8.33%  09/07/2026 | IN0020120039 | MAGNUM GILT FUND-LONG TERM | 09-JUL-2026 | 5116 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 500000 | 50100000 | 100.2 | 8.3055 | MARKET TRADE
10 | GOI 8.33%  09/07/2026 | IN0020120039 | MAGNUM GILT FUND-LONG TERM | 09-JUL-2026 | 5116 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 1000000 | 100200000 | 100.2 | 8.3055 | MARKET TRADE
11 | GOI 8.33%  09/07/2026 | IN0020120039 | MAGNUM GILT FUND-LONG TERM | 09-JUL-2026 | 5116 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 500000 | 50100000 | 100.2 | 8.3055 | MARKET TRADE
12 | GOI 8.33%  09/07/2026 | IN0020120039 | MAGNUM INCOME FUND - 1998 | 09-JUL-2026 | 5116 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 800000 | 80252000 | 100.32 | 8.2914 | MARKET TRADE
13 | GOI 8.33%  09/07/2026 | IN0020120039 | MAGNUM GILT FUND-LONG TERM | 09-JUL-2026 | 5116 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 1000000 | 100290000 | 100.29 | 8.2945 | MARKET TRADE
14 | GOI 8.33%  09/07/2026 | IN0020120039 | MAGNUM GILT FUND-LONG TERM | 09-JUL-2026 | 5116 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 1000000 | 100300000 | 100.3 | 8.2933 | MARKET TRADE
15 | GOI 8.33%  09/07/2026 | IN0020120039 | MAGNUM GILT FUND-LONG TERM | 09-JUL-2026 | 5116 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 500000 | 50150000 | 100.3 | 8.2933 | MARKET TRADE
16 | GOI 8.33%  09/07/2026 | IN0020120039 | MAGNUM GILT FUND-LONG TERM | 09-JUL-2026 | 5116 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 500000 | 50175000 | 100.35 | 8.2872 | MARKET TRADE
17 | GOI 8.33%  09/07/2026 | IN0020120039 | MAGNUM GILT FUND-LONG TERM | 09-JUL-2026 | 5116 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 700000 | 70220500 | 100.32 | 8.2914 | MARKET TRADE
18 | UCO BANK CD MAT 06.12.2012 | INE691A16GE5 | SBI CAPITAL PROTN ORNTD FUND SERS-1 | 06-DEC-2012 | 153 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 700 | 67476570 | 96395.1 | 9.1 | MARKET TRADE
19 | UCO BANK CD MAT 06.12.2012 | INE691A16GE5 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 06-DEC-2012 | 153 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 1100 | 106034610 | 96395.1 | 9.1 | MARKET TRADE
20 | UNION BANK CD MAT. 31.05.2013 | INE692A16BE4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 31-MAY-2013 | 329 | T+1 | 06-JUL-2012 | 06-JUL-2012 | 09-JUL-2012 | 7500 | 692166750 | 92288.9 | 9.355 | MARKET TRADE
21 | KOTAK MAHINDRA PRIME LTD 0% 09.07.12 | INE916D072F0 | SBI DEBT FUND SERIES - 18 MONTHS - 5 (10/01/2011) | 09-JUL-2012 | 0 | T+0 | 09-JUL-2012 | 09-JUL-2012 | 09-JUL-2012 | 110 | 110000000 | 1000000 | 0 | MARKET TRADE
22 | SUNDARAM BNP PARIBAS HOME FINANCE  LTD., 0% 09.07.2012 | INE667F07287 | SBI DEBT FUND SERIES - 18 MONTHS - 5 (10/01/2011) | 09-JUL-2012 | 0 | T+0 | 09-JUL-2012 | 09-JUL-2012 | 09-JUL-2012 | 57 | 57000000 | 1000000 | 0 | MARKET TRADE
23 | SYNDICATE BANK CD MAT 06.09.12 | INE667A16AM1 | MAGNUM INSTACASH FUND | 06-SEP-2012 | 59 | T+0 | 09-JUL-2012 | 09-JUL-2012 | 09-JUL-2012 | 500 | 49314450 | 98628.9 | 8.6001 | MARKET TRADE
24 | CANARA BANK CD MAT 01.03.2013 | INE476A16GJ0 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 01-MAR-2013 | 235 | T+0 | 09-JUL-2012 | 09-JUL-2012 | 09-JUL-2012 | 2500 | 235991250 | 94396.5 | 9.2199 | MARKET TRADE
25 | CANARA BANK CD MAT 12.03.2013 | INE476A16GO0 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 12-MAR-2013 | 246 | T+0 | 09-JUL-2012 | 09-JUL-2012 | 09-JUL-2012 | 2500 | 235373750 | 94149.5 | 9.22 | MARKET TRADE
26 | CANARA BANK CD MAT 14.03.2013 | INE476A16GT9 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 14-MAR-2013 | 248 | T+0 | 09-JUL-2012 | 09-JUL-2012 | 09-JUL-2012 | 2500 | 235262000 | 94104.8 | 9.2199 | MARKET TRADE
27 | CANARA BANK CD MAT 26.03.2013 | INE476A16HF6 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 26-MAR-2013 | 260 | T+0 | 09-JUL-2012 | 09-JUL-2012 | 09-JUL-2012 | 2500 | 234592750 | 93837.1 | 9.22 | MARKET TRADE
28 | CANARA BANK CD MAT 27.03.2013 | INE476A16HL4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 27-MAR-2013 | 261 | T+0 | 09-JUL-2012 | 09-JUL-2012 | 09-JUL-2012 | 2500 | 234537250 | 93814.9 | 9.2199 | MARKET TRADE
29 | CANARA BANK CD MAT 26.12.2012 | INE476A16FS3 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 26-DEC-2012 | 170 | T+0 | 09-JUL-2012 | 09-JUL-2012 | 09-JUL-2012 | 2500 | 239781250 | 95912.5 | 9.1501 | MARKET TRADE
30 | SYNDICATE BANK CD MAT 28.03.13 | INE667A16AH1 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 28-MAR-2013 | 262 | T+0 | 09-JUL-2012 | 09-JUL-2012 | 09-JUL-2012 | 2500 | 234434250 | 93773.7 | 9.25 | MARKET TRADE
31 | CANARA BANK CD MAT 27.09.2012 | INE476A16HS9 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 27-SEP-2012 | 80 | T+0 | 09-JUL-2012 | 09-JUL-2012 | 09-JUL-2012 | 10000 | 981331000 | 98133.1 | 8.6798 | MARKET TRADE
32 | CANARA BANK CD MAT 27.09.2012 | INE476A16HS9 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 27-SEP-2012 | 80 | T+0 | 09-JUL-2012 | 09-JUL-2012 | 09-JUL-2012 | 10000 | 981331000 | 98133.1 | 8.6798 | MARKET TRADE
33 | SUNDARAM FINANCE LTD CP MAT 25.03.2013 | INE660A14GQ9 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 25-MAR-2013 | 259 | T+0 | 09-JUL-2012 | 09-JUL-2012 | 09-JUL-2012 | 500 | 233978250 | 467956.5 | 9.65 | 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.