Spreadsheet: 6c1c3855-caa1-46b2-b56d-8401a9896a29
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: 14/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 | ANDHRA BANK CD MAT. 28.03.2013 | INE434A16BP7 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 28-MAR-2013 | 288 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 2500 | 232793750 | 93117.5 | 9.4 | MARKET TRADE
2 | BANK OF INDIA CD MAT. DT. 26.03.2013 | INE084A16782 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 26-MAR-2013 | 286 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 2500 | 232905500 | 93162.2 | 9.3999 | MARKET TRADE
3 | LIC HOUSING FINANCE LTD. 9.70% 11/06/2017(D) | INE115A07CM6 | MAGNUM INCOME FUND - 1998 | 11-JUN-2017 | 1824 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 50 | 50000000 | 1000000 | 9.6988 | MARKET TRADE
4 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 1000000 | 106430000 | 106.43 | 8.3084 | MARKET TRADE
5 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 500000 | 53215000 | 106.43 | 8.3084 | MARKET TRADE
6 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND-LONG TERM | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 500000 | 53215000 | 106.43 | 8.3084 | MARKET TRADE
7 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM GILT FUND - SHORT TERM | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 500000 | 53215000 | 106.43 | 8.3084 | MARKET TRADE
8 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 2500000 | 266075000 | 106.43 | 8.3084 | MARKET TRADE
9 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 1000000 | 106430000 | 106.43 | 8.3084 | MARKET TRADE
10 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 500000 | 53215000 | 106.43 | 8.3084 | MARKET TRADE
11 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 1000000 | 106430000 | 106.43 | 8.3084 | MARKET TRADE
12 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 500000 | 53215000 | 106.43 | 8.3084 | MARKET TRADE
13 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 1000000 | 106430000 | 106.43 | 8.3084 | MARKET TRADE
14 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 500000 | 53215000 | 106.43 | 8.3084 | MARKET TRADE
15 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 500000 | 53215000 | 106.43 | 8.3084 | MARKET TRADE
16 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 1000000 | 106430000 | 106.43 | 8.3084 | MARKET TRADE
17 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 1000000 | 106430000 | 106.43 | 8.3084 | MARKET TRADE
18 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 1000000 | 106430000 | 106.43 | 8.3084 | MARKET TRADE
19 | GOI 09.15%  14/11/2024 | IN0020110048 | SBI DYNAMIC BOND FUND | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 1000000 | 106430000 | 106.43 | 8.3084 | MARKET TRADE
20 | GOI 09.15%  14/11/2024 | IN0020110048 | MAGNUM INCOME FUND - 1998 | 14-NOV-2024 | 4537 | T+1 | 13-JUN-2012 | 13-JUN-2012 | 14-JUN-2012 | 1000000 | 106430000 | 106.43 | 8.3084 | MARKET TRADE
21 | HDFC 0% 10/06/2013(SERIES I-008) | INE001A07GW8 | MAGNUM INCOME FUND - 1998 | 10-JUN-2013 | 361 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 40 | 44263680 | 1106592 | 9.755 | MARKET TRADE
22 | HDFC 0% 10/06/2013(SERIES I-008) | INE001A07GW8 | MAGNUM INCOME PLUS - INVESTMENT | 10-JUN-2013 | 361 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 10 | 11065920 | 1106592 | 9.755 | MARKET TRADE
23 | HDFC 0% 21/06/2013(SERIES [NAME]) | INE001A07GY4 | SBI DYNAMIC BOND FUND | 21-JUN-2013 | 372 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 50 | 54927000 | 1098540 | 9.75 | MARKET TRADE
24 | HINDALCO INDUSTRIES LIMITED 9.55% 25.04.2022(D) | INE038A07258 | MAGNUM INCOME FUND - 1998 | 25-APR-2022 | 3602 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 50 | 50025000 | 1000500 | 9.5336 | MARKET TRADE
25 | HINDALCO INDUSTRIES LIMITED 9.55% 25.04.2022(D) | INE038A07258 | SBI DYNAMIC BOND FUND | 25-APR-2022 | 3602 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 450 | 450225000 | 1000500 | 9.5336 | MARKET TRADE
26 | INDUSIND BANK - CD - MAT 10.09.2012 | INE095A16FX1 | SBI PREMIER LIQUID FUND | 10-SEP-2012 | 88 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 2500 | 244408000 | 97763.2 | 9.4899 | MARKET TRADE
27 | IDBI BANK CD MAT 10.09.2012 | INE008A16LD4 | SBI DEBT FUND SERIES - 90 DAYS - 65 (12.06.2012) | 10-SEP-2012 | 88 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 2000 | 195634800 | 97817.4 | 9.2548 | MARKET TRADE
28 | IDBI BANK CD MAT 10.09.2012 | INE008A16LD4 | MAGNUM INSTACASH FUND | 10-SEP-2012 | 88 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 500 | 48908700 | 97817.4 | 9.2548 | MARKET TRADE
29 | PUNJAB NATIONAL BANK CD MAT. 10.09.2012 | [NAME] | SBI PREMIER LIQUID FUND | 10-SEP-2012 | 88 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 2500 | 244555000 | 97822 | 9.2349 | MARKET TRADE
30 | PUNJAB NATIONAL BANK CD MAT. 10.09.2012 | [NAME] | SBI PREMIER LIQUID FUND | 10-SEP-2012 | 88 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 7500 | 733665000 | 97822 | 9.2349 | MARKET TRADE
31 | FEDERAL BANK CD MAT 07.09.2012 | INE171A16DD7 | SBI PREMIER LIQUID FUND | 07-SEP-2012 | 85 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 5000 | 489345000 | 97869 | 9.35 | MARKET TRADE
32 | UNITED BANK OF INDIA CD MAT 10.09.2012 | INE695A16FD0 | SBI DEBT FUND SERIES - 90 DAYS - 65 (12.06.2012) | 10-SEP-2012 | 88 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 2100 | 205416540 | 97817.4 | 9.2548 | MARKET TRADE
33 | UNITED BANK OF INDIA CD MAT 10.09.2012 | INE695A16FD0 | MAGNUM INSTACASH FUND | 10-SEP-2012 | 88 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 400 | 39126960 | 97817.4 | 9.2548 | MARKET TRADE
34 | ANDHRA BANK CD MAT. 20.03.2013 | INE434A16BL6 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 20-MAR-2013 | 279 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 2460 | 229509390 | 93296.5 | 9.3999 | MARKET TRADE
35 | ANDHRA BANK CD MAT. 20.03.2013 | INE434A16BL6 | MAGNUM INCOME FUND-FLOATIG RT-LTP | 20-MAR-2013 | 279 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 40 | 3731860 | 93296.5 | 9.3999 | MARKET TRADE
36 | ANDHRA BANK CD MAT. 01.03.2013 | INE434A16BG6 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 01-MAR-2013 | 260 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 2500 | 234264000 | 93705.6 | 9.4299 | MARKET TRADE
37 | ANDHRA BANK CD MAT. 01.03.2013 | INE434A16BG6 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 01-MAR-2013 | 260 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 2500 | 234264000 | 93705.6 | 9.4299 | MARKET TRADE
38 | ANDHRA BANK CD MAT. 14.03.2013 | INE434A16BH4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 14-MAR-2013 | 273 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 2500 | 233529000 | 93411.6 | 9.4299 | MARKET TRADE
39 | ANDHRA BANK CD MAT. 14.03.2013 | INE434A16BH4 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 14-MAR-2013 | 273 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 2460 | 229792536 | 93411.6 | 9.4299 | MARKET TRADE
40 | BANK OF INDIA CD MAT. DT. 20.03.2013 | INE084A16790 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 20-MAR-2013 | 279 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 2500 | 233241250 | 93296.5 | 9.3999 | MARKET TRADE
41 | CANARA BANK CD MAT 01.03.2013 | INE476A16GJ0 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 01-MAR-2013 | 260 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 5000 | 468621500 | 93724.3 | 9.4 | MARKET TRADE
42 | CANARA BANK CD MAT 14.03.2013 | INE476A16GT9 | SBI SHORT HORI DEBT FUND-ULTRASHORT | 14-MAR-2013 | 273 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 5000 | 467156000 | 93431.2 | 9.3999 | MARKET TRADE
43 | ANDHRA BANK CD MAT. 14.03.2013 | INE434A16BH4 | MAGNUM INCOME FUND-FLOATIG RT-LTP | 14-MAR-2013 | 273 | T+0 | 14-JUN-2012 | 14-JUN-2012 | 14-JUN-2012 | 40 | 3736464 | 93411.6 | 9.4299 | 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.