Spreadsheet: 57437d66-6a59-43f7-a4e6-889e691ef973
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:26/06/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 | SBI DYNAMIC BOND FUND | 08-NOV-2021 | 3423 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 1000000 | 102900000 | 102.9 | 8.3351 | MARKET TRADE
2 | GOI 8.79%  08/11/2021 | IN0020110030 | SBI DYNAMIC BOND FUND | 08-NOV-2021 | 3423 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 1000000 | 102900000 | 102.9 | 8.3351 | MARKET TRADE
3 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM MONTHLY INCOME PLAN | 08-NOV-2021 | 3423 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 1000000 | 102900000 | 102.9 | 8.3351 | MARKET TRADE
4 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3423 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 1000000 | 102900000 | 102.9 | 8.3351 | MARKET TRADE
5 | GOI 8.79%  08/11/2021 | IN0020110030 | MAGNUM GILT FUND-LONG TERM | 08-NOV-2021 | 3423 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 1000000 | 102900000 | 102.9 | 8.3351 | MARKET TRADE
6 | GOI 8.19%  16/01/2020 | IN0020110071 | SBI DYNAMIC BOND FUND | 16-JAN-2020 | 2761 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 1000000 | 100000000 | 100 | 8.1885 | MARKET TRADE
7 | GOI 8.19%  16/01/2020 | IN0020110071 | MAGNUM BALANCED FUND - 1995 | 16-JAN-2020 | 2761 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 1000000 | 100000000 | 100 | 8.1885 | MARKET TRADE
8 | NATIONAL HOUSING BANK 9.40%  10.01.2015 | INE557F08EB5 | SBI SHORT HORI DEBT FUND-SHORTTERM | 10-JAN-2015 | 929 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 50 | 50050050 | 1001001 | 9.3112 | MARKET TRADE
9 | GOI 8.19%  16/01/2020 | IN0020110071 | SBI SHORT HORI DEBT FUND-SHORTTERM | 16-JAN-2020 | 2761 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 1000000 | 100195000 | 100.2 | 8.1535 | MARKET TRADE
10 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4525 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 2500000 | 264937500 | 105.98 | 8.3639 | MARKET TRADE
11 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4525 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 500000 | 52987500 | 105.98 | 8.3639 | MARKET TRADE
12 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4525 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 500000 | 52987500 | 105.98 | 8.3639 | MARKET TRADE
13 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4525 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 500000 | 52987500 | 105.98 | 8.3639 | MARKET TRADE
14 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4525 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 500000 | 52987500 | 105.98 | 8.3639 | MARKET TRADE
15 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4525 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 500000 | 52987500 | 105.98 | 8.3639 | MARKET TRADE
16 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4525 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 1000000 | 105940000 | 105.94 | 8.3683 | MARKET TRADE
17 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4525 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 1000000 | 105830000 | 105.83 | 8.3822 | MARKET TRADE
18 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM MONTHLY INCOME PLAN | 14-NOV-2024 | 4525 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 500000 | 52915000 | 105.83 | 8.3822 | MARKET TRADE
19 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4525 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 316300 | 33527800 | 106 | 8.3607 | MARKET TRADE
20 | HDFC BANK CD MAT  13.08.2012 | INE040A16784 | SBI DEBT FUND SERIES - 90 DAYS - 64 (29.05.2012) | 13-AUG-2012 | 49 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 700 | 69167700 | 98811 | 9.1501 | MARKET TRADE
21 | HDFC BANK CD MAT  13.08.2012 | INE040A16784 | MICF-LIQUID FLOATER PLAN | 13-AUG-2012 | 49 | T+1 | 25-JUN-2012 | 25-JUN-2012 | 26-JUN-2012 | 300 | 29643300 | 98811 | 9.1501 | MARKET TRADE
22 | TATA SONS LTD 8.7% 26/06/2012 | INE895D08204 | SBI DEBT FUND SERIES - 18 MONTHS - 6 (21/01/2011) | 26-JUN-2012 | 0 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 36 | 36000000 | 1000000 | 0 | MARKET TRADE
23 | TATA SONS LTD 8.7% 26/06/2012 | INE895D08204 | SBI DEBT FUND SERIES - 18 MONTHS - 5 (10/01/2011) | 26-JUN-2012 | 0 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 93 | 93000000 | 1000000 | 0 | MARKET TRADE
24 | 91 DAY TBILL MAT 27.07.2012 | IN002012X024 | SBI PREMIER LIQUID FUND | 27-JUL-2012 | 31 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 11985000 | 1189996642.5 | 99.29 | 8.4135 | MARKET TRADE
25 | 364 DAY TBILL MAT 16.11.2012 | IN002011Z021 | SBI PREMIER LIQUID FUND | 16-NOV-2012 | 143 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 10115000 | 979940188.5 | 96.88 | 8.2204 | MARKET TRADE
26 | GOI 7.99% 2017 | IN0020070010 | SBI PREMIER LIQUID FUND | 09-JUL-2017 | 1839 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 9708000 | 963955860 | 99.3 | 8.162 | MARKET TRADE
27 | 91 DAY TBILL MAT 17.08.2012 | IN002012X024 | SBI PREMIER LIQUID FUND | 17-AUG-2012 | 52 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 5000000 | 494112500 | 98.82 | 8.3636 | MARKET TRADE
28 | 91 DAY TBILL MAT 17.08.2012 | IN002012X024 | SBI PREMIER LIQUID FUND | 17-AUG-2012 | 52 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 10000000 | 988225000 | 98.82 | 8.3636 | MARKET TRADE
29 | 182 DAY TBILL MAT 21.12.12 | IN002012Y022 | SBI PREMIER LIQUID FUND | 21-DEC-2012 | 178 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 20500000 | 1971452200 | 96.17 | 8.17 | MARKET TRADE
30 | 182 DAY TBILL MAT 21.12.12 | IN002012Y022 | SBI PREMIER LIQUID FUND | 21-DEC-2012 | 178 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 10000000 | 961684000 | 96.17 | 8.17 | MARKET TRADE
31 | 182 DAY TBILL MAT 21.12.12 | IN002012Y022 | SBI PREMIER LIQUID FUND | 21-DEC-2012 | 178 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 10000000 | 961684000 | 96.17 | 8.17 | MARKET TRADE
32 | 182 DAY TBILL MAT 21.12.12 | IN002012Y022 | SBI PREMIER LIQUID FUND | 21-DEC-2012 | 178 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 5000000 | 480842000 | 96.17 | 8.17 | MARKET TRADE
33 | 182 DAY TBILL MAT 21.12.12 | IN002012Y022 | SBI PREMIER LIQUID FUND | 21-DEC-2012 | 178 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 10000000 | 961684000 | 96.17 | 8.17 | MARKET TRADE
34 | IDBI BANK CD MAT 24.09.2012 | INE008A16ID0 | MICF-LIQUID FLOATER PLAN | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 2500 | 244283750 | 97713.5 | 9.49 | MARKET TRADE
35 | IDBI BANK CD MAT 24.09.2012 | INE008A16ID0 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 2500 | 244283750 | 97713.5 | 9.49 | MARKET TRADE
36 | IDBI BANK CD MAT 24.09.2012 | INE008A16ID0 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 15000 | 1465702500 | 97713.5 | 9.49 | MARKET TRADE
37 | UCO BANK CD MAT 24.09.2012 | INE691A16GJ4 | MICF-LIQUID FLOATER PLAN | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 1900 | 185769840 | 97773.6 | 9.2349 | MARKET TRADE
38 | BANK OF BARODA CD MAT. DT. 12.09.2012 | INE028A16433 | MICF-LIQUID FLOATER PLAN | 12-SEP-2012 | 78 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 3000 | 294264900 | 98088.3 | 9.1201 | MARKET TRADE
39 | UCO BANK CD MAT 24.09.2012 | INE691A16GJ4 | MAGNUM INSTACASH FUND | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 2500 | 244437000 | 97774.8 | 9.2298 | MARKET TRADE
40 | UCO BANK CD MAT 24.09.2012 | INE691A16GJ4 | MAGNUM INSTACASH FUND | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 7500 | 733311000 | 97774.8 | 9.2298 | MARKET TRADE
41 | UCO BANK CD MAT 24.09.2012 | INE691A16GJ4 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 2500 | 244434000 | 97773.6 | 9.2349 | MARKET TRADE
42 | UCO BANK CD MAT 24.09.2012 | INE691A16GJ4 | SBI DEBT FUND SERIES - 90 DAYS - 67 (26.06.2012) | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 3000 | 293356200 | 97785.4 | 9.1848 | MARKET TRADE
43 | UCO BANK CD MAT 24.09.2012 | INE691A16GJ4 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 2000 | 195570800 | 97785.4 | 9.1848 | MARKET TRADE
44 | UCO BANK CD MAT 24.09.2012 | INE691A16GJ4 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 5000 | 488924000 | 97784.8 | 9.1874 | MARKET TRADE
45 | CANARA BANK CD MAT 14.03.2013 | INE476A16GT9 | SBI DYNAMIC BOND FUND | 14-MAR-2013 | 261 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 1500 | 140402100 | 93601.4 | 9.5599 | MARKET TRADE
46 | CANARA BANK CD MAT 14.03.2013 | INE476A16GT9 | SBI DYNAMIC BOND FUND | 14-MAR-2013 | 261 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 3500 | 327604900 | 93601.4 | 9.5599 | MARKET TRADE
47 | PUNJAB NATIONAL BANK CD MAT. 24.09.2012 | INE160A16GI2 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 2500 | 244513500 | 97805.4 | 9.1 | MARKET TRADE
48 | PUNJAB NATIONAL BANK CD MAT. 24.09.2012 | INE160A16GI2 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 2500 | 244525250 | 97810.1 | 9.0801 | MARKET TRADE
49 | PUNJAB NATIONAL BANK CD MAT. 24.09.2012 | INE160A16GI2 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 7500 | 733575750 | 97810.1 | 9.0801 | MARKET TRADE
50 | PUNJAB NATIONAL BANK CD MAT. 24.09.2012 | INE160A16GI2 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 17500 | 1711263750 | 97786.5 | 9.1802 | MARKET TRADE
51 | PUNJAB NATIONAL BANK CD MAT. 24.09.2012 | INE160A16GI2 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 6100 | 596497650 | 97786.5 | 9.1802 | MARKET TRADE
52 | PUNJAB NATIONAL BANK CD MAT. 24.09.2012 | INE160A16GI2 | MICF-LIQUID FLOATER PLAN | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 1400 | 136901100 | 97786.5 | 9.1802 | MARKET TRADE
53 | PUNJAB NATIONAL BANK CD MAT. 24.09.2012 | INE160A16GI2 | SBI DEBT FUND SERIES - 90 DAYS - 67 (26.06.2012) | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 2500 | 244466250 | 97786.5 | 9.1802 | MARKET TRADE
54 | PUNJAB NATIONAL BANK CD MAT. 24.09.2012 | INE160A16GI2 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 2500 | 244466250 | 97786.5 | 9.1802 | MARKET TRADE
55 | UCO BANK CD MAT 24.09.2012 | INE691A16GJ4 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 5600 | 547532160 | 97773.6 | 9.2349 | MARKET TRADE
56 | BANK OF MAHARASHTRA CD MAT 24.09.2012 | INE457A16AS4 | SBI PREMIER LIQUID FUND | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 5000 | 488921000 | 97784.2 | 9.1899 | MARKET TRADE
57 | BANK OF MAHARASHTRA CD MAT 24.09.2012 | INE457A16AS4 | MICF-LIQUID FLOATER PLAN | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 2000 | 195568400 | 97784.2 | 9.1899 | MARKET TRADE
58 | BANK OF MAHARASHTRA CD MAT 24.09.2012 | INE457A16AS4 | SBI DEBT FUND SERIES - 90 DAYS - 67 (26.06.2012) | 24-SEP-2012 | 90 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 3000 | 293352600 | 97784.2 | 9.1899 | MARKET TRADE
59 | KOTAK MAHINDRA PRIME LTD CP MAT.24.08.2012 | INE916D14LL0 | SBI PREMIER LIQUID FUND | 24-AUG-2012 | 59 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 1500 | 738657000 | 492438 | 9.5001 | MARKET TRADE
60 | ICICI SECURITIES LTD CP MAT 25.09.2012 | [NAME] | SBI PREMIER LIQUID FUND | 25-SEP-2012 | 91 | T+0 | 26-JUN-2012 | 26-JUN-2012 | 26-JUN-2012 | 1000 | 488550500 | 488550.5 | 9.4 | 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.