Spreadsheet: c89886f7-4e72-4a5d-bce6-30f92fe2dad1
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: 27/04/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 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 1000000 | 103800000 | 103.8 | 8.6467 | MARKET TRADE
2 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 51905000 | 103.81 | 8.6454 | MARKET TRADE
3 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 1000000 | 103800000 | 103.8 | 8.6467 | MARKET TRADE
4 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 51900000 | 103.8 | 8.6467 | MARKET TRADE
5 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 1000000 | 103800000 | 103.8 | 8.6467 | MARKET TRADE
6 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 51900000 | 103.8 | 8.6467 | MARKET TRADE
7 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 51900000 | 103.8 | 8.6467 | MARKET TRADE
8 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 4000000 | 415610000 | 103.9 | 8.6335 | MARKET TRADE
9 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 51955000 | 103.91 | 8.6326 | MARKET TRADE
10 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 1000000 | 103802500 | 103.8 | 8.6464 | MARKET TRADE
11 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI SHORT HORI DEBT FUND-SHORTTERM | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 200000 | 20780500 | 103.9 | 8.6335 | MARKET TRADE
12 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI SHORT HORI DEBT FUND-SHORTTERM | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 2000000 | 207810000 | 103.91 | 8.6332 | MARKET TRADE
13 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM CHILDREN BENEFIT PLAN | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 300000 | 31170750 | 103.9 | 8.6335 | MARKET TRADE
14 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI SHORT HORI DEBT FUND-SHORTTERM | 08-NOV-2021 | 3483 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 2200000 | 222332000 | 101.06 | 8.6238 | MARKET TRADE
15 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM CHILDREN BENEFIT PLAN | 08-NOV-2021 | 3483 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 300000 | 30318000 | 101.06 | 8.6238 | MARKET TRADE
16 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3483 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 1000000 | 101060000 | 101.06 | 8.6238 | MARKET TRADE
17 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3483 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 1000000 | 101060000 | 101.06 | 8.6238 | MARKET TRADE
18 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3483 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 50530000 | 101.06 | 8.6238 | MARKET TRADE
19 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3483 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 2500000 | 252618750 | 101.05 | 8.6257 | MARKET TRADE
20 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI DYNAMIC BOND FUND | 08-NOV-2021 | 3483 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 50530000 | 101.06 | 8.6238 | MARKET TRADE
21 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI DYNAMIC BOND FUND | 08-NOV-2021 | 3483 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 2500000 | 252650000 | 101.06 | 8.6238 | MARKET TRADE
22 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI DYNAMIC BOND FUND | 08-NOV-2021 | 3483 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 2500000 | 252500000 | 101 | 8.6331 | MARKET TRADE
23 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM INCOME FUND - 1998 | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 1000000 | 103910000 | 103.91 | 8.6326 | MARKET TRADE
24 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM INCOME FUND - 1998 | 08-NOV-2021 | 3483 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 1000000 | 101000000 | 101 | 8.6331 | MARKET TRADE
25 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 51867500 | 103.74 | 8.6551 | MARKET TRADE
26 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 51865000 | 103.73 | 8.6557 | MARKET TRADE
27 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 51865000 | 103.73 | 8.6557 | MARKET TRADE
28 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 51865000 | 103.73 | 8.6557 | MARKET TRADE
29 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 51862500 | 103.73 | 8.6564 | MARKET TRADE
30 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM MONTHLY INCOME PLAN | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 1000000 | 103720000 | 103.72 | 8.657 | MARKET TRADE
31 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM BALANCED FUND - 1995 | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 51860000 | 103.72 | 8.657 | MARKET TRADE
32 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 1000000 | 103722500 | 103.72 | 8.6567 | MARKET TRADE
33 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 51860000 | 103.72 | 8.657 | MARKET TRADE
34 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 1000000 | 103720000 | 103.72 | 8.657 | MARKET TRADE
35 | IDBI BANK CD MAT 07.05.2012 | INE008A16IW0 | MICF-LIQUID FLOATER PLAN | 07-MAY-2012 | 11 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 5000 | 498770000 | 99754 | 9.0011 | MARKET TRADE
36 | UCO BANK CD MAT 19.06.12 | INE691A16FT5 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 19-JUN-2012 | 54 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 2500 | 246686750 | 98674.7 | 9.2497 | MARKET TRADE
37 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 51860000 | 103.72 | 8.657 | MARKET TRADE
38 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4585 | T+1 | 26-APR-2012 | 26-APR-2012 | 27-APR-2012 | 500000 | 51860000 | 103.72 | 8.657 | MARKET TRADE
39 | 182 DAY TBILL MAT 20.07.12 | IN002011Y024 | SBI PREMIER LIQUID FUND | 20-JUL-2012 | 84 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 41542000 | 4069956978.2 | 97.97 | 8.9941 | MARKET TRADE
40 | NATIONAL BANK FOR AGRI. & RURAL DEVT. SERIES XII Q . 9.6550% , 18/10/2014 | INE261F09GT9 | SBI DYNAMIC BOND FUND | 18-OCT-2014 | 904 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 250 | 250783500 | 1003134 | 9.4618 | MARKET TRADE
41 | HINDALCO INDUSTRIES LIMITED 9.55% 25.04.2022 | INE038A07258 | MAGNUM MONTHLY INCOME PLAN | 25-APR-2022 | 3650 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 100 | 100000000 | 1000000 | 9.5494 | MARKET TRADE
42 | HINDALCO INDUSTRIES LIMITED 9.55% 25.04.2022 | INE038A07258 | MAGNUM BALANCED FUND - 1995 | 25-APR-2022 | 3650 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 100 | 100000000 | 1000000 | 9.5494 | MARKET TRADE
43 | VIJAYA BANK CD MAT 23.07.12 | INE705A16FC9 | SBI DEBT FUND SERIES - 90 DAYS - 61 (24.04.12) | 23-JUL-2012 | 87 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 1500 | 146667450 | 97778.3 | 9.5327 | MARKET TRADE
44 | VIJAYA BANK CD MAT 23.07.12 | INE705A16FC9 | MAGNUM INSTACASH FUND | 23-JUL-2012 | 87 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 500 | 48889150 | 97778.3 | 9.5327 | MARKET TRADE
45 | YES BANK CD MAT 26.04.2013 | INE528G16OS0 | SBI DEBT FUND SERIES - 366 DAYS - 2 (26.04.12) | 26-APR-2013 | 364 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 2000 | 182111200 | 91055.6 | 9.85 | MARKET TRADE
46 | TATA CAPITAL FINANCIAL SERVICES LTD CP MAT 05.06.12 | INE306N14068 | SBI PREMIER LIQUID FUND | 05-JUN-2012 | 39 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 1000 | 494876000 | 494876 | 9.6904 | MARKET TRADE
47 | AXIS BANK CD MAT. 23.07.2012 | INE238A16PE6 | SBI DEBT FUND SERIES - 90 DAYS - 61 (24.04.12) | 23-JUL-2012 | 87 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 1500 | 146658150 | 97772.1 | 9.5599 | MARKET TRADE
48 | AXIS BANK CD MAT. 23.07.2012 | INE238A16PE6 | MAGNUM INSTACASH FUND | 23-JUL-2012 | 87 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 500 | 48886050 | 97772.1 | 9.5599 | MARKET TRADE
49 | ECL FINANCE LTD CP MAT 27.06.2012 | INE804I14BZ8 | MAGNUM INSTACASH FUND | 27-JUN-2012 | 61 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 100 | 49137750 | 491377.5 | 10.4998 | MARKET TRADE
50 | ECL FINANCE LTD CP MAT 27.06.2012 | INE804I14BZ8 | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 27-JUN-2012 | 61 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 400 | 196551000 | 491377.5 | 10.4998 | MARKET TRADE
51 | NATIONAL COOPERATIVE DEVELOPMENT  CORPORTION CP MAT 28.06.12 | INE014N14035 | MICF-LIQUID FLOATER PLAN | 28-JUN-2012 | 62 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 1000 | 491936500 | 491936.5 | 9.6497 | MARKET TRADE
52 | NATIONAL COOPERATIVE DEVELOPMENT  CORPORTION CP MAT 28.06.12 | INE014N14035 | SBI PREMIER LIQUID FUND | 28-JUN-2012 | 62 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 2000 | 983873000 | 491936.5 | 9.6497 | MARKET TRADE
53 | ICICI SECURITIES PRIMARY DEALERSHIP LTD CP MAT 30.04.2012 | INE849D14CJ6 | SBI ARBITRAGE OPPORTUNITIES FUND | 30-APR-2012 | 3 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 20 | 9992818 | 499640.9 | 8.7444 | INTERSCHEME
54 | ICICI SECURITIES PRIMARY DEALERSHIP LTD CP MAT 30.04.2012 | INE849D14CJ6 | MICF-LIQUID FLOATER PLAN | 30-APR-2012 | 3 | T+0 | 27-APR-2012 | 27-APR-2012 | 27-APR-2012 | 20 | 9992818 | 499640.9 | 8.7444 | INTERSCHEME
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.