Spreadsheet: 7d694c04-3992-4832-aaff-2472f0a8fd21
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: 30/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 | 4584 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 1500000 | 155085000 | 103.39 | 8.6997 | MARKET TRADE
2 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4584 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 1000000 | 103350000 | 103.35 | 8.7048 | MARKET TRADE
3 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4584 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 2500000 | 258375000 | 103.35 | 8.7048 | MARKET TRADE
4 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM BALANCED FUND - 1995 | 14-NOV-2024 | 4584 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 500000 | 51675000 | 103.35 | 8.7048 | MARKET TRADE
5 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM MONTHLY INCOME PLAN | 14-NOV-2024 | 4584 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 500000 | 51675000 | 103.35 | 8.7048 | MARKET TRADE
6 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI DYNAMIC BOND FUND | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 2000000 | 201540000 | 100.77 | 8.669 | MARKET TRADE
7 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI DYNAMIC BOND FUND | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 500000 | 50385000 | 100.77 | 8.669 | MARKET TRADE
8 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI DYNAMIC BOND FUND | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 1500000 | 151125000 | 100.75 | 8.6721 | MARKET TRADE
9 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 1000000 | 100750000 | 100.75 | 8.6721 | MARKET TRADE
10 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 1000000 | 100750000 | 100.75 | 8.6721 | MARKET TRADE
11 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 500000 | 50400000 | 100.8 | 8.6643 | MARKET TRADE
12 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 500000 | 50400000 | 100.8 | 8.6643 | MARKET TRADE
13 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 2000000 | 201600000 | 100.8 | 8.6643 | MARKET TRADE
14 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM BALANCED FUND - 1995 | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 500000 | 50495000 | 100.99 | 8.6348 | MARKET TRADE
15 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM MONTHLY INCOME PLAN | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 500000 | 50495000 | 100.99 | 8.6348 | MARKET TRADE
16 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM MONTHLY INCOME PLAN | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 1000000 | 100990000 | 100.99 | 8.6348 | MARKET TRADE
17 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM INCOME FUND - 1998 | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 500000 | 50375000 | 100.75 | 8.6721 | MARKET TRADE
18 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 1000000 | 101010000 | 101.01 | 8.6317 | MARKET TRADE
19 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI DYNAMIC BOND FUND | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 500000 | 50500000 | 101 | 8.6332 | MARKET TRADE
20 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM INCOME FUND - 1998 | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 1000000 | 101000000 | 101 | 8.6332 | MARKET TRADE
21 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM INCOME FUND - 1998 | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 500000 | 50525000 | 101.05 | 8.6255 | MARKET TRADE
22 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI DYNAMIC BOND FUND | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 1500000 | 151500000 | 101 | 8.6332 | MARKET TRADE
23 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 1365900 | 137955900 | 101 | 8.6332 | MARKET TRADE
24 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM INCOME FUND - 1998 | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 500000 | 50445000 | 100.89 | 8.6503 | MARKET TRADE
25 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM INCOME FUND - 1998 | 08-NOV-2021 | 3482 | T+1 | 27-APR-2012 | 27-APR-2012 | 30-APR-2012 | 500000 | 50450000 | 100.9 | 8.6487 | MARKET TRADE
26 | INDIAN BANK CD MAT. 25.04.2013 | INE562A16BB5 | SBI DEBT FUND SERIES - 366 DAYS - 2 (26.04.12) | 25-APR-2013 | 360 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 3000 | 273693900 | 91231.3 | 9.745 | MARKET TRADE
27 | INDIAN OIL [NAME] MAT 27.06.2012 | INE242A14BU9 | MAGNUM INSTACASH FUND | 27-JUN-2012 | 58 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 1500 | 738904414.64991 | 492602.94 | 9.4499 | INTERSCHEME
28 | INDIAN OIL [NAME] MAT 27.06.2012 | INE242A14BU9 | SBI PREMIER LIQUID FUND | 27-JUN-2012 | 58 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 1500 | 738904414.64991 | 492602.94 | 9.4499 | INTERSCHEME
29 | NATIONAL HOUSING BANK CP MAT.25.06.2012 | INE557F14AP1 | MAGNUM INSTACASH FUND | 25-JUN-2012 | 56 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 1000 | 492817000 | 492817 | 9.5 | MARKET TRADE
30 | CANARA BANK CD MAT 19.06.2012 | INE476A16HA7 | MAGNUM INSTACASH FUND | 19-JUN-2012 | 50 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 2500 | 246871750 | 98748.7 | 9.2502 | MARKET TRADE
31 | CANARA BANK CD MAT 19.06.2012 | INE476A16HA7 | MAGNUM INSTACASH FUND | 19-JUN-2012 | 50 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 2500 | 246871750 | 98748.7 | 9.2502 | MARKET TRADE
32 | BANK OF BARODA CD MAT. DT. 08.06.2012 | INE028A16417 | SBI PREMIER LIQUID FUND | 08-JUN-2012 | 39 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 3400 | 336640460 | 99011.9 | 9.3399 | MARKET TRADE
33 | ICICI BANK LTD CD MAT 26.04.2013 | INE090A16TO2 | SBI DEBT FUND SERIES - 366 DAYS - 2 (26.04.12) | 26-APR-2013 | 361 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 3000 | 273615000 | 91205 | 9.75 | MARKET TRADE
34 | AXIS BANK CD MAT. 26.04.2013 | INE238A16PF3 | SBI DEBT FUND SERIES - 366 DAYS - 2 (26.04.12) | 26-APR-2013 | 361 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 3000 | 273615000 | 91205 | 9.75 | MARKET TRADE
35 | L & T FINANCE LIMITED CP MAT. DT. 25.06.2012 | INE523E14GN8 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 25-JUN-2012 | 56 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 2000 | 985381000 | 492690.5 | 9.6698 | MARKET TRADE
36 | L & T FINANCE LIMITED CP MAT. DT. 25.06.2012 | INE523E14GN8 | SBI PREMIER LIQUID FUND | 25-JUN-2012 | 56 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 2000 | 985381000 | 492690.5 | 9.6698 | MARKET TRADE
37 | BANK OF BARODA CD MAT. DT. 08.06.2012 | INE028A16417 | SBI ARBITRAGE OPPORTUNITIES FUND | 08-JUN-2012 | 39 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 600 | 59407140 | 99011.9 | 9.3399 | MARKET TRADE
38 | INDIAN OIL [NAME] MAT 26.06.2012 | INE242A14BX3 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 26-JUN-2012 | 57 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 4000 | 1971108475.40752 | 492777.12 | 9.3859 | INTERSCHEME
39 | INDIAN OIL [NAME] MAT 26.06.2012 | INE242A14BX3 | SBI PREMIER LIQUID FUND | 26-JUN-2012 | 57 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 4000 | 1971108475.40752 | 492777.12 | 9.3859 | INTERSCHEME
40 | INDIAN OVERSEAS BANK CD MAT 11.06.2012 | INE565A16566 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 11-JUN-2012 | 42 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 10000 | 989521968.0908 | 98952.2 | 9.2023 | INTERSCHEME
41 | INDIAN OVERSEAS BANK CD MAT 11.06.2012 | INE565A16566 | SBI PREMIER LIQUID FUND | 11-JUN-2012 | 42 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 10000 | 989521968.0908 | 98952.2 | 9.2023 | INTERSCHEME
42 | YES BANK CD MAT 26.04.2013 | INE528G16OS0 | SBI DEBT FUND SERIES - 366 DAYS - 2 (26.04.12) | 26-APR-2013 | 361 | T+0 | 30-APR-2012 | 30-APR-2012 | 30-APR-2012 | 1000 | 91122800 | 91122.8 | 9.85 | 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.