Spreadsheet: 49696d1249027032-set-a-range-for-multiple-functions-editing-help-book1
Sheet: Sheet1

Date | PX_LAST | MOV_AVG_200D | more than 1% | b/s | TRADE SIGNAL | PROFIT/LOSS
1990-07-02 00:00:00 | 359.54 | 344.12 | 1 | 1 | BUY | -25.11 |  | YEAR | TRADE SIGNALS | TOTAL P/L | PROFIT HIGH | PROFIT LOW
1990-08-06 00:00:00 | 334.43 | 345.15 | 1 | 2 | SELL | 1.639999999999986 |  | 1990 | 2 | -23.47 | 1.639999999999986 | -25.11
1991-01-25 00:00:00 | 336.07 | 332.66 | 1 | 1 | BUY | 40.07 |  | 1991 | 3 | 71.5
1991-11-22 00:00:00 | 376.14 | 381.17 | 1 | 2 | SELL | 10.9 |  | 1992 | 2 | 44.91
1991-12-20 00:00:00 | 387.04 | 382.24 | 1 | 1 | BUY | 20.53 |  | 1993 | 0 | 0
1992-10-05 00:00:00 | 407.57 | 412.72 | 1 | 2 | SELL | 10.59 |  | 1994 | 6 | 174.39
1992-10-26 00:00:00 | 418.16 | 412.72 | 1 | 1 | BUY | 34.32 |  | 1995 | 0 | 0
1994-03-29 00:00:00 | 452.48 | 461.66 | 1 | 2 | SELL | 12.53 |  | 1996 | 2 | 415.72
1994-08-16 00:00:00 | 465.01 | 460.27 | 1 | 1 | BUY | -10.42 |  | 1997 | 0 | 0
1994-10-04 00:00:00 | 454.59 | 460.87 | 1 | 2 | SELL | 11.2 |  | 1998 | 2 | 237.82
1994-10-11 00:00:00 | 465.79 | 460.62 | 1 | 1 | BUY | -15.71 |  | 1999 | 4 | 65.67999999999984
1994-11-22 00:00:00 | 450.08 | 459.42 | 1 | 2 | SELL | 12.39 |  | 2000 | 7 | -181.78
1994-12-27 00:00:00 | 462.47 | 457.82 | 1 | 1 | BUY | 164.4 |  | 2001 | 0 | 0
1996-07-23 00:00:00 | 626.87 | 633.43 | 1 | 2 | SELL | 23.15 |  | 2002 | 2 | -273.5
1996-08-01 00:00:00 | 650.02 | 635.31 | 1 | 1 | BUY | 392.57 |  | 2003 | 1 | 203.07
1998-08-27 00:00:00 | 1042.59 | 1058.74 | 1 | 2 | SELL | 43.34000000000015 |  | 2004 | 6 | 43.61999999999989
1998-10-29 00:00:00 | 1085.93 | 1073.81 | 1 | 1 | BUY | 194.48 |  | 2005 | 4 | 98.90000000000009
1999-09-23 00:00:00 | 1280.41 | 1302.35 | 1 | 2 | SELL | 44.99 |  | 2006 | 4 | 196.66
1999-10-06 00:00:00 | 1325.4 | 1307.74 | 1 | 1 | BUY | -39.85000000000014 |  | 2007 | 9 | -490.19
1999-10-13 00:00:00 | 1285.55 | 1310.25 | 1 | 2 | SELL | 56.8900000000001 |  | 2008 | 0 | 0
1999-10-28 00:00:00 | 1342.44 | 1312.27 | 1 | 1 | BUY | 3.649999999999864 |  | 2009 | 1 | -942.87
2000-02-18 00:00:00 | 1346.09 | 1361.88 | 1 | 2 | SELL | 33.10000000000014 |  | TOTAL | 55 | -359.54
2000-03-01 00:00:00 | 1379.19 | 1362.1 | 1 | 1 | BUY | -22.63000000000011
2000-04-14 00:00:00 | 1356.56 | 1383.42 | 1 | 2 | SELL | 44.88000000000011
2000-04-17 00:00:00 | 1401.44 | 1383.47 | 1 | 1 | BUY | -27.58000000000015 |  | 1990 | PROFIT/LOSS | Trade Signal
2000-05-23 00:00:00 | 1373.86 | 1391.96 | 1 | 2 | SELL | 48.59000000000015 |  | 1990-07-02 00:00:00 | -25.11 | BUY
2000-05-30 00:00:00 | 1422.45 | 1393.82 | 1 | 1 | BUY | 4.759999999999991 |  | 1990-08-06 00:00:00 | 1.639999999999986 | SELL
2000-09-26 00:00:00 | 1427.21 | 1446.95 | 1 | 2 | SELL | -262.9
2002-03-08 00:00:00 | 1164.31 | 1150.37 | 1 | 1 | BUY | -32.44000000000005 |  | 1991
2002-03-25 00:00:00 | 1131.87 | 1143.53 | 1 | 2 | SELL | -241.06
2003-04-15 00:00:00 | 890.81 | 880.95 | 1 | 1 | BUY | 203.07
2004-07-21 00:00:00 | 1093.88 | 1105.01 | 1 | 2 | SELL | 31.93999999999983
2004-09-13 00:00:00 | 1125.82 | 1114.66 | 1 | 1 | BUY | -22.3 |  | 1992
2004-09-27 00:00:00 | 1103.52 | 1117.43 | 1 | 2 | SELL | 27.98
2004-10-01 00:00:00 | 1131.5 | 1118.42 | 1 | 1 | BUY | -28.21
2004-10-14 00:00:00 | 1103.29 | 1119.97 | 1 | 2 | SELL | 39.91000000000008
2004-11-03 00:00:00 | 1143.2 | 1119.37 | 1 | 1 | BUY | -5.700000000000045 |  | 1993
2005-04-20 00:00:00 | 1137.5 | 1153.84 | 1 | 2 | SELL | 38.15000000000009
2005-05-04 00:00:00 | 1175.65 | 1156.26 | 1 | 1 | BUY | 11.67999999999984
2005-10-10 00:00:00 | 1187.33 | 1199.86 | 1 | 2 | SELL | 27.43000000000006
2005-11-02 00:00:00 | 1214.76 | 1199.5 | 1 | 1 | BUY | 21.6400000000001
2006-06-12 00:00:00 | 1236.4 | 1260.68 | 1 | 2 | SELL | 43.79
2006-07-03 00:00:00 | 1280.19 | 1262.56 | 1 | 1 | BUY | -37.90000000000009
2006-07-13 00:00:00 | 1242.29 | 1264.08 | 1 | 2 | SELL | 43.29
2006-08-15 00:00:00 | 1285.58 | 1271.95 | 1 | 1 | BUY | 147.48
2007-08-03 00:00:00 | 1433.06 | 1450.65 | 1 | 2 | SELL | 34.61000000000013
2007-08-06 00:00:00 | 1467.67 | 1451.17 | 1 | 1 | BUY | -41.13000000000011
2007-08-14 00:00:00 | 1426.54 | 1453.78 | 1 | 2 | SELL | 52.82999999999993
2007-08-24 00:00:00 | 1479.37 | 1456.58 | 1 | 1 | BUY | -47.01
2007-08-28 00:00:00 | 1432.36 | 1457.23 | 1 | 2 | SELL | 41.63000000000011
2007-08-31 00:00:00 | 1473.99 | 1458.49 | 1 | 1 | BUY | -20.29
2007-11-09 00:00:00 | 1453.7 | 1483.53 | 1 | 2 | SELL | 53.63999999999987
2007-12-06 00:00:00 | 1507.34 | 1484.44 | 1 | 1 | BUY | -39.38999999999987
2007-12-14 00:00:00 | 1467.95 | 1486.67 | 1 | 2 | SELL | -525.08
2009-06-01 00:00:00 | 942.87 | 926.89 | 1 | 1 | BUY | -942.87