Spreadsheet: 87357d1287164409-excel-2007-using-xirr-with-dynamic-ranges-test-workbook-for-xirr-no-vba
Sheet: 7 NOV 2009

MKSYM | PTDate | Transaction | NSB | CDCR | BasisValue | CASH_FLOW
BNI | 2008-06-04 00:00:00 | PURCHASE | 200 |  | 22130.35 | -22130.35
BNI | 2008-07-01 00:00:00 | Cash Dividend |  | 64 |  | 64
BNI | 2008-10-01 00:00:00 | Cash Dividend |  | 80 |  | 80
BNI | 2009-04-01 00:00:00 | Cash Dividend |  | 80 |  | 80
BNI | 2009-07-01 00:00:00 | Cash Dividend |  | 80 |  | 80
BNI | 2009-10-01 00:00:00 | Cash Dividend |  | 80 |  | 80
BNI | 2009-11-07 00:00:00 | MARKET |  |  |  | 19446
IJT | 2009-02-24 00:00:00 | PURCHASE | 110 |  | 4016.78 | -4016.78
IJT | 2009-03-31 00:00:00 | Cash Dividend |  | 1.69 |  | 1.69
IJT | 2009-06-29 00:00:00 | Cash Dividend |  | 7.53 |  | 7.53
IJT | 2009-09-29 00:00:00 | Cash Dividend |  | 5.08 |  | 5.08
IJT | 2009-11-07 00:00:00 | MARKET |  |  |  | 5821.2
IWP | 2009-01-16 00:00:00 | PURCHASE | 70 |  | 2119.6 | -2119.6
IWP | 2009-02-24 00:00:00 | PURCHASE | 110 |  | 3077.66 | -3077.66
IWP | 2009-03-30 00:00:00 | Cash Dividend |  | 15.45 |  | 15.45
IWP | 2009-07-09 00:00:00 | Cash Dividend |  | 16.48 |  | 16.48
IWP | 2009-09-28 00:00:00 | Cash Dividend |  | 16.04 |  | 16.04
IWP | 2009-11-07 00:00:00 | MARKET |  |  |  | 7648.2
LQD | 2009-01-16 00:00:00 | PURCHASE | 20 |  | 2023.79 | -2023.79
LQD | 2009-02-06 00:00:00 | Cash Dividend |  | 9.82 |  | 9.82
LQD | 2009-03-30 00:00:00 | Cash Dividend |  | 9.65 |  | 9.65
LQD | 2009-04-07 00:00:00 | Cash Dividend |  | 10.37 |  | 10.37
LQD | 2009-05-07 00:00:00 | Cash Dividend |  | 9.35 |  | 9.35
LQD | 2009-06-05 00:00:00 | Cash Dividend |  | 9.77 |  | 9.77
LQD | 2009-07-08 00:00:00 | Cash Dividend |  | 8.89 |  | 8.89
LQD | 2009-08-07 00:00:00 | Cash Dividend |  | 9.83 |  | 9.83
LQD | 2009-09-08 00:00:00 | Cash Dividend |  | 9.88 |  | 9.88
LQD | 2009-10-07 00:00:00 | Cash Dividend |  | 9.43 |  | 9.43
LQD | 2009-11-07 00:00:00 | MARKET |  |  |  | 2106.4
MLN | 2009-01-16 00:00:00 | PURCHASE | 120 |  | 2060.08 | -2060.08
MLN | 2009-02-24 00:00:00 | PURCHASE | 120 |  | 2046.47 | -2046.47
MLN | 2009-02-26 00:00:00 | Cash Dividend |  | 7.2 |  | 7.2
MLN | 2009-03-06 00:00:00 | Cash Dividend |  | 17.28 |  | 17.28
MLN | 2009-04-07 00:00:00 | Cash Dividend |  | 17.28 |  | 17.28
MLN | 2009-05-07 00:00:00 | Cash Dividend |  | 17.76 |  | 17.76
MLN | 2009-06-05 00:00:00 | Cash Dividend |  | 18.72 |  | 18.72
MLN | 2009-07-08 00:00:00 | Cash Dividend |  | 18 |  | 18
MLN | 2009-08-07 00:00:00 | Cash Dividend |  | 18 |  | 18
MLN | 2009-09-08 00:00:00 | Cash Dividend |  | 18 |  | 18
MLN | 2009-10-07 00:00:00 | Cash Dividend |  | 16.8 |  | 16.8
MLN | 2009-11-07 00:00:00 | MARKET |  |  |  | 4340.16
OAKBX | 2002-01-10 00:00:00 | PURCHASE | 2165.67 |  | 40000 | -40000
OAKBX | 2009-11-07 00:00:00 | MARKET |  |  |  | 70369.68
PHB | 2009-01-16 00:00:00 | PURCHASE | 130 |  | 2089.1 | -2089.1
PHB | 2009-02-07 00:00:00 | Cash Dividend |  | 14.86 |  | 14.86
PHB | 2009-03-31 00:00:00 | Cash Dividend |  | 15.85 |  | 15.85
PHB | 2009-04-30 00:00:00 | Cash Dividend |  | 15.45 |  | 15.45
PHB | 2009-05-29 00:00:00 | Cash Dividend |  | 18.43 |  | 18.43
PHB | 2009-06-30 00:00:00 | Cash Dividend |  | 15.88 |  | 15.88
PHB | 2009-07-31 00:00:00 | Cash Dividend |  | 16.37 |  | 16.37
PHB | 2009-08-31 00:00:00 | Cash Dividend |  | 16.32 |  | 16.32
PHB | 2009-09-30 00:00:00 | Cash Dividend |  | 16.42 |  | 16.42
PHB | 2009-10-30 00:00:00 | Cash Dividend |  | 17.33 |  | 17.33
PHB | 2009-11-07 00:00:00 | MARKET |  |  |  | 2301
ROTH DIA | 2009-01-16 00:00:00 | PURCHASE | 25 |  | 2049.5 | -2049.5
ROTH DIA | 2009-03-16 00:00:00 | Cash Dividend |  | 9.13 |  | 9.13
ROTH DIA | 2009-04-13 00:00:00 | Cash Dividend |  | 4.42 |  | 4.42
ROTH DIA | 2009-05-11 00:00:00 | Cash Dividend |  | 3.35 |  | 3.35
ROTH DIA | 2009-05-11 00:00:00 | Cash Dividend |  | 3.35 |  | 3.35
ROTH DIA | 2009-06-15 00:00:00 | Cash Dividend |  | 6.15 |  | 6.15
ROTH DIA | 2009-07-12 00:00:00 | Cash Dividend |  | 7.06 |  | 7.06
ROTH DIA | 2009-08-17 00:00:00 | Cash Dividend |  | 3.15 |  | 3.15
ROTH DIA | 2009-09-14 00:00:00 | Cash Dividend |  | 8.22 |  | 8.22
ROTH DIA | 2009-10-13 00:00:00 | Cash Dividend |  | 4.38 |  | 4.38
ROTH DIA | 2009-11-07 00:00:00 | MARKET |  |  |  | 2509.25
ROTH FIGRX | 2005-06-06 00:00:00 | PURCHASE | 490.844 |  | 13792.72 | -13792.72
ROTH FIGRX | 2006-01-13 00:00:00 | PURCHASE | 119.796 |  | 4000 | -4000
ROTH FIGRX | 2009-11-07 00:00:00 | MARKET |  |  |  | 20932.33
ROTH ITM | 2009-02-24 00:00:00 | PURCHASE | 100 |  | 2090.82 | -2090.82
ROTH ITM | 2009-03-06 00:00:00 | Cash Dividend |  | 6.3 |  | 6.3
ROTH ITM | 2009-04-07 00:00:00 | Cash Dividend |  | 6.4 |  | 6.4
ROTH ITM | 2009-05-07 00:00:00 | Cash Dividend |  | 6.6 |  | 6.6
ROTH ITM | 2009-05-07 00:00:00 | Cash Dividend |  | 6.6 |  | 6.6
ROTH ITM | 2009-07-08 00:00:00 | Cash Dividend |  | 6.7 |  | 6.7
ROTH ITM | 2009-08-07 00:00:00 | Cash Dividend |  | 6.8 |  | 6.8
ROTH ITM | 2009-09-08 00:00:00 | Cash Dividend |  | 6.25 |  | 6.25
ROTH ITM | 2009-10-07 00:00:00 | Cash Dividend |  | 6.05 |  | 6.05
ROTH ITM | 2009-11-06 00:00:00 | Cash Dividend |  | 6.25 |  | 6.25
ROTH ITM | 2009-11-07 00:00:00 | MARKET |  |  |  | 2120
ROTH IYC | 2009-01-16 00:00:00 | PURCHASE | 50 |  | 2020 | -2020
ROTH IYC | 2009-03-31 00:00:00 | Cash Dividend |  | 7.46 |  | 7.46
ROTH IYC | 2009-06-30 00:00:00 | Cash Dividend |  | 6.7 |  | 6.7
ROTH IYC | 2009-09-28 00:00:00 | Cash Dividend |  | 6.11 |  | 6.11
ROTH IYC | 2009-11-07 00:00:00 | MARKET |  |  |  | 2637.5
[NAME] TAVIX | 2005-06-06 00:00:00 | PURCHASE | 669.758 |  | 13000 | -13000
[NAME] TAVIX | 2009-11-07 00:00:00 | MARKET |  |  |  | 14703.48
RWJ | 2009-01-16 00:00:00 | PURCHASE | 130 |  | 2054 | -2054
RWJ | 2009-04-08 00:00:00 | Cash Dividend |  | 1.93 |  | 1.93
RWJ | 2009-07-09 00:00:00 | Cash Dividend |  | 1.81 |  | 1.81
RWJ | 2009-10-08 00:00:00 | Cash Dividend |  | 0.83 |  | 0.83
RWJ | 2009-11-07 00:00:00 | MARKET |  |  |  | 3122.6
WGGFX | 2008-03-18 00:00:00 | PURCHASE | 985.724 |  | 16274.31 | -16274.31
WGGFX | 2009-11-07 00:00:00 | MARKET |  |  |  | 12102.5
XRT | 2009-01-16 00:00:00 | PURCHASE | 100 |  | 2010.77 | -2010.77
XRT | 2009-02-24 00:00:00 | PURCHASE | 155 |  | 3056.24 | -3056.24
XRT | 2009-04-01 00:00:00 | Cash Dividend |  | 7.93 |  | 7.93
XRT | 2009-07-01 00:00:00 | Cash Dividend |  | 20.72 |  | 20.72
XRT | 2009-09-30 00:00:00 | Cash Dividend |  | 17.02 |  | 17.02
XRT | 2009-11-07 00:00:00 | MARKET |  |  |  | 8848.5
 |  |  |  |  |  | TOTAL