Spreadsheet: d75dfade-0fa8-4ac4-b06a-926670a2b0e2
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: 19/03/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 | POWER FINANCE CORPORATION LTD  9.43%  23/09/2013 (SERIES 78-A) | INE134E08DV6 | SBI MUTUAL FUND | MAGNUM INCOME FUND - 1998 | 23/09/2013 | 553 | BROKER | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 50 | 49655250 | 993105 | 9.8754 | MARKET TRADE
2 | CENTRAL BANK OF INDIA CD MAT. DT. 15.06.2012 | INE483A16AX0 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 15/06/2012 | 88 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 20000 | 1948650000 | 97432.5 | 10.9299 | MARKET TRADE
3 | CENTRAL BANK OF INDIA CD MAT. DT. 15.06.2012 | INE483A16AX0 | SBI MUTUAL FUND | MAGNUM INSTACASH FUND | 15/06/2012 | 88 | BROKER | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 5000 | 487174000 | 97434.8 | 10.9199 | MARKET TRADE
4 | BANK OF INDIA CD MAT. DT. 14.09.2012 | INE084A16667 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 14/09/2012 | 179 | BROKER | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 5000 | 474110000 | 94822 | 11.1351 | MARKET TRADE
5 | IDBI BANK CD MAT 12.06.2012 | INE008A16HF7 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 12/06/2012 | 85 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 5000 | 486925500 | 97385.1 | 11.5302 | MARKET TRADE
6 | IDBI BANK CD MAT 12.06.2012 | INE008A16HF7 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 12/06/2012 | 85 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 5000 | 486925500 | 97385.1 | 11.5302 | MARKET TRADE
7 | IDBI BANK CD MAT 29.05.2012 | INE008A16JF3 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 29/05/2012 | 71 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 15000 | 1467801000 | 97853.4 | 11.2774 | MARKET TRADE
8 | INDIAN OVERSEAS BANK CD MAT 18.06.2012 | INE565A16608 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 18/06/2012 | 91 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 10000 | 973461000 | 97346.1 | 10.935 | MARKET TRADE
9 | PUNJAB NATIONAL BANK CD MAT. 14.06.2012 | INE160A16HP5 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 14/06/2012 | 87 | BROKER | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 2500 | 243460000 | 97384 | 11.27 | MARKET TRADE
10 | PUNJAB NATIONAL BANK CD MAT. 14.06.2012 | INE160A16HP5 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 14/06/2012 | 87 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 7500 | 730380000 | 97384 | 11.27 | MARKET TRADE
11 | PUNJAB NATIONAL BANK CD MAT. 14.06.2012 | INE160A16HP5 | SBI MUTUAL FUND | MAGNUM INSTACASH FUND | 14/06/2012 | 87 | BROKER | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 2500 | 243460000 | 97384 | 11.27 | MARKET TRADE
12 | PUNJAB NATIONAL BANK CD MAT. 14.06.2012 | INE160A16HP5 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 14/06/2012 | 87 | BROKER | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 2500 | 243460000 | 97384 | 11.27 | MARKET TRADE
13 | PUNJAB NATIONAL BANK CD MAT. 14.06.2012 | INE160A16HP5 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 14/06/2012 | 87 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 15000 | 1460760000 | 97384 | 11.27 | MARKET TRADE
14 | INDIAN BANK CD MAT. 14.06.2012 | INE562A16AU7 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 14/06/2012 | 87 | BROKER | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 2500 | 243513750 | 97405.5 | 11.1749 | MARKET TRADE
15 | INDIAN BANK CD MAT. 14.06.2012 | INE562A16AU7 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 14/06/2012 | 87 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 7500 | 730541250 | 97405.5 | 11.1749 | MARKET TRADE
16 | IDBI BANK CD MAT 18.03.2013 | INE008A16JQ0 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 18/03/2013 | 364 | BROKER | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 4500 | 405807300 | 90179.4 | 10.92 | MARKET TRADE
17 | IDBI BANK CD MAT 18.03.2013 | INE008A16JQ0 | SBI MUTUAL FUND | MAGNUM INCOME FUND - 1998 | 18/03/2013 | 364 | BROKER | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 500 | 45089700 | 90179.4 | 10.92 | MARKET TRADE
18 | SOUTH INDIAN BANK CD MAT 22.05.2012 | INE683A16633 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 22/05/2012 | 64 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 5000 | 489927500 | 97985.5 | 11.7251 | MARKET TRADE
19 | UCO BANK CD MAT 28.03.2012 | INE691A16DO1 | SBI MUTUAL FUND | MAGNUM INCOME FUND - FLOATING RATE PLAN - SAVINGS PLUS BOND PLAN | 28/03/2012 | 9 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-19 00:00:00 | 6000 | 598656600 | 99776.1 | 9.1008 | MARKET TRADE
20 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3521 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-20 00:00:00 | 500000 | 51235000 | 102.47 | 8.4081 | MARKET TRADE
21 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3521 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-20 00:00:00 | 500000 | 51235000 | 102.47 | 8.4081 | MARKET TRADE
22 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3521 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-20 00:00:00 | 500000 | 51235000 | 102.47 | 8.4081 | MARKET TRADE
23 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3521 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-20 00:00:00 | 300000 | 30738000 | 102.46 | 8.4096 | MARKET TRADE
24 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM BALANCED FUND - 1995 | 08/11/2021 | 3521 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-20 00:00:00 | 500000 | 51230000 | 102.46 | 8.4096 | MARKET TRADE
25 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM BALANCED FUND - 1995 | 08/11/2021 | 3521 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-20 00:00:00 | 500000 | 51230000 | 102.46 | 8.4096 | MARKET TRADE
26 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM BALANCED FUND - 1995 | 08/11/2021 | 3521 | DIRECT | 19/03/2012 | 19/03/2012 | 2012-03-20 00:00:00 | 200000 | 20492000 | 102.46 | 8.4096 | 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.