Spreadsheet: 112886d1308853846-adding-additional-string-to-formula-example
Sheet: Corporate Actions

 |  |  |  | Announced Dividends |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paid/Received Dividends
Account Number | Symbol | Ex Date | Rec Date | Payable Date | Position | Rate | Base CCY Gross Amount | Payable CCY Code | Type | Dividend Description | L/S/E Indicator | Trade Name #1 | Trade Name #2 | Trade Name #3 | Trade Name #4 | Trade Name #5 | Trade Name #6 | Trade Name #7 | Trade Name #8 | Trade Name #9 | Trade Name #10 | Side #1 | Side #2 | Side #3 | Side #4 | Side #5 | Side #6 | Side #7 | Side #8 | Side #9 | Side #10 | Shares #1 | Shares #2 | Shares #3 | Shares #4 | Shares #5 | Shares #6 | Shares #7 | Shares #8 | Shares #9 | Shares #10 | Base CCY Gross Amount # 1 | Base CCY Gross Amount # 2 | Base CCY Gross Amount # 3 | Base CCY Gross Amount # 4 | Base CCY Gross Amount # 5 | Base CCY Gross Amount # 6 | Base CCY Gross Amount # 7 | Base CCY Gross Amount # 8 | Base CCY Gross Amount # 9 | Base CCY Gross Amount # 10 |  |  |  | Account Number | Symbol/Description | Settle Date/ValueDate | Process Date | Settle CCY Price | Settle CCY Net Amount | Rate | Trade Name #1 | Trade Name #2 | Trade Name #3 | Trade Name #4 | Trade Name #5 | Trade Name #6 | Trade Name #7 | Trade Name #8 | Trade Name #9 | Trade Name #10 | Side #1 | Side #2 | Side #3 | Side #4 | Side #5 | Side #6 | Side #7 | Side #8 | Side #9 | Side #10 | Shares #1 | Shares #2 | Shares #3 | Shares #4 | Shares #5 | Shares #6 | Shares #7 | Shares #8 | Shares #9 | Shares #10 | Settle CCY Net Amount #1 | Settle CCY Net Amount #2 | Settle CCY Net Amount #3 | Settle CCY Net Amount #4 | Settle CCY Net Amount #5 | Settle CCY Net Amount #6 | Settle CCY Net Amount #7 | Settle CCY Net Amount #8 | Settle CCY Net Amount #9 | Settle CCY Net Amount #10 |  |  |  |  | Account Number | Symbol/Description | Settle Date/ValueDate | Process Date | Settle CCY Price | Settle CCY Net Amount
7Y4D1209 | SMH | 2011-05-27 00:00:00 | 2011-06-01 00:00:00 | 2011-06-24 00:00:00 | 5600 | 0.0208 | 116.48 | USD | Pending | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | RTH | 2011-06-21 00:00:00 | 2011-06-21 00:00:00 | 0 | -28.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | NEE | 2011-03-15 00:00:00 | 2011-03-15 00:00:00 | 0 | 50.05
7Y4D1209 | RTH | 2011-06-06 00:00:00 | 2011-06-08 00:00:00 | 2011-07-01 00:00:00 | -1800 | 0.015 | -27 | USD | Pending | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | D | 2011-03-21 00:00:00 | 2011-03-21 00:00:00 | 0 | 54.66
7Y4D1209 | VIAB | 2011-06-13 00:00:00 | 2011-06-15 00:00:00 | 2011-07-01 00:00:00 | 1969 | 0.25 | 492.25 | USD | Pending | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | KRE | 2011-03-30 00:00:00 | 2011-03-30 00:00:00 | 0 | -299.72
7Y4D1209 | RTH | 2011-06-13 00:00:00 | 2011-06-15 00:00:00 | 2011-07-06 00:00:00 | -1800 | 0.011738 | -21.12 | USD | Pending | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | PEG | 2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 0 | 52.74
7Y4D1209 | RTH | 2011-06-14 00:00:00 | 2011-06-16 00:00:00 | 2011-07-05 00:00:00 | -1800 | 0.1 | -180 | USD | Pending | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | EXPE | 2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 0 | 325.57
7Y4D1209 | RTH | 2011-06-15 00:00:00 | 2011-06-17 00:00:00 | 2011-07-06 00:00:00 | -1800 | 0.08 | -144 | USD | Pending | SPECIAL DIV | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | POM | 2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 0 | 73.17
7Y4D1209 | KRE | 2011-06-17 00:00:00 | 2011-06-21 00:00:00 | 2011-06-29 00:00:00 | -4110 | 0.098124 | -403.28 | USD | Pending | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | PPL | 2011-04-01 00:00:00 | 2011-04-01 00:00:00 | 0 | 69.65
7Y4D1209 | XLF | 2011-06-17 00:00:00 | 2011-06-21 00:00:00 | 2011-06-29 00:00:00 | -6640 | 0.05288 | -351.12 | USD | Pending | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | DTE | 2011-04-15 00:00:00 | 2011-04-15 00:00:00 | 0 | 59.36
7Y4D1209 | XLK | 2011-06-17 00:00:00 | 2011-06-21 00:00:00 | 2011-06-29 00:00:00 | 3945 | 0.09823 | 387.51 | USD | Pending | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | SRE | 2011-04-15 00:00:00 | 2011-04-15 00:00:00 | 0 | -910.08
7Y4D1209 | XLP | 2011-06-17 00:00:00 | 2011-06-21 00:00:00 | 2011-06-29 00:00:00 | -6361 | 0.21694 | -1379.95 | USD | Pending | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | PCG | 2011-04-15 00:00:00 | 2011-04-15 00:00:00 | 0 | 49.59
7Y4D1209 | XOP | 2011-06-17 00:00:00 | 2011-06-21 00:00:00 | 2011-06-29 00:00:00 | -1776 | 0.037032 | -65.76 | USD | Pending | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | XEL | 2011-04-20 00:00:00 | 2011-04-20 00:00:00 | 0 | 53.02
7Y4D1209 | RTH | 2011-06-21 00:00:00 | 2011-06-23 00:00:00 | 2011-07-18 00:00:00 | -900 | 0.01305 | -11.74 | USD | Pending | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | HTS | 2011-04-25 00:00:00 | 2011-04-25 00:00:00 | 0 | -308
7Y4D1209 | HNZ | 2011-06-22 00:00:00 | 2011-06-24 00:00:00 | 2011-07-10 00:00:00 | N/A | 0.48 | N/A | USD | Announcement | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | AGNC | 2011-04-27 00:00:00 | 2011-04-27 00:00:00 | 0 | -431.2
7Y4D1209 | IBB | 2011-06-23 00:00:00 | 2011-06-27 00:00:00 | 2011-06-29 00:00:00 | N/A | 0 | N/A | USD | Announcement | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | IVR | 2011-04-27 00:00:00 | 2011-04-27 00:00:00 | 0 | 4261
7Y4D1209 | RTH | 2011-06-30 00:00:00 | 2011-07-05 00:00:00 | 2011-07-28 00:00:00 | N/A | 0.0135 | N/A | USD | Announcement | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | PGN | 2011-05-02 00:00:00 | 2011-05-02 00:00:00 | 0 | 68.2
7Y4D1209 | RTH | 2011-07-01 00:00:00 | 2011-07-06 00:00:00 | 2011-07-29 00:00:00 | N/A | 0.018 | N/A | USD | Announcement | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | EIX | 2011-05-02 00:00:00 | 2011-05-02 00:00:00 | 0 | 44.48
7Y4D1209 | RTH | 2011-07-18 00:00:00 | 2011-07-20 00:00:00 | 2011-08-05 00:00:00 | N/A | 0.0392 | N/A | USD | Announcement | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | COV | 2011-05-06 00:00:00 | 2011-05-06 00:00:00 | 0 | 385
7Y4D1209 | RTH | 2011-08-09 00:00:00 | 2011-08-11 00:00:00 | 2011-09-06 00:00:00 | N/A | 0.019 | N/A | USD | Announcement | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | CMS | 2011-05-31 00:00:00 | 2011-05-31 00:00:00 | 0 | 54.81
7Y4D1209 | RTH | 2011-08-10 00:00:00 | 2011-08-12 00:00:00 | 2011-09-08 00:00:00 | N/A | 0.1314 | N/A | USD | Announcement | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | PNW | 2011-06-01 00:00:00 | 2011-06-01 00:00:00 | 0 | 63
7Y4D1209 | RTH | 2011-08-16 00:00:00 | 2011-08-18 00:00:00 | 2011-09-14 00:00:00 | N/A | 0.048 | N/A | USD | Announcement | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | SO | 2011-06-06 00:00:00 | 2011-06-06 00:00:00 | 0 | 61.89
7Y4D1209 | IBB | 2011-09-26 00:00:00 | 2011-09-28 00:00:00 | 2011-09-30 00:00:00 | N/A | 0 | N/A | USD | Announcement | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | NOC | 2011-06-13 00:00:00 | 2011-06-13 00:00:00 | 0 | -786
7Y4D1209 | RTH | 2011-12-07 00:00:00 | 2011-12-09 00:00:00 | 2012-01-05 00:00:00 | N/A | 0.1314 | N/A | USD | Announcement | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | CSX | 2011-06-15 00:00:00 | 2011-06-15 00:00:00 | 0 | 474.12
7Y4D1209 | IBB | 2011-12-22 00:00:00 | 2011-12-27 00:00:00 | 2011-12-29 00:00:00 | N/A | 0 | N/A | USD | Announcement | CASH DIVIDEND | Domestic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7Y4D1209 | SMH | 2011-06-17 00:00:00 | 2011-06-17 00:00:00 | 0 | 84
7Y4D1209 | IBB | 2011-12-28 00:00:00 | 2011-12-30 00:00:00 | 2012-01-05 00:00:00 | N/A | 0 | N/A | USD | Announcement | CASH DIVIDEND | Domestic