Spreadsheet: 745594d1630036935-add-conditional-array-to-simple-if-formula-that-includes-blank-cells-rd-excel-forum-question
Sheet: Weekly Long S&P

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PSAR | Starting [NAME] | Ending Cap | Gross Earnings | Annual % |  | Tax bracket |  |  | MACD BB | Starting [NAME] | Ending Cap | Gross Earnings | Annual % |  | HA | Starting [NAME] | Ending Cap | Gross Earnings | Annual %
 | S&P SuperComp | WEEKLY LONG SIGNALS (Entered 5.14.10, signals through 5.7.10) |  |  |  |  |  |  |  |  |  |  | (=no reversal signal) |  |  | (waiting for next bar open for value) |  |  |  |  |  |  |  |  |  |  |  |  |  | (after taxes) | 1 year (before taxes) |  |  |  | Multiple
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30000 |  |  |  |  | 0.9 | -0.1
Symbol | Date of Signal(s) | Entry Date | Entry Price | 2 Signals? | Pre-existing HA Signal | Vol over 130% Avg. | [NAME] | [NAME] | # bars | [NAME] | [NAME] | # bars | Exit Price at Open | Exit % | # bars until rev. | [NAME] | [NAME] | # bars [NAME] drawdown | [NAME] | [NAME] | # bars [NAME] runup | Exit Price at Open | Exit % | # bars until HA rev. | Par SAR exit | Par SAR Exit % | # bars until Par SAR Exit |  |  |  |  |  |  |  | 0.85 | -0.15
 |  |  |  | (1=yes, 0=No) | (2=Y, 1=same day, 0=No) | (1=Y, 0=No) | before sig reverse | before sig reverse | [NAME] drawdown | before sig reverse | before sig reverse | [NAME] runup | after sig reverse | after sig rev. | inc. rev. [NAME] | before HA reverse | before HA reverse | before HA reverse | before HA reverse | before HA reverse | before HA reverse | after HA reverse | after HA rev. | inc. rev bar | Open after SAR sig |  | inc. rev bar |  |  |  |  |  |  |  | 0.75 | -0.25
 |  |  |  |  |  |  | inc. rev. [NAME] | inc. rev. [NAME] | (1=entry bar) | inc. rev. [NAME] | inc. rev. [NAME] |  |  |  |  | inc. rev. [NAME] | inc. rev. [NAME] | inc. rev. [NAME] | inc. rev. [NAME] | inc. rev. [NAME] | inc. rev. [NAME] |  |  |  | .03, .3 |  |  |  |  |  |  |  |  |  | 0.72 | -0.28
WIBC | 2009-05-29 00:00:00 | 2009-06-01 00:00:00 | 4.89 | 0 | 0 | 0 | 4.71 |  | 1 | 9.57 |  | 11 | 6.48 |  | 23 | 4.71 |  | 1 | 9.57 |  | 11 | 7.47 |  | 17 | 7.91 |  | 14 |  |  |  |  |  |  |  | 0.67 | -0.33
DCOM | 2009-06-05 00:00:00 | 2009-06-08 00:00:00 | 8.6 | 0 | 0 | 0 | 7.82 |  | 3 | 12.94 |  | 9 | 12.67 |  | 51 | 7.82 |  | 21 | 12.94 |  | 9 | 11.03 |  | 21 | 11.08 |  | 17 |  |  |  |  |  |  |  | 0.65 | -0.35
JAKK | 2009-06-05 00:00:00 | 2009-06-08 00:00:00 | 12.68 | 0 | 0 | 0 | 10.65 |  | 8 | 16.26 |  | 21 | 10.94 |  | 33 | 11.91 |  | 2 | 13.4 |  | 3 | 12.57 |  | 4 | 11.58 |  | 8
LAWS | 2009-06-05 00:00:00 | 2009-06-08 00:00:00 | 14.72 | 1 | 1 | 1 | 11.58 |  | 6 | 20.41 |  | 20 | 14.77 |  | 23 | 11.58 |  | 21 | 20.41 |  | 21 | 15.65 |  | 21 | 11.72 |  | 5
CELG | 2009-06-05 00:00:00 | 2009-06-08 00:00:00 | 44.54 | 1 | 1 | 0 | 42 |  | 2 | 65.79 |  | 41 | 58.94 |  | 48 | 42 |  | 2 | 58.31 |  | 8 | 51.74 |  | 14 | 51.74 |  | 13
MATW | 2009-06-05 00:00:00 | 2009-06-08 00:00:00 | 30.33 | 1 | 1 | 0 | 28 |  | 6 | 39.81 |  | 20 | 34.48 |  | 33 | 28.16 |  | 5 | 31.72 |  | 1 | 28.59 |  | 5 | 28.59 |  | 5
AMGN | 2009-06-12 00:00:00 | 2009-06-15 00:00:00 | 49.98 | 0 | 2 | 0 | 49.21 |  | 1 | 64.76 |  | 9 | 52.86 |  | 20 | 49.21 |  | 1 | 64.76 |  | 9 | 58.5 |  | 13 | 59 |  | 12
[NAME] | 2009-06-12 00:00:00 | 2009-06-15 00:00:00 | 5.93 | 1 | 1 | 0 | 5.49 |  | 6 | 6.83 |  | 9 | 5.77 |  | 35 | 5.71 |  | 1 | 6.16 |  | 1 | 5.61 |  | 4 | 6.12 |  | 19
ZNT | 2009-06-12 00:00:00 | 2009-06-15 00:00:00 | 21.98 | 0 | 0 | 0 | 20.56 |  | 4 | 32.49 |  | 18 | 28.33 |  | 32 | 20.56 |  | 4 | 32.49 |  | 18 | 28.7 |  | 20 | 30.16 |  | 19
SAFT | 2009-06-12 00:00:00 | 2009-06-15 00:00:00 | 32.2 | 1 | 1 | 0 | 29 |  | 2 | 37.14 |  | 28 | 34.2 |  | 34 | 30.36 |  | 1 | 32.78 |  | 1 | 32.41 |  | 12 | 36.44 |  | 30
SPTN | 2009-06-19 00:00:00 | 2009-06-22 00:00:00 | 13.87 | 0 | 0 | 0 | 11.78 |  | 4 | 15.7 |  | 18 | 12.33 |  | 34 | 11.78 |  | 6 | 15.06 |  | 6 | 13.1 |  | 6 | 13.63 |  | 21
SXI | 2009-06-26 00:00:00 | 2009-06-29 00:00:00 | 11.56 | 0 | 0 | 1 | 9.56 |  | 2 | 30.93 |  | 44 | 23.65 |  | 45 | 9.56 |  | 2 | 12.24 |  | 1 | 10.03 |  | 2 | 20.51 |  | 17
[NAME] | 2009-06-26 00:00:00 | 2009-06-29 00:00:00 | 18.39 | 0 | 2 | 1 | 17.15 |  | 2 | 21.48 |  | 28 | 19.45 |  | 34 | 17.15 |  | 10 | 20.16 |  | 10 | 18.52 |  | 10 | 18.12 |  | 6
SWS | 2009-07-17 00:00:00 | 2009-07-20 00:00:00 | 14.86 | 0 | 2 | 0 | 12.35 |  | 18 | 15.62 |  | 9 | 12.76 |  | 18 | 13.31 |  | 7 | 15.3 |  | 6 | 13.92 |  | 7 | 14.08 |  | 11
NAFC | 2009-07-24 00:00:00 | 2009-07-27 00:00:00 | 27.83 | 0 | 0 | 0 | 26.25 |  | 4 | 38.14 |  | 24 | 33.83 |  | 36 | 26.25 |  | 4 | 31.32 |  | 1 | 27.2 |  | 4 | 35.42 |  | 25
LG | 2009-07-31 00:00:00 | 2009-08-03 00:00:00 | 33.96 | 0 | 2 | 0 | 30.17 |  | 14 | 35.89 |  | 42 | 32.51 |  | 44 | 30.85 |  | 1 | 35.24 |  | 4 | 32.81 |  | 5 | 31.85 |  | 9
SUSQ | 2009-08-14 00:00:00 | 2009-08-17 00:00:00 | 5.74 | 0 | 2 | 0 | 5.04 |  | 12 | 7.38 |  | 22 | 8.15 |  | 42 | 5.18 |  | 3 | 6.79 |  | 5 | 5.41 |  | 10 | 5.39 |  | 7
QSII | 2009-10-09 00:00:00 | 2009-10-12 00:00:00 | 65.55 | 0 | 2 | 0 | 57.63 |  | 3 | 65.98 |  | 2 | 59.63 |  | 7 | 57.63 |  | 3 | 65.98 |  | 2 | 61.03 |  | 3 | 59.63 |  | 7
PLCE | 2009-10-23 00:00:00 | 2009-10-26 00:00:00 | 35 | 0 | 2 | 0 | 26.65 |  | 6 | 37 |  | 3 | 29.28 |  | 7 | 31 |  | 1 | 37 |  | 3 | 27.67 |  | 6 | 27.67 |  | 6
HMSY | 2009-11-06 00:00:00 | 2009-11-09 00:00:00 | 43.25 | 0 | 2 | 0 | 42.87 |  | 1 | 53 |  | 9 | 44.35 |  | 13 | 42.87 |  | 1 | 53 |  | 9 | 45.94 |  | 11 | 48.43 |  | 10
GLW | 2009-12-04 00:00:00 | 2009-12-07 00:00:00 | 18.42 | 0 | 2 | 0 | 16.75 |  | 12 | 20.85 |  | 6 | 17.7 |  | 12 | 17.4 |  | 1 | 20.85 |  | 6 | 18.72 |  | 7 | 18.72 |  | 7
STC | 2009-12-25 00:00:00 | 2009-12-28 00:00:00 | 11.05 | 0 | 2 | 0 | 10.26 |  | 5 | 14.96 |  | 16 | 10.8 |  | 21 | 10.26 |  | 5 | 11.6 |  | 2 | 10.52 |  | 5 | 10.52 |  | 5
QCOM | 2010-01-08 00:00:00 | 2010-01-11 00:00:00 | 49.58 | 0 | 2 | 1 | 37.43 |  | 4 | 49.69 |  | 1 | 38.11 |  | 4 | 37.43 |  | 4 | 49.69 |  | 1 | 38.11 |  | 4 | 38.11 |  | 4
SWKS | 2010-01-08 00:00:00 | 2010-01-11 00:00:00 | 15.01 | 0 | 2 | 0 | 12.64 |  | 3 | 18.14 |  | 16 | 15.81 |  | 17 | 12.64 |  | 3 | 15.62 |  | 1 | 12.67 |  | 3 | 12.67 |  | 3
SPAR | 2010-01-08 00:00:00 | 2010-01-11 00:00:00 | 6.97 | 0 | 2 | 1 | 4.61 |  | 19 | 7.09 |  | 16 | 4.91 |  | 19 | 5.54 |  | 7 | 7 |  | 1 | 5.67 |  | 7 | 5.67 |  | 7
FITB | 2010-01-22 00:00:00 | 2010-01-25 00:00:00 | 12.25 | 0 | 2 | 1 | 11.01 |  | 3 | 15.95 |  | 13 | 12.9 |  | 18 | 11.01 |  | 3 | 15.95 |  | 13 | 13.2 |  | 17 | 14.26 |  | 15
UVV | 2010-02-12 00:00:00 | 2010-02-16 00:00:00 | 53.19 | 1 | 1 | 1 | 51.74 |  | 11 | 55.98 |  | 10 | 52.13 |  | 11 | 47 |  | 12 | 56 |  | 10 | 49.8 |  | 12 | 52.13 |  | 11
RMD | 2010-02-19 00:00:00 | 2010-02-22 00:00:00 | 57.72 | 0 | 2 | 0 | 56.58 |  | 1 | 70.65 |  | 10 | 62.82 |  | 14 | 56.58 |  | 1 | 70.65 |  | 10 | 60.4 |  | 13 | 61.75 |  | 7
[NAME] | 2010-02-26 00:00:00 | 2010-03-01 00:00:00 | 26.38 | 0 | 2 | 0 | 23.22 |  | 18 | 32.36 |  | 8 | 24.74 |  | 18 | 25.99 |  | 1 | 32.36 |  | 8 | 28.84 |  | 9 | 28.84 |  | 9
MAT | 2010-03-05 00:00:00 | 2010-03-08 00:00:00 | 22.49 | 0 | 2 | 0 | 20.55 |  | 9 | 24.6 |  | 6 | 22.19 |  | 9 | 20.55 |  | 9 | 24.6 |  | 6 | 22.19 |  | 9 | 22.19 |  | 9
FFIV | 2010-03-12 00:00:00 | 2010-03-15 00:00:00 | 62.99 | 0 | 2 | 0 | 60.5 |  | 8 | 77.1 |  | 15 | 69.9 |  | 16 |  |  |  |  |  |  |  |  |  | 66.5 |  | 8
IFSIA | 2010-03-12 00:00:00 | 2010-03-15 00:00:00 | 11.36 | 0 | 2 | 1 | 10.09 |  | 13 | 14.42 |  | 9 | 10.93 |  | 16 | 10.53 |  | 1 | 14.42 |  | 9 | 11.62 |  | 11 | 13.12 |  | 8
NSR | 2010-03-19 00:00:00 | 2010-03-22 00:00:00 | 25.79 | 0 | 2 | 0 | 21.87 |  | 7 | 26.73 |  | 4 | 22.82 |  | 8 | 24.46 |  | 6 | 26.73 |  | 4 | 24.55 |  | 6 | 24.55 |  | 6
SEIC | 2010-03-19 00:00:00 | 2010-03-22 00:00:00 | 20.9 | 0 | 2 | 0 | 19.93 |  | 12 | 24.43 |  | 6 | 20.59 |  | 15 | 20.79 |  | 1 | 24.43 |  | 6 | 21.2 |  | 9 | 22.34 |  | 7
EPIQ | 2010-04-01 00:00:00 | 2010-04-04 00:00:00 | 12.35 | 0 | 2 | 0 |  |  |  |  |  |  |  |  |  | 11.56 |  | 4 | 12.79 |  | 4 | 12.11 |  | 5 | 11.59 |  | 7
CSX | 2010-04-16 00:00:00 | 2010-04-19 00:00:00 | 56.96 | 0 | 2 | 0 | 48.04 |  | 4 | 62 |  | 2 | 50.12 |  | 6 | 48.04 |  | 4 | 62 |  | 2 | 50.52 |  | 4 | 54.6 |  | 2
GMT | 2010-04-16 00:00:00 | 2010-04-19 00:00:00 | 33.01 | 0 | 2 | 1 | 25.5 |  | 8 | 35.75 |  | 1 | 28.53 |  | 8 | 28.01 |  | 5 | 35.75 |  | 1 | 28.68 |  | 5 | 31.89 |  | 3
OGE | 2010-04-16 00:00:00 | 2010-04-19 00:00:00 | 39.63 | 0 | 2 | 0 | 35.74 |  | 3 | 42.25 |  | 2 | 38.76 |  | 4 | 35.74 |  | 3 | 42.25 |  | 2 | 38.09 |  | 3 | 38.09 |  | 3
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | to Drawdown |  |  |  |  |  |  |  |  | to Drawdown