Spreadsheet: 745594d1630036935-add-conditional-array-to-simple-if-formula-that-includes-blank-cells-rd-excel-forum-question
Sheet: Short Trades '12 w_5%_stops

 | Contra |  |  | Contra Gap + MACD |  |  | Contra Gap, no MACD |  |  | With Gap, no MACD
Symbol | Signal Date | Entry Date | Entry Price | Target Price | % Profit | Bars to | Exit at Open | % P/L at Open | Bars per loser | Drawdown % | Drawdown | [NAME] | 5% Stop Bar
 |  |  |  | Exit | target exit | target exit | 6th Bar | 6th Bar or stop |  | during trade | during trade
CVH | 2012-06-29 00:00:00 | 2012-07-02 00:00:00 | 31.95 | 31.25 |  | 1 |  |  |  |  | 32.03 | 1
SKX | 2012-06-29 00:00:00 | 2012-07-02 00:00:00 | 20.44 | 19.99 |  | 5 |  |  |  |  | 20.65 | 3
LXK | 2012-07-13 00:00:00 | 2012-07-16 00:00:00 | 20.15 | 19.71 |  | 5 |  |  |  |  | 20.63 | 1
WYNN | 2012-07-13 00:00:00 | 2012-07-16 00:00:00 | 96.03 |  |  |  | 95.34 | -0.05 | 3 |  | 100.94 | 3 | 3
SLH | 2012-07-13 00:00:00 | 2012-07-16 00:00:00 | 39.33 | 38.48 |  | 2 |  |  |  |  | 39.39 | 2
LINC | 2012-07-13 00:00:00 | 2012-07-16 00:00:00 | 5.81 | 5.68 |  | 2 |  |  |  |  | 5.91 | 1
NTRS | 2012-07-20 00:00:00 | 2012-07-23 00:00:00 | 44.68 |  |  |  | 46.09 |  | 6 |  | 46.49 | 5
RAI | 2012-07-20 00:00:00 | 2012-07-23 00:00:00 | 44.66 |  |  |  | 44.94 |  | 6 |  | 45.18 | 5
[NAME] | 2012-07-20 00:00:00 | 2012-07-23 00:00:00 | 5.21 |  |  |  | 5.46 | -0.05 | 5 |  | 5.48 | 5 | 5
BXS | 2012-07-20 00:00:00 | 2012-07-23 00:00:00 | 14.4 | 14.08 |  | 1 |  |  |  |  | 14.4 | 1
LPS | 2012-07-20 00:00:00 | 2012-07-23 00:00:00 | 23.97 | 23.45 |  | 1 |  |  |  |  | 24.05 | 1
CLI | 2012-07-20 00:00:00 | 2012-07-23 00:00:00 | 28.26 | 27.64 |  | 4 |  |  |  |  | 28.74 | 4
NCS | 2012-07-20 00:00:00 | 2012-07-23 00:00:00 | 10.31 |  |  |  | 11.1 | -0.05 | 4 |  | 11.09 | 5 | 4
SPPI | 2012-07-20 00:00:00 | 2012-07-23 00:00:00 | 15.6 | 15.26 |  | 1 |  |  |  |  | 15.91 | 1
[NAME] | 2012-07-20 00:00:00 | 2012-07-23 00:00:00 | 36.58 | 35.78 |  | 1 |  |  |  |  | 36.92 | 1
DHI | 2012-07-27 00:00:00 | 2012-07-30 00:00:00 | 18.65 | 18.24 |  | 1 |  |  |  |  | 18.89 | 1
NCIT | 2012-07-27 00:00:00 | 2012-07-30 00:00:00 | 5.06 |  |  |  | 6.3 | -0.05 | 1 |  | 6.29 | 5 | 1
MNRO | 2012-07-27 00:00:00 | 2012-07-30 00:00:00 | 33.63 | 32.9 |  | 2 |  |  |  |  | 33.97 | 1
SWN | 2012-08-03 00:00:00 | 2012-08-06 00:00:00 | 30.65 |  |  |  | 32.18 | -0.05 | 2 |  | 33.24 | 4 | 2
ABFS | 2012-08-03 00:00:00 | 2012-08-06 00:00:00 | 9.92 |  |  |  | 10.41 | -0.05 | 1 |  | 10.83 | 2 | 1
GAS | 2012-08-10 00:00:00 | 2012-08-13 00:00:00 | 40.16 |  |  |  | 39.89 |  | 6 |  | 40.4 | 3
MON | 2012-08-10 00:00:00 | 2012-08-13 00:00:00 | 86.39 |  |  |  | 88.1 |  | 6 |  | 88.96 | 4
BPFH | 2012-08-17 00:00:00 | 2012-08-20 00:00:00 | 9.45 |  |  |  | 9.44 |  | 6 |  | 9.75 | 2
CBST | 2012-08-17 00:00:00 | 2012-08-20 00:00:00 | 43.04 |  |  |  | 45.99 | -0.05 | 5 |  | 46 | 5 | 5
HAS | 2012-08-24 00:00:00 | 2012-08-27 00:00:00 | 37.68 |  |  |  | 37.48 |  | 6 |  | 38 | 1
AWR | 2012-08-24 00:00:00 | 2012-08-27 00:00:00 | 43.5 |  |  |  | 43.1 |  | 6 |  | 44.3 | 3
FTR | 2012-08-31 00:00:00 | 2012-09-04 00:00:00 | 4.63 | 4.53 |  | 1 |  |  |  |  | 4.58 | 1
CSC | 2012-08-31 00:00:00 | 2012-09-04 00:00:00 | 32.68 | 31.97 |  | 1 |  |  |  |  | 32.68 | 1
SUPX | 2012-08-31 00:00:00 | 2012-09-04 00:00:00 | 17.25 | 16.87 |  | 1 |  |  |  |  | 18.05 | 1
BGC | 2012-09-07 00:00:00 | 2012-09-10 00:00:00 | 30.25 |  |  |  | 31.76 | -0.05 | 5 |  | 32.12 | 5 | 5
ANR | 2012-09-07 00:00:00 | 2012-09-10 00:00:00 | 6.95 |  |  |  | 8.28 | -0.05 | 1 |  | 9.05 | 5 | 1
ZQK | 2012-09-07 00:00:00 | 2012-09-10 00:00:00 | 3.55 | 3.47 |  | 5 |  |  |  |  | 3.67 | 5
LII | 2012-09-07 00:00:00 | 2012-09-10 00:00:00 | 45.79 |  |  |  | 46.42 |  | 6 |  | 46.85 | 4
SLXP | 2012-09-07 00:00:00 | 2012-09-10 00:00:00 | 41.92 |  |  |  | 42.73 |  | 6 |  | 43.49 | 5
SLB | 2012-09-14 00:00:00 | 2012-09-17 00:00:00 | 77.29 | 75.62 |  | 2 |  |  |  |  | 78.27 | 1
ORLY | 2012-09-14 00:00:00 | 2012-09-17 00:00:00 | 80.37 |  |  |  | 83.79 | -0.05 | 4 |  | 84.56 | 4 | 4
EA | 2012-09-21 00:00:00 | 2012-09-24 00:00:00 | 13.11 | 12.82 |  | 2 |  |  |  |  | 13.36 | 1
MDRX | 2012-09-21 00:00:00 | 2012-09-24 00:00:00 | 10.75 | 10.51 |  | 3 |  |  |  |  | 11.17 | 1
AM | 2012-09-21 00:00:00 | 2012-09-24 00:00:00 | 14.57 | 14.25 |  | 2 |  |  |  |  | 14.87 | 1
SFD | 2012-09-21 00:00:00 | 2012-09-24 00:00:00 | 19.62 | 19.19 |  | 5 |  |  |  |  | 19.83 | 2
IPI | 2012-09-21 00:00:00 | 2012-09-24 00:00:00 | 22.38 | 21.89 |  | 1 |  |  |  |  | 22.42 | 1
PEI | 2012-09-21 00:00:00 | 2012-09-24 00:00:00 | 15.96 |  |  |  | 15.94 |  | 6 |  | 16.42 | 5
EPR | 2012-09-21 00:00:00 | 2012-09-24 00:00:00 | 45.68 | 44.69 |  | 2 |  |  |  |  | 46.07 | 1
PSB | 2012-09-21 00:00:00 | 2012-09-24 00:00:00 | 68.1 | 66.62 |  | 3 |  |  |  |  | 68.51 | 1
JOY | 2012-09-28 00:00:00 | 2012-10-01 00:00:00 | 56.64 |  |  |  | 56.71 |  | 6 |  | 58.63 | 5
ACN | 2012-09-28 00:00:00 | 2012-10-01 00:00:00 | 69.99 |  |  |  | 69.5 |  | 6 |  | 71.56 | 4
CELG | 2012-09-28 00:00:00 | 2012-10-01 00:00:00 | 76.97 |  |  |  | 80 | -0.05 | 5 |  | 81.24 | 5 | 5
RSH | 2012-09-28 00:00:00 | 2012-10-01 00:00:00 | 2.4 | 2.34 |  | 1 |  |  |  |  | 2.44 | 1
ADTN | 2012-09-28 00:00:00 | 2012-10-01 00:00:00 | 17 | 16.63 |  | 3 |  |  |  |  | 17.55 | 1
ISCA | 2012-09-28 00:00:00 | 2012-10-01 00:00:00 | 28.56 | 27.94 |  | 1 |  |  |  |  | 28.65 | 1
MD | 2012-09-28 00:00:00 | 2012-10-01 00:00:00 | 74.58 |  |  |  | 73.58 |  | 6 |  | 74.82 | 1
HUBG | 2012-09-28 00:00:00 | 2012-10-01 00:00:00 | 29.68 | 29.03 |  | 3 |  |  |  |  | 30.06 | 1
BGS | 2012-09-28 00:00:00 | 2012-10-01 00:00:00 | 30.35 |  |  |  |  | -0.05 | 2 |  | 31.99 | 2 | 2
SVU | 2012-10-05 00:00:00 | 2012-10-08 00:00:00 | 2.22 | 2.17 |  | 2 |  |  |  |  | 2.24 | 1
THC | 2012-10-05 00:00:00 | 2012-10-08 00:00:00 | 24.8 | 24.26 |  | 2 |  |  |  |  | 24.84 | 1
MWV | 2012-10-05 00:00:00 | 2012-10-08 00:00:00 | 30.32 |  |  |  | 30.07 |  | 6 |  | 30.58 | 2
RBCN | 2012-10-05 00:00:00 | 2012-10-08 00:00:00 | 9.13 | 8.93 |  | 1 |  |  |  |  | 9.17 | 1
LOGM | 2012-10-05 00:00:00 | 2012-10-08 00:00:00 | 21.71 | 21.24 |  | 3 |  |  |  |  | 21.97 | 2
CW | 2012-10-05 00:00:00 | 2012-10-08 00:00:00 | 31.27 | 30.59 |  | 2 |  |  |  |  | 31.44 | 1
CIR | 2012-10-05 00:00:00 | 2012-10-08 00:00:00 | 37.38 | 36.57 |  | 3 |  |  |  |  | 37.92 | 1
POOL | 2012-10-12 00:00:00 | 2012-10-15 00:00:00 | 41.4 |  |  |  | 42.88 |  | 6 |  | 43.07 | 5
TYL | 2012-10-12 00:00:00 | 2012-10-15 00:00:00 | 43.64 | 42.63 |  | 5 |  |  |  |  | 44.42 | 2
FNF | 2012-10-19 00:00:00 | 2012-10-22 00:00:00 | 22.57 | 22.08 |  | 4 |  |  |  |  | 22.77 | 1
STRA | 2012-10-19 00:00:00 | 2012-10-22 00:00:00 | 56.38 | 55.13 |  | 4 |  |  |  |  | 58.99 | 2
CLF | 2012-10-26 00:00:00 | 2012-10-31 00:00:00 | 36.9 |  |  |  | 36.53 |  | 6 |  | 38.36 | 3
TTI | 2012-10-26 00:00:00 | 2012-10-31 00:00:00 | 5.58 | 5.45 |  | 1 |  |  |  |  | 5.63 | 1
GTAT | 2012-11-02 00:00:00 | 2012-11-05 00:00:00 | 4.28 | 4.18 |  | 1 |  |  |  |  | 4.27 | 1
CRUS | 2012-11-02 00:00:00 | 2012-11-05 00:00:00 | 33.03 | 32.31 |  | 1 |  |  |  |  | 33.3 | 1
HLIT | 2012-11-09 00:00:00 | 2012-11-12 00:00:00 | 4.17 | 4.08 |  | 1 |  |  |  |  | 4.25 | 1
PETS | 2012-11-09 00:00:00 | 2012-11-12 00:00:00 | 10.55 | 10.32 |  | 2 |  |  |  |  | 10.56 | 1
VVI | 2012-11-09 00:00:00 | 2012-11-12 00:00:00 | 20.1 | 19.66 |  | 3 |  |  |  |  | 20.95 | 3
STMP | 2012-11-16 00:00:00 | 2012-11-19 00:00:00 | 24.37 | 23.84 |  | 2 |  |  |  |  | 25.12 | 1
CASY | 2012-11-16 00:00:00 | 2012-11-19 00:00:00 | 46.84 |  |  |  | 47.29 |  | 6 |  | 47.99 | 5
MOV | 2012-11-23 00:00:00 | 2012-11-26 00:00:00 | 31.07 | 30.39 |  | 1 |  |  |  |  | 31.18 | 1
AVD | 2012-11-23 00:00:00 | 2012-11-26 00:00:00 | 33.16 |  |  |  | 33.39 |  | 6 |  | 34.71 | 2
RRC | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 64.74 | 63.34 |  | 2 |  |  |  |  | 64.78 | 1
JOSB | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 43.56 | 42.61 |  | 4 |  |  |  |  | 45.3 | 2
MAS | 2012-12-07 00:00:00 | 2012-12-10 00:00:00 | 15.97
EXPE | 2012-12-07 00:00:00 | 2012-12-10 00:00:00 | 59.56
CGX | 2012-12-07 00:00:00 | 2012-12-10 00:00:00 | 33.98
 |  |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  | (bars per loser)
 |  |  |  |  |  |  |  |  | Median
 |  |  |  |  |  | Winners
 |  |  |  |  |  | Losers
 |  |  |  |  |  | Avg. %/trade |  | Avg. # bars/trade
 |  |  |  |  |  |  |  | Avg. # bars/trade- rounded up
 |  |  |  |  |  |  | Starting [NAME] | Ending Cap | Annual Return
 |  |  |  |  |  |  | 10000