Spreadsheet: a7550b88-f6cc-40f3-a91d-692eaad9a2c4
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 | Unnamed: 15
Transaction Date: 03/04/2012
Debt and Money Market Securities Transaction Details
SR. NO. | NAME OF SECURITY | ISIN | FUND HOUSE | 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 | UNION BANK CD MAT. 25.06.2012 | INE692A16BA2 | SBI MUTUAL FUND | MICF-LIQUID FLOATER PLAN | 25/06/2012 | 83 | BROKER | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 5000 | 488492500 | 97698.5 | 10.3595 | MARKET TRADE
2 | UNION BANK CD MAT. 25.06.2012 | INE692A16BA2 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 25/06/2012 | 83 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 2500 | 244246250 | 97698.5 | 10.3595 | MARKET TRADE
3 | BANK OF INDIA CD MAT. DT. 25.06.2012 | INE084A16717 | SBI MUTUAL FUND | MICF-LIQUID FLOATER PLAN | 25/06/2012 | 83 | BROKER | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 2500 | 244261750 | 97704.7 | 10.3309 | MARKET TRADE
4 | BANK OF INDIA CD MAT. DT. 25.06.2012 | INE084A16717 | SBI MUTUAL FUND | MICF-LIQUID FLOATER PLAN | 25/06/2012 | 83 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 2500 | 244261750 | 97704.7 | 10.3309 | MARKET TRADE
5 | BANK OF INDIA CD MAT. DT. 25.06.2012 | INE084A16717 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 25/06/2012 | 83 | BROKER | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 5000 | 488720000 | 97744 | 10.1499 | MARKET TRADE
6 | BANK OF INDIA CD MAT. DT. 25.06.2012 | INE084A16717 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 25/06/2012 | 83 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 15000 | 1466160000 | 97744 | 10.1499 | MARKET TRADE
7 | UNION BANK CD MAT. 25.06.2012 | INE692A16BA2 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 25/06/2012 | 83 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 2500 | 244246250 | 97698.5 | 10.3595 | MARKET TRADE
8 | SYNDICATE BANK CD MAT 08.06.2012 | INE667A16AB4 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 08/06/2012 | 66 | BROKER | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 1460 | 143330536 | 98171.6 | 10.2999 | MARKET TRADE
9 | BANK OF BARODA CD MAT. DT. 08.06.2012 | INE028A16417 | SBI MUTUAL FUND | SBI ARBITRAGE OPPORTUNITIES FUND | 08/06/2012 | 66 | BROKER | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 1000 | 98180300 | 98180.3 | 10.25 | MARKET TRADE
10 | UCO BANK CD MAT 26.06.12 | INE691A16FX7 | SBI MUTUAL FUND | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 26/06/2012 | 84 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 7500 | 732219750 | 97629.3 | 10.5514 | MARKET TRADE
11 | UNION BANK CD MAT. 25.06.2012 | INE692A16BA2 | SBI MUTUAL FUND | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 25/06/2012 | 83 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 5000 | 488492500 | 97698.5 | 10.3595 | MARKET TRADE
12 | ANDHRA BANK CD MAT. 21.05.2012 | INE434A16953 | SBI MUTUAL FUND | MAGNUM TAXGAIN SCHEME - 1993 | 21/05/2012 | 48 | BROKER | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 5000 | 493382000 | 98676.4 | 10.1999 | MARKET TRADE
13 | CORPORATION BANK CD MAT. 04.03.2013 | INE112A16BE3 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 04/03/2013 | 335 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 100 | 9140713.46 | 91407.13 | 10.2425 | INTERSCHEME
14 | CORPORATION BANK CD MAT. 04.03.2013 | INE112A16BE3 | SBI MUTUAL FUND | MAGNUM MONTHLY INCOME PLAN | 04/03/2013 | 335 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 100 | 9140713.46 | 91407.13 | 10.2425 | INTERSCHEME
15 | CENTRAL BANK OF INDIA CD MAT. DT. 26.06.2012 | INE483A16AZ5 | SBI MUTUAL FUND | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 26/06/2012 | 84 | BROKER | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 5000 | 488134500 | 97626.9 | 10.5623 | MARKET TRADE
16 | UNITED BANK OF INDIA CD MAT 29.06.2012 | INE695A16ET9 | SBI MUTUAL FUND | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 29/06/2012 | 87 | BROKER | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 5000 | 488114500 | 97622.9 | 10.2157 | MARKET TRADE
17 | SYNDICATE BANK CD MAT 08.06.2012 | INE667A16AB4 | SBI MUTUAL FUND | SBI BLUE CHIP FUND | 08/06/2012 | 66 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 2500 | 245429000 | 98171.6 | 10.2999 | MARKET TRADE
18 | SYNDICATE BANK CD MAT 08.06.2012 | INE667A16AB4 | SBI MUTUAL FUND | SBI ARBITRAGE OPPORTUNITIES FUND | 08/06/2012 | 66 | BROKER | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 3500 | 343600600 | 98171.6 | 10.2999 | MARKET TRADE
19 | ANDHRA BANK CD MAT. 21.05.2012 | INE434A16953 | SBI MUTUAL FUND | MAGNUM TAXGAIN SCHEME - 1993 | 21/05/2012 | 48 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 5000 | 493382000 | 98676.4 | 10.1999 | MARKET TRADE
20 | SYNDICATE BANK CD MAT 08.06.2012 | INE667A16AB4 | SBI MUTUAL FUND | SBI ONE INDIA FUND | 08/06/2012 | 66 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 2500 | 245429000 | 98171.6 | 10.2999 | MARKET TRADE
21 | SYNDICATE BANK CD MAT 08.06.2012 | INE667A16AB4 | SBI MUTUAL FUND | MAGNUM INCOME FUND-FLOATIG RT-LTP | 08/06/2012 | 66 | BROKER | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 40 | 3926864 | 98171.6 | 10.2999 | MARKET TRADE
22 | SYNDICATE BANK CD MAT 26.06.2012 | INE667A16AG3 | SBI MUTUAL FUND | MAGNUM EQUITY FUND | 26/06/2012 | 84 | BROKER | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 2500 | 244266000 | 97706.4 | 10.2002 | MARKET TRADE
23 | ING VYSYA BANK CD MAT 28.05.2012 | INE166A16EM6 | SBI MUTUAL FUND | MAGNUM SECTOR FUNDS UMBRELLA - CONTRA | 28/05/2012 | 55 | BROKER | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 3000 | 295415100 | 98471.7 | 10.2998 | MARKET TRADE
24 | CORPORATION BANK CD MAT. 05.06.2012 | INE112A16BG8 | SBI MUTUAL FUND | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 05/06/2012 | 63 | BROKER | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 2500 | 245695500 | 98278.2 | 10.1503 | MARKET TRADE
25 | ING VYSYA BANK CD MAT 28.05.2012 | INE166A16EM6 | SBI MUTUAL FUND | SBI CAPITAL PROTECTION ORIENTED FUND SERIES - 2 | 28/05/2012 | 55 | BROKER | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 1650 | 162478305 | 98471.7 | 10.2998 | MARKET TRADE
26 | AXIS BANK CD MAT. 29.06.2012 | [NAME] | SBI MUTUAL FUND | MAGNUM INSTACASH FUND | 29/06/2012 | 87 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 5000 | 488075500 | 97615.1 | 10.2501 | MARKET TRADE
27 | AXIS BANK CD MAT. 29.06.2012 | [NAME] | SBI MUTUAL FUND | MICF-LIQUID FLOATER PLAN | 29/06/2012 | 87 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 5000 | 488075500 | 97615.1 | 10.2501 | MARKET TRADE
28 | ING VYSYA BANK CD MAT 28.05.2012 | INE166A16EM6 | SBI MUTUAL FUND | SBI ARBITRAGE OPPORTUNITIES FUND | 28/05/2012 | 55 | BROKER | 03/04/2012 | 03/04/2012 | 2012-04-03 00:00:00 | 350 | 34465095 | 98471.7 | 10.2998 | MARKET TRADE
29 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 14/11/2024 | 4608 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-04 00:00:00 | 2500000 | 257375000 | 102.95 | 8.7568 | MARKET TRADE
30 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3506 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-04 00:00:00 | 1000000 | 100750000 | 100.75 | 8.671 | MARKET TRADE
31 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3506 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-04 00:00:00 | 800000 | 80600000 | 100.75 | 8.671 | MARKET TRADE
32 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM INCOME FUND - 1998 | 08/11/2021 | 3506 | DIRECT | 03/04/2012 | 03/04/2012 | 2012-04-04 00:00:00 | 200000 | 20150000 | 100.75 | 8.671 | 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.