Spreadsheet: 9427265a-f5c1-49a1-aa18-b4996fbfc5a8
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: 11/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 | 91 DAY TBILL MAT 07.09.12 | IN002012X024 | MAGNUM TAX SAVING SCHEME - 1990 | 07-SEP-2012 | 91 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 950000 | 93158235 | 98.06 | 8.2002 | MARKET TRADE
2 | 91 DAY TBILL MAT 07.09.12 | IN002012X024 | MAGNUM GR INV FROM TAX SAVINGS SCHEME  1992 A | 07-SEP-2012 | 91 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 700000 | 68642910 | 98.06 | 8.2002 | MARKET TRADE
3 | 91 DAY TBILL MAT 07.09.12 | IN002012X024 | MAGNUM TRIPLE PLUS 1991 | 07-SEP-2012 | 91 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 650000 | 63739845 | 98.06 | 8.2002 | MARKET TRADE
4 | 91 DAY TBILL MAT 07.09.12 | IN002012X024 | MAGNUM GR IN FROM TAX SAVINGS SCHEME  1992 B | 07-SEP-2012 | 91 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 1650000 | 161801145 | 98.06 | 8.2002 | MARKET TRADE
5 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI SHORT HORI DEBT FUND-SHORTTERM | 14-NOV-2024 | 4542 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 1000000 | 106055000 | 106.06 | 8.3559 | MARKET TRADE
6 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4542 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 500000 | 53025000 | 106.05 | 8.3565 | MARKET TRADE
7 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND - SHORT TERM | 14-NOV-2024 | 4542 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 500000 | 53027500 | 106.06 | 8.3559 | MARKET TRADE
8 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4542 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 1000000 | 106050000 | 106.05 | 8.3565 | MARKET TRADE
9 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4542 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 1000000 | 106050000 | 106.05 | 8.3565 | MARKET TRADE
10 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4542 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 1000000 | 106070000 | 106.07 | 8.354 | MARKET TRADE
11 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4542 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 500000 | 53035000 | 106.07 | 8.354 | MARKET TRADE
12 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4542 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 3500000 | 371245000 | 106.07 | 8.354 | MARKET TRADE
13 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM INCOME FUND - 1998 | 14-NOV-2024 | 4542 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 1000000 | 106055000 | 106.06 | 8.3559 | MARKET TRADE
14 | 91 DAY TBILL MAT 07.09.12 | IN002012X024 | MAGNUM EQUITY LINKED SAVINGS SCHEME - 1991 | 07-SEP-2012 | 91 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 1000000 | 98061300 | 98.06 | 8.2002 | MARKET TRADE
15 | 91 DAY TBILL MAT 07.09.12 | IN002012X024 | MAGNUM MONTHLY INCOME SCHEME - 1989 | 07-SEP-2012 | 91 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 50000 | 4903065 | 98.06 | 8.2002 | MARKET TRADE
16 | 91 DAY TBILL MAT 07.09.12 | IN002012X024 | MAGNUM TAX PROFIT SCHEME - 1994 | 07-SEP-2012 | 91 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 800000 | 78449040 | 98.06 | 8.2002 | MARKET TRADE
17 | 91 DAY TBILL MAT 07.09.12 | IN002012X024 | MAGNUM EQUITY LINKED SAVINGS SCHEME - 1995 | 07-SEP-2012 | 91 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 700000 | 68642910 | 98.06 | 8.2002 | MARKET TRADE
18 | 91 DAY TBILL MAT 07.09.12 | IN002012X024 | MAGNUM GILT FUND - SHORT TERM | 07-SEP-2012 | 91 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 1000000 | 98061300 | 98.06 | 8.2002 | MARKET TRADE
19 | 91 DAY TBILL MAT 07.09.12 | IN002012X024 | MAGNUM EXPRESS SCHEME 1991 | 07-SEP-2012 | 91 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 350000 | 34321455 | 98.06 | 8.2002 | MARKET TRADE
20 | 91 DAY TBILL MAT 07.09.12 | IN002012X024 | MAGNUM MONTHLY INCOME SCHEME - II | 07-SEP-2012 | 91 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 300000 | 29418390 | 98.06 | 8.2002 | MARKET TRADE
21 | 91 DAY TBILL MAT 07.09.12 | IN002012X024 | MAGNUM RISING INCOME SCHEME -  1987 | 07-SEP-2012 | 91 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 300000 | 29418390 | 98.06 | 8.2002 | MARKET TRADE
22 | 91 DAY TBILL MAT 07.09.12 | IN002012X024 | MAGNUM TAX SAVING SCHEME - 1988-89 | 07-SEP-2012 | 91 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 500000 | 49030650 | 98.06 | 8.2002 | MARKET TRADE
23 | 91 DAY TBILL MAT 07.09.12 | IN002012X024 | MAGNUM BOND FUND - 1994 | 07-SEP-2012 | 91 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 1050000 | 102964365 | 98.06 | 8.2002 | MARKET TRADE
24 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI SHORT HORI DEBT FUND-SHORTTERM | 14-NOV-2024 | 4542 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 1000000 | 105932500 | 105.93 | 8.3713 | MARKET TRADE
25 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND - SHORT TERM | 14-NOV-2024 | 4542 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 500000 | 52966250 | 105.93 | 8.3713 | MARKET TRADE
26 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM INCOME FUND - 1998 | 14-NOV-2024 | 4542 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 1000000 | 105932500 | 105.93 | 8.3713 | MARKET TRADE
27 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4542 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 2500000 | 264831250 | 105.93 | 8.3713 | MARKET TRADE
28 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4542 | T+1 | 08-JUN-2012 | 08-JUN-2012 | 11-JUN-2012 | 5000000 | 529662500 | 105.93 | 8.3713 | MARKET TRADE
29 | HINDALCO INDUSTRIES LIMITED 9.55% 25.04.2022(D) | INE038A07258 | SBI DYNAMIC BOND FUND | 25-APR-2022 | 3605 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 500 | 500000000 | 1000000 | 9.542 | MARKET TRADE
30 | NATIONAL BANK FOR AGRI. & RURAL DEVT. 9.55% , 12/07/2014 | INE261F09GK8 | SBI SHORT HORI DEBT FUND-SHORTTERM | 12-JUL-2014 | 761 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 100 | 99815200 | 998152 | 9.646 | MARKET TRADE
31 | ORIENTAL BANK OF COMMERCE CD MAT 20.03.2013 | INE141A16GY9 | SBI DYNAMIC BOND FUND | 20-MAR-2013 | 282 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 2500 | 232620750 | 93048.3 | 9.67 | MARKET TRADE
32 | ORIENTAL BANK OF COMMERCE CD MAT 20.03.2013 | INE141A16GY9 | SBI DYNAMIC BOND FUND | 20-MAR-2013 | 282 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 2500 | 232620750 | 93048.3 | 9.67 | MARKET TRADE
33 | CANARA BANK CD MAT 10.09.2012 | INE476A16IE7 | MAGNUM INSTACASH FUND | 10-SEP-2012 | 91 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 5000 | 488568500 | 97713.7 | 9.3849 | MARKET TRADE
34 | CANARA BANK CD MAT 10.09.2012 | INE476A16IE7 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 10-SEP-2012 | 91 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 7500 | 732852750 | 97713.7 | 9.3849 | MARKET TRADE
35 | CANARA BANK CD MAT 10.09.2012 | INE476A16IE7 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 10-SEP-2012 | 91 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 7000 | 683995900 | 97713.7 | 9.3849 | MARKET TRADE
36 | CENTRAL BANK OF INDIA CD MAT. DT. 10.09.2012 | INE483A16DF1 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 10-SEP-2012 | 91 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 10000 | 977113000 | 97711.3 | 9.395 | MARKET TRADE
37 | CENTRAL BANK OF INDIA CD MAT. DT. 10.09.2012 | INE483A16DF1 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 10-SEP-2012 | 91 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 5000 | 488556500 | 97711.3 | 9.395 | MARKET TRADE
38 | CENTRAL BANK OF INDIA CD MAT. DT. 10.09.2012 | INE483A16DF1 | SBI PREMIER LIQUID FUND | 10-SEP-2012 | 91 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 15000 | 1465669500 | 97711.3 | 9.395 | MARKET TRADE
39 | CANARA BANK CD MAT 10.09.2012 | INE476A16IE7 | MICF-LIQUID FLOATER PLAN | 10-SEP-2012 | 91 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 3000 | 293141100 | 97713.7 | 9.3849 | MARKET TRADE
40 | IDBI BANK CD MAT 27.05.2013 | INE008A16KN5 | MAGNUM INCOME FUND-FLOATIG RT-LTP | 27-MAY-2013 | 350 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 100 | 9147410 | 91474.1 | 9.72 | MARKET TRADE
41 | ANDHRA BANK CD MAT. 26.12.2012 | INE434A16AS3 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 26-DEC-2012 | 198 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 5000 | 475250500 | 95050.1 | 9.6 | MARKET TRADE
42 | IDBI BANK CD MAT 27.05.2013 | INE008A16KN5 | SBI DEBT FUND SERIES - 366 DAYS - 5 (30.05.2012) | 27-MAY-2013 | 350 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 1300 | 118916330 | 91474.1 | 9.72 | MARKET TRADE
43 | E.I.D. PARRY (INDIA) LTD CP MAT 10.09.2012 | INE126A14562 | SBI PREMIER LIQUID FUND | 10-SEP-2012 | 91 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 1000 | 488253000 | 488253 | 9.6501 | MARKET TRADE
44 | ADITYA BIRLA FINANCE LTD CP MAT 10.09.2012 | INE860H14HD6 | SBI PREMIER LIQUID FUND | 10-SEP-2012 | 91 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 1000 | 487897000 | 487897 | 9.9498 | MARKET TRADE
45 | IDBI BANK CD MAT 27.05.2013 | INE008A16KN5 | MAGNUM MONTHLY INCOME PLAN FLOATER | 27-MAY-2013 | 350 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 100 | 9147410 | 91474.1 | 9.72 | MARKET TRADE
46 | INDIAN OIL [NAME] MAT 07.09.2012 | INE242A14CB7 | SBI PREMIER LIQUID FUND | 07-SEP-2012 | 88 | T+0 | 11-JUN-2012 | 11-JUN-2012 | 11-JUN-2012 | 6000 | 2932551000 | 488758.5 | 9.5398 | 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.