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

 | contra |  | Gap, no MACD |  |  | with gap, no MACD |  |  | contra 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] | 9% Stop Bar
 |  |  |  | Exit | target exit | target exit | 13th Bar | 13th Bar |  | during trade | during trade
ETN | 2012-06-29 00:00:00 | 2012-07-02 00:00:00 | 38.89 |  |  |  | 38.59 |  | 13 |  | 35.77 | 8
[NAME] | 2012-06-29 00:00:00 | 2012-07-02 00:00:00 | 46.07 |  |  |  | 44.25 | -0.09 | 6 |  | 39.91 | 10 | 6
KMX | 2012-07-06 00:00:00 | 2012-07-09 00:00:00 | 26.5 | 27.52 |  | 9 |  |  |  |  | 25.84 | 4
SHOO | 2012-07-13 00:00:00 | 2012-07-16 00:00:00 | 34.58 | 36.54 |  | 9 |  |  |  |  | 32.36 | 8
KLAC | 2012-07-20 00:00:00 | 2012-07-23 00:00:00 | 48.37 | 50.22 |  | 4 |  |  |  |  | 47.62 | 1
TEX | 2012-07-27 00:00:00 | 2012-07-30 00:00:00 | 19.27 | 20.01 |  | 3 |  |  |  |  | 18.35 | 1
NANO | 2012-07-27 00:00:00 | 2012-07-30 00:00:00 | 15.31 |  |  |  | 15.01 |  | 13 |  | 14.42 | 1
IEX | 2012-07-27 00:00:00 | 2012-07-30 00:00:00 | 38.84 | 40.33 |  | 7 |  |  |  |  | 36.78 | 4
AET | 2012-08-03 00:00:00 | 2012-08-06 00:00:00 | 36.83 | 38.24 |  | 10 |  |  |  |  | 36.55 | 1
MJN | 2012-08-03 00:00:00 | 2012-08-06 00:00:00 | 73.74 |  |  |  | 70.79 |  | 13 |  | 70.59 | 12
ZEUS | 2012-08-03 00:00:00 | 2012-08-06 00:00:00 | 16.35 |  |  |  | 16.07 |  | 13 |  | 15.3 | 8
SFD | 2012-08-03 00:00:00 | 2012-08-06 00:00:00 | 18.79 | 19.51 |  | 8 |  |  |  |  | 17.55 | 2
VAL | 2012-08-10 00:00:00 | 2012-08-13 00:00:00 | 52.41 |  |  |  | 52.87 |  | 13 |  | 49.6 | 2
LO | 2012-08-17 00:00:00 | 2012-08-20 00:00:00 | 130.94 |  |  |  | 125.09 |  | 13 |  | 124.41 | 12
VLY | 2012-08-17 00:00:00 | 2012-08-20 00:00:00 | 9.63 |  |  |  | 9.77 |  | 13 |  | 9.42 | 4
IBOC | 2012-08-17 00:00:00 | 2012-08-20 00:00:00 | 18.18 | 18.88 |  | 2 |  |  |  |  | 18.18 | 1
CYH | 2012-08-17 00:00:00 | 2012-08-20 00:00:00 | 25.66 | 26.65 |  | 6 |  |  |  |  | 25.47 | 1
OMI | 2012-08-17 00:00:00 | 2012-08-20 00:00:00 | 28.24 |  |  |  | 28.48 |  | 13 |  | 27.5 | 11
NUVA | 2012-08-17 00:00:00 | 2012-08-20 00:00:00 | 21.43 |  |  |  | 21.29 |  | 13 |  | 20.4 | 3
[NAME] | 2012-08-17 00:00:00 | 2012-08-20 00:00:00 | 18.15 |  |  |  | 18.15 |  | 13 |  | 17.51 | 7
BMY | 2012-08-24 00:00:00 | 2012-08-27 00:00:00 | 32.62 |  |  |  | 33.55 |  | 13 |  | 32.47 | 1
TRIP | 2012-08-24 00:00:00 | 2012-08-27 00:00:00 | 34.29 | 35.6 |  | 7 |  |  |  |  | 33.19 | 6
CPSI | 2012-08-24 00:00:00 | 2012-08-27 00:00:00 | 50.97 | 52.92 |  | 7 |  |  |  |  | 48.64 | 2
SVNT | 2012-08-24 00:00:00 | 2012-08-27 00:00:00 | 1.3 | 1.35 |  | 1 |  |  |  |  | 1.26 | 1
PRFT | 2012-09-07 00:00:00 | 2012-09-10 00:00:00 | 10.98 | 11.4 |  | 3 |  |  |  |  | 10.98 | 1
IQNT | 2012-09-07 00:00:00 | 2012-09-10 00:00:00 | 11.14 |  |  |  | 9.49 | -0.09 | 10 |  | 9.27 | 10 | 10
NEWP | 2012-09-07 00:00:00 | 2012-09-10 00:00:00 | 13.12 |  |  |  | 11.48 | -0.09 | 10 |  | 11.35 | 12 | 10
PULS | 2012-09-28 00:00:00 | 2012-10-01 00:00:00 | 0.85 |  |  |  | 0.66 | -0.09 | 1 |  | 0.62 | 9 | 1
HOTT | 2012-10-05 00:00:00 | 2012-10-08 00:00:00 | 9.08 | 9.43 |  | 4 |  |  |  |  | 8.82 | 3
LSI | 2012-10-26 00:00:00 | 2012-10-31 00:00:00 | 6.96 |  |  |  | 6.43 |  | 13 |  | 6.35 | 12
PCS | 2012-11-16 00:00:00 | 2012-11-19 00:00:00 | 11.36 |  |  |  | 10.18 | -0.09 | 7 |  | 9.9 | 11 | 7
AMED | 2012-11-23 00:00:00 | 2012-11-26 00:00:00 | 10.24 | 10.64 |  | 4 |  |  |  |  | 9.97 | 3
CBU | 2012-11-23 00:00:00 | 2012-11-26 00:00:00 | 26.72
ACAT | 2012-11-23 00:00:00 | 2012-11-26 00:00:00 | 36.05 | 37.57 |  | 4 |  |  |  |  | 35.78 | 1
AEE | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 30
M | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 38.93
TE | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 16.86
SCG | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 45.93
UNH | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 54.56
WMT | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 71.71
CNL | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 40.34
[NAME] | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 42.93
MNTA | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 10.81
RECN | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 11.68
ALE | 2012-11-30 00:00:00 | 2012-12-03 00:00:00 | 39.48
BTU | 2012-12-07 00:00:00 | 2012-12-10 00:00:00 | 26.7
 |  |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  | (bars per loser)
 |  |  |  |  |  |  |  |  | Median
 |  |  |  |  |  | Winners
 |  |  |  |  |  | Losers
 |  |  |  |  |  | Avg. %/trade |  | Avg. # bars/trade
 |  |  |  |  |  |  |  | Avg. # bars/trade rounded up
 |  |  |  |  |  |  | Starting [NAME] | Ending Cap | Annual Return
 |  |  |  |  |  |  | 10000