Spreadsheet: 85b8cb61-1a35-48d8-ac2b-5265c86d25bb
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: 21/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 | CANARA BANK CD MAT 26.03.2012 | INE476A16DD0 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 26/03/2012 | 5 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 15000 | 1498153500 | 99876.9 | 8.9974 | MARKET TRADE
2 | DENA BANK CD MAT 26.03.2012 | INE077A16653 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 26/03/2012 | 5 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 15000 | 1498153500 | 99876.9 | 8.9974 | MARKET TRADE
3 | ALLAHABAD BANK CD MAT 28.03.2012 | INE428A16FR6 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 28/03/2012 | 7 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 10000 | 998287000 | 99828.7 | 8.9474 | MARKET TRADE
4 | YES BANK CD MAT 26.03.2012 | INE528G16JG5 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 26/03/2012 | 5 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 2500 | 249695500 | 99878.2 | 8.9022 | MARKET TRADE
5 | 91 DAY TBILL MAT 08.06.12 |  | SBI MUTUAL FUND | MAGNUM GILT FUND - SHORT TERM | 08/06/2012 | 79 | BROKER | 21/03/2012 | 21/03/2012 | 2012-03-22 00:00:00 | 1000000 | 98115100 | 98.12 | 8.9898 | MARKET TRADE
6 | 91 DAY TBILL MAT 08.06.12 |  | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/06/2012 | 79 | BROKER | 21/03/2012 | 21/03/2012 | 2012-03-22 00:00:00 | 5500000 | 539633050 | 98.12 | 8.9898 | MARKET TRADE
7 | ALLAHABAD BANK CD MAT 18.06.2012 | INE428A16GC6 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 18/06/2012 | 89 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 10000 | 973515000 | 97351.5 | 11.1573 | MARKET TRADE
8 | BANK OF BARODA CD MAT. DT. 19.06.2012 | INE028A16458 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 19/06/2012 | 90 | BROKER | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 10000 | 972997000 | 97299.7 | 11.2551 | MARKET TRADE
9 | ALLAHABAD BANK CD MAT 14.06.2012 | INE428A16GH5 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 14/06/2012 | 85 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 10000 | 974620000 | 97462 | 11.1823 | MARKET TRADE
10 | INDIAN OVERSEAS BANK CD MAT 21.03.2013 | INE565A16616 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 21/03/2013 | 365 | BROKER | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 2500 | 225805000 | 90322 | 10.715 | MARKET TRADE
11 | UCO BANK CD MAT 19.06.12 | INE691A16FT5 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 19/06/2012 | 90 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 14300 | 1390652120 | 97248.4 | 11.475 | MARKET TRADE
12 | HDFC BANK CD MAT  19.06.2012 | INE040A16776 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 19/06/2012 | 90 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 20000 | 1945528000 | 97276.4 | 11.355 | MARKET TRADE
13 | HDFC BANK CD MAT  19.06.2012 | INE040A16776 | SBI MUTUAL FUND | SBI PREMIER LIQUID FUND | 19/06/2012 | 90 | BROKER | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 5000 | 486393500 | 97278.7 | 11.3451 | MARKET TRADE
14 | ANDHRA BANK CD MAT. 20.03.2013 | INE434A16BL6 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 20/03/2013 | 364 | BROKER | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 2000 | 180651200 | 90325.6 | 10.74 | MARKET TRADE
15 | KOTAK MAHINDRA BANK CD MAT - 28.03.2012 | INE237A16NI4 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 13 (20.03.12) | 28/03/2012 | 7 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 7500 | 748712250 | 99828.3 | 8.9683 | MARKET TRADE
16 | ORIENTAL BANK OF COMMERCE CD MAT 27.03.2012 | INE141A16DF5 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 13 (20.03.12) | 27/03/2012 | 6 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 7500 | 748904250 | 99853.9 | 8.9008 | MARKET TRADE
17 | CORPORATION BANK CD MAT. 26.03.2012 | INE112A16898 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 13 (20.03.12) | 26/03/2012 | 5 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 7500 | 749086500 | 99878.2 | 8.9022 | MARKET TRADE
18 | INDIAN OVERSEAS BANK CD MAT 21.03.2013 | INE565A16616 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 21/03/2013 | 365 | BROKER | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 5000 | 451753000 | 90350.6 | 10.68 | MARKET TRADE
19 | INDIAN OVERSEAS BANK CD MAT 21.03.2013 | INE565A16616 | SBI MUTUAL FUND | SBI DYNAMIC BOND FUND | 21/03/2013 | 365 | BROKER | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 2500 | 225805000 | 90322 | 10.715 | MARKET TRADE
20 | INDIAN OVERSEAS BANK CD MAT 21.03.2013 | INE565A16616 | SBI MUTUAL FUND | MAGNUM MONTHLY INCOME PLAN | 21/03/2013 | 365 | BROKER | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 2500 | 225805000 | 90322 | 10.715 | MARKET TRADE
21 | BANK OF INDIA CD MAT. DT. 18.06.2012 | INE084A16766 | SBI MUTUAL FUND | MAGNUM BALANCED FUND - 1995 | 18/06/2012 | 89 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 1000 | 97325500 | 97325.5 | 11.2699 | MARKET TRADE
22 | BANK OF BARODA CD MAT. DT. 19.06.2012 | INE028A16458 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 19/06/2012 | 90 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 10000 | 972986000 | 97298.6 | 11.2599 | MARKET TRADE
23 | HDFC BANK CD MAT  19.06.2012 | INE040A16776 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 19/06/2012 | 90 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 15000 | 1459180500 | 97278.7 | 11.3451 | MARKET TRADE
24 | BANK OF INDIA CD MAT. DT. 18.06.2012 | INE084A16766 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 18/06/2012 | 89 | BROKER | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 2500 | 243313750 | 97325.5 | 11.2699 | MARKET TRADE
25 | BANK OF INDIA CD MAT. DT. 18.06.2012 | INE084A16766 | SBI MUTUAL FUND | SBI SHORT HORI DEBT FUND-ULTRASHORT | 18/06/2012 | 89 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 6500 | 632615750 | 97325.5 | 11.2699 | MARKET TRADE
26 | ANDHRA BANK CD MAT. 20.03.2013 | INE434A16BL6 | SBI MUTUAL FUND | MAGNUM INCOME FUND - 1998 | 20/03/2013 | 364 | BROKER | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 500 | 45162800 | 90325.6 | 10.74 | MARKET TRADE
27 | UCO BANK CD MAT 19.06.12 | INE691A16FT5 | SBI MUTUAL FUND | SBI ARBITRAGE OPPORTUNITIES FUND | 19/06/2012 | 90 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 700 | 68073880 | 97248.4 | 11.475 | MARKET TRADE
28 | DENA BANK CD MAT 26.03.2012 | INE077A16653 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 13 MONTHS - 13 (20.03.12) | 26/03/2012 | 5 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 7500 | 749091750 | 99878.9 | 8.851 | MARKET TRADE
29 | DENA BANK CD MAT 26.03.2012 | INE077A16653 | SBI MUTUAL FUND | SBI DEBT FUND SERIES - 367 DAYS - 17 (21.03.12) | 26/03/2012 | 5 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 2500 | 249697250 | 99878.9 | 8.851 | MARKET TRADE
30 | STERLITE ENERGY LIMITED CP MAT 27.04.2012 | INE957I14126 | SBI MUTUAL FUND | MAGNUM INSTACASH FUND | 27/04/2012 | 37 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 30 | 14848549.5362223 | 494951.65 | 10.0618 | INTERSCHEME
31 | STERLITE ENERGY LIMITED CP MAT 27.04.2012 | INE957I14126 | SBI MUTUAL FUND | MAGNUM INCOME FUND - 1998 | 27/04/2012 | 37 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-21 00:00:00 | 30 | 14848549.5362223 | 494951.65 | 10.0618 | INTERSCHEME
32 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM INCOME FUND - 1998 | 08/11/2021 | 3519 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-22 00:00:00 | 500000 | 51300000 | 102.6 | 8.3884 | MARKET TRADE
33 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM INCOME FUND - 1998 | 08/11/2021 | 3519 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-22 00:00:00 | 500000 | 51261250 | 102.52 | 8.4001 | MARKET TRADE
34 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3519 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-22 00:00:00 | 2000000 | 205100000 | 102.55 | 8.3959 | MARKET TRADE
35 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM GILT FUND-LONG TERM | 08/11/2021 | 3519 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-22 00:00:00 | 1000000 | 102570000 | 102.57 | 8.3929 | MARKET TRADE
36 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI MUTUAL FUND | MAGNUM INCOME FUND - 1998 | 08/11/2021 | 3519 | DIRECT | 21/03/2012 | 21/03/2012 | 2012-03-22 00:00:00 | 500000 | 51275000 | 102.55 | 8.3959 | 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.