Spreadsheet: e698c9cb-347e-4d12-993e-8330d2a1eaa3
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: 23/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 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3489 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 500000 | 51200000 | 102.4 | 8.418 | MARKET TRADE
2 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3489 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 500000 | 51200000 | 102.4 | 8.418 | MARKET TRADE
3 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3489 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 500000 | 51200000 | 102.4 | 8.418 | MARKET TRADE
4 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3489 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 1000000 | 102360000 | 102.36 | 8.4241 | MARKET TRADE
5 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 1500000 | 157421250 | 104.95 | 8.5002 | MARKET TRADE
6 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 1000000 | 104945000 | 104.95 | 8.5005 | MARKET TRADE
7 | BANK OF INDIA CD MAT. DT. 26.03.2013 | INE084A16782 | SBI DYNAMIC BOND FUND | 26-MAR-2013 | 340 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 7440 | 682960752 | 91795.8 | 9.68 | MARKET TRADE
8 | BANK OF INDIA CD MAT. DT. 26.03.2013 | INE084A16782 | SBI SHORT HORI DEBT FUND-SHORTTERM | 26-MAR-2013 | 340 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 60 | 5507748 | 91795.8 | 9.68 | MARKET TRADE
9 | INDIAN OVERSEAS BANK CD MAT 21.03.2013 | INE565A16616 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 21-MAR-2013 | 335 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 2500 | 229730750 | 91892.3 | 9.7 | MARKET TRADE
10 | PUNJAB NATIONAL BANK CD MAT. 15.03.2013 | INE160A16HI0 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 15-MAR-2013 | 329 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 2500 | 230068000 | 92027.2 | 9.7 | MARKET TRADE
11 | ANDHRA BANK CD MAT. 25.03.2013 | INE434A16BN2 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 25-MAR-2013 | 339 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 2500 | 229603750 | 91841.5 | 9.6499 | MARKET TRADE
12 | ANDHRA BANK CD MAT. 28.03.2013 | INE434A16BP7 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 28-MAR-2013 | 342 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 2500 | 229436500 | 91774.6 | 9.65 | MARKET TRADE
13 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM CHILDREN BENEFIT PLAN | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 300000 | 31479000 | 104.93 | 8.5024 | MARKET TRADE
14 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 500000 | 52460000 | 104.92 | 8.5037 | MARKET TRADE
15 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 2000000 | 209720000 | 104.86 | 8.5113 | MARKET TRADE
16 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 1000000 | 104865000 | 104.87 | 8.5106 | MARKET TRADE
17 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 1000000 | 104865000 | 104.87 | 8.5106 | MARKET TRADE
18 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 1000000 | 104865000 | 104.87 | 8.5106 | MARKET TRADE
19 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 500000 | 52432500 | 104.87 | 8.5106 | MARKET TRADE
20 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 500000 | 52460000 | 104.92 | 8.5037 | MARKET TRADE
21 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 1000000 | 104920000 | 104.92 | 8.5037 | MARKET TRADE
22 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 2500000 | 262425000 | 104.97 | 8.4973 | MARKET TRADE
23 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI DYNAMIC BOND FUND | 08-NOV-2021 | 3489 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 2500000 | 253875000 | 101.55 | 8.548 | MARKET TRADE
24 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 2500000 | 262425000 | 104.97 | 8.4973 | MARKET TRADE
25 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM MONTHLY INCOME PLAN | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 1500000 | 157455000 | 104.97 | 8.4973 | MARKET TRADE
26 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI SHORT HORI DEBT FUND-SHORTTERM | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 1000000 | 104930000 | 104.93 | 8.5024 | MARKET TRADE
27 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI SHORT HORI DEBT FUND-SHORTTERM | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 200000 | 20986000 | 104.93 | 8.5024 | MARKET TRADE
28 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM BALANCED FUND - 1995 | 14-NOV-2024 | 4591 | T+1 | 20-APR-2012 | 20-APR-2012 | 23-APR-2012 | 1000000 | 104970000 | 104.97 | 8.4973 | MARKET TRADE
29 | PUNJAB NATIONAL BANK CD MAT. 15.03.2013 | INE160A16HI0 | MAGNUM BALANCED FUND - 1995 | 15-MAR-2013 | 326 | T+0 | 23-APR-2012 | 23-APR-2012 | 23-APR-2012 | 1000 | 91966700 | 91966.7 | 9.78 | MARKET TRADE
30 | PUNJAB NATIONAL BANK CD MAT. 15.03.2013 | INE160A16HI0 | SBI DYNAMIC BOND FUND | 15-MAR-2013 | 326 | T+0 | 23-APR-2012 | 23-APR-2012 | 23-APR-2012 | 2840 | 261185428 | 91966.7 | 9.78 | MARKET TRADE
31 | PUNJAB NATIONAL BANK CD MAT. 15.03.2013 | INE160A16HI0 | MAGNUM MONTHLY INCOME PLAN | 15-MAR-2013 | 326 | T+0 | 23-APR-2012 | 23-APR-2012 | 23-APR-2012 | 1160 | 106681372 | 91966.7 | 9.78 | MARKET TRADE
32 | INDIABULLS HOUSING FINANCE LTD. CP MAT 26.06.2012 | INE148I14429 | SBI PREMIER LIQUID FUND | 26-JUN-2012 | 64 | T+0 | 23-APR-2012 | 23-APR-2012 | 23-APR-2012 | 1000 | 491638000 | 491638 | 9.7001 | MARKET TRADE
33 | INDIAN OIL [NAME] MAT 20.07.2012 | INE242A14BW5 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 20-JUL-2012 | 88 | T+0 | 23-APR-2012 | 23-APR-2012 | 23-APR-2012 | 1000 | 489012000 | 489012 | 9.3199 | MARKET TRADE
34 | INDIAN OIL [NAME] MAT 20.07.2012 | INE242A14BW5 | SBI PREMIER LIQUID FUND | 20-JUL-2012 | 88 | T+0 | 23-APR-2012 | 23-APR-2012 | 23-APR-2012 | 1000 | 489012000 | 489012 | 9.3199 | 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.