Spreadsheet: 745594d1630036935-add-conditional-array-to-simple-if-formula-that-includes-blank-cells-rd-excel-forum-question
Sheet: Weekly Short 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 500 | WEEKLY SHORT 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
AZO | 2009-05-29 00:00:00 | 2009-06-01 00:00:00 | 153.88 | 0 | 2 | 1 | 161.59 |  | 2 | 135.31 |  | 22 | 158.36 |  | 28 | 161.59 |  | 2 | 135.31 |  | 22 | 149.63 |  | 26 | 155.99 |  | 7 |  |  |  |  |  |  |  | 0.67 | -0.33
BMC | 2009-07-10 00:00:00 | 2009-07-13 00:00:00 | 31.24 | 0 | 2 | 0 | 36.91 |  | 9 | 31 |  | 1 | 37.2 |  | 9 | 35.4 |  | 5 | 31 |  | 1 | 34.38 |  | 5 | 34.27 |  | 3 |  |  |  |  |  |  |  | 0.65 | -0.35
AKAM | 2009-07-31 00:00:00 | 2009-08-03 00:00:00 | 16.67 | 1 | 1 | 1 | 22.41 |  | 11 | 16.11 |  | 1 | 21.79 |  | 11 | 19.8 |  | 2 | 16.11 |  | 1 | 18.63 |  | 7 | 18.63 |  | 7
S | 2009-08-07 00:00:00 | 2009-08-10 00:00:00 | 3.83 | 0 | 2 | 0 | 4.65 |  | 6 | 2.78 |  | 13 | 3.7 |  | 32 | 4.65 |  | 6 | 3.47 |  | 4 | 4.11 |  | 6 | 4.11 |  | 6
TSN | 2009-08-07 00:00:00 | 2009-08-10 00:00:00 | 11.19 | 0 | 2 | 1 | 14.09 |  | 23 | 10.94 |  | 1 | 13.88 |  | 24 | 12.29 |  | 3 | 10.94 |  | 1 | 11.75 |  | 3 | 11.75 |  | 3
GENZ | 2009-08-07 00:00:00 | 2009-08-10 00:00:00 | 48.09 | 0 | 2 | 1 | 57.39 |  | 4 | 47.09 |  | 1 | 56.22 |  | 4 | 57.5 |  | 3 | 47.09 |  | 1 | 53.85 |  | 3 | 56.58 |  | 6
YUM | 2009-09-04 00:00:00 | 2009-09-07 00:00:00 | 34.32 | 2 | 1 | 0 | 38.86 |  | 28 | 32.49 |  | 23 | 37.79 |  | 28 | 35.28 |  | 5 | 32.5 |  | 3 | 34.94 |  | 5 | 35.18 |  | 6
MHP | 2009-09-11 00:00:00 | 2009-09-14 00:00:00 | 27.31 | 0 | 2 | 1 | 35.18 |  | 13 | 23.55 |  | 2 | 35.24 |  | 13 | 29.66 |  | 5 | 23.55 |  | 2 | 29.69 |  | 5 | 29.66 |  | 5
DGX | 2009-09-18 00:00:00 | 2009-09-21 00:00:00 | 50.56 | 1 | 1 | 1 | 59.02 |  | 8 | 50.56 |  | 1 | 58.87 |  | 8 | 55.78 |  | 1 | 50.56 |  | 1 | 54.91 |  | 3 | 55.26 |  | 4
GLW | 2009-09-18 00:00:00 | 2009-09-21 00:00:00 | 15.24 | 0 | 2 | 0 | 18.59 |  | 11 | 14.14 |  | 7 | 18.59 |  | 11 | 15.99 |  | 4 | 14.4 |  | 3 | 15.18 |  | 4 | 15.65 |  | 5
PBG | 2009-09-25 00:00:00 | 2009-09-28 00:00:00 | 36.67 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | 38.74 |  | 11 | 36.3 |  | 1 | 38.36 |  | 21 | 38.36 |  | 21
INTU | 2009-09-25 00:00:00 | 2009-09-28 00:00:00 | 27.75 | 0 | 2 | 0 | 30.99 |  | 13 | 27.56 |  | 1 | 30.88 |  | 13 | 29.96 |  | 3 | 27.56 |  | 1 | 29.93 |  | 3 | 29.93 |  | 3
WLP | 2009-10-02 00:00:00 | 2009-10-05 00:00:00 | 46.14 | 0 | 2 | 1 | 60.72 |  | 11 | 44.04 |  | 1 | 58.46 |  | 11 | 53.62 |  | 6 | 44.04 |  | 1 | 52.61 |  | 6 | 50.64 |  | 5
BSX | 2009-10-09 00:00:00 | 2009-10-12 00:00:00 | 10.42 | 0 | 2 | 0 | 10.45 |  | 1 | 5.04 |  | 47 | 5.38 |  | 48 | 10.45 |  | 1 | 7.84 |  | 4 | 8.93 |  | 10 | 8.78 |  | 9
TXN | 2009-10-16 00:00:00 | 2009-10-19 00:00:00 | 23 | 0 | 2 | 0 | 27 |  | 7 | 22.28 |  | 15 | 26.74 |  | 27 | 25.85 |  | 4 | 22.85 |  | 1 | 25.57 |  | 4 | 25.57 |  | 4
STT | 2009-10-23 00:00:00 | 2009-10-26 00:00:00 | 45.84 | 1 | 1 | 1 | 47.55 |  | 17 | 39.25 |  | 7 | 45.77 |  | 19 | 46 |  | 1 | 39.25 |  | 7 | 45.29 |  | 9 | 43.81 |  | 10
GT | 2009-10-30 00:00:00 | 2009-11-02 00:00:00 | 13.15 | 1 | 1 | 1 | 16.39 |  | 11 | 9.1 |  | 43 | 10.89 |  | 47 | 16.18 |  | 10 | 12.48 |  | 1 | 16.11 |  | 11 | 13.57 |  | 26
AES | 2009-10-30 00:00:00 | 2009-11-02 00:00:00 | 13.06 | 1 | 1 | 1 | 14.46 |  | 1 | 8.82 |  | 36 | 10.46 |  | 39 | 14.46 |  | 1 | 12.5 |  | 6 | 13.82 |  | 7 | 14.03 |  | 11
IGT | 2009-10-30 00:00:00 | 2009-11-02 00:00:00 | 17.89 | 1 | 1 | 1 | 21.94 |  | 12 | 16.18 |  | 20 | 21.12 |  | 5 | 21.05 |  | 3 | 17.53 |  | 6 | 20.23 |  | 11 | 20.23 |  | 11
TLAB | 2009-10-30 00:00:00 | 2009-11-02 00:00:00 | 6.04 | 1 | 1 | 1 | 7.06 |  | 16 | 5.36 |  | 7 | 7 |  | 16 | 6.16 |  | 1 | 5.36 |  | 7 | 6.18 |  | 10 | 6.18 |  | 10
LSI | 2009-10-30 00:00:00 | 2009-11-02 00:00:00 | 5.1 | 1 | 1 | 1 | 5.88 |  | 3 | 4.88 |  | 1 | 6.02 |  | 9 | 5.88 |  | 3 | 4.88 |  | 1 | 5.76 |  | 5 | 5.6 |  | 7
WPI | 2009-10-30 00:00:00 | 2009-11-02 00:00:00 | 34.33 | 1 | 1 | 1 | 39.96 |  | 8 | 34.1 |  | 1 | 39.7 |  | 9 | 38.35 |  | 5 | 34.1 |  | 1 | 38 |  | 5 | 38 |  | 5
UNP | 2009-10-30 00:00:00 | 2009-11-02 00:00:00 | 55.22 | 0 | 2 | 1 | 69.31 |  | 19 | 54.2 |  | 1 | 72.8 |  | 19 | 63.68 |  | 2 | 54.2 |  | 1 | 63.61 |  | 2 | 65.82 |  | 3
GT | 2009-10-30 00:00:00 | 2009-11-02 00:00:00 | 13.15 | 1 | 1 | 1 | 16.39 |  | 11 | 9.1 |  | 43 | 10.89 |  | 47 | 16.18 |  | 10 | 12.48 |  | 1 | 16.11 |  | 10 | 13.57 |  | 26
MU | 2009-11-06 00:00:00 | 2009-11-09 00:00:00 | 7.27 | 0 | 2 | 0 | 10.29 |  | 7 | 6.85 |  | 2 | 10.27 |  | 7 | 8.84 |  | 4 | 6.85 |  | 2 | 8.69 |  | 5 | 8.44 |  | 4
EXPE | 2009-11-06 00:00:00 | 2009-11-09 00:00:00 | 23.64 | 1 | 1 | 0 | 27.51 |  | 8 | 18.25 |  | 34 | 23.41 |  | 40 | 25.04 |  | 1 | 23.49 |  | 1 | 23.75 |  | 1 | 23.03 |  | 17
JCP | 2009-11-13 00:00:00 | 2009-11-16 00:00:00 | 30.42 | 0 | 2 | 1 | 31.52 |  | 18 | 23.92 |  | 12 | 31.07 |  | 18 | 31.45 |  | 1 | 23.92 |  | 12 | 27.89 |  | 14 | 27.89 |  | 14
[NAME] | 2009-11-13 00:00:00 | 2009-11-16 00:00:00 | 27.52 | 1 | 1 | 0 | 33.71 |  | 15 | 24.94 |  | 4 | 35.92 |  | 15 | 29.88 |  | 9 | 24.94 |  | 4 | 27.83 |  | 9 | 27.83 |  | 9
M | 2009-12-04 00:00:00 | 2009-12-07 00:00:00 | 16.08 | 0 | 2 | 1 | 21.8 |  | 14 | 15.34 |  | 9 | 21.59 |  | 14 | 18.63 |  | 11 | 15.34 |  | 9 | 18.61 |  | 11 | 16.9 |  | 4
PEP | 2009-12-18 00:00:00 | 2009-12-21 00:00:00 | 59.72 | 1 | 1 | 1 | 66.98 |  | 13 | 58.75 |  | 8 | 66.43 |  | 13 | 62.92 |  | 4 | 58.75 |  | 8 | 62.69 |  | 9 | 62.69 |  | 9
WAG | 2009-12-18 00:00:00 | 2009-12-21 00:00:00 | 37.29 | 0 | 2 | 0 | 37.95 |  | 16 | 26.1 |  | 28 | 29.25 |  | 39 | 37.63 |  | 2 | 33 |  | 7 | 36.68 |  | 14 | 36.68 |  | 14
USB | 2009-12-18 00:00:00 | 2009-12-21 00:00:00 | 22.43 | 0 | 2 | 0 | 26.84 |  | 5 | 22.19 |  | 2 | 25.89 |  | 13 | 24.48 |  | 3 | 22.19 |  | 2 | 24.5 |  | 3 | 24.49 |  | 4
RDC | 2009-12-18 00:00:00 | 2009-12-21 00:00:00 | 24.06 | 0 | 1 | 0 | 28.29 |  | 12 | 21.21 |  | 7 | 27.3 |  | 12 | 25.31 |  | 3 | 22.64 |  | 2 | 25.5 |  | 3 | 25.5 |  | 9
CTAS | 2009-12-25 00:00:00 | 2009-12-28 00:00:00 | 26.41 | 1 | 1 | 1 | 28.79 |  | 17 | 23.1 |  | 8 | 27.76 |  | 37 | 26.93 |  | 3 | 23.1 |  | 8 | 25.56 |  | 10 | 26.67 |  | 11
STZ | 2009-12-25 00:00:00 | 2009-12-28 00:00:00 | 15.88 | 0 | 2 | 0 | 17.02 |  | 17 | 14.6 |  | 10 | 18.23 |  | 17 | 17.04 |  | 4 | 15.1 |  | 2 | 16.8 |  | 4 | 16.8 |  | 4
MCK | 2009-12-25 00:00:00 | 2009-12-28 00:00:00 | 63.25 | 0 | 0 | 0 | 70.87 |  | 22 | 57.23 |  | 6 | 69.66 |  | 22 | 64.05 |  | 1 | 57.23 |  | 6 | 61.04 |  | 11 | 61.91 |  | 10
R | 2010-01-08 00:00:00 | 2010-01-11 00:00:00 | 40.42 | 1 | 1 | 0 | 44.58 |  | 14 | 31.88 |  | 4 | 43.24 |  | 14 | 41.17 |  | 1 | 31.88 |  | 4 | 38.44 |  | 10 | 38.44 |  | 10
TSS | 2010-01-15 00:00:00 | 2010-01-19 00:00:00 | 16.54 | 0 | 2 | 0 | 17.75 |  | 2 | 14.11 |  | 4 | 16.71 |  | 14 | 17.75 |  | 2 | 14.11 |  | 4 | 15.7 |  | 10 | 14.34 |  | 2
TIF | 2010-01-22 00:00:00 | 2010-01-25 00:00:00 | 41.87 | 1 | 1 | 0 | 49.82 |  | 11 | 38.89 |  | 2 | 49.85 |  | 11 | 42.13 |  | 2 | 38.89 |  | 2 | 43.62 |  | 4 | 45.72 |  | 6
MWV | 2010-01-22 00:00:00 | 2010-01-25 00:00:00 | 26.5 | 1 | 1 | 0 | 28.18 |  | 14 | 20.81 |  | 31 | 24.48 |  | 36 | 26.62 |  | 1 | 21.86 |  | 2 | 24.34 |  | 8 | 25.83 |  | 10
LTD | 2010-01-22 00:00:00 | 2010-01-25 00:00:00 | 18.6 | 1 | 1 | 0 | 22.53 |  | 5 | 18.39 |  | 1 | 22.25 |  | 5 | 19.82 |  | 1 | 18.39 |  | 1 | 19.23 |  | 1 | 26.12 |  | 27
AXP | 2010-01-22 00:00:00 | 2010-01-25 00:00:00 | 39.1 | 1 | 1 | 0 | 49.19 |  | 13 | 36.6 |  | 2 | 47.12 |  | 13 | 41 |  | 7 | 36.6 |  | 2 | 40.62 |  | 7 | 40.62 |  | 7
SLE | 2010-01-22 00:00:00 | 2010-01-25 00:00:00 | 12.11 | 0 | 2 | 0 | 13.9 |  | 4 | 11.86 |  | 1 | 13.88 |  | 4 | 12.6 |  | 2 | 11.86 |  | 1 | 12.54 |  | 2 | 12.54 |  | 2
ADP | 2010-01-22 00:00:00 | 2010-01-25 00:00:00 | 40.52 | 0 | 2 | 0 | 44.97 |  | 14 | 26.02 |  | 15 | 41.89 |  | 36 | 40.66 |  | 6 | 38.75 |  | 2 | 42.12 |  | 6 | 42.12 |  | 6
NTAP | 2010-01-29 00:00:00 | 2010-02-01 00:00:00 | 29.1 | 0 | 2 | 0 | 40.09 |  | 19 | 29.1 |  | 1 | 41.78 |  | 19 | 33.69 |  | 6 | 29.1 |  | 1 | 33.27 |  | 6 | 33.27 |  | 6
AVY | 2010-01-29 00:00:00 | 2010-02-01 00:00:00 | 32.82 | 1 | 1 | 1 | 43.33 |  | 13 | 30.22 |  | 5 | 36.46 |  | 34 | 34.19 |  | 1 | 30.22 |  | 5 | 34.91 |  | 7 | 34.91 |  | 7
KG | 2010-02-05 00:00:00 | 2010-02-08 00:00:00 | 11.33 | 0 | 2 | 0 | 12.61 |  | 6 | 7.18 |  | 21 | 9.2 |  | 30 | 12.5 |  | 5 | 10.45 |  | 3 | 12.34 |  | 5 | 12.34 |  | 5
AMT | 2010-02-05 00:00:00 | 2010-02-08 00:00:00 | 40.03 | 0 | 2 | 1 | 47.42 |  | 25 | 38.09 |  | 15 | 46.99 |  | 25 | 42.88 |  | 1 | 40 |  | 1 | 42.92 |  | 1 | 44.08 |  | 2
JBL | 2010-02-05 00:00:00 | 2010-02-08 00:00:00 | 14.39 | 1 | 1 | 0 | 18.49 |  | 7 | 10.17 |  | 30 |  |  |  | 16.96 |  | 4 | 13.85 |  | 1 | 16.77 |  | 4 | 16.77 |  | 4
CMS | 2010-02-12 00:00:00 | 2010-02-16 00:00:00 | 14.99 | 0 | 2 | 0 | 16.89 |  | 25 | 14.09 |  | 15 | 16.98 |  | 25 | 15.75 |  | 3 | 14.86 |  | 1 | 15.59 |  | 3 | 15.59 |  | 3
DF | 2010-02-19 00:00:00 | 2010-02-22 00:00:00 | 14.67 | 0 | 2 | 0 | 16.99 |  | 9 | 9.38 |  | 13 | 9.99 |  | 31 | 16.93 |  | 8 | 14.33 |  | 1 | 16.84 |  | 8
CNP | 2010-02-26 00:00:00 | 2010-03-01 00:00:00 | 13.47 | 0 | 2 | 0 | 14.88 |  | 24 | 12.75 |  | 13 | 14.43 |  | 24 | 14.39 |  | 2 | 13.47 |  | 1 | 14.25 |  | 2 | 13.82 |  | 20
ABT | 2010-03-19 00:00:00 | 2010-03-22 00:00:00 | 53.4 | 1 | 1 | 1 | 54.39 |  | 1 | 44.59 |  | 18 | 50.63 |  | 20 | 54.39 |  | 1 | 44.59 |  | 18 | 48.82 |  | 18 | 48.71 |  | 13
DTE | 2010-04-16 00:00:00 | 2010-04-19 00:00:00 | 45.49 | 0 | 0 | 0 | 47.98 |  | 1 | 45.49 |  | 1 | 47.82 |  | 1 | 49.05 |  | 3 | 43 |  | 3 | 48.15 |  | 9 | 46 |  | 10
BDX | 2010-04-16 00:00:00 | 2010-04-19 00:00:00 | 77.82 | 0 | 0 | 0 | 79.92 |  | 1 | 66.12 |  | 14 | 73.56 |  | 22 | 79.92 |  | 1 | 66.12 |  | 14 | 71.22 |  | 16 | 71.22 |  | 16
BIIB | 2010-04-23 00:00:00 | 2010-04-26 00:00:00 | 52.35 | 0 | 2 | 1 | 58.16 |  | 14 | 45.96 |  | 7 | 56.59 |  | 14 | 54.04 |  | 1 | 45.96 |  | 7 | 50.02 |  | 15 | 50.02 |  | 15
AMD | 2010-04-30 00:00:00 | 2010-05-03 00:00:00 | 9.18 | 1 | 1 | 0 |  |  |  |  |  |  |  |  |  | 9.78 |  | 2 | 7.42 |  | 6 | 9.03 |  | 7 | 8.14 |  | 8
NYT | 2010-04-30 00:00:00 | 2010-05-03 00:00:00 | 9.99 | 1 | 1 | 0 |  |  |  |  |  |  |  |  |  | 10.29 |  | 1 | 8.21 |  | 6 | 9.97 |  | 7 | 9.5 |  | 8
SWK | 2010-05-07 00:00:00 | 2010-05-10 00:00:00 | 58.97 | 1 | 1 | 1 | 62.99 |  | 1 | 48.45 |  | 8 | 60.19 |  | 20 | 62.99 |  | 1 | 58.32 |  | 1 | 59.87 |  | 1 | 50.93 |  | 10
LUV | 2010-05-07 00:00:00 | 2010-05-10 00:00:00 | 12.82 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  | 13.34 |  | 1 | 10.42 |  | 9 | 12.33 |  | 21 | 11.79 |  | 11
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | to Drawdown |  |  |  |  |  |  |  |  | to Drawdown